Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Doctrine\DBAL\Exception\ConnectionLost: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at <<closure>> #2781

Closed
ostasevych opened this issue Jan 26, 2024 · 1 comment
Closed

Doctrine\DBAL\Exception\ConnectionLost: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at <<closure>> #2781

ostasevych opened this issue Jan 26, 2024 · 1 comment
Labels
0. Needs triage Issues that need to be triaged bug

Comments

@ostasevych
Copy link

ostasevych commented Jan 26, 2024 •
edited

Hi! I've got a strange error, which may be resulted in timeouts while connecting to the DB. As far as the log contains groupfolders app reference I decided to post the issue here. Please, correct me, if I am wrong.

[core] Error: Doctrine\DBAL\Exception\ConnectionLost: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at <<closure>>

 0. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1814
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
 1. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1749
    Doctrine\DBAL\Connection->handleDriverException()
 2. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1055
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /var/www/html/nextcloud/lib/private/DB/Connection.php line 262
    Doctrine\DBAL\Connection->executeQuery()
 4. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 345
    OC\DB\Connection->executeQuery()
 5. /var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /var/www/html/nextcloud/lib/private/Files/Cache/Cache.php line 168
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /var/www/html/nextcloud/lib/private/Files/View.php line 1324
    OC\Files\Cache\Cache->get()
 8. /var/www/html/nextcloud/lib/private/Files/View.php line 1374
    OC\Files\View->getCacheEntry()
 9. /var/www/html/nextcloud/lib/private/Files/Node/Root.php line 202
    OC\Files\View->getFileInfo()
10. /var/www/html/nextcloud/lib/private/Files/Node/Folder.php line 135
    OC\Files\Node\Root->get()
11. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/VersionsBackend.php line 148
    OC\Files\Node\Folder->get()
12. <<closure>>
    OCA\GroupFolders\Versions\VersionsBackend->OCA\GroupFolders\Versions\{closure}("*** sensitive parameters replaced ***")
13. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/VersionsBackend.php line 142
    array_map()
14. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/VersionsBackend.php line 80
    OCA\GroupFolders\Versions\VersionsBackend->getVersionsForFileFromDB()
15. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/GroupVersionsExpireManager.php line 81
    OCA\GroupFolders\Versions\VersionsBackend->getVersionsForFile()
16. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/GroupVersionsExpireManager.php line 60
    OCA\GroupFolders\Versions\GroupVersionsExpireManager->expireFolder()
17. /var/www/html/nextcloud/apps/groupfolders/lib/BackgroundJob/ExpireGroupVersions.php line 43
    OCA\GroupFolders\Versions\GroupVersionsExpireManager->expireAll()
18. /var/www/html/nextcloud/lib/public/BackgroundJob/Job.php line 81
    OCA\GroupFolders\BackgroundJob\ExpireGroupVersions->run()
19. /var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php line 103
    OCP\BackgroundJob\Job->start()
20. /var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php line 93
    OCP\BackgroundJob\TimedJob->start()
21. /var/www/html/nextcloud/cron.php line 152
    OCP\BackgroundJob\TimedJob->execute()

Caused by:

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at <<closure>>

 0. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 103
    Doctrine\DBAL\Driver\PDO\Exception::new()
 1. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1045
    Doctrine\DBAL\Driver\PDO\Statement->execute()
 2. /var/www/html/nextcloud/lib/private/DB/Connection.php line 262
    Doctrine\DBAL\Connection->executeQuery()
 3. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 345
    OC\DB\Connection->executeQuery()
 4. /var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /var/www/html/nextcloud/lib/private/Files/Cache/Cache.php line 168
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /var/www/html/nextcloud/lib/private/Files/View.php line 1324
    OC\Files\Cache\Cache->get()
 7. /var/www/html/nextcloud/lib/private/Files/View.php line 1374
    OC\Files\View->getCacheEntry()
 8. /var/www/html/nextcloud/lib/private/Files/Node/Root.php line 202
    OC\Files\View->getFileInfo()
 9. /var/www/html/nextcloud/lib/private/Files/Node/Folder.php line 135
    OC\Files\Node\Root->get()
10. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/VersionsBackend.php line 148
    OC\Files\Node\Folder->get()
