Archonw Posted July 21, 2022 Share Posted July 21, 2022 (edited) Hallo, seit gestern bekomme ich von meiner Nextcloud (linuxserver's Repository Container) nur noch Internal Server Error wenn ich versuche darauf zuzugreifen. Meine Unraid Version Version: 6.10.3 In den Logs der Nextcloud hab ich das hier: #24 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet() #25 /config/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query() #26 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query() #27 /config/www/nextcloud/lib/private/Server.php(2082): OC\AppFramework\Utility\SimpleContainer->get() #28 /config/www/nextcloud/lib/private/Files/View.php(122): OC\Server->getLockingProvider() #29 /config/www/nextcloud/lib/private/Server.php(454): OC\Files\View->__construct() #30 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\Server->OC\{closure}() #31 /config/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}() #32 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet() #33 /config/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query() #34 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query() #35 /config/www/nextcloud/lib/private/Server.php(1445): OC\AppFramework\Utility\SimpleContainer->get() #36 /config/www/nextcloud/lib/base.php(602): OC\Server->boot() #37 /config/www/nextcloud/lib/base.php(1104): OC::init() #38 /config/www/nextcloud/cron.php(43): require_once('/config/www/nex...') #39 {main} Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /config/www/nextcloud/lib/private/DB/Connection.php:139 Stack trace: #0 /config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\DB\Connection->connect() #1 /config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\DBAL\Connection->getWrappedConnection() #2 /config/www/nextcloud/lib/private/DB/Connection.php(261): Doctrine\DBAL\Connection->executeQuery() #3 /config/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery() #4 /config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\DBAL\Query\QueryBuilder->execute() #5 /config/www/nextcloud/lib/private/AppConfig.php(411): OC\DB\QueryBuilder\QueryBuilder->execute() #6 /config/www/nextcloud/lib/private/AppConfig.php(176): OC\AppConfig->loadConfigValues() #7 /config/www/nextcloud/lib/private/AppConfig.php(367): OC\AppConfig->getApps() #8 /config/www/nextcloud/lib/private/legacy/OC_App.php(983): OC\AppConfig->getValues() #9 /config/www/nextcloud/lib/private/Server.php(713): OC_App::getAppVersions() #10 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\Server->OC\{closure}() #11 /config/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}() #12 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet() #13 /config/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query() #14 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query() #15 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(184): OC\AppFramework\Utility\SimpleContainer->get() #16 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}() #17 /config/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}() #18 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet() #19 /config/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query() #20 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query() #21 /config/www/nextcloud/lib/private/Server.php(1105): OC\AppFramework\Utility\SimpleContainer->get() #22 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\Server->OC\{closure}() #23 /config/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}() #24 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet() #25 /config/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query() #26 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query() #27 /config/www/nextcloud/lib/private/Server.php(2082): OC\AppFramework\Utility\SimpleContainer->get() #28 /config/www/nextcloud/lib/private/Files/View.php(122): OC\Server->getLockingProvider() #29 /config/www/nextcloud/lib/private/Server.php(454): OC\Files\View->__construct() #30 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\Server->OC\{closure}() #31 /config/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}() #32 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet() #33 /config/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query() #34 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query() #35 /config/www/nextcloud/lib/private/Server.php(1445): OC\AppFramework\Utility\SimpleContainer->get() #36 /config/www/nextcloud/lib/base.php(602): OC\Server->boot() #37 /config/www/nextcloud/lib/base.php(1104): OC::init() #38 /config/www/nextcloud/cron.php(43): require_once('/config/www/nex...') #39 {main} Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /config/www/nextcloud/lib/private/DB/Connection.php:139 Stack trace: #0 /config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\DB\Connection->connect() #1 /config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\DBAL\Connection->getWrappedConnection() #2 /config/www/nextcloud/lib/private/DB/Connection.php(261): Doctrine\DBAL\Connection->executeQuery() #3 /config/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery() #4 /config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\DBAL\Query\QueryBuilder->execute() #5 /config/www/nextcloud/lib/private/AppConfig.php(411): OC\DB\QueryBuilder\QueryBuilder->execute() #6 /config/www/nextcloud/lib/private/AppConfig.php(176): OC\AppConfig->loadConfigValues() #7 /config/www/nextcloud/lib/private/AppConfig.php(367): OC\AppConfig->getApps() #8 /config/www/nextcloud/lib/private/legacy/OC_App.php(983): OC\AppConfig->getValues() #9 /config/www/nextcloud/lib/private/Server.php(713): OC_App::getAppVersions() #10 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\Server->OC\{closure}() #11 /config/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}() #12 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet() #13 /config/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query() #14 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query() #15 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(184): OC\AppFramework\Utility\SimpleContainer->get() #16 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}() #17 /config/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}() #18 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet() #19 /config/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query() #20 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query() #21 /config/www/nextcloud/lib/private/Server.php(1105): OC\AppFramework\Utility\SimpleContainer->get() #22 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\Server->OC\{closure}() #23 /config/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}() #24 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet() #25 /config/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query() #26 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query() #27 /config/www/nextcloud/lib/private/Server.php(2082): OC\AppFramework\Utility\SimpleContainer->get() #28 /config/www/nextcloud/lib/private/Files/View.php(122): OC\Server->getLockingProvider() #29 /config/www/nextcloud/lib/private/Server.php(454): OC\Files\View->__construct() #30 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(162): OC\Server->OC\{closure}() #31 /config/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}() #32 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(129): Pimple\Container->offsetGet() #33 /config/www/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query() #34 /config/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(57): OC\ServerContainer->query() #35 /config/www/nextcloud/lib/private/Server.php(1445): OC\AppFramework\Utility\SimpleContainer->get() #36 /config/www/nextcloud/lib/base.php(602): OC\Server->boot() #37 /config/www/nextcloud/lib/base.php(1104): OC::init() #38 /config/www/nextcloud/cron.php(43): require_once('/config/www/nex...') #39 {main} Als Database hab ich den Container: Mariadb linuxserver Dieser gibt mir in den Logs fortlaufend folgendes aus: 220721 19:34:10 mysqld_safe Logging to '/config/databases/66f0914e6896.err'. 220721 19:34:10 mysqld_safe Starting mariadbd daemon with databases from /config/databases UMASK must be a 3-digit mode with an additional leading 0 to indicate octal. The first digit will be corrected to 6, the others may be 0, 2, 4, or 6. UMASK corrected from 22 to 0640 ... Wer kann mir da eventuell behilflich sein? Das steht in der /config/databases/66f0914e6896.err 220721 20:01:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 220721 20:01:48 mysqld_safe Starting mariadbd daemon with databases from /config/databases 2022-07-21 20:01:48 0 [Note] /usr/bin/mariadbd (mysqld 10.5.16-MariaDB-log) starting as process 13686 ... 2022-07-21 20:01:48 0 [Note] InnoDB: Uses event mutexes 2022-07-21 20:01:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2022-07-21 20:01:48 0 [Note] InnoDB: Number of pools: 1 2022-07-21 20:01:48 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-07-21 20:01:48 0 [Note] InnoDB: Using Linux native AIO 2022-07-21 20:01:48 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2022-07-21 20:01:48 0 [Note] InnoDB: Completed initialization of buffer pool 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction 58136827 was in the XA prepared state. 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction 58136828 was in the XA prepared state. 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction 58136829 was in the XA prepared state. 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction 58136832 was in the XA prepared state. 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction 58136833 was in the XA prepared state. 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction 58136835 was in the XA prepared state. 2022-07-21 20:01:49 0 [Note] InnoDB: 6 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2022-07-21 20:01:49 0 [Note] InnoDB: Trx id counter is 58136836 2022-07-21 20:01:49 0 [Note] InnoDB: 128 rollback segments are active. 2022-07-21 20:01:49 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2022-07-21 20:01:49 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2022-07-21 20:01:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-07-21 20:01:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-07-21 20:01:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-07-21 20:01:49 0 [Note] InnoDB: 10.5.16 started; log sequence number 114220102450; transaction id 58136837 2022-07-21 20:01:49 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool 2022-07-21 20:01:49 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-07-21 20:01:49 0 [Note] InnoDB: Starting recovery for XA transactions... 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction 58136833 in prepared state after recovery 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction contains changes to 1 rows 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction 58136832 in prepared state after recovery 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction contains changes to 1 rows 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction 58136828 in prepared state after recovery 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction contains changes to 1 rows 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction 58136835 in prepared state after recovery 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction contains changes to 1 rows 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction 58136829 in prepared state after recovery 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction contains changes to 1 rows 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction 58136827 in prepared state after recovery 2022-07-21 20:01:49 0 [Note] InnoDB: Transaction contains changes to 1 rows 2022-07-21 20:01:49 0 [Note] InnoDB: 6 transactions in prepared state after recovery 2022-07-21 20:01:49 0 [Note] Found 6 prepared transaction(s) in InnoDB 2022-07-21 20:01:49 0 [ERROR] Found 6 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions. 2022-07-21 20:01:49 0 [ERROR] Aborting Edited July 21, 2022 by Archonw Quote Link to comment
alturismo Posted July 21, 2022 Share Posted July 21, 2022 1 hour ago, Archonw said: 2022-07-21 20:01:49 0 [ERROR] Found 6 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions. das mal im mysql docker in der konsole versucht ? gibt auch einige Google Einträge dazu ... hierzu sicherheitshalber folgendes, vorher NC stoppen, was auch immer evtl noch auf mariadb zugreift stoppen, mariadb stoppen, backup von appdata machen (mariadb ... dann kannst du jederzeit zum jetzigen Zustad retour), dann mariadb starten, console von mariadb und mal ausführen und schauen was passiert ... und, hast du ein backup von mysql appdata ? wenn ja, das mal probiert ? Quote Link to comment
Archonw Posted July 21, 2022 Author Share Posted July 21, 2022 Hab in der Console von Maria mal folgendes eingegeben: root@bf2ece204d0a:/# mysqld --tc-heuristic-recover commit 2022-07-21 21:15:20 0 [Note] mysqld (mysqld 10.5.16-MariaDB-log) starting as process 22886 ... mysqld: Please consult the Knowledge Base to find out how to run mysqld as root! 2022-07-21 21:15:20 0 [ERROR] Aborting root@bf2ece204d0a:/# mysqld --tc-heuristic-recover=ROLLBACK 2022-07-21 21:15:52 0 [Note] mysqld (mysqld 10.5.16-MariaDB-log) starting as process 29450 ... mysqld: Please consult the Knowledge Base to find out how to run mysqld as root! 2022-07-21 21:15:52 0 [ERROR] Aborting Laut bash bin ich doch schon root, oder? Quote Link to comment
Archonw Posted July 21, 2022 Author Share Posted July 21, 2022 Ich hab fürs Backup das Script von mgutt benutzt. Also ein vier Tage altes Backup ist da. Nur bin ich mir nicht sicher mit welchen Attributen ich das jetzt mit rsync zurück spiele. Quote Link to comment
alturismo Posted July 21, 2022 Share Posted July 21, 2022 1 hour ago, Archonw said: mysqld: Please consult the Knowledge Base to find out how to run mysqld as root! einmal google und es sollte klar sein 1 hour ago, Archonw said: Nur bin ich mir nicht sicher mit welchen Attributen ich das jetzt mit rsync zurück spiele. mal versucht es einfach rüber zu kopieren ? ich nutze das script jetzt nicht ... aber was hält dich davon ab ? kannst ja nichts kaputter machen als es ist maria stop, vorhandenes appdata Verzeichnis umbenennen (als backup), backup rüber kopieren ... mariadb starten, schauen was passiert ... Quote Link to comment
hawihoney Posted July 21, 2022 Share Posted July 21, 2022 22 minutes ago, alturismo said: einmal google und es sollte klar sein Die Ausgabe von mysqld wundert mich, denn genau so habe ich es vor einigen Jahren, beim bisher einzigen Crash, noch machen können. Ich habe das Dokument mit dem passenden Skript eben nochmal aus dem Archiv geladen. Seltsam. Gut, man pappt jetzt noch -u mit dem User/root und -p ohne weitere Angabe dazwischen, gibt das root Passwort auf Nachfrage an und gut ist. Quote Link to comment
alturismo Posted July 22, 2022 Share Posted July 22, 2022 6 hours ago, hawihoney said: Die Ausgabe von mysqld wundert mich mysql hat seinen eigenen db root user für sich, daher ja auch diese Variable ... da bringt mir root im terminal erstmal nichts ... Quote Link to comment
hawihoney Posted July 22, 2022 Share Posted July 22, 2022 2 hours ago, alturismo said: da bringt mir root im terminal erstmal nichts ... Du meinst, dass das nicht geht: mysqld -u root -p --tc-heuristic-recover=ROLLBACK -p erzwingt die versteckte Eingabe des Passworts und da müsste der Inhalt von MYSQL_ROOT_PASSWORD rein. Bin unterwegs, kann gerade nicht an die Kiste. Quote Link to comment
alturismo Posted July 22, 2022 Share Posted July 22, 2022 4 minutes ago, hawihoney said: Du meinst, dass das nicht geht: doch, genau so ich meinte dass es OHNE nicht geht ... nur weil man als root in der shell ist ... ist man noch nicht root in mysql, das war alles Quote Link to comment
Archonw Posted July 22, 2022 Author Share Posted July 22, 2022 @hawihoney hatte es bisher nur ohne -p versucht. Werde das heute abend noch versuchen. Danke schon mal. Quote Link to comment
hawihoney Posted July 22, 2022 Share Posted July 22, 2022 27 minutes ago, alturismo said: nur weil man als root in der shell ist ... ist man noch nicht root in mysql, das war alles Alles klar, hatte Dich falsch verstanden. Das muss natürlich in der MariaDB/mySQL Konsole gemacht werden. Aber das hat der OP schon gefunden. Quote Link to comment
Solution Archonw Posted July 22, 2022 Author Solution Share Posted July 22, 2022 (edited) @hawihoneyund @alturismo Danke für die Hilfe. Ich konnte es wieder zum laufen bringen. Ansatz: 1. mein Backup mittels cp -aT /mnt/user/unraidbackup/appdata/20220717_043012/mariadb /mnt/user/appdata/mariadb zurueck gespielt. Danach konnte ich die Nextcloud schon mal wieder erreichen. Doch mir wurden über das Webui keinerlei Dateien angezeigt. Dafuer in der Nextcloud Console folgendes eingegeben 2. sudo -u abc php occ maintenance:repair Jetzt scheint alles wieder reibungslos zu laufen. Edited July 22, 2022 by Archonw 1 Quote Link to comment
hawihoney Posted July 22, 2022 Share Posted July 22, 2022 1 hour ago, Archonw said: Dafuer in der Nextcloud Console folgendes eingegeben Eigentlich müsste in der Nextcloud Konsole "occ maintenance:repair" ausreichen. Das "sudo -u abc php" ist meines Erachtens nicht notwendig. Quote Link to comment
Archonw Posted July 22, 2022 Author Share Posted July 22, 2022 @hawihoney ja, stimmt. So lernt man halt jeden Tag dazu. Danke. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.