Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Error while syncing/uploading large files #4392

Closed
GautamMKGarg opened this issue Apr 19, 2017 · 15 comments
Closed

Error while syncing/uploading large files #4392

GautamMKGarg opened this issue Apr 19, 2017 · 15 comments
Labels
needs info

Comments

@GautamMKGarg
Copy link

GautamMKGarg commented Apr 19, 2017 •
edited by MorrisJobke
Loading

Steps to reproduce

  1. Sync large file using desktop client (upload)
  2. All Chunks uploaded successfully
  3. I think error while combining them at server side.

Expected behaviour

Large file should uploaded and sync properly

Actual behaviour

Error occured

Server configuration

Operating system: Linux uk-m247-web19.main-hosting.eu 2.6.32-673.26.1.lve1.4.20.el6.x86_64 #1 SMP Tue Dec 27 17:42:53 EST 2016 x86_64

Web server: Apache (litespeed)

Database: mysql 10.0.28

PHP version: 7.0.18
Modules loaded: Core, date, libxml, openssl, pcre, sqlite3, zlib, bz2, calendar, ctype, curl, hash, filter, ftp, gettext, gmp, SPL, iconv, pcntl, readline, Reflection, session, standard, shmop, SimpleXML, mbstring, tokenizer, xml, litespeed, bcmath, dom, fileinfo, gd, imagick, imap, intl, Phar, json, exif, mcrypt, mysqlnd, mysqli, PDO, pdo_mysql, pdo_sqlite, posix, pspell, soap, sockets, tidy, wddx, xmlreader, xmlrpc, xmlwriter, xsl, zip, ionCube Loader

Nextcloud version: 11.0.2 (stable) - 11.0.2.7

Updated from an older Nextcloud/ownCloud or fresh install:

Where did you install Nextcloud from:

Signing status:

Signing status 
[]

List of activated apps:

App list 
Enabled:
 - activity: 2.4.1
 - comments: 1.1.0
 - dav: 1.1.1
 - federatedfilesharing: 1.1.1
 - files: 1.6.1
 - files_pdfviewer: 1.0.1
 - files_sharing: 1.1.1
 - files_texteditor: 2.2
 - files_trashbin: 1.1.0
 - files_versions: 1.4.0
 - files_videoplayer: 1.0.0
 - firstrunwizard: 2.0
 - gallery: 16.0.0
 - issuetemplate: 0.2.1
 - keeweb: 0.3.1
 - logreader: 2.0.0
 - lookup_server_connector: 1.0.0
 - nextcloud_announcements: 1.0
 - notifications: 1.0.1
 - password_policy: 1.1.0
 - provisioning_api: 1.1.0
 - serverinfo: 1.1.1
 - sharebymail: 1.0.1
 - survey_client: 0.1.5
 - systemtags: 1.1.3
 - theming: 1.1.1
 - twofactor_backupcodes: 1.0.0
 - updatenotification: 1.1.1
 - workflowengine: 1.1.1

Disabled:
 - admin_audit
 - encryption
 - external
 - federation
 - files_accesscontrol
 - files_automatedtagging
 - files_external
 - files_retention
 - templateeditor
 - user_external
 - user_ldap
 - user_saml

The content of config/config.php:

Config report 
{
    "instanceid": "ocjlvh4hdm3g",
    "passwordsalt": "***REMOVED SENSITIVE VALUE***",
    "secret": "***REMOVED SENSITIVE VALUE***",
    "trusted_domains": [
        "ggdrive.tk"
    ],
    "datadirectory": "\/home\/u298798049\/data",
    "overwrite.cli.url": "https:\/\/ggdrive.tk",
    "dbtype": "mysql",
    "version": "11.0.2.7",
    "dbname": "u298798049_db",
    "dbhost": "mysql.hostinger.in",
    "dbport": "",
    "dbtableprefix": "oc_",
    "dbuser": "***REMOVED SENSITIVE VALUE***",
    "dbpassword": "***REMOVED SENSITIVE VALUE***",
    "logtimezone": "UTC",
    "installed": true,
    "maintenance": false,
    "loglevel": 2,
    "mail_smtpmode": "php",
    "singleuser": false
}

Are you using external storage, if yes which one: files_external is disabled

Are you using encryption: no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

Client configuration

Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36

Operating system:

Logs

