Nextcloud problem with upgrade to 13

after upgrade from version 12

  • installed: true
  • version: 13.0.0.14
  • versionstring: 13.0.0

server: Debian Stable

occ upgrade:
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Set log level to debug
Updating database schema
Updated database
Checking for update of app activity in appstore
Checked for update of app “activity” in appstore
Checking for update of app admin_audit in appstore
Checked for update of app “admin_audit” in appstore
Checking for update of app calendar in appstore
Checked for update of app “calendar” in appstore
Checking for update of app comments in appstore
Checked for update of app “comments” in appstore
Checking for update of app contacts in appstore
Checked for update of app “contacts” in appstore
Checking for update of app dav in appstore
Checked for update of app “dav” in appstore
Checking for update of app encryption in appstore
Checked for update of app “encryption” in appstore
Checking for update of app federatedfilesharing in appstore
Checked for update of app “federatedfilesharing” in appstore
Checking for update of app federation in appstore
Checked for update of app “federation” in appstore
Checking for update of app files in appstore
Checked for update of app “files” in appstore
Checking for update of app files_external in appstore
Checked for update of app “files_external” in appstore
Checking for update of app files_pdfviewer in appstore
Checked for update of app “files_pdfviewer” in appstore
Checking for update of app files_sharing in appstore
Checked for update of app “files_sharing” in appstore
Checking for update of app files_texteditor in appstore
Checked for update of app “files_texteditor” in appstore
Checking for update of app files_trashbin in appstore
Checked for update of app “files_trashbin” in appstore
Checking for update of app files_versions in appstore
Checked for update of app “files_versions” in appstore
Checking for update of app files_videoplayer in appstore
Checked for update of app “files_videoplayer” in appstore
Checking for update of app firstrunwizard in appstore
Checked for update of app “firstrunwizard” in appstore
Checking for update of app gallery in appstore
Checked for update of app “gallery” in appstore
Checking for update of app logreader in appstore
Checked for update of app “logreader” in appstore
Checking for update of app lookup_server_connector in appstore
Checked for update of app “lookup_server_connector” in appstore
Checking for update of app nextcloud_announcements in appstore
Checked for update of app “nextcloud_announcements” in appstore
Checking for update of app notes in appstore
Checked for update of app “notes” in appstore
Checking for update of app notifications in appstore
Checked for update of app “notifications” in appstore
Checking for update of app oauth2 in appstore
Checked for update of app “oauth2” in appstore
Checking for update of app ownbackup in appstore
Checked for update of app “ownbackup” in appstore
Checking for update of app provisioning_api in appstore
Checked for update of app “provisioning_api” in appstore
Checking for update of app serverinfo in appstore
Checked for update of app “serverinfo” in appstore
Checking for update of app sharebymail in appstore
Checked for update of app “sharebymail” in appstore
Checking for update of app survey_client in appstore
Checked for update of app “survey_client” in appstore
Checking for update of app theming in appstore
Checked for update of app “theming” in appstore
Checking for update of app twofactor_backupcodes in appstore
Checked for update of app “twofactor_backupcodes” in appstore
Checking for update of app updatenotification in appstore
Checked for update of app “updatenotification” in appstore
Checking for update of app user_saml in appstore
Checked for update of app “user_saml” in appstore
Checking for update of app workflowengine in appstore
Checked for update of app “workflowengine” in appstore
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘
UPDATE oc_filecache
SET mimetype = ?
WHERE mimetype <> ? AND mimetype <> ? AND name COLLATE UTF8_general_ci LIKE ?
’ with params [“133”, 2, “133”, “%.gpx”]:

SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size
Update failed
Maintenance mode is kept active
Reset log level

Your mysql installation needs some tuning. Probably innodb_buffer_pool_size is set to low. Try to search for that error. Maybe other solutions are available too.

Hi,

I’m receiving this error while updating with the updater:

Parsing response failed. <html> <head><title>504 Gateway Time-out</title></head> <body bgcolor="white"> <center><h1>504 Gateway Time-out</h1></center> <hr><center>nginx</center> </body> </html> <!-- a padding to disable MSIE and Chrome friendly error page --> <!-- a padding to disable MSIE and Chrome friendly error page --> <!-- a padding to disable MSIE and Chrome friendly error page --> <!-- a padding to disable MSIE and Chrome friendly error page --> <!-- a padding to disable MSIE and Chrome friendly error page --> <!-- a padding to disable MSIE and Chrome friendly error page -->
1 Like

I fixed by by performed the upgrade via CLI.

This v13 is a pain.