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


#1

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!


#2

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?


#3

Hi Dmitry,

We are running ownCloud 10.0.8 (stable).


#4

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