Upgrade Issue

[bueste]

Hi all
I've the same issue when I update from command line or from webupdater:

Update vorbereiten
Log-Level auf "debug" gesetzt
Wartungsmodus eingeschaltet
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT DISTINCT(TABLE_NAME) AS table FROM INFORMATION_SCHEMA . COLUMNS WHERE TABLE_SCHEMA = ? AND (COLLATION_NAME <> 'utf8_bin' OR CHARACTER_SET_NAME <> 'utf8') AND TABLE_NAME LIKE "oc_%"' with params ["nextcloud_db"]: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_25eb_0.MAI' (Errcode: 2)

Can anyone help?

Thx
Stefan

[MariusBluem]

Hi Stefan,

Please fill out the issue template 😅
Only with this information we are able to reproduce - and help you best 💪 THX!

[bueste]

Server configuration

Operating system: Centos 7

Web server: Apache 2.4.6

Database: MariaDB 10.1

PHP version: 7.0.14

Nextcloud version: 11.0 (Upgrade from lastest 10.0 to 11.0)

Updated from an older Nextcloud/ownCloud or fresh install: Updated from 10

Where did you install Nextcloud from: I use this Howto: https://www.canox.net/2016/12/upgrade-nextcloud-10-0-2-11-0-0/ - of course with the apache user from centos www-data is debian based

List of activated apps:
App list none

The content of config/config.php:
Config report

$CONFIG = array (
'instanceid' => 'ocuidqhd0v6x',
'passwordsalt' =>'passwordsalted',
'secret' => 'secret',
'trusted_domains' =>
array (
0 => 'server',
),
'datadirectory' => '/var/www/owncloud/data',
'overwrite.cli.url' => 'https://url',
'dbtype' => 'mysql',
'version' => '9.1.2.2',
'dbname' => 'nextcloud_db',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'dbuser' => 'nextcloud_db',
'dbpassword' => 'password',
'logtimezone' => 'UTC',
'installed' => true,
'mail_smtpmode' => 'smtp',
'mail_smtpsecure' => 'tls',
'mail_from_address' => 'user',
'mail_domain' => 'domain',
'mail_smtpauth' => 1,
'mail_smtpauthtype' => 'LOGIN',
'mail_smtphost' => 'smtp.office365.com',
'mail_smtpport' => '587',
'mail_smtpname' => 'mail',
'mail_smtppassword' => 'password',
'updater.secret' => '$2y$10$nE56YJtob17TZqNItU5SQudmctGDR0BfvJ7ajzQIw.FOKHXVAX2oe',
'maintenance' => false,
'theme' => '',
'loglevel' => 2,
'updater.release.channel' => 'stable
',
);

Are you using external storage, if yes which one: local/smb/sftp/... no

Are you using encryption: no

Client configuration

Browser:

Operating system:

Nextcloud log (data/nextcloud.log)

