Hello,
I have a problem with my cloud. After fixing that Apache issue, now I see that I can not upload video files on cloud from my iPhone.
I've looked into logs and I saw the output below.
On this server I use:
DEBIAN 3.16.39-1 (2016-12-30) x86_64
PHP 7.0.15
Apache 2.4.25
MariaDB 10.1.21
upload_max_filesize = 2G
OwnCloud version: 9.1.2 Stable
Error:
Exception: {"Message":"An exception occurred while executing 'UPDATE
oc_file_locks
SETlock
= -1,ttl
= ? WHEREkey
= ? ANDlock
= 1' with params [1486382928, \"files\\/c688b56183bbbe4df954608c593b87bf\"]:\n\nSQLSTATE[HY000]:
General error: 2006 MySQL server has gone away","Exception":"
Doctrine\DBAL\Exception\DriverException","Code":0,"Trace":"#0 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(116):
Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))\n#1 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(996):
Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'UPDATEoc_file...', Array)\n#2 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/lib\/private\/DB\/Connection.php(209):
oc_file...', Array, Array)\n#3 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/lib\/private\/Lock\/DBLockingProvider.php(228): OC\\DB\\Connection->executeUpdate('UPDATE`oc_file...', Array)\n#4 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/lib\/private\/Files\/Storage\/Common.php(686):
Doctrine\\DBAL\\Connection->executeUpdate('UPDATE
OC\Lock\DBLockingProvider->changeLock('files\/c688b5618...', 2)\n#5 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/lib\/private\/Files\/Storage\/Wrapper\/Wrapper.php(608):
OC\Files\Storage\Common->changeLock('files\/Photos\/20...', 2, Object(OC\Lock\DBLockingProvider))\n#6 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/lib\/private\/Files\/Storage\/Wrapper\/Wrapper.php(608):
OC\Files\Storage\Wrapper\Wrapper->changeLock('files\/Photos\/20...', 2, Object(OC\Lock\DBLockingProvider))\n#7 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/lib\/private\/Files\/View.php(1956):
OC\Files\Storage\Wrapper\Wrapper->changeLock('files\/Photos\/20...', 2, Object(OC\Lock\DBLockingProvider))\n#8 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/apps\/dav\/lib\/Connector\/Sabre\/Node.php(348):
OC\Files\View->changeLock('\/Photos\/2017\/fe...', 2)\n#9 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/apps\/dav\/lib\/Connector\/Sabre\/File.php(169):
OCA\DAV\Connector\Sabre\Node->changeLock(2)\n#10 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/apps\/dav\/lib\/Connector\/Sabre\/Directory.php(136):
OCA\DAV\Connector\Sabre\File->put(Resource id #369)\n#11 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(1036):
OCA\DAV\Connector\Sabre\Directory->createFile('Video-2017-02-0...', Resource id #369)\n#12 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/3rdparty\/sabre\/dav\/lib\/DAV\/CorePlugin.php(523):
Sabre\DAV\Server->createFile('Photos\/2017\/feb...', Resource id #369, NULL)\n#13 [internal function]:
Sabre\DAV\CorePlugin->httpPut(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))\n#14 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105):
call_user_func_array(Array, Array)\n#15 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(459):
Sabre\Event\EventEmitter->emit('method:PUT', Array)\n#16 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(248):
Sabre\DAV\Server->invokeMethod(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))\n#17 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/apps\/dav\/appinfo\/v1\/webdav.php(56):
Sabre\DAV\Server->exec()\n#18 \/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/remote.php(164):
require_once('\/home\/USER\/doma...')\n#19 {main}","File":"\/home\/USER\/domains\/mydomain.TLD\/public_html\/cloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php","Line":115,"User":"USERNAME"}
Any ideas?
Thank you!