I had to replace https:// with https—/ because forum software doesn’t allow for “more than two urls”.
Nextcloud version (eg, 10.0.2): 11.0.2?
Operating system and version (eg, Ubuntu 16.04): ? CentOS release 6.9 (Final)
Apache or nginx version (eg, Apache 2.4.25): Apache/2.2.15 (Unix)
PHP version (eg, 5.6): 7.1.7
Is this the first time you’ve seen this error?: t
Can you reliably replicate it? (If so, please outline steps):
N/A
The issue you are facing:
Auto updater failed at “create backup”.
Now my server is stuck in maintenance mode.
nextcloud.log:
{"reqId":"foo"
,"remoteAddr":"foo"
,"app":"webdav"
,"message":"Exception: {\"Message\":\"An exception occurred while executing 'INSERT INTO \\\"oc_file_locks\\\" (\\\"key\\\"
,\\\"lock\\\"
,\\\"ttl\\\") SELECT ?
,?
,? FROM \\\"oc_file_locks\\\" WHERE \\\"key\
\\" = ? HAVING COUNT(*) = 0' with params [\\\"files\\\\\\\/545d8foo\\\"
, 1
, 1503484093
, \\\"files\\\\\\\/545d8foo\\\"]:\\n\\nSQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint \\\"lock_key_index\\\"\\nDETAIL: Key (key)=(files\\\/545foo) already exists.\"
,\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\UniqueConstraintViolationException\"
,\"Code\":0
,\"Trace\":\"#0 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractPostgreSQLDriver->convertException('An exception oc...'
, Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(996): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOPgSql\\\\Driver)
, Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException)
, 'INSERT INTO \\\"oc...'
, Array)\\n#2 \
\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/lib\\\/private\\\/DB\\\/Connection.php(215): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO \\\"oc...'
, Array
, Array)\\n#3 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/lib\\\/private\\\/DB\\\/Adapter.php(114): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO \\\"oc...'
, Array)\\n#4 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/lib\\\/private\\\/DB\\\/Connection.php(253): OC\\\\DB\\\\Adapter->insertIfNotExist('*PREFIX*file_lo...'
, Array
, Array)\\n#5 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(118): OC\\\\DB\\\\Connection->insertIfNotExist('*PREFIX*file_lo...'
, Array
, Array)\\n#6 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/lib\\\/private\\\/Lock\\\/DBLockingProvider.php(163): OC\\\\Lock\\\\DBLockingProvider->initLockField('files\\\/545...'
, 1)\\n#7 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/lib\\\/private\\\/Files\\\/Storage\\\/Common.php(680): OC\\\\Lock\\\\DBLockingProvider->acquireLock('files\\\/545...'
, 1)\\n#8 \\\/var\\\/www
\\\/virtual\\\/myuser\\\/myserver.com\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(588): OC\\\\Files\\\\Storage\\\\Common->acquireLock('files\\\/tracks'
, 1
, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#9 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/lib\\\/private\\\/Files\\\/Storage\\\/Wrapper\\\/Wrapper.php(588): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/tracks'
, 1
, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#10 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/lib\\\/private\\\/Files\\\/View.php(1894): OC\\\\Files\\\\Storage\\\\Wrapper\\\\Wrapper->acquireLock('files\\\/tracks'
, 1
, Object(OC\\\\Lock\\\\DBLockingProvider))\\n#11 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/lib\\\/private\\\/Files\\\/View.php(2001): OC\\\\Files\\\\View->lockPath('\\\/tracks'
, 1)\\n#12 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/lib\\\/private\\\/Files\\\/View.php(1110): OC\\\\Files\\\\View->lockFile('\\\/tracks\\\/t186181...'
, 1)\\n#13 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/lib\\\/private\\\/Files\\\/View.php(967): OC\\\\Files\\
\\View->basicOperation('fopen'
, '\\\/tracks\\\/t186181...'
, Array
, 'rb')\\n#14 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/apps\\\/dav\\\/lib\\\/Connector\\\/Sabre\\\/File.php(305): OC\\\\Files\\\\View->fopen('tracks\\\/t1861818...'
, 'rb')\\n#15 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(85): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->get()\\n#16 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpGet(Object(Sabre\\\\HTTP\\\\Request)
, Object(Sabre\\\\HTTP\\\\Response))\\n#17
\\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array
, Array)\\n#18 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(479): Sabre\\\\Event\\\\EventEmitter->emit('method:GET'
, Array)\\n#19 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(254): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request)
, Object(Sabre\\\\HTTP\\\\Response))\\n
#20 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/apps\\\/dav\\\/lib\\\/Server.php(227): Sabre\\\\DAV\\\\Server->exec()\\n#21 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(30): OCA\\\\DAV\\\\Server->exec()\\n#22 \\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/remote.php(165): require_once('\\\/var\\\/www\\\/virtua...')\\n#23 {main}\"
,\"File\":\"\\\/var\\\/www\\\/virtual\\\/myuser\\\/myserver.com\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractPostgreSQLDrive
r.php\"
,\"Line\":63
,\"User\":\"myncuser\"}"
,"level":4
,"time":"2017-08-23T09:28:15+00:00"
,"method":"GET"
,"url":"\/remote.php\/dav\/files\/bla123\/tracks\/t18618181somefile"
,"user":"myncuser"
,"version":"11.0.2.7"}
updater.log:
2017-09-26T13:08:57+0200 KcmNiZHZyz [info] request to updater
2017-09-26T13:08:57+0200 KcmNiZHZyz [info] currentStep()
2017-09-26T13:08:57+0200 KcmNiZHZyz [info] show HTML page
2017-09-26T13:08:57+0200 KcmNiZHZyz [info] current version: 11.0.2 build time: 2017-02-26T19:43:43+00:00 f299c9b2f4cb98b6dcd79943882740f9b72dc3c0
2017-09-26T13:08:57+0200 KcmNiZHZyz [info] getUpdateServerResponse()
2017-09-26T13:08:57+0200 KcmNiZHZyz [info] updaterServer: https------/updates.nextcloud.org/updater_server/
2017-09-26T13:08:57+0200 KcmNiZHZyz [info] releaseChannel: stable
2017-09-26T13:08:57+0200 KcmNiZHZyz [info] internal version: 11.0.2.7
2017-09-26T13:08:58+0200 KcmNiZHZyz [info] getUpdateServerResponse response: Array
(
[version] => 11.0.5.1
[versionstring] => Nextcloud 11.0.5
[url] => https------/download.nextcloud.com/server/releases/nextcloud-11.0.5.zip
[web] => https------/docs.nextcloud.com/server/11/admin_manual/maintenance/upgrade.html
[autoupdater] => 1
[signature] => cHDTGRqT5giXS+sgbFsOxvpag1dZRbJdU5OJ1bHp4j1o4/WE5uGM/bEC96G3tbHM
AT/tOw71l6lMX3zDM9QAZxAY2ZnfnQoBGn6DiURFV7DR/xpEVLY4+d/yLMlpi9bE
y3l4SxnM0NDbF0brD168Oi4aKquccpXQmngEPK9JcRcN8OZ9PksKQmI8C78b/2b2
PWXMikNX9t2Ir7pMnCHUoeLAuN/7KVxbkDRKIqVp/7xPEwbFKS2g4YuF7NdA2WA5
HXOX96B1e8foC+zLoFn/BKhOWMFgOsPogn17xscfsNYsIC8kosegEp0qWmi3pFZ0
czpgycaoL8+t+4iHq4CLiA==
)
2017-09-26T13:08:58+0200 KcmNiZHZyz [info] checkForUpdate() Array
(
[version] => 11.0.5.1
[versionstring] => Nextcloud 11.0.5
[url] => https------/download.nextcloud.com/server/releases/nextcloud-11.0.5.zip
[web] => https------/docs.nextcloud.com/server/11/admin_manual/maintenance/upgrade.html
[autoupdater] => 1
[signature] => cHDTGRqT5giXS+sgbFsOxvpag1dZRbJdU5OJ1bHp4j1o4/WE5uGM/bEC96G3tbHM
AT/tOw71l6lMX3zDM9QAZxAY2ZnfnQoBGn6DiURFV7DR/xpEVLY4+d/yLMlpi9bE
y3l4SxnM0NDbF0brD168Oi4aKquccpXQmngEPK9JcRcN8OZ9PksKQmI8C78b/2b2
PWXMikNX9t2Ir7pMnCHUoeLAuN/7KVxbkDRKIqVp/7xPEwbFKS2g4YuF7NdA2WA5
HXOX96B1e8foC+zLoFn/BKhOWMFgOsPogn17xscfsNYsIC8kosegEp0qWmi3pFZ0
czpgycaoL8+t+4iHq4CLiA==
)
2017-09-26T13:08:58+0200 KcmNiZHZyz [info] end of checkForUpdate() Update to Nextcloud 11.0.5 available. (channel: "stable")<br /><span class="light">Following file will be downloaded automatically:</span> <code class="light">https------/download.nextcloud.com/server/releases/nextcl
oud-11.0.5.zip</code>
2017-09-26T13:09:01+0200 liN8olSQAu [info] request to updater
2017-09-26T13:09:01+0200 liN8olSQAu [info] currentStep()
2017-09-26T13:09:01+0200 liN8olSQAu [info] POST request for step "1"
2017-09-26T13:09:01+0200 liN8olSQAu [info] startStep("1")
2017-09-26T13:09:01+0200 liN8olSQAu [info] checkForExpectedFilesAndFolders()
2017-09-26T13:09:01+0200 liN8olSQAu [info] end of checkForExpectedFilesAndFolders()
2017-09-26T13:09:01+0200 liN8olSQAu [info] endStep("1")
2017-09-26T13:09:01+0200 dPfLz4B39S [info] request to updater
2017-09-26T13:09:01+0200 dPfLz4B39S [info] currentStep()
2017-09-26T13:09:01+0200 dPfLz4B39S [info] Step 1 is in state "end".
2017-09-26T13:09:01+0200 dPfLz4B39S [info] POST request for step "2"
2017-09-26T13:09:01+0200 dPfLz4B39S [info] startStep("2")
2017-09-26T13:09:01+0200 dPfLz4B39S [info] checkWritePermissions()
2017-09-26T13:09:10+0200 dPfLz4B39S [info] end of checkWritePermissions()
2017-09-26T13:09:10+0200 dPfLz4B39S [info] endStep("2")
2017-09-26T13:09:10+0200 0Yy7pykRGd [info] request to updater
2017-09-26T13:09:10+0200 0Yy7pykRGd [info] currentStep()
2017-09-26T13:09:10+0200 0Yy7pykRGd [info] Step 2 is in state "end".
2017-09-26T13:09:10+0200 0Yy7pykRGd [info] POST request for step "3"
2017-09-26T13:09:10+0200 0Yy7pykRGd [info] startStep("3")
2017-09-26T13:09:10+0200 0Yy7pykRGd [info] setMaintenanceMode("true")
2017-09-26T13:09:10+0200 0Yy7pykRGd [info] configFileName /var/www/virtual/myser/myserver.com/updater/../config/config.php
2017-09-26T13:09:10+0200 0Yy7pykRGd [info] end of setMaintenanceMode()
2017-09-26T13:09:10+0200 0Yy7pykRGd [info] endStep("3")
2017-09-26T13:09:10+0200 kB72ikajt8 [info] request to updater
2017-09-26T13:09:10+0200 kB72ikajt8 [info] currentStep()
2017-09-26T13:09:10+0200 kB72ikajt8 [info] Step 3 is in state "end".
2017-09-26T13:09:10+0200 kB72ikajt8 [info] POST request for step "4"
2017-09-26T13:09:10+0200 kB72ikajt8 [info] startStep("4")
2017-09-26T13:09:10+0200 kB72ikajt8 [info] createBackup()
2017-09-26T13:11:34+0200 kB72ikajt8 [info] end of createBackup()
2017-09-26T13:11:34+0200 kB72ikajt8 [info] endStep("4")
The output of your Nextcloud log in Admin > Logging:
Not possible, maintenance mode activated
The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => 'foo',
'passwordsalt' => 'foo',
'secret' => 'foo',
'trusted_domains' =>
array (
0 => 'myserver.com',
),
'datadirectory' => '/var/www/virtual/myuser/myserver.com/data',
'overwrite.cli.url' => 'https------/myserver.com',
'dbtype' => 'pgsql',
'version' => '11.0.2.7',
'dbname' => 'nextcloud',
'dbhost' => '/home/myuser/tmp',
'dbport' => '',
'dbtableprefix' => 'oc_',
'dbuser' => 'nextcloud',
'dbpassword' => 'foo',
'logtimezone' => 'UTC',
'installed' => true,
'maintenance' => true,
'theme' => '',
'loglevel' => 2,
'updater.secret' => 'foo',
);
The output of your Apache/nginx/system log in /var/log/____:
[crit] [client foo] (13)Permission denied: /var/www/virtual/myuser/myserver.com/data/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable
rights were: -rw-r--r--
How do I proceed from here?