General infos:
Nextcloud version 11.0.3 stable
Operating system Ubuntu 16.04
MariaDB + Nginx+PHP
The last days I had several similar errors pop up in my nextcloud log. The seems to mainly pop up after a new user tried to connect to the server with the nextcloud app (iOS and android).
The errors are looking like this (from admin > logging):
Fatal webdav Sabre\DAV\Exception\ServiceUnavailable: HTTP/1.1 503 Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE LOWER(`uid`) = LOWER(?)' with params ["NAMEOFAUSER"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2017-07-17T21:30:16+0200
Error PHP Error while sending QUERY packet. PID=26940 at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91 2017-07-17T21:30:16+0200
Error PHP Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE LOWER(`uid`) = LOWER(?)' with params ["NAMEOFAUSER"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php#116 2017-07-17T21:30:16+0200
Error PHP Error while sending QUERY packet. PID=26942 at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91 2017-07-17T21:30:16+0200
Fatal webdav Sabre\DAV\Exception\ServiceUnavailable: HTTP/1.1 503 Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE LOWER(`uid`) = LOWER(?)' with params ["NAMEOFAUSER"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2017-07-17T21:30:16+0200
Error PHP Error while sending QUERY packet. PID=26075 at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91 2017-07-17T21:30:16+0200
Error PHP Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE LOWER(`uid`) = LOWER(?)' with params ["NAMEOFAUSER"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php#116 2017-07-17T21:30:16+0200
Error PHP Error while sending QUERY packet. PID=26074 at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91
I removed the username here and replaced it by NAMEOFAUSER.
What does this mean? The mariadb database seems to be up and running (at least systemctl status mariadb.service says so).
I also got some other error that seem to be connected to preview images.
Error PHP touch(): Unable to create file /var/nextcloud_data/appdata_ocn629c5tepp/preview/20/256-256-crop.png because No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#198 2017-07-17T22:09:28+0200
Error core OC_Image::crop(): No image loaded 2017-07-17T22:09:28+0200
Error core OC_Image::preciseResize(): No image loaded 2017-07-17T22:09:28+0200
Error PHP fclose() expects parameter 1 to be resource, boolean given at /var/www/nextcloud/lib/private/Files/Storage/Local.php#218 2017-07-17T22:09:28+0200
Error PHP fread() expects parameter 1 to be resource, boolean given at /var/www/nextcloud/lib/private/Files/Storage/Local.php#217 2017-07-17T22:09:28+0200
Error PHP fopen(/var/nextcloud_data/appdata_ocn629c5tepp/preview/20/2000-1333-max.png): failed to open stream: No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#216 2017-07-17T22:09:28+0200
Error PHP filesize(): stat failed for /var/nextcloud_data/appdata_ocn629c5tepp/preview/20/2000-1333-max.png at /var/www/nextcloud/lib/private/Files/Storage/Local.php#211 2017-07-17T22:09:28+0200
Error PHP touch(): Unable to create file /var/nextcloud_data/appdata_ocn629c5tepp/preview/18/256-256-crop.png because No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#198 2017-07-17T22:09:27+0200
Error core OC_Image::crop(): No image loaded 2017-07-17T22:09:27+0200
Error core OC_Image::preciseResize(): No image loaded 2017-07-17T22:09:27+0200
Error PHP fclose() expects parameter 1 to be resource, boolean given at /var/www/nextcloud/lib/private/Files/Storage/Local.php#218 2017-07-17T22:09:27+0200
Error PHP fread() expects parameter 1 to be resource, boolean given at /var/www/nextcloud/lib/private/Files/Storage/Local.php#217 2017-07-17T22:09:27+0200
Error PHP fopen(/var/nextcloud_data/appdata_ocn629c5tepp/preview/18/1100-734-max.png): failed to open stream: No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#216 2017-07-17T22:09:27+0200
Error PHP filesize(): stat failed for /var/nextcloud_data/appdata_ocn629c5tepp/preview/18/1100-734-max.png at /var/www/nextcloud/lib/private/Files/Storage/Local.php#211
There is no “/20” directory under “/var/nextcloud_data/appdata_ocn629c5tepp/preview/”. Is there a way to (re)generated the preview images if there is some error with them? What could have caused this?
Thanks for any help! If more info is needed I can provide it, just tell me.