Desktop Client Logs

Desktop client log 
# timestamp | duration | file | instruction | dir | modtime | etag | size | fileId | status | errorString | http result code | other size | other modtime | other etag | other fileId | other instruction
#=#=#=# Syncrun started  until  (0 msec)
|0|College/July 2011/Momentum '11/Video clips/Official.mp4|INST_NEW|Up|1325714466||207222697||1|Error downloading https://ggdrive.tk/remote.php/webdav/Memories/College/July 2011/Momentum '11/Video clips/Official.mp4-chunking-3097873139-396-302 - server replied: Service Unavailable|503|0|0|||INST_NONE|
|0|College/July 2011 - June 2012/Antenna Fabrication/cst.mp4|INST_NEW|Up|1340134902||96367481||1|Error downloading https://ggdrive.tk/remote.php/webdav/Memories/College/July 2011 - June 2012/Antenna Fabrication/cst.mp4-chunking-1016173710-184-39 - server replied: Service Unavailable|503|0|0|||INST_NONE|
|0|College/July 2011 - June 2012/Friendship Day/MOV00006.3gp|INST_NEW|Up|1372276195||139427891||2|Error downloading https://ggdrive.tk/remote.php/webdav/Memories/College/July 2011 - June 2012/Friendship Day/MOV00006.3gp-chunking-3522196201-266-3 - server replied: Internal Server Error (An exception occurred while executing 'SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`,
					   `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`
				FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?' with params [1, "aca0c3d2c5b8bfbf744a476097d536a0"]:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away)|500|0|0|||INST_NONE|

Nextcloud log (data/nextcloud.log)

