[Bug]: General error: 2006 MySQL server has gone away #37916
Comments
ttenberg
added
0. Needs triage
|
This error suggests your db service was inaccessible briefly for whatever reason near the very end of the update process (during the code integrity check). Can you look at your db services logs for the NC update time period? Did it show any signs of restarting, crashing+restarting, running out of memory, etc? Also can you provide the details requested in the issue form - namely the Web Server, PHP version, OS, and the database (MySQL/MariaDB) version you're currently using? Out of curiosity, did you attempt to install any intermediate v24 point updates along the way that failed as well as or was this your first attempt doing an update ever? P.S. Your details suggest you're updating from v24.0.3 not v24.0.4, but that shouldn't make much difference. |
|
This issue has been automatically marked as stale because it has not had recent activity and seems to be missing some essential information. It will be closed if no further activity occurs. Thank you for your contributions. |
|
I had the same issue a while back. Some upgrades would just kill mariadb. Sadly i dont have all the specifics anymore. It crashed on both app-upgrades or nextcloud-upgrades. One of the error-messages was: and
However: in normal operation, the error 2006 also regularly showed up, roughly in 24 hour intervals. This did not have a lasting impact and was likely triggered by a restart of mariadb. I "fixed" this issue by moving mariadb to a docker container, and since then i did not have any further problems. Maybe this information helps someone else. |
|
Thanks for the additional info @newhinton. In any case, this isn't a bug in NC. It's a db server issue. Some other workaround steps are in the docs here too (which I hadn't realized we even had documented in my prior response): Let's take further follow-up to https://help.nextcloud.com 😄 |
Bug description
...
Reparaturschritt: Add token cleanup job
[Bug]: Code-Integrität wird überprüft
Doctrine\DBAL\Exception\ConnectionLost: An exception occurred while executing a query: SQLSTATE[HY000]:
General error: 2006 MySQL server has gone away
Steps to reproduce
Expected behavior
I expected the update from 24.0.4 to 24.0.12 to go through without errors.
Installation method
None
Nextcloud Server version
24
Operating system
None
PHP engine version
None
Web server
None
Database engine version
None
Is this bug present after an update or on a fresh install?
None
Are you using the Nextcloud Server Encryption module?
None
What user-backends are you using?
Configuration report
{ "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "cloud.ten-vision.de" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "24.0.3.2", "overwrite.cli.url": "https:\/\/cloud.ten-vision.de", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "mysql.utf8mb4": true, "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "maintenance": false, "default_phone_region": "PY", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "smtp", "mail_sendmailmode": "smtp", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtpsecure": "ssl", "mail_smtpauthtype": "LOGIN", "mail_smtpauth": 1, "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "465", "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "skeletondirectory": "\/home\/u883193172\/domains\/cloud.ten-vision.de\/default_files", "filesystem_check_changes": 1, "defaultapp": "files, dashboard", "updater.secret": "***REMOVED SENSITIVE VALUE***", "updater.release.channel": "stable", "theme": "", "loglevel": 2 } }List of activated Apps
Nextcloud Signing status
Nextcloud Logs
{"reqId":"1NhdaXZpR6lOCFupghFA","level":1,"time":"2023-04-25T06:40:50+00:00","remoteAddr":"45.184.111.136","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=fuOJJUQp%2F8xwGWxB%2FRvTJCWr43ufL1MNkl0zCx%2Fzl4w%3D%3ARtPvaG9slaAJLRV1vl7nbn%2FjiinPFwU09z8ETWjC5uA%3D","message":"\\OC\\Updater::startCheckCodeIntegrity: Starting code integrity check...","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0","version":"24.0.3.2","data":{"app":"updater"}} {"reqId":"1NhdaXZpR6lOCFupghFA","level":3,"time":"2023-04-25T06:41:43+00:00","remoteAddr":"45.184.111.136","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=fuOJJUQp%2F8xwGWxB%2FRvTJCWr43ufL1MNkl0zCx%2Fzl4w%3D%3ARtPvaG9slaAJLRV1vl7nbn%2FjiinPFwU09z8ETWjC5uA%3D","message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0","version":"24.0.3.2","exception":{"Exception":"Doctrine\\DBAL\\Exception\\ConnectionLost","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":2006,"Trace":[{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1780,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1719,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1173,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/DB/Connection.php","line":294,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1799,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/DB/Connection.php","line":272,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/DB/Adapter.php","line":126,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/DB/Connection.php","line":356,"function":"insertIfNotExist","class":"OC\\DB\\Adapter","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/AppConfig.php","line":260,"function":"insertIfNotExist","class":"OC\\DB\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/AllConfig.php","line":209,"function":"setValue","class":"OC\\AppConfig","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/IntegrityCheck/Checker.php","line":464,"function":"setAppValue","class":"OC\\AllConfig","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/IntegrityCheck/Checker.php","line":580,"function":"storeResults","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/IntegrityCheck/Checker.php","line":591,"function":"verifyCoreSignature","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/Updater.php","line":301,"function":"runInstanceVerification","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/Updater.php","line":133,"function":"doUpgrade","class":"OC\\Updater","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/core/ajax/update.php","line":194,"function":"upgrade","class":"OC\\Updater","type":"->"}],"File":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":101,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":2006,"Trace":[{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":94,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1165,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/DB/Connection.php","line":294,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1799,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/DB/Connection.php","line":272,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/DB/Adapter.php","line":126,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/DB/Connection.php","line":356,"function":"insertIfNotExist","class":"OC\\DB\\Adapter","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/AppConfig.php","line":260,"function":"insertIfNotExist","class":"OC\\DB\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/AllConfig.php","line":209,"function":"setValue","class":"OC\\AppConfig","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/IntegrityCheck/Checker.php","line":464,"function":"setAppValue","class":"OC\\AllConfig","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/IntegrityCheck/Checker.php","line":580,"function":"storeResults","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/IntegrityCheck/Checker.php","line":591,"function":"verifyCoreSignature","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/Updater.php","line":301,"function":"runInstanceVerification","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/Updater.php","line":133,"function":"doUpgrade","class":"OC\\Updater","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/core/ajax/update.php","line":194,"function":"upgrade","class":"OC\\Updater","type":"->"}],"File":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":26,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":"HY000","Trace":[{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":92,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1165,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/DB/Connection.php","line":294,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Connection.php","line":1799,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/DB/Connection.php","line":272,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/DB/Adapter.php","line":126,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/DB/Connection.php","line":356,"function":"insertIfNotExist","class":"OC\\DB\\Adapter","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/AppConfig.php","line":260,"function":"insertIfNotExist","class":"OC\\DB\\Connection","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/AllConfig.php","line":209,"function":"setValue","class":"OC\\AppConfig","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/IntegrityCheck/Checker.php","line":464,"function":"setAppValue","class":"OC\\AllConfig","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/IntegrityCheck/Checker.php","line":580,"function":"storeResults","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/IntegrityCheck/Checker.php","line":591,"function":"verifyCoreSignature","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/Updater.php","line":301,"function":"runInstanceVerification","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/lib/private/Updater.php","line":133,"function":"doUpgrade","class":"OC\\Updater","type":"->"},{"file":"/home/u883193172/domains/cloud.ten-vision.de/public_html/core/ajax/update.php","line":194,"function":"upgrade","class":"OC\\Updater","type":"->"}],"File":"/home/u883193172/domains/cloud.ten-vision.de/public_html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":92}},"message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","exception":{},"CustomMessage":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away"}} {"reqId":"1NhdaXZpR6lOCFupghFA","level":3,"time":"2023-04-25T06:41:43+00:00","remoteAddr":"45.184.111.136","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=fuOJJUQp%2F8xwGWxB%2FRvTJCWr43ufL1MNkl0zCx%2Fzl4w%3D%3ARtPvaG9slaAJLRV1vl7nbn%2FjiinPFwU09z8ETWjC5uA%3D","message":"\\OC\\Updater::failure: Doctrine\\DBAL\\Exception\\ConnectionLost: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0","version":"24.0.3.2","data":{"app":"updater"}} {"reqId":"1NhdaXZpR6lOCFupghFA","level":3,"time":"2023-04-25T06:41:43+00:00","remoteAddr":"45.184.111.136","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=fuOJJUQp%2F8xwGWxB%2FRvTJCWr43ufL1MNkl0zCx%2Fzl4w%3D%3ARtPvaG9slaAJLRV1vl7nbn%2FjiinPFwU09z8ETWjC5uA%3D","message":"\\OC\\Updater::updateEnd: Update failed","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0","version":"24.0.3.2","data":{"app":"updater"}} {"reqId":"1NhdaXZpR6lOCFupghFA","level":1,"time":"2023-04-25T06:41:43+00:00","remoteAddr":"45.184.111.136","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=fuOJJUQp%2F8xwGWxB%2FRvTJCWr43ufL1MNkl0zCx%2Fzl4w%3D%3ARtPvaG9slaAJLRV1vl7nbn%2FjiinPFwU09z8ETWjC5uA%3D","message":"\\OC\\Updater::maintenanceActive: Maintenance mode is kept active","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0","version":"24.0.3.2","data":{"app":"updater"}} {"reqId":"1NhdaXZpR6lOCFupghFA","level":1,"time":"2023-04-25T06:41:43+00:00","remoteAddr":"45.184.111.136","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=fuOJJUQp%2F8xwGWxB%2FRvTJCWr43ufL1MNkl0zCx%2Fzl4w%3D%3ARtPvaG9slaAJLRV1vl7nbn%2FjiinPFwU09z8ETWjC5uA%3D","message":"\\OC\\Updater::resetLogLevel: Reset log level to Warning(2)","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0","version":"24.0.3.2","data":{"app":"updater"}}Additional info
nix weiteres
The text was updated successfully, but these errors were encountered: