Hallo allesamt,
ich habe NC auf meinem Webhoster installiert.
Ich bekomme bei Dateien die größer sind als 100MB immer einen Timeout ,sei es der Desktop Client oder irgendeine Android App (NC / FolderSync Lite).
Ich würde gerne einen Rat haben… könnte dieser Timeout durch eine zu langsame Schreibgeschwindigkeit am Webhoster liegen ? Dieser schreibt mit max 2048KB/sec.
Das Ganze läuft auf Apache 2.4.23 und PHP 7 und 10.1.16-MariaDB
NC-Log:
Fatal webdav Exception: {“Message”:“An exception occurred while executing ‘UPDATE oc_file_locks SET lock = -1, ttl = ? WHERE key = ? AND lock = 1’ with params [1472147020, “files\/b8a665807ecbe6115e43aa78764735d7”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Exception”:“Doctrine\DBAL\Exception\DriverException”,“Code”:0,“Trace”:"#0 /home/sauron/public_html/dnc/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/sauron/public_html/dnc/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(996): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘UPDATE oc_file...', Array)\n#2 \/home\/sauron\/public_html\/dnc\/lib\/private\/DB\/Connection.php(210): Doctrine\\DBAL\\Connection->executeUpdate('UPDATEoc_file…’, Array, Array)\n#3 /home/sauron/public_html/dnc/lib/private/Lock/DBLockingProvider.php(229): OC\DB\Connection->executeUpdate(‘UPDATE `oc_file…’, Array)\n#4 /home/sauron/public_html/dnc/lib/private/Files/Storage/Common.php(669): OC\Lock\DBLockingProvider->changeLock(‘files/b8a665807…’, 2)\n#5 /home/sauron/public_html/dnc/lib/private/Files/Storage/Wrapper/Wrapper.php(606): OC\Files\Storage\Common->changeLock(‘files/Photos/LG…’, 2, Object(OC\Lock\DBLockingProvider))\n#6 /home/sauron/public_html/dnc/lib/private/Files/Storage/Wrapper/Wrapper.php(606): OC\Files\Storage\Wrapper\Wrapper->changeLock(‘files/Photos/LG…’, 2, Object(OC\Lock\DBLockingProvider))\n#7 /home/sauron/public_html/dnc/lib/private/Files/View.php(1951): OC\Files\Storage\Wrapper\Wrapper->changeLock(‘files/Photos/LG…’, 2, Object(OC\Lock\DBLockingProvider))\n#8 /home/sauron/public_html/dnc/apps/dav/lib/Connector/Sabre/Node.php(349): OC\Files\View->changeLock(’/Photos/LG G3/2…’, 2)\n#9 /home/sauron/public_html/dnc/apps/dav/lib/Connector/Sabre/File.php(170): OCA\DAV\Connector\Sabre\Node->changeLock(2)\n#10 /home/sauron/public_html/dnc/apps/dav/lib/Connector/Sabre/Directory.php(137): OCA\DAV\Connector\Sabre\File->put(Resource id #457)\n#11 /home/sauron/public_html/dnc/3rdparty/sabre/dav/lib/DAV/Server.php(1036): OCA\DAV\Connector\Sabre\Directory->createFile(‘20141030_173522…’, Resource id #457)\n#12 /home/sauron/public_html/dnc/3rdparty/sabre/dav/lib/DAV/CorePlugin.php(523): Sabre\DAV\Server->createFile(‘files/ducky/Phot…’, Resource id #457, NULL)\n#13 [internal function]: Sabre\DAV\CorePlugin->httpPut(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))\n#14 /home/sauron/public_html/dnc/3rdparty/sabre/event/lib/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\n#15 /home/sauron/public_html/dnc/3rdparty/sabre/dav/lib/DAV/Server.php(459): Sabre\Event\EventEmitter->emit(‘method:PUT’, Array)\n#16 /home/sauron/public_html/dnc/3rdparty/sabre/dav/lib/DAV/Server.php(248): Sabre\DAV\Server->invokeMethod(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))\n#17 /home/sauron/public_html/dnc/apps/dav/lib/Server.php(184): Sabre\DAV\Server->exec()\n#18 /home/sauron/public_html/dnc/apps/dav/appinfo/v2/remote.php(30): OCA\DAV\Server->exec()\n#19 /home/sauron/public_html/dnc/remote.php(165): require_once(’/home/sauron/…’)\n#20 {main}",“File”:"/home/sauron/public_html/dnc/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",“Line”:116,“User”:“ducky”}
Error no app in context Exception: {“Exception”:“Doctrine\DBAL\Exception\DriverException”,“Message”:“An exception occurred while executing ‘SELECT fileid, storage, path, parent, name, mimetype, mimepart, size, mtime,\n\t\t\t\t\t storage_mtime, encrypted, etag, permissions, checksum\n\t\t\t\tFROM oc_filecache WHERE storage = ? AND path_hash = ?’ with params [“3”, “55be85fa257748b0e6ab02debda7338a”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Code”:0,“Trace”:"#0 /home/sauron/public_html/dnc/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/sauron/public_html/dnc/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘SELECT fileid…’, Array)\n#2 /home/sauron/public_html/dnc/lib/private/DB/Connection.php(189): Doctrine\DBAL\Connection->executeQuery(‘SELECT fileid…’, Array, Array, NULL)\n#3 /home/sauron/public_html/dnc/lib/private/Files/Cache/Cache.php(129): OC\DB\Connection->executeQuery(‘SELECT fileid…’, Array)\n#4 /home/sauron/public_html/dnc/lib/private/Files/Cache/HomeCache.php(76): OC\Files\Cache\Cache->get(‘files/Photos/LG…’)\n#5 /home/sauron/public_html/dnc/lib/private/Files/View.php(1285): OC\Files\Cache\HomeCache->get(‘files/Photos/LG…’)\n#6 /home/sauron/public_html/dnc/lib/private/Files/View.php(1338): OC\Files\View->getCacheEntry(Object(OCA\Files_Trashbin\Storage), ‘files/Photos/LG…’, ‘/Photos/LG G3/2…’)\n#7 /home/sauron/public_html/dnc/lib/private/Files/Node/HookConnector.php(144): OC\Files\View->getFileInfo(’/ducky/files/Pho…’)\n#8 /home/sauron/public_html/dnc/lib/private/Files/Node/HookConnector.php(78): OC\Files\Node\HookConnector->getNodeForPath(’/Photos/LG G3/2…’)\n#9 /home/sauron/public_html/dnc/lib/private/legacy/hook.php(106): OC\Files\Node\HookConnector->write(Array)\n#10 /home/sauron/public_html/dnc/apps/dav/lib/Connector/Sabre/File.php(267): OC_Hook::emit(‘OC_Filesystem’, ‘write’, Array)\n#11 /home/sauron/public_html/dnc/apps/dav/lib/Connector/Sabre/File.php(164): OCA\DAV\Connector\Sabre\File->emitPreHooks(false)\n#12 /home/sauron/public_html/dnc/apps/dav/lib/Connector/Sabre/Directory.php(137): OCA\DAV\Connector\Sabre\File->put(Resource id #457)\n#13 /home/sauron/public_html/dnc/3rdparty/sabre/dav/lib/DAV/Server.php(1036): OCA\DAV\Connector\Sabre\Directory->createFile(‘20141030_173522…’, Resource id #457)\n#14 /home/sauron/public_html/dnc/3rdparty/sabre/dav/lib/DAV/CorePlugin.php(523): Sabre\DAV\Server->createFile(‘files/ducky/Phot…’, Resource id #457, NULL)\n#15 [internal function]: Sabre\DAV\CorePlugin->httpPut(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))\n#16 /home/sauron/public_html/dnc/3rdparty/sabre/event/lib/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\n#17 /home/sauron/public_html/dnc/3rdparty/sabre/dav/lib/DAV/Server.php(459): Sabre\Event\EventEmitter->emit(‘method:PUT’, Array)\n#18 /home/sauron/public_html/dnc/3rdparty/sabre/dav/lib/DAV/Server.php(248): Sabre\DAV\Server->invokeMethod(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))\n#19 /home/sauron/public_html/dnc/apps/dav/lib/Server.php(184): Sabre\DAV\Server->exec()\n#20 /home/sauron/public_html/dnc/apps/dav/appinfo/v2/remote.php(30): OCA\DAV\Server->exec()\n#21 /home/sauron/public_html/dnc/remote.php(165): require_once(’/home/sauron/…’)\n#22 {main}",“File”:"/home/sauron/public_html/dnc/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",“Line”:116}
Schöne Grüße
Damir