11. <<closure>>
    OCA\GroupFolders\Versions\VersionsBackend->OCA\GroupFolders\Versions\{closure}("*** sensitive parameters replaced ***")
12. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/VersionsBackend.php line 142
    array_map()
13. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/VersionsBackend.php line 80
    OCA\GroupFolders\Versions\VersionsBackend->getVersionsForFileFromDB()
14. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/GroupVersionsExpireManager.php line 81
    OCA\GroupFolders\Versions\VersionsBackend->getVersionsForFile()
15. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/GroupVersionsExpireManager.php line 60
    OCA\GroupFolders\Versions\GroupVersionsExpireManager->expireFolder()
16. /var/www/html/nextcloud/apps/groupfolders/lib/BackgroundJob/ExpireGroupVersions.php line 43
    OCA\GroupFolders\Versions\GroupVersionsExpireManager->expireAll()
17. /var/www/html/nextcloud/lib/public/BackgroundJob/Job.php line 81
    OCA\GroupFolders\BackgroundJob\ExpireGroupVersions->run()
18. /var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php line 103
    OCP\BackgroundJob\Job->start()
19. /var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php line 93
    OCP\BackgroundJob\TimedJob->start()
20. /var/www/html/nextcloud/cron.php line 152
    OCP\BackgroundJob\TimedJob->execute()

Caused by:

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at <<closure>>

 0. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 101
    PDOStatement->execute()
 1. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1045
    Doctrine\DBAL\Driver\PDO\Statement->execute()
 2. /var/www/html/nextcloud/lib/private/DB/Connection.php line 262
    Doctrine\DBAL\Connection->executeQuery()
 3. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 345
    OC\DB\Connection->executeQuery()
 4. /var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /var/www/html/nextcloud/lib/private/Files/Cache/Cache.php line 168
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /var/www/html/nextcloud/lib/private/Files/View.php line 1324
    OC\Files\Cache\Cache->get()
 7. /var/www/html/nextcloud/lib/private/Files/View.php line 1374
    OC\Files\View->getCacheEntry()
 8. /var/www/html/nextcloud/lib/private/Files/Node/Root.php line 202
    OC\Files\View->getFileInfo()
 9. /var/www/html/nextcloud/lib/private/Files/Node/Folder.php line 135
    OC\Files\Node\Root->get()
10. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/VersionsBackend.php line 148
    OC\Files\Node\Folder->get()
11. <<closure>>
    OCA\GroupFolders\Versions\VersionsBackend->OCA\GroupFolders\Versions\{closure}("*** sensitive parameters replaced ***")
12. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/VersionsBackend.php line 142
    array_map()
13. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/VersionsBackend.php line 80
    OCA\GroupFolders\Versions\VersionsBackend->getVersionsForFileFromDB()
14. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/GroupVersionsExpireManager.php line 81
    OCA\GroupFolders\Versions\VersionsBackend->getVersionsForFile()
15. /var/www/html/nextcloud/apps/groupfolders/lib/Versions/GroupVersionsExpireManager.php line 60
    OCA\GroupFolders\Versions\GroupVersionsExpireManager->expireFolder()
16. /var/www/html/nextcloud/apps/groupfolders/lib/BackgroundJob/ExpireGroupVersions.php line 43
    OCA\GroupFolders\Versions\GroupVersionsExpireManager->expireAll()
17. /var/www/html/nextcloud/lib/public/BackgroundJob/Job.php line 81
    OCA\GroupFolders\BackgroundJob\ExpireGroupVersions->run()
18. /var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php line 103
    OCP\BackgroundJob\Job->start()
19. /var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php line 93
    OCP\BackgroundJob\TimedJob->start()
20. /var/www/html/nextcloud/cron.php line 152
    OCP\BackgroundJob\TimedJob->execute()

I use MariaDB at Ubuntu 22.04, NC 27.1.6.

Please, advice, what may be wrong?
@ostasevych ostasevych added 0. Needs triage Issues that need to be triaged bug labels Jan 26, 2024
@ostasevych
Copy link
Author

Closed, see nextcloud/server#37916

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
0. Needs triage Issues that need to be triaged bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@ostasevych