Nextcloud log 
{"reqId":"WPcg0X8AAAEABQEkGLoAAAAp","remoteAddr":"103.217.245.171","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 500 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 [1, \\\"b8cba9a24a103d663e2d77018aeb9c00\\\"]:\\n\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\",\"Exception\":\"Sabre\\\\DAV\\\\Exception\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(106): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->convertToSabreException(Object(Doctrine\\\\DBAL\\\\Exception\\\\DriverException))\\n#1 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/Directory.php(137): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->put(Resource id #440)\\n#2 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1072): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('MOV00006.3gp-ch...', Resource id #440)\\n#3 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(525): Sabre\\\\DAV\\\\Server->createFile('Memories\\\/Colleg...', Resource id #440, NULL)\\n#4 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#5 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#6 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#7 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#8 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(60): Sabre\\\\DAV\\\\Server->exec()\\n#9 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(165): require_once('\\\/home\\\/u29879804...')\\n#10 {main}\",\"File\":\"\\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php\",\"Line\":557,\"User\":\"admingg\"}","level":4,"time":"2017-04-19T08:34:06+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011%20-%20June%202012\/Friendship%20Day\/MOV00006.3gp-chunking-3521671913-133-4","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcg1H8AAAEABMdjljwAAAAL","remoteAddr":"103.217.245.171","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 503 Doctrine\\\\DBAL\\\\Exception\\\\DriverException: An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE LOWER(`uid`) = LOWER(?)' with params [\\\"admingg\\\"]:\\n\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\",\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\ServiceUnavailable\",\"Code\":0,\"Trace\":\"#0 [internal function]: {closure}(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#1 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Object(Closure), Array)\\n#2 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(466): Sabre\\\\Event\\\\EventEmitter->emit('beforeMethod', Array)\\n#3 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#4 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(70): Sabre\\\\DAV\\\\Server->exec()\\n#5 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(168): handleException(Object(Doctrine\\\\DBAL\\\\Exception\\\\DriverException))\\n#6 {main}\",\"File\":\"\\\/home\\\/u298798049\\\/public_html\\\/remote.php\",\"Line\":68,\"User\":\"admingg\"}","level":4,"time":"2017-04-19T08:34:06+00:00","method":"PROPFIND","url":"\/remote.php\/webdav\/Project","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcg1n8AAAEABMe1maQAAAAc","remoteAddr":"103.217.245.171","app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/home\/u298798049\/public_html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php#91","level":3,"time":"2017-04-19T08:34:06+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011\/Momentum%20'11\/Video%20clips\/Official.mp4-chunking-3099446003-198-29","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcg1n8AAAEABMe1maQAAAAc","remoteAddr":"103.217.245.171","app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/home\/u298798049\/public_html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php#91","level":3,"time":"2017-04-19T08:34:06+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011\/Momentum%20'11\/Video%20clips\/Official.mp4-chunking-3099446003-198-29","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcg1n8AAAEABMe1maQAAAAc","remoteAddr":"103.217.245.171","app":"remote","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE LOWER(`uid`) = LOWER(?)' with params [\\\"admingg\\\"]:\\n\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Statement.php(177): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT `uid`, `...', Array)\\n#2 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/db\\\/statementwrapper.php(74): Doctrine\\\\DBAL\\\\Statement->execute(Array)\\n#3 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Database.php(242): OC_DB_StatementWrapper->execute(Array)\\n#4 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Database.php(291): OC\\\\User\\\\Database->loadUser('admingg')\\n#5 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Manager.php(132): OC\\\\User\\\\Database->userExists('admingg')\\n#6 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Session.php(205): OC\\\\User\\\\Manager->get('admingg')\\n#7 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/app.php(324): OC\\\\User\\\\Session->getUser()\\n#8 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/app.php(111): OC_App::getEnabledApps()\\n#9 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/user.php(128): OC_App::loadApps(Array)\\n#10 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/base.php(745): OC_User::setupBackends()\\n#11 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/base.php(1092): OC::init()\\n#12 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(110): require_once('\\\/home\\\/u29879804...')\\n#13 {main}\",\"File\":\"\\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":116}","level":3,"time":"2017-04-19T08:34:06+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011\/Momentum%20'11\/Video%20clips\/Official.mp4-chunking-3099446003-198-29","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcg1n8AAAEABMe1maQAAAAc","remoteAddr":"103.217.245.171","app":"core","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE LOWER(`uid`) = LOWER(?)' with params [\\\"admingg\\\"]:\\n\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Statement.php(177): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT `uid`, `...', Array)\\n#2 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/db\\\/statementwrapper.php(74): Doctrine\\\\DBAL\\\\Statement->execute(Array)\\n#3 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Database.php(242): OC_DB_StatementWrapper->execute(Array)\\n#4 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Database.php(291): OC\\\\User\\\\Database->loadUser('admingg')\\n#5 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Manager.php(132): OC\\\\User\\\\Database->userExists('admingg')\\n#6 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Session.php(205): OC\\\\User\\\\Manager->get('admingg')\\n#7 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/app.php(324): OC\\\\User\\\\Session->getUser()\\n#8 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/app.php(111): OC_App::getEnabledApps()\\n#9 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/user.php(128): OC_App::loadApps(Array)\\n#10 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/base.php(745): OC_User::setupBackends()\\n#11 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/base.php(1092): OC::init()\\n#12 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(110): require_once('\\\/home\\\/u29879804...')\\n#13 {main}\",\"File\":\"\\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":116}","level":3,"time":"2017-04-19T08:34:06+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011\/Momentum%20'11\/Video%20clips\/Official.mp4-chunking-3099446003-198-29","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcg1n8AAAEABMe1maQAAAAc","remoteAddr":"103.217.245.171","app":"core","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE LOWER(`uid`) = LOWER(?)' with params [\\\"admingg\\\"]:\\n\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Statement.php(177): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT `uid`, `...', Array)\\n#2 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/db\\\/statementwrapper.php(74): Doctrine\\\\DBAL\\\\Statement->execute(Array)\\n#3 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Database.php(242): OC_DB_StatementWrapper->execute(Array)\\n#4 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Database.php(291): OC\\\\User\\\\Database->loadUser('admingg')\\n#5 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Manager.php(132): OC\\\\User\\\\Database->userExists('admingg')\\n#6 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Session.php(205): OC\\\\User\\\\Manager->get('admingg')\\n#7 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/L10N\\\/Factory.php(135): OC\\\\User\\\\Session->getUser()\\n#8 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/util.php(526): OC\\\\L10N\\\\Factory->findLanguage('search')\\n#9 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/util.php(499): OC_Util::addTranslations('search')\\n#10 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/template.php(140): OC_Util::addScript('search', 'search', true)\\n#11 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/template.php(74): OC_Template::initTemplateEngine('error')\\n#12 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/template.php(351): OC_Template->__construct('', 'exception', 'error', false)\\n#13 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(83): OC_Template::printExceptionErrorPage(Object(Doctrine\\\\DBAL\\\\Exception\\\\DriverException))\\n#14 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(168): handleException(Object(Doctrine\\\\DBAL\\\\Exception\\\\DriverException))\\n#15 {main}\",\"File\":\"\\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":116}","level":3,"time":"2017-04-19T08:34:06+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011\/Momentum%20'11\/Video%20clips\/Official.mp4-chunking-3099446003-198-29","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcpC38AAAEABW4jqj8AAAAX","remoteAddr":"103.217.245.171","app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/home\/u298798049\/public_html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php#91","level":3,"time":"2017-04-19T09:09:43+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011%20-%20June%202012\/Antenna%20Fabrication\/cst.mp4-chunking-1016173710-184-9","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcpC38AAAEABW4jqj8AAAAX","remoteAddr":"103.217.245.171","app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/home\/u298798049\/public_html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php#91","level":3,"time":"2017-04-19T09:09:43+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011%20-%20June%202012\/Antenna%20Fabrication\/cst.mp4-chunking-1016173710-184-9","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcpC38AAAEABW4jqj8AAAAX","remoteAddr":"103.217.245.171","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 500 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 [1, \\\"3a26f6c240b4194da0ca8ef639bb1a70\\\"]:\\n\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\",\"Exception\":\"Sabre\\\\DAV\\\\Exception\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(491): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->convertToSabreException(Object(Doctrine\\\\DBAL\\\\Exception\\\\DriverException))\\n#1 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(104): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->createFileChunked(Resource id #440)\\n#2 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/Directory.php(137): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->put(Resource id #440)\\n#3 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1072): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('cst.mp4-chunkin...', Resource id #440)\\n#4 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(525): Sabre\\\\DAV\\\\Server->createFile('Memories\\\/Colleg...', Resource id #440, NULL)\\n#5 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#6 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#7 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#8 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#9 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(60): Sabre\\\\DAV\\\\Server->exec()\\n#10 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(165): require_once('\\\/home\\\/u29879804...')\\n#11 {main}\",\"File\":\"\\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php\",\"Line\":557,\"User\":\"admingg\"}","level":4,"time":"2017-04-19T09:09:43+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011%20-%20June%202012\/Antenna%20Fabrication\/cst.mp4-chunking-1016173710-184-9","user":"admingg","version":"11.0.2.7"}
^C
-bash-4.1$ tail -f nextcloud.log
{"reqId":"WPcg0X8AAAEABQEkGLoAAAAp","remoteAddr":"103.217.245.171","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 500 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 [1, \\\"b8cba9a24a103d663e2d77018aeb9c00\\\"]:\\n\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\",\"Exception\":\"Sabre\\\\DAV\\\\Exception\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(106): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->convertToSabreException(Object(Doctrine\\\\DBAL\\\\Exception\\\\DriverException))\\n#1 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/Directory.php(137): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->put(Resource id #440)\\n#2 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1072): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('MOV00006.3gp-ch...', Resource id #440)\\n#3 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(525): Sabre\\\\DAV\\\\Server->createFile('Memories\\\/Colleg...', Resource id #440, NULL)\\n#4 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#5 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#6 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#7 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#8 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(60): Sabre\\\\DAV\\\\Server->exec()\\n#9 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(165): require_once('\\\/home\\\/u29879804...')\\n#10 {main}\",\"File\":\"\\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php\",\"Line\":557,\"User\":\"admingg\"}","level":4,"time":"2017-04-19T08:34:06+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011%20-%20June%202012\/Friendship%20Day\/MOV00006.3gp-chunking-3521671913-133-4","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcg1H8AAAEABMdjljwAAAAL","remoteAddr":"103.217.245.171","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 503 Doctrine\\\\DBAL\\\\Exception\\\\DriverException: An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE LOWER(`uid`) = LOWER(?)' with params [\\\"admingg\\\"]:\\n\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\",\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\ServiceUnavailable\",\"Code\":0,\"Trace\":\"#0 [internal function]: {closure}(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#1 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Object(Closure), Array)\\n#2 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(466): Sabre\\\\Event\\\\EventEmitter->emit('beforeMethod', Array)\\n#3 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#4 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(70): Sabre\\\\DAV\\\\Server->exec()\\n#5 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(168): handleException(Object(Doctrine\\\\DBAL\\\\Exception\\\\DriverException))\\n#6 {main}\",\"File\":\"\\\/home\\\/u298798049\\\/public_html\\\/remote.php\",\"Line\":68,\"User\":\"admingg\"}","level":4,"time":"2017-04-19T08:34:06+00:00","method":"PROPFIND","url":"\/remote.php\/webdav\/Project","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcg1n8AAAEABMe1maQAAAAc","remoteAddr":"103.217.245.171","app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/home\/u298798049\/public_html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php#91","level":3,"time":"2017-04-19T08:34:06+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011\/Momentum%20'11\/Video%20clips\/Official.mp4-chunking-3099446003-198-29","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcg1n8AAAEABMe1maQAAAAc","remoteAddr":"103.217.245.171","app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/home\/u298798049\/public_html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php#91","level":3,"time":"2017-04-19T08:34:06+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011\/Momentum%20'11\/Video%20clips\/Official.mp4-chunking-3099446003-198-29","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcg1n8AAAEABMe1maQAAAAc","remoteAddr":"103.217.245.171","app":"remote","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE LOWER(`uid`) = LOWER(?)' with params [\\\"admingg\\\"]:\\n\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Statement.php(177): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT `uid`, `...', Array)\\n#2 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/db\\\/statementwrapper.php(74): Doctrine\\\\DBAL\\\\Statement->execute(Array)\\n#3 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Database.php(242): OC_DB_StatementWrapper->execute(Array)\\n#4 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Database.php(291): OC\\\\User\\\\Database->loadUser('admingg')\\n#5 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Manager.php(132): OC\\\\User\\\\Database->userExists('admingg')\\n#6 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Session.php(205): OC\\\\User\\\\Manager->get('admingg')\\n#7 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/app.php(324): OC\\\\User\\\\Session->getUser()\\n#8 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/app.php(111): OC_App::getEnabledApps()\\n#9 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/user.php(128): OC_App::loadApps(Array)\\n#10 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/base.php(745): OC_User::setupBackends()\\n#11 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/base.php(1092): OC::init()\\n#12 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(110): require_once('\\\/home\\\/u29879804...')\\n#13 {main}\",\"File\":\"\\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":116}","level":3,"time":"2017-04-19T08:34:06+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011\/Momentum%20'11\/Video%20clips\/Official.mp4-chunking-3099446003-198-29","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcg1n8AAAEABMe1maQAAAAc","remoteAddr":"103.217.245.171","app":"core","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE LOWER(`uid`) = LOWER(?)' with params [\\\"admingg\\\"]:\\n\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Statement.php(177): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT `uid`, `...', Array)\\n#2 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/db\\\/statementwrapper.php(74): Doctrine\\\\DBAL\\\\Statement->execute(Array)\\n#3 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Database.php(242): OC_DB_StatementWrapper->execute(Array)\\n#4 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Database.php(291): OC\\\\User\\\\Database->loadUser('admingg')\\n#5 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Manager.php(132): OC\\\\User\\\\Database->userExists('admingg')\\n#6 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Session.php(205): OC\\\\User\\\\Manager->get('admingg')\\n#7 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/app.php(324): OC\\\\User\\\\Session->getUser()\\n#8 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/app.php(111): OC_App::getEnabledApps()\\n#9 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/user.php(128): OC_App::loadApps(Array)\\n#10 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/base.php(745): OC_User::setupBackends()\\n#11 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/base.php(1092): OC::init()\\n#12 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(110): require_once('\\\/home\\\/u29879804...')\\n#13 {main}\",\"File\":\"\\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":116}","level":3,"time":"2017-04-19T08:34:06+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011\/Momentum%20'11\/Video%20clips\/Official.mp4-chunking-3099446003-198-29","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcg1n8AAAEABMe1maQAAAAc","remoteAddr":"103.217.245.171","app":"core","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` WHERE LOWER(`uid`) = LOWER(?)' with params [\\\"admingg\\\"]:\\n\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Statement.php(177): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT `uid`, `...', Array)\\n#2 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/db\\\/statementwrapper.php(74): Doctrine\\\\DBAL\\\\Statement->execute(Array)\\n#3 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Database.php(242): OC_DB_StatementWrapper->execute(Array)\\n#4 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Database.php(291): OC\\\\User\\\\Database->loadUser('admingg')\\n#5 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Manager.php(132): OC\\\\User\\\\Database->userExists('admingg')\\n#6 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/User\\\/Session.php(205): OC\\\\User\\\\Manager->get('admingg')\\n#7 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/L10N\\\/Factory.php(135): OC\\\\User\\\\Session->getUser()\\n#8 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/util.php(526): OC\\\\L10N\\\\Factory->findLanguage('search')\\n#9 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/util.php(499): OC_Util::addTranslations('search')\\n#10 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/template.php(140): OC_Util::addScript('search', 'search', true)\\n#11 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/template.php(74): OC_Template::initTemplateEngine('error')\\n#12 \\\/home\\\/u298798049\\\/public_html\\\/lib\\\/private\\\/legacy\\\/template.php(351): OC_Template->__construct('', 'exception', 'error', false)\\n#13 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(83): OC_Template::printExceptionErrorPage(Object(Doctrine\\\\DBAL\\\\Exception\\\\DriverException))\\n#14 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(168): handleException(Object(Doctrine\\\\DBAL\\\\Exception\\\\DriverException))\\n#15 {main}\",\"File\":\"\\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":116}","level":3,"time":"2017-04-19T08:34:06+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011\/Momentum%20'11\/Video%20clips\/Official.mp4-chunking-3099446003-198-29","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcpC38AAAEABW4jqj8AAAAX","remoteAddr":"103.217.245.171","app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/home\/u298798049\/public_html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php#91","level":3,"time":"2017-04-19T09:09:43+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011%20-%20June%202012\/Antenna%20Fabrication\/cst.mp4-chunking-1016173710-184-9","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcpC38AAAEABW4jqj8AAAAX","remoteAddr":"103.217.245.171","app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/home\/u298798049\/public_html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php#91","level":3,"time":"2017-04-19T09:09:43+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011%20-%20June%202012\/Antenna%20Fabrication\/cst.mp4-chunking-1016173710-184-9","user":"admingg","version":"11.0.2.7"}
{"reqId":"WPcpC38AAAEABW4jqj8AAAAX","remoteAddr":"103.217.245.171","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 500 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 [1, \\\"3a26f6c240b4194da0ca8ef639bb1a70\\\"]:\\n\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\",\"Exception\":\"Sabre\\\\DAV\\\\Exception\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(491): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->convertToSabreException(Object(Doctrine\\\\DBAL\\\\Exception\\\\DriverException))\\n#1 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(104): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->createFileChunked(Resource id #440)\\n#2 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/Directory.php(137): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->put(Resource id #440)\\n#3 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1072): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('cst.mp4-chunkin...', Resource id #440)\\n#4 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(525): Sabre\\\\DAV\\\\Server->createFile('Memories\\\/Colleg...', Resource id #440, NULL)\\n#5 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#6 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#7 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#8 \\\/home\\\/u298798049\\\/public_html\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#9 \\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(60): Sabre\\\\DAV\\\\Server->exec()\\n#10 \\\/home\\\/u298798049\\\/public_html\\\/remote.php(165): require_once('\\\/home\\\/u29879804...')\\n#11 {main}\",\"File\":\"\\\/home\\\/u298798049\\\/public_html\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php\",\"Line\":557,\"User\":\"admingg\"}","level":4,"time":"2017-04-19T09:09:43+00:00","method":"PUT","url":"\/remote.php\/webdav\/Memories\/College\/July%202011%20-%20June%202012\/Antenna%20Fabrication\/cst.mp4-chunking-1016173710-184-9","user":"admingg","version":"11.0.2.7"}
@Stibila
Copy link

