Box Internal Server Error

Hi,

I have a Box which has been working up till recently.

Now I have an error when I try to sync using the owncloud client on Xubuntu 16.04 or the Nextcloudclient on Windows 10:

“An error occurred while opening a folder Error downloading https://xxxx.xxxx/remote.php/webdav/xxxx/xxxx/file - server replied: Internal Server Error”

Accessing files via browser or android phone is all fine

I’m completely out of my depth here, can anyone help?

I downloaded the Log file and cut and paste some of the last entries below

Thanks

{“reqId”:“xObZ/I5JH1gLi/Ejc7Vm”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“PDOStatement::execute(): MySQL server has gone away at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:34:20+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Audio%20Books",“user”:“leigh”}
{“reqId”:“xObZ/I5JH1gLi/Ejc7Vm”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“PDOStatement::execute(): Error reading result set’s header at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:34:20+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Audio%20Books",“user”:“leigh”}
{“reqId”:“xObZ/I5JH1gLi/Ejc7Vm”,“remoteAddr”:“85.243.22.183”,“app”:“webdav”,“message”:“Exception: {“Message”:“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 [\“leigh\”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Code”:0,“Trace”:”#0 [internal function]: {closure}(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#1 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Object(Closure), Array)\n#2 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(446): Sabre\\Event\\EventEmitter->emit(‘beforeMethod’, Array)\n#3 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(248): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#4 \/snap\/nextcloud\/173\/htdocs\/remote.php(70): Sabre\\DAV\\Server->exec()\n#5 \/snap\/nextcloud\/173\/htdocs\/remote.php(168): handleException(Object(Doctrine\\DBAL\\Exception\\DriverException))\n#6 {main}",“File”:"\/snap\/nextcloud\/173\/htdocs\/remote.php",“Line”:68,“User”:“leigh”}",“level”:4,“time”:“2016-11-30T21:34:20+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Audio%20Books",“user”:“leigh”}
{“reqId”:“HDg0v3lKjJ0jyOladNJG”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“PDOStatement::execute(): MySQL server has gone away at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:34:51+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Laptop%20Documents",“user”:“leigh”}
{“reqId”:“HDg0v3lKjJ0jyOladNJG”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“PDOStatement::execute(): Error reading result set’s header at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:34:51+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Laptop%20Documents",“user”:“leigh”}
{“reqId”:“HDg0v3lKjJ0jyOladNJG”,“remoteAddr”:“85.243.22.183”,“app”:“webdav”,“message”:“Exception: {“Message”:“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 [\“leigh\”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Code”:0,“Trace”:”#0 [internal function]: {closure}(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#1 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Object(Closure), Array)\n#2 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(446): Sabre\\Event\\EventEmitter->emit(‘beforeMethod’, Array)\n#3 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(248): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#4 \/snap\/nextcloud\/173\/htdocs\/remote.php(70): Sabre\\DAV\\Server->exec()\n#5 \/snap\/nextcloud\/173\/htdocs\/remote.php(168): handleException(Object(Doctrine\\DBAL\\Exception\\DriverException))\n#6 {main}",“File”:"\/snap\/nextcloud\/173\/htdocs\/remote.php",“Line”:68,“User”:“leigh”}",“level”:4,“time”:“2016-11-30T21:34:51+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Laptop%20Documents",“user”:“leigh”}
{“reqId”:“R/Rw03K4Ytvp4Q08QusM”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“PDOStatement::execute(): MySQL server has gone away at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:35:22+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/music",“user”:“leigh”}
{“reqId”:“R/Rw03K4Ytvp4Q08QusM”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“PDOStatement::execute(): Error reading result set’s header at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:35:22+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/music",“user”:“leigh”}
{“reqId”:“R/Rw03K4Ytvp4Q08QusM”,“remoteAddr”:“85.243.22.183”,“app”:“webdav”,“message”:“Exception: {“Message”:“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 [\“leigh\”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Code”:0,“Trace”:”#0 [internal function]: {closure}(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#1 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Object(Closure), Array)\n#2 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(446): Sabre\\Event\\EventEmitter->emit(‘beforeMethod’, Array)\n#3 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(248): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#4 \/snap\/nextcloud\/173\/htdocs\/remote.php(70): Sabre\\DAV\\Server->exec()\n#5 \/snap\/nextcloud\/173\/htdocs\/remote.php(168): handleException(Object(Doctrine\\DBAL\\Exception\\DriverException))\n#6 {main}",“File”:"\/snap\/nextcloud\/173\/htdocs\/remote.php",“Line”:68,“User”:“leigh”}",“level”:4,“time”:“2016-11-30T21:35:22+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/music",“user”:“leigh”}
{“reqId”:“eAak6gPNfQLzWbjX2xy/”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“PDOStatement::execute(): MySQL server has gone away at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:35:53+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/music",“user”:“leigh”}
{“reqId”:“eAak6gPNfQLzWbjX2xy/”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“PDOStatement::execute(): Error reading result set’s header at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:35:53+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/music",“user”:“leigh”}
{“reqId”:“eAak6gPNfQLzWbjX2xy/”,“remoteAddr”:“85.243.22.183”,“app”:“webdav”,“message”:“Exception: {“Message”:“HTTP\/1.1 503 Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing ‘SELECT * FROM oc_storages WHERE id = ?’ with params [\“local::\\\/var\\\/snap\\\/nextcloud\\\/common\\\/nextcloud\\\/data\\\/leigh\\\/\”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Code”:0,“Trace”:”#0 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Auth\/Plugin.php(163): OCA\\DAV\\Connector\\Sabre\\Auth->check(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#1 [internal function]: Sabre\\DAV\\Auth\\Plugin->beforeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#2 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\n#3 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(446): Sabre\\Event\\EventEmitter->emit(‘beforeMethod’, Array)\n#4 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(248): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#5 \/snap\/nextcloud\/173\/htdocs\/apps\/dav\/appinfo\/v1\/webdav.php(60): Sabre\\DAV\\Server->exec()\n#6 \/snap\/nextcloud\/173\/htdocs\/remote.php(165): require_once(’\/snap\/nextcloud…’)\n#7 {main}",“File”:"\/snap\/nextcloud\/173\/htdocs\/apps\/dav\/lib\/Connector\/Sabre\/Auth.php",“Line”:162,“User”:“leigh”}",“level”:4,“time”:“2016-11-30T21:35:53+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/music",“user”:“leigh”}
{“reqId”:“OMOtrZPjeILYj3wSvwYJ”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“Error while sending QUERY packet. PID=5632 at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:36:25+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Photos",“user”:“leigh”}
{“reqId”:“OMOtrZPjeILYj3wSvwYJ”,“remoteAddr”:“85.243.22.183”,“app”:“webdav”,“message”:“Exception: {“Message”:“HTTP\/1.1 503 Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing ‘SELECT * FROM oc_storages WHERE id = ?’ with params [\“local::\\\/var\\\/snap\\\/nextcloud\\\/common\\\/nextcloud\\\/data\\\/leigh\\\/\”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Code”:0,“Trace”:”#0 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Auth\/Plugin.php(163): OCA\\DAV\\Connector\\Sabre\\Auth->check(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#1 [internal function]: Sabre\\DAV\\Auth\\Plugin->beforeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#2 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\n#3 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(446): Sabre\\Event\\EventEmitter->emit(‘beforeMethod’, Array)\n#4 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(248): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#5 \/snap\/nextcloud\/173\/htdocs\/apps\/dav\/appinfo\/v1\/webdav.php(60): Sabre\\DAV\\Server->exec()\n#6 \/snap\/nextcloud\/173\/htdocs\/remote.php(165): require_once(’\/snap\/nextcloud…’)\n#7 {main}",“File”:"\/snap\/nextcloud\/173\/htdocs\/apps\/dav\/lib\/Connector\/Sabre\/Auth.php",“Line”:162,“User”:“leigh”}",“level”:4,“time”:“2016-11-30T21:36:25+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Photos",“user”:“leigh”}
{“reqId”:“scaP2ggLaYKcV52UeESd”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“PDOStatement::execute(): MySQL server has gone away at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:41:03+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/",“user”:“leigh”}
{“reqId”:“scaP2ggLaYKcV52UeESd”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“PDOStatement::execute(): Error reading result set’s header at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:41:03+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/",“user”:“leigh”}
{“reqId”:“scaP2ggLaYKcV52UeESd”,“remoteAddr”:“85.243.22.183”,“app”:“webdav”,“message”:“Exception: {“Message”:“HTTP\/1.1 503 Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing ‘SELECT * FROM oc_storages WHERE id = ?’ with params [\“local::\\\/var\\\/snap\\\/nextcloud\\\/common\\\/nextcloud\\\/data\\\/leigh\\\/\”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Code”:0,“Trace”:”#0 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Auth\/Plugin.php(163): OCA\\DAV\\Connector\\Sabre\\Auth->check(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#1 [internal function]: Sabre\\DAV\\Auth\\Plugin->beforeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#2 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\n#3 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(446): Sabre\\Event\\EventEmitter->emit(‘beforeMethod’, Array)\n#4 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(248): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#5 \/snap\/nextcloud\/173\/htdocs\/apps\/dav\/appinfo\/v1\/webdav.php(60): Sabre\\DAV\\Server->exec()\n#6 \/snap\/nextcloud\/173\/htdocs\/remote.php(165): require_once(’\/snap\/nextcloud…’)\n#7 {main}",“File”:"\/snap\/nextcloud\/173\/htdocs\/apps\/dav\/lib\/Connector\/Sabre\/Auth.php",“Line”:162,“User”:“leigh”}",“level”:4,“time”:“2016-11-30T21:41:03+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/",“user”:“leigh”}
{“reqId”:“hz1DSEj/7Tl+7xhyxTLk”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“PDOStatement::execute(): MySQL server has gone away at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:49:50+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Audio%20Books",“user”:“leigh”}
{“reqId”:“hz1DSEj/7Tl+7xhyxTLk”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“PDOStatement::execute(): Error reading result set’s header at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:49:50+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Audio%20Books",“user”:“leigh”}
{“reqId”:“hz1DSEj/7Tl+7xhyxTLk”,“remoteAddr”:“85.243.22.183”,“app”:“webdav”,“message”:“Exception: {“Message”:“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 [\“leigh\”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Code”:0,“Trace”:”#0 [internal function]: {closure}(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#1 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Object(Closure), Array)\n#2 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(446): Sabre\\Event\\EventEmitter->emit(‘beforeMethod’, Array)\n#3 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(248): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#4 \/snap\/nextcloud\/173\/htdocs\/remote.php(70): Sabre\\DAV\\Server->exec()\n#5 \/snap\/nextcloud\/173\/htdocs\/remote.php(168): handleException(Object(Doctrine\\DBAL\\Exception\\DriverException))\n#6 {main}",“File”:"\/snap\/nextcloud\/173\/htdocs\/remote.php",“Line”:68,“User”:“leigh”}",“level”:4,“time”:“2016-11-30T21:49:50+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Audio%20Books",“user”:“leigh”}
{“reqId”:“SjGKmcix9/UXxRoEd/Pc”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“Error while sending QUERY packet. PID=12370 at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:50:21+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Laptop%20Documents",“user”:“leigh”}
{“reqId”:“SjGKmcix9/UXxRoEd/Pc”,“remoteAddr”:“85.243.22.183”,“app”:“webdav”,“message”:“Exception: {“Message”:“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 [\“leigh\”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Code”:0,“Trace”:”#0 [internal function]: {closure}(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#1 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Object(Closure), Array)\n#2 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(446): Sabre\\Event\\EventEmitter->emit(‘beforeMethod’, Array)\n#3 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(248): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#4 \/snap\/nextcloud\/173\/htdocs\/remote.php(70): Sabre\\DAV\\Server->exec()\n#5 \/snap\/nextcloud\/173\/htdocs\/remote.php(168): handleException(Object(Doctrine\\DBAL\\Exception\\DriverException))\n#6 {main}",“File”:"\/snap\/nextcloud\/173\/htdocs\/remote.php",“Line”:68,“User”:“leigh”}",“level”:4,“time”:“2016-11-30T21:50:21+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/Laptop%20Documents",“user”:“leigh”}
{“reqId”:“dBNzQwnjZMfyA3sbKTaU”,“remoteAddr”:“85.243.22.183”,“app”:“PHP”,“message”:“Error while sending QUERY packet. PID=12616 at /snap/nextcloud/173/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91”,“level”:3,“time”:“2016-11-30T21:50:52+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/music",“user”:“leigh”}
{“reqId”:“dBNzQwnjZMfyA3sbKTaU”,“remoteAddr”:“85.243.22.183”,“app”:“webdav”,“message”:“Exception: {“Message”:“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 [\“leigh\”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Exception”:“Sabre\\DAV\\Exception\\ServiceUnavailable”,“Code”:0,“Trace”:”#0 [internal function]: {closure}(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#1 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Object(Closure), Array)\n#2 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(446): Sabre\\Event\\EventEmitter->emit(‘beforeMethod’, Array)\n#3 \/snap\/nextcloud\/173\/htdocs\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(248): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#4 \/snap\/nextcloud\/173\/htdocs\/remote.php(70): Sabre\\DAV\\Server->exec()\n#5 \/snap\/nextcloud\/173\/htdocs\/remote.php(168): handleException(Object(Doctrine\\DBAL\\Exception\\DriverException))\n#6 {main}",“File”:"\/snap\/nextcloud\/173\/htdocs\/remote.php",“Line”:68,“User”:“leigh”}",“level”:4,“time”:“2016-11-30T21:50:52+00:00”,“method”:“PROPFIND”,“url”:"/remote.php/webdav/music",“user”:“leigh”}

Your database server can’t be reached any more. Either the database just crashed and needs to be restarted, there are too many requests (optimized configuration can help), or there is a problem with your database (database-logs).

Thanks,

I found the following commands to try to restart the database via ssh:

  `service mysqld restart`
  `service mysql restart`

but they both gave the error:

  `Failed to restart mysql.service: Unit mysql.service not found.`

The following

  `sudo /etc/init.d/mysql start`

doesnt work either

How should I try to restart the database?

Box as in the Nextcloud Box? MySQL is bundled into the snap - @oparoz might be able to advise.

Yup,
I have a Nextcloud Box

It seems there was a bug with the MySQL config, similar to the one with the Let’s Encrypt script where the link to a config file would be broken after updates. It’s possible to fix manually.

Edit /var/snap/nextcloud/current/mysql/root.ini

Change
socket=/var/snap/nextcloud/xxxxx/mysql/mysql.sock
to
socket=/var/snap/nextcloud/current/mysql/mysql.sock

xxxxx is a number.

1 Like

Thank you Oparoz!

That solved the problem; all syncing well now.

Also, recently the client has been slow/stubborn to start (I would have to try to start it two or three times before it started) but now that is cured too.

I had to change one thing in your solution:

Edit /var/snaps/nextcloud/current/mysql/root.ini

wasn’t found but changing from snaps to snap did:

Edit/var/snap/nextcloud/current/mysql/root.ini

Thanks again.

Great :slight_smile: and sorry for the typo :wink: