On my installation (clean centos 7.3, dedicated to run nextcloud) the update from 11.0.2.to 11.0.3 fails. My nextcloud is now unusable because it shows the ‘Update now’ screen permanently - no way to log in or use it.
Available file system space is not an issue here. (190G free disk space in /, single partition).
Can I just abort the upgrade and stick with 11.0.2 meanwhile? I need a working instance back here!
Steps to reproduce
Follow the notification that nextclud 11.0.3 is available (currently installed i 11.0.2)
Follow the dialog
Finish update
Expected behaviour
Updates suceeds
Actual behaviour
Update fails:
Preparing update
Set log level to debug
Turned on maintenance mode
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_81b_0.MAI’ (Errcode: 2)
Server configuration
Operating system:
Centos 7.3
Web server:
apache2
Database:
mariadb
PHP version:
php7
Nextcloud version: (see Nextcloud admin page)
11.0.2
Updated from an older Nextcloud/ownCloud or fresh install:
fresh install
I’m seeing a common theme with these failed updates: permission issues. Based on the error message you posted, it’s saying it can’t write to /var/tmp which is necessary for storing temporary files.[quote=“feli74, post:1, topic:11929”]
General error: 1 Can’t create/write to file ‘/var/tmp/#sql_81b_0.MAI’ (Errcode: 2)
[/quote]
Can you try changing your /var/tmp permissions by running these?
I honesty don’t know about aborting the upgrade at this point, so what I would do is attempt to proceed forward if possible. Otherwise, you did a back up right? You could always restore to that and start fresh.
If you’re sure the filesystem is not the issue here, although that’s not clear to me since you haven’t provided those details, you need to figure out why else this error is happening. I googled that error message and found some other things to check regarding the MySQL config and server, but that’s beyond my level of experience so I just want to also mention that to you.
A quick thing to try which shouldn’t hurt anything would be to restart the mysql server, or even the entire server and see if that makes any difference.
Yes permissions are good (777) and I have around 190GB of space on the filesystem.
My deployment is mariadb based so the database files shouldn’t be in /var/tmp anyway…Do you have any clue what the updater is trying to do here?