{"reqId":"pvOrlCdHSwMi19Ma8CZ6","remoteAddr":"92.75.46.249","app":"PHP","message":"Function split() is deprecated at \/var\/www\/owncloud\/lib\/private\/files.php#194","level":3,"time":"2016-07-13T18:26:18+00:00","method":"GET","url":"\/owncloud\/index.php\/s\/J4pAVVhm7nqr3SJ\/download?path=%2F&files=MAH00265.MP4","user":"--"}
{"reqId":"MSOZGvuFazDtM\/IiI5v1","remoteAddr":"92.75.46.249","app":"PHP","message":"Function split() is deprecated at \/var\/www\/owncloud\/lib\/private\/files.php#194","level":3,"time":"2016-07-13T18:26:53+00:00","method":"GET","url":"\/owncloud\/index.php\/s\/J4pAVVhm7nqr3SJ\/download?path=%2F&files=MAH00282.MP4","user":"--"}
{"reqId":"lG2FhiUNZMhnMJS7muxY","remoteAddr":"92.75.46.249","app":"PHP","message":"Function split() is deprecated at \/var\/www\/owncloud\/lib\/private\/files.php#194","level":3,"time":"2016-07-13T18:26:53+00:00","method":"GET","url":"\/owncloud\/index.php\/s\/J4pAVVhm7nqr3SJ\/download?path=%2F&files=MAH00282.MP4","user":"--"}
{"reqId":"aZRzuqM23910TM0GhEgC","remoteAddr":"92.75.46.249","app":"PHP","message":"Function split() is deprecated at \/var\/www\/owncloud\/lib\/private\/files.php#194","level":3,"time":"2016-07-13T18:26:53+00:00","method":"GET","url":"\/owncloud\/index.php\/s\/J4pAVVhm7nqr3SJ\/download?path=%2F&files=MAH00282.MP4","user":"--"}
{"reqId":"NVB7hKSB97Jrz3TxjEHR","remoteAddr":"92.75.46.249","app":"PHP","message":"Function split() is deprecated at \/var\/www\/owncloud\/lib\/private\/files.php#194","level":3,"time":"2016-07-13T18:27:45+00:00","method":"GET","url":"\/owncloud\/index.php\/s\/J4pAVVhm7nqr3SJ\/download?path=%2F&files=MAH00282.MP4","user":"--"}
{"reqId":"qmEKdm4O3BFeoUKYvP2x","remoteAddr":"92.75.46.249","app":"PHP","message":"Function split() is deprecated at \/var\/www\/owncloud\/lib\/private\/files.php#194","level":3,"time":"2016-07-13T18:28:33+00:00","method":"GET","url":"\/owncloud\/index.php\/s\/J4pAVVhm7nqr3SJ\/download?path=%2F&files=MAH00282.MP4","user":"--"}
{"reqId":"hAm5k1luursyVli19RGt","remoteAddr":"92.75.46.249","app":"PHP","message":"Function split() is deprecated at \/var\/www\/owncloud\/lib\/private\/files.php#194","level":3,"time":"2016-07-13T18:29:33+00:00","method":"GET","url":"\/owncloud\/index.php\/s\/J4pAVVhm7nqr3SJ\/download?path=%2F&files=MAH00311.MP4","user":"--"}
{"reqId":"q1B6yHBNKGwc3RAqwc1j","remoteAddr":"92.75.46.249","app":"PHP","message":"Function split() is deprecated at \/var\/www\/owncloud\/lib\/private\/files.php#194","level":3,"time":"2016-07-13T18:29:38+00:00","method":"GET","url":"\/owncloud\/index.php\/s\/J4pAVVhm7nqr3SJ\/download?path=%2F&files=MAH00311.MP4","user":"--"}
{"reqId":"NLybX4k9wPltWrtaUgdh","remoteAddr":"92.75.46.249","app":"PHP","message":"Function split() is deprecated at \/var\/www\/owncloud\/lib\/private\/files.php#194","level":3,"time":"2016-07-13T18:29:38+00:00","method":"GET","url":"\/owncloud\/index.php\/s\/J4pAVVhm7nqr3SJ\/download?path=%2F&files=MAH00311.MP4","user":"--"}
{"reqId":"0gzNB\/9z3p2NVjTiwalV","remoteAddr":"178.197.232.60","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 400 expected filesize 1024000 got 524288\",\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\BadRequest\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/connector\\\/sabre\\\/file.php(103): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->createFileChunked(Resource id #36)\\n#1 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/connector\\\/sabre\\\/directory.php(134): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->put(Resource id #36)\\n#2 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1036): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('IMG_20160618_09...', Resource id #36)\\n#3 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(523): Sabre\\\\DAV\\\\Server->createFile('Natel\\\/IMG_20160...', Resource id #36, NULL)\\n#4 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#5 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#6 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(459): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#7 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(248): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#8 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(55): Sabre\\\\DAV\\\\Server->exec()\\n#9 \\\/var\\\/www\\\/owncloud\\\/remote.php(138): require_once('\\\/var\\\/www\\\/ownclo...')\\n#10 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/connector\\\/sabre\\\/file.php\",\"Line\":404,\"User\":\"Stefan\"}","level":4,"time":"2016-08-07T20:31:38+00:00","method":"PUT","url":"\/owncloud\/remote.php\/webdav\/Natel\/IMG_20160618_095012.jpg-chunking-2941-2-0","user":"Stefan"}
{"reqId":"U+l5q92cYq8CeJ85ebVh","remoteAddr":"213.144.157.176","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 400 expected filesize 1024000 got 696320\",\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\BadRequest\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/connector\\\/sabre\\\/file.php(103): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->createFileChunked(Resource id #36)\\n#1 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/connector\\\/sabre\\\/directory.php(134): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->put(Resource id #36)\\n#2 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1036): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('IMG_20160529_16...', Resource id #36)\\n#3 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(523): Sabre\\\\DAV\\\\Server->createFile('Natel\\\/IMG_20160...', Resource id #36, NULL)\\n#4 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#5 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#6 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(459): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#7 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(248): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#8 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(55): Sabre\\\\DAV\\\\Server->exec()\\n#9 \\\/var\\\/www\\\/owncloud\\\/remote.php(138): require_once('\\\/var\\\/www\\\/ownclo...')\\n#10 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/connector\\\/sabre\\\/file.php\",\"Line\":404,\"User\":\"Stefan\"}","level":4,"time":"2016-08-07T20:36:20+00:00","method":"PUT","url":"\/owncloud\/remote.php\/webdav\/Natel\/IMG_20160529_161439.jpg-chunking-8014-4-0","user":"Stefan"}
{"reqId":"GUYGZnSGb84bx8NpnD4F","remoteAddr":"178.197.232.60","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 400 expected filesize 1024000 got 540672\",\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\BadRequest\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/connector\\\/sabre\\\/file.php(103): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->createFileChunked(Resource id #36)\\n#1 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/connector\\\/sabre\\\/directory.php(134): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\File->put(Resource id #36)\\n#2 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(1036): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\Directory->createFile('IMG_20160615_21...', Resource id #36)\\n#3 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(523): Sabre\\\\DAV\\\\Server->createFile('Natel\\\/IMG_20160...', Resource id #36, NULL)\\n#4 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpPut(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#5 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#6 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(459): Sabre\\\\Event\\\\EventEmitter->emit('method:PUT', Array)\\n#7 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(248): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#8 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(55): Sabre\\\\DAV\\\\Server->exec()\\n#9 \\\/var\\\/www\\\/owncloud\\\/remote.php(138): require_once('\\\/var\\\/www\\\/ownclo...')\\n#10 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/lib\\\/connector\\\/sabre\\\/file.php\",\"Line\":404,\"User\":\"Stefan\"}","level":4,"time":"2016-08-07T20:40:54+00:00","method":"PUT","url":"\/owncloud\/remote.php\/webdav\/Natel\/IMG_20160615_210611.jpg-chunking-8563-2-0","user":"Stefan"}
{"reqId":"GW29N9HusTI6Pu4p9F9J","remoteAddr":"213.144.157.176","app":"webdav","message":"Exception: {\"Message\":\"HTTP\\\/1.1 409 Parent node does not exist\",\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\Conflict\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/CorePlugin.php(588): Sabre\\\\DAV\\\\Server->createCollection('Natel\\\/2016\\\/08', Object(Sabre\\\\DAV\\\\MkCol))\\n#1 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpMkcol(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#2 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/event\\\/lib\\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#3 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(459): Sabre\\\\Event\\\\EventEmitter->emit('method:MKCOL', Array)\\n#4 \\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(248): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#5 \\\/var\\\/www\\\/owncloud\\\/apps\\\/dav\\\/appinfo\\\/v1\\\/webdav.php(55): Sabre\\\\DAV\\\\Server->exec()\\n#6 \\\/var\\\/www\\\/owncloud\\\/remote.php(138): require_once('\\\/var\\\/www\\\/ownclo...')\\n#7 {main}\",\"File\":\"\\\/var\\\/www\\\/owncloud\\\/3rdparty\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php\",\"Line\":1107,\"User\":\"Stefan\"}","level":4,"time":"2016-08-08T17:26:58+00:00","method":"MKCOL","url":"\/owncloud\/remote.php\/webdav\/Natel\/2016\/08\/","user":"Stefan"}
{"reqId":"iF8t98pZLxOUjMNu7PC5","remoteAddr":"213.144.157.176","app":"core","message":"Could not get application: cURL error 28: Operation timed out after 0 milliseconds with 0 out of 0 bytes received","level":3,"time":"2016-10-16T15:16:55+00:00","method":"GET","url":"\/owncloud\/index.php\/settings\/apps\/list?category=enabled&includeUpdateInfo=0","user":"Stefan"}
{"reqId":"isgyA8nLS4v9CuvU7fem","remoteAddr":"213.144.157.176","app":"PHP","message":"Doctrine\\DBAL\\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory at \/var\/www\/owncloud\/lib\/private\/db\/connection.php#54","level":3,"time":"2016-10-16T15:52:39+00:00","method":"GET","url":"\/owncloud\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","user":"--"}
{"reqId":"VpyX7RsCQEL+pQ7NJByi","remoteAddr":"213.144.157.176","app":"PHP","message":"Doctrine\\DBAL\\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory at \/var\/www\/owncloud\/lib\/private\/db\/connection.php#54","level":3,"time":"2016-10-16T15:52:55+00:00","method":"GET","url":"\/owncloud\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","user":"--"}
{"reqId":"XX9wNskkHlrcB99FjAxR","remoteAddr":"213.144.157.176","app":"PHP","message":"Doctrine\\DBAL\\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory at \/var\/www\/owncloud\/lib\/private\/db\/connection.php#54","level":3,"time":"2016-10-16T15:53:01+00:00","method":"GET","url":"\/owncloud\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","user":"--"}
{"reqId":"CH851\/03FYQBOEH92xT8","remoteAddr":"213.144.157.176","app":"PHP","message":"Doctrine\\DBAL\\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory at \/var\/www\/owncloud\/lib\/private\/db\/connection.php#54","level":3,"time":"2016-10-16T15:53:09+00:00","method":"GET","url":"\/owncloud\/ocs\/v2.php\/apps\/notifications\/api\/v1\/notifications?format=json","user":"--"}
{"reqId":"62E5TZ465JcPF2ynvRNZ","remoteAddr":"213.144.157.176","app":"core","message":"starting upgrade from 9.0.51.0 to 9.0.53.0","level":0,"time":"2016-10-16T15:55:59+00:00","method":"GET","url":"\/owncloud\/core\/ajax\/update.php?requesttoken=Zz1NeRlEEykVHyJpByEwK3MnCjg3dCgLNVxTLm5wUTQ%3D%3AQlb%2FargaGNjFeteGARIyGGLoZ82T8B8rgD1TZUyxxaM%3D","user":"--"}
{"reqId":"62E5TZ465JcPF2ynvRNZ","remoteAddr":"213.144.157.176","app":"PHP","message":"file_put_contents(\/var\/www\/owncloud\/data\/.htaccess): failed to open stream: Permission denied at \/var\/www\/owncloud\/lib\/private\/setup.php#485","level":3,"time":"2016-10-16T15:55:59+00:00","method":"GET","url":"\/owncloud\/core\/ajax\/update.php?requesttoken=Zz1NeRlEEykVHyJpByEwK3MnCjg3dCgLNVxTLm5wUTQ%3D%3AQlb%2FargaGNjFeteGARIyGGLoZ82T8B8rgD1TZUyxxaM%3D","user":"--"}

[MorrisJobke]

SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_25eb_0.MAI' (Errcode: 2)

We can't do much, when the DB is just dying. Please check your logs of the DB first and try to fix the issues there.

Thanks