Stibila commented Apr 20, 2017

Can you provide error logs? Also how large is the file and what filesystem is on your server?

@GautamMKGarg
Copy link
Author

GautamMKGarg commented Apr 20, 2017 •
edited
Loading

Error logs, I have provided in the description above.
File size: 91 MB and several other files of various sizes
Filesystem: I am on shared hosting server, df command is not working, I could not check filesystem.

@Stibila
Copy link

Stibila commented Apr 20, 2017

You provided server configuration, not logs.
91MB isn't that large, I thought it is something beyond capability of filesystem.

@Stibila
Copy link

Stibila commented Apr 20, 2017 •
edited
Loading

But on second thought 91 MB is beyond default php configuration. Check php configuration 'upload_max_filesize'. You may not be able to edit this on shared hosting.

@GautamMKGarg
Copy link
Author

upload_max_filesize = 128MB
Please click on app list, error logs are hidden beyond it, I don't know how, but they got hidden.

@Stibila
Copy link

Stibila commented Apr 20, 2017

"General error: 2006 MySQL server has gone away"
Looks like MySQL connection timed out. Check out https://dev.mysql.com/doc/refman/5.7/en/gone-away.html

@GautamMKGarg
Copy link
Author

from bellow link, I followed instruction by "ManoM" and reduced the OWNCLOUD_CHUNK_SIZE to 512 KB
now, most of "General error: 2006 MySQL server has gone away" issues are resolved.

