Nextcloud pi crashes on uploading stuff

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
1

I fresh installed Nextcloudpi and im saving my data on my external 2tb harddrive. For some reason it crashes everytime i upload something. mostly on files that are bigger then 20mb or smthing.

nextcloud log:
Error no app in context RedisException: Connection lost 2019-01-07T01:38:39+0100
Fatal webdav Sabre\DAV\Exception\ServiceUnavailable: RedisException: read error on connection 2019-01-07T01:38:39+0100
Error PHP unlink(/media/USBdrive/ncdata/appdata_ockubejeb23o/css/systemtags/1bf6-8cd0-systemtagsfilelist.css): No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#227 2019-01-07T00:52:19+0100
Error PHP unlink(/media/USBdrive/ncdata/appdata_ockubejeb23o/css/systemtags/1bf6-6f15-systemtagsfilelist.css.gzip): No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#227 2019-01-07T00:52:18+0100
Error PHP unlink(/media/USBdrive/ncdata/appdata_ockubejeb23o/css/systemtags/1bf6-6f15-systemtagsfilelist.css.deps): No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#227 2019-01-07T00:52:18+0100
Error PHP unlink(/media/USBdrive/ncdata/appdata_ockubejeb23o/css/firstrunwizard/70e2-8cd0-firstrunwizard.css.gzip): No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#227 2019-01-07T00:52:17+0100
Error PHP unlink(/media/USBdrive/ncdata/appdata_ockubejeb23o/css/firstrunwizard/70e2-8cd0-firstrunwizard.css.deps): No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#227 2019-01-07T00:52:17+0100
Error PHP unlink(/media/USBdrive/ncdata/appdata_ockubejeb23o/css/comments/1bf6-8cd0-autocomplete.css.deps): No such file or directory at /var/www/nextcloud/lib/private/Files/Storage/Local.php#227 2019-01-07T00:52:14+0100
Error remote RedisException: Redis server went away 2019-01-06T22:39:58+0100
Error index OCP\Files\ForbiddenException: Following symlinks is not allowed 2019-01-06T20:35:56+0100
Error core Following symlinks is not allowed (’/media/USBdrive/ncdata/involvex/.’ -> ‘/media/myCloudDrive/ncdata/involvex/’ not inside ‘/media/USBdrive/ncdata/involvex/’) 2019-01-06T20:35:56+0100
Error core Following symlinks is not allowed (’/media/USBdrive/ncdata/involvex/files’ -> ‘/media/myCloudDrive/ncdata/involvex/files/’ not inside ‘/media/USBdrive/ncdata/involvex/’) 2019-01-06T20:35:56+0100
Error core Following symlinks is not allowed (’/media/USBdrive/ncdata/involvex/cache’ -> ‘/media/myCloudDrive/ncdata/involvex/cache/’ not inside ‘/media/USBdrive/ncdata/involvex/’) 2019-01-06T20:35:56+0100
Warning core OCP\Files\ForbiddenException: Following symlinks is not allowed 2019-01-06T20:35:56+0100
Error core Following symlinks is not allowed (’/media/USBdrive/ncdata/involvex/cache’ -> ‘/media/myCloudDrive/ncdata/involvex/cache/’ not inside ‘/media/USBdrive/ncdata/involvex/’) 2019-01-06T20:35:56+0100
Error core Following symlinks is not allowed (’/media/USBdrive/ncdata/involvex/cache’ -> ‘/media/myCloudDrive/ncdata/involvex/cache/’ not inside ‘/media/USBdrive/ncdata/involvex/’) 2019-01-06T20:35:56+0100

2

I’m having a similar problem. I’m on version 15.0.5. Did you solve your problem?

Does someone else have hints on how to troubleshoot or to solve the problem ?

Here are my logs:

