TB's of .part files - MySQL server has gone away & Exception: HTTP\/1.1 400 expected filesize

Hi everyone!

Looking for some help with one of our OC installations. Every couple of days I am finding about 1000 .part files with a total size of 1 to 2 TB. I then have to remove the files and do a “occ files:scan --all”.

Files are being uploaded using a Synology NAS and Cloudsync version 2.3.9-1050.
I am seeing 4 different errors in owncloud.log which can be found here: https://pastebin.com/raw/SgcFMTiJ

First issue: MySQL server has gone away. We have since tweaked the MySQL instance but this does not seem to help.
Second issue: Exception: HTTP/1.1 400 expected filesize 347911659 got 57540608. I have no idea what the issue might be. Is cloudsync not finishing the uploads?
Third issue: File(/tmp) is not within the allowed path(s). I believe the permissions are fine?
ls -all /tmp
drwxrwxrwt. 14 root root 4096 Nov 13 14:58 .
dr-xr-xr-x. 18 root root 258 Nov 13 09:57 …
Fourth issue: Error while sending QUERY packet. Could this be because of “max_allowed_packet” setting? What is the recommended setting for OC?

Any assistance or pointers are much appreciated. Thanks!

Hi Mark,

can you tell me what Version of ownCloud you are using?

Also I am not familiar with cloudsync. Is this some kind of ftp program?

Hi Dmitry,

We are running ownCloud 10.0.8 (stable).

Hey,

maybe it helps to update to the recent ownCloud Server 10.0.10 Release first?

I think it could be possible that the only pointer could be to check/search existing threads and possible existing solutions within these. Those messages seems to be coming up quite frequently, even outside of ownCloud.

https://dev.mysql.com/doc/refman/5.7/en/gone-away.html

https://doc.owncloud.org/server/latest/admin_manual/configuration/database/linux_database_configuration.html#how-to-workaround-general-error-2006-mysql-server-has-gone-away

https://www.garron.me/en/bits/file-is-not-within-the-allowed-path.html