https://forum.owncloud.org/viewtopic.php?t=26712

but still facing some issue while uploading large files. I was continuously monitoring my webserver while uploading cst.mp4 which was of size 91 MB. while syncing the file, chunks of size 512 KB each were getting uploaded one by one. All the 183 chunks got uploaded in the cache folder. After that nextcloud started joining those chunks to one file in webserver. Count of chunks started getting reduced, I think nextcloud was joining them and deleting them from cache folder. after some time, error was shown in desktop client and when I check cache folder in webserver, chunks which were getting deleted were stoped in between. I think issue occuered while joining the chunks back. I am using shared hosting, hence can't change much in the server configuration. I think there should be self healing and recovery machanism in the webserver to handle such cases. so that, It can be resumed later. After this error, this file, "cst.mp4" went to lock state, and I started getting error that file is locked, Then I had to clear Lock table in the mysql db.
I hope this explaination will help the team to replicate the issue.

@MorrisJobke
Copy link
Member

Without the error and the log we can't do much here. Please provide this information first.

@GautamMKGarg
Copy link
Author

Please click on app list, error logs are hidden beyond it, I don't know how, but they got hidden.

@MorrisJobke
Copy link
Member

Please click on app list, error logs are hidden beyond it, I don't know how, but they got hidden.

Ah ... this is a little bit broken syntax. let me fix this.

