Database error on upgrade to 22.1.0

Nextcloud version (eg, 20.0.5): 21.0.2.1
Operating system and version (eg, Ubuntu 20.04): Ubuntu 20.04
Apache or nginx version (eg, Apache 2.4.25): Using latest docker image
PHP version (eg, 7.4): Using latest docker image

The issue you are facing:
Error when trying to update the database
Exception: Database error when running migration latest for app core

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. docker-compose down
  2. docker-compose pull
  3. docker-compose up -d
  4. Go to nextcloud GUI and click Start Upgrade

The output of your Nextcloud log in Admin > Logging:

I'm unable to find any useful logs.  the /logs directory is empty.  I updated config.php to log level 0 (debugging)

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):


<?php
$CONFIG = array (
  'htaccess.RewriteBase' => '/',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'apps_paths' => 
  array (
    0 => 
    array (
      'path' => '/var/www/html/apps',
      'url' => '/apps',
      'writable' => false,
    ),
    1 => 
    array (
      'path' => '/var/www/html/custom_apps',
      'url' => '/custom_apps',
      'writable' => true,
    ),
  ),
  'instanceid' => 'ocntupfih31g',
  'passwordsalt' => 'redacted',
  'secret' => 'redacted',
  'trusted_domains' => 
  array (
    0 => 'nextcloud.example.org',
    1 => 'ubuntu.example.org',
  ),
  'datadirectory' => '/mnt/shared/apps/nextcloud/data',
  'dbtype' => 'mysql',
  'version' => '21.0.2.1',
  'overwrite.cli.url' => 'http://nextcloud.example.org',
  'dbname' => 'nextcloud',
  'dbhost' => 'nextclouddb',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => 'redacted',
  'installed' => true,
  'theme' => '',
  'loglevel' => 0,
  'maintenance' => false,
);

The output of your Apache/nginx/system log in /var/log/____:

Not sure how to get this from docker.  There is no path like this.

any ideas?

This post fixed it for me:

I set mariadb to image version 10.5 and the upgrade went through. I set NextCloud to :stable which is currently 21.0.4. I’ll just stick with the stable versions from now on.