Error Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] Connection refused 2019-03-21T04:11:45-0400
Error Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] Connection refused 2019-03-21T04:11:45-0400
Error Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] Connection refused 2019-03-21T04:11:20-0400
Error PDO::__construct(): send of 119 bytes failed with errno=32 Broken pipe at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php#43 2019-03-21T04:05:03-0400
Error RedisException: read error on connection 2019-03-21T04:05:02-0400
Error RedisException: NOAUTH Authentication required. at /var/www/nextcloud/lib/private/Memcache/Redis.php#54 2019-03-21T04:05:02-0400
Error RedisException: read error on connection 2019-03-21T04:05:02-0400
Error RedisException: read error on connection 2019-03-21T04:05:02-0400
Error Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] Connection refused 2019-03-21T04:00:48-0400
Error Error while sending QUERY packet. PID=900 at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php#104 2019-03-21T03:59:42-0400
Error Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT * FROM oc_authtoken WHERE (token = ?) AND (version = ?)’ with params [“b0a864284fd52ff9e1815ba2359558a7074cd2dd9367529ebfa3b48860f0ff32e04c577be47dabbcc9af8836b02df8bd84a0251d698c932b707fd1216943ed19”, 2]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2019-03-21T03:59:45-0400
Error PDOStatement::execute(): Error reading result set’s header at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#105 2019-03-21T03:59:41-0400
Error PDOStatement::execute(): MySQL server has gone away at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#105 2019-03-21T03:59:39-0400
Error RedisException: read error on connection 2019-03-21T03:55:25-0400
Error RedisException: NOAUTH Authentication required. at /var/www/nextcloud/lib/private/Memcache/Redis.php#54 2019-03-21T03:30:06-0400
Error RedisException: read error on connection 2019-03-21T03:21:53-0400
Error RedisException: NOAUTH Authentication required. at /var/www/nextcloud/lib/private/Memcache/Redis.php#54 2019-03-21T02:45:07-0400
Error RedisException: read error on connection 2019-03-21T02:45:06-0400
Error Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT id, numeric_id, available, last_checked FROM oc_storages WHERE id IN (?)’ with params [“local::/media/external-nxtcloud/”]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2019-03-21T01:09:06-0400
Error Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT id, numeric_id, available, last_checked FROM oc_storages WHERE id IN (?)’ with params [“local::/media/external-nxtcloud/”]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2019-03-21T01:09:06-0400
Error Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT * FROM oc_authtoken WHERE (token = ?) AND (version = ?)’ with params [“f3a1c799fd9235ff14f53af765039b9ad0e145074bee04d089790619388773ce74b7975eea4fe811e4f1b11ba27b4ca94f5811c83c8a1e0dbf3c84c3f7c4ccd5”, 2]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2019-03-21T01:09:06-0400
Error Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT * FROM oc_authtoken WHERE (token = ?) AND (version = ?)’ with params [“9571ca9ea3770a22e4e09fa05d4ca58f2c3d53d783864f558c7300e351a9420b77f4b2bf8da550d4dd98af47032fb44e7a7cf941d4efdc83f538bc3098d927a9”, 2]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2019-03-21T01:09:06-0400
Error Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] Connection refused 2019-03-21T01:09:04-0400
Error Error while sending QUERY packet. PID=11427 at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php#104 2019-03-21T01:09:04-0400
Error Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] Connection refused 2019-03-21T01:09:03-0400
Error Error while sending QUERY packet. PID=11742 at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php#104 2019-03-21T01:09:03-0400
Error Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] Connection refused 2019-03-21T01:09:03-0400
Error Error while sending QUERY packet. PID=11548 at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php#104 2019-03-21T01:09:03-0400
Error Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT * FROM oc_authtoken WHERE (token = ?) AND (version = ?)’ with params [“f3a1c799fd9235ff14f53af765039b9ad0e145074bee04d089790619388773ce74b7975eea4fe811e4f1b11ba27b4ca94f5811c83c8a1e0dbf3c84c3f7c4ccd5”, 2]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2019-03-21T01:09:02-0400
Error Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT * FROM oc_authtoken WHERE (token = ?) AND (version = ?)’ with params [“9571ca9ea3770a22e4e09fa05d4ca58f2c3d53d783864f558c7300e351a9420b77f4b2bf8da550d4dd98af47032fb44e7a7cf941d4efdc83f538bc3098d927a9”, 2]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 2019-03-21T01:09:02-0400
Error Error while sending QUERY packet. PID=901 at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#105 2019-03-21T01:09:02-0400
Error Error while sending QUERY packet. PID=900 at /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#105 2019-03-21T01:09:02-0400
3

its pretty long ago, but since then i remember i reinstalled it atleast once got other issues and fixed them back there. But since then 1 update fixed it for me. So try updateing all your stuff or maybe try reinstalling.
nextcloudpi is pretty easy to install.

4

Thanks. I will try that.

5

I dont’t think it’s the same problem. It’s pretty obvious that you have a problem with your mysql-server which seemingly doesn’t run.