@MorrisJobke
Copy link
Member

Please click on app list, error logs are hidden beyond it, I don't know how, but they got hidden.

Looking at the logs: There are only "Mysql has gone away messages. Could I ask you to open a new ticket. This here is clearly because of the mysql server issue. Please provide new logs where the MySQL server is available.

Thanks

@GautamMKGarg
Copy link
Author

yes, "mysql gone" may be the reason of file upload error but can't be handle such cases in coding, so that file upload resumes if such cases occurs. while uploading large file, chances of mysql or php issues are also large. Can't we handle and resume uploading of such cases. On 20 april, I have mentioned all the steps by which we can replicate the issue please refer below link.
#4392 (comment)

@MorrisJobke
Copy link
Member

while uploading large file, chances of mysql or php issues are also large.

What? Usually there shouldn't be any such cases.

yes, "mysql gone" may be the reason of file upload error but can't be handle such cases in coding, so that file upload resumes if such cases occurs.

We go into "server not available" mode once the mysql is gone and then in operation once the mysql is available again. This is more a client issue. In the web UI there is no other way then to ask the user to retry.

@GautamMKGarg
Copy link
Author

GautamMKGarg commented May 15, 2017 •
edited
Loading

I have not uploaded file using web UI, I am using desktop client. I tried to upload same file several times, more that 20 times. But still there is no success. Every time I am facing similar issues. If you want, I can give you access to my logs and create your account in my nextcloud server. Please provide me email id. you can try to upload large file and check.

@MorrisJobke
Copy link
Member

Please ask in the forums for help to make MySQL and PHP more stable. If they fail there is a reason. Nevertheless we will try to make the desktop client more stable, but with mysql failures on every upload we can't do much.

@nextcloud-bot nextcloud-bot mentioned this issue Jun 29, 2018
Closed
@nextcloud-bot nextcloud-bot mentioned this issue Sep 23, 2018
Closed
This was referenced Oct 10, 2018
Closed
Closed
Closed
@nextcloud-bot nextcloud-bot mentioned this issue Nov 7, 2018
Closed
@nextcloud-bot nextcloud-bot mentioned this issue Nov 14, 2018
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
needs info
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@MorrisJobke @Stibila @GautamMKGarg