Upgrade NC 11.0.6.1 > 12.0.4.3 (dockerized) fails: General error: 1025 Error on rename of './owncloud/#sql-1_108' to './owncloud/oc_properties' (errno: 184 - Tablespace already exists)

Like in the past I’ve tried to upgrade NC 11 to 12.
I change the docker image from nextcloud:11-fpm to nextcloud:12-fpm and restarted the docker app and started the upgrade. It fails with errors, (there is no difference if it’s trigged by occ or the website) :

nextcloud.log

Failed to update database structure (PDOException: SQLSTATE[HY000]: General error: 1025 Error on rename of '.\/owncloud\/#sql-1_108' to '.\/owncloud\/oc_properties' (errno: 184 - Tablespace already exists) in \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php:104
Stack trace:
#0 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php(104): PDO->query('ALTER TABLE oc_...')
#1 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(954): Doctrine\\DBAL\\Driver\\PDOConnection->query('ALTER TABLE oc_...')
#2 \/var\/www\/html\/lib\/private\/DB\/Migrator.php(258): Doctrine\\DBAL\\Connection->query('ALTER TABLE oc_...')
#3 \/var\/www\/html\/lib\/private\/DB\/Migrator.php(86): OC\\DB\\Migrator->applySchema(Object(Doctrine\\DBAL\\Schema\\Schema))
#4 \/var\/www\/html\/lib\/private\/DB\/MDB2SchemaManager.php(122): OC\\DB\\Migrator->migrate(Object(Doctrine\\DBAL\\Schema\\Schema))
#5 \/var\/www\/html\/lib\/private\/legacy\/db.php(186): OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/html\/d...')
#6 \/var\/www\/html\/lib\/private\/Updater.php(305): OC_DB::updateDbFromStructure('\/var\/www\/html\/d...')
#7 \/var\/www\/html\/lib\/private\/Updater.php(254): OC\\Updater->doCoreUpgrade()
#8 \/var\/www\/html\/lib\/private\/Updater.php(130): OC\\Updater->doUpgrade('12.0.4.3', '11.0.6.1')
#9 \/var\/www\/html\/core\/Command\/Upgrade.php(263): OC\\Updater->upgrade()
#10 \/var\/www\/html\/3rdparty\/symfony\/console\/Command\/Command.php(256): OC\\Core\\Command\\Upgrade->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#11 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(818): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#12 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(186): Symfony\\Component\\Console\\Application->doRunCommand(Object(OC\\Core\\Command\\Upgrade), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#13 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(117): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#14 \/var\/www\/html\/lib\/private\/Console\/Application.php(170): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#15 \/var\/www\/html\/console.php(100): OC\\Console\\Application->run()
#16 \/var\/www\/html\/occ(11): require_once('\/var\/www\/html\/c...')
#17 {main}

Next Doctrine\\DBAL\\Driver\\PDOException: SQLSTATE[HY000]: General error: 1025 Error on rename of '.\/owncloud\/#sql-1_108' to '.\/owncloud\/oc_properties' (errno: 184 - Tablespace already exists) in \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php:106
Stack trace:
#0 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(954): Doctrine\\DBAL\\Driver\\PDOConnection->query('ALTER TABLE oc_...')
#1 \/var\/www\/html\/lib\/private\/DB\/Migrator.php(258): Doctrine\\DBAL\\Connection->query('ALTER TABLE oc_...')
#2 \/var\/www\/html\/lib\/private\/DB\/Migrator.php(86): OC\\DB\\Migrator->applySchema(Object(Doctrine\\DBAL\\Schema\\Schema))
#3 \/var\/www\/html\/lib\/private\/DB\/MDB2SchemaManager.php(122): OC\\DB\\Migrator->migrate(Object(Doctrine\\DBAL\\Schema\\Schema))
#4 \/var\/www\/html\/lib\/private\/legacy\/db.php(186): OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/html\/d...')
#5 \/var\/www\/html\/lib\/private\/Updater.php(305): OC_DB::updateDbFromStructure('\/var\/www\/html\/d...')
#6 \/var\/www\/html\/lib\/private\/Updater.php(254): OC\\Updater->doCoreUpgrade()
#7 \/var\/www\/html\/lib\/private\/Updater.php(130): OC\\Updater->doUpgrade('12.0.4.3', '11.0.6.1')
#8 \/var\/www\/html\/core\/Command\/Upgrade.php(263): OC\\Updater->upgrade()
#9 \/var\/www\/html\/3rdparty\/symfony\/console\/Command\/Command.php(256): OC\\Core\\Command\\Upgrade->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#10 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(818): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#11 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(186): Symfony\\Component\\Console\\Application->doRunCommand(Object(OC\\Core\\Command\\Upgrade), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#12 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(117): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#13 \/var\/www\/html\/lib\/private\/Console\/Application.php(170): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#14 \/var\/www\/html\/console.php(100): OC\\Console\\Application->run()
#15 \/var\/www\/html\/occ(11): require_once('\/var\/www\/html\/c...')
#16 {main}

Next Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing 'ALTER TABLE oc_properties CHANGE `propertyvalue` `propertyvalue` LONGTEXT NOT NULL':

SQLSTATE[HY000]: General error: 1025 Error on rename of '.\/owncloud\/#sql-1_108' to '.\/owncloud\/oc_properties' (errno: 184 - Tablespace already exists) in \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php:116
Stack trace:
#0 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(128): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))
#1 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(964): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'ALTER TABLE oc_...')
#2 \/var\/www\/html\/lib\/private\/DB\/Migrator.php(258): Doctrine\\DBAL\\Connection->query('ALTER TABLE oc_...')
#3 \/var\/www\/html\/lib\/private\/DB\/Migrator.php(86): OC\\DB\\Migrator->applySchema(Object(Doctrine\\DBAL\\Schema\\Schema))
#4 \/var\/www\/html\/lib\/private\/DB\/MDB2SchemaManager.php(122): OC\\DB\\Migrator->migrate(Object(Doctrine\\DBAL\\Schema\\Schema))
#5 \/var\/www\/html\/lib\/private\/legacy\/db.php(186): OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/html\/d...')
#6 \/var\/www\/html\/lib\/private\/Updater.php(305): OC_DB::updateDbFromStructure('\/var\/www\/html\/d...')
#7 \/var\/www\/html\/lib\/private\/Updater.php(254): OC\\Updater->doCoreUpgrade()
#8 \/var\/www\/html\/lib\/private\/Updater.php(130): OC\\Updater->doUpgrade('12.0.4.3', '11.0.6.1')
#9 \/var\/www\/html\/core\/Command\/Upgrade.php(263): OC\\Updater->upgrade()
#10 \/var\/www\/html\/3rdparty\/symfony\/console\/Command\/Command.php(256): OC\\Core\\Command\\Upgrade->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#11 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(818): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#12 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(186): Symfony\\Component\\Console\\Application->doRunCommand(Object(OC\\Core\\Command\\Upgrade), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#13 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(117): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#14 \/var\/www\/html\/lib\/private\/Console\/Application.php(170): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#15 \/var\/www\/html\/console.php(100): OC\\Console\\Application->run()
#16 \/var\/www\/html\/occ(11): require_once('\/var\/www\/html\/c...')
#17 {main})

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

config.php

<?php
$CONFIG = array (
  'instanceid' => 'xxx',
  'passwordsalt' => 'xxx',
  'secret' => 'xxx',
  'trusted_domains' =>
  array (
    0 => 'domain',
  ),
  'datadirectory' => '/var/www/html/data',
  'overwrite.cli.url' => 'https://domain',
  'dbtype' => 'mysql',
  'version' => '11.0.6.1',
  'dbname' => 'owncloud',
  'dbhost' => 'nextcloud_db_1',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'xxx',
  'dbpassword' => 'xxx',
  'logtimezone' => 'UTC',
  'installed' => true,
  'theme' => '',
  'loglevel' => 0,
  'maintenance' => false,
  'mail_from_address' => 'noreply',
  'mail_smtpmode' => 'smtp',
  'mail_domain' => 'domain',
  'mail_smtphost' => 'nextcloud_sendmail_1',
  'mail_smtpport' => '25',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'auth.bruteforce.protection.enabled' => false,
);

Cause was a problem in the mysql database.

created a clean database container :ballot_box_with_check:
dumped the database into it :ballot_box_with_check:
set correct permission :ballot_box_with_check:

upgrade worked :checkered_flag: