[Bug]: Upgrade from 30 to 31 fails on database migration #55240
Description
⚠️ This issue respects the following points: ⚠️
- This is a bug, not a question or a configuration/webserver/proxy issue.
- This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
- Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
- I agree to follow Nextcloud's Code of Conduct.
Bug description
When updating 30.0.15 to 31.0.9 the update fails with:
php 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
Setting log level to debug
Updating database schema
Exception: Database error when running migration 31000Date20240101084401 for app core
An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_sec_signatory' already exists
Update failed
php 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
Setting log level to debug
Updating database schema
Updated database
Updating ...
Exception: Database error when running migration 31000Date20241114171300 for app systemtags
An exception occurred while executing a query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'color'
Update failed
Steps to reproduce
- Update to latest version of v30
- Upgrate to v31 using occ
Expected behavior
No errors during upgrade
Nextcloud Server version
31
Operating system
docker container (nextcloud-docker)
Database engine version
MariaDB 10.11
Is this bug present after an update or on a fresh install?
update
Are you using the Nextcloud Server Encryption module?
No
What user-backends are you using?
- Default user-backend (database)
- LDAP/ Active Directory
- SSO - SAML
- Other
Configuration report
List of activated Apps
Enabled:
- activity: 4.0.0
- announcementcenter: 7.2.1
- bruteforcesettings: 4.0.0
- calendar: 5.5.4
- circles: 31.0.0
- cloud_federation_api: 1.14.0
- collectives: 3.1.2
- contacts: 7.3.1
- contactsinteraction: 1.12.0
- dashboard: 7.11.0
- dav: 1.33.0
- deck: 1.15.2
- federatedfilesharing: 1.21.0
- federation: 1.21.0
- files: 2.3.1
- files_automatedtagging: 2.0.0
- files_downloadlimit: 4.0.0
- files_pdfviewer: 4.0.0
- files_reminders: 1.4.0
- files_sharing: 1.23.1
- files_trashbin: 1.21.0
- files_versions: 1.24.0
- firstrunwizard: 4.0.0
- forms: 5.1.2
- groupfolders: 19.1.5
- ldap_write_support: 1.13.0
- logreader: 4.0.0
- lookup_server_connector: 1.19.0
- notifications: 4.0.0
- oauth2: 1.19.1
- orders: 0.0.1
- password_policy: 3.0.0
- photos: 4.0.0
- privacy: 3.0.0
- profile: 1.0.0
- provisioning_api: 1.21.0
- recommendations: 4.0.0
- related_resources: 2.0.0
- richdocuments: 8.7.5
- serverinfo: 3.0.0
- settings: 1.14.0
- sharebymail: 1.21.0
- survey_client: 3.0.0
- systemtags: 1.21.1
- tasks: 0.16.1
- text: 5.0.0
- theming: 2.6.1
- theming_customcss: 1.18.0
- twofactor_backupcodes: 1.20.0
- updatenotification: 1.21.0
- user_ldap: 1.22.0
- viewer: 4.0.0
- weather_status: 1.11.0
- webapppassword: 25.8.0
- webhook_listeners: 1.2.0
- webhooks: 0.4.3
- workflowengine: 2.13.0
Disabled:
- admin_audit: 1.21.0
- app_api: 5.0.2 (installed 4.0.5)
- comments: 1.21.0 (installed 1.18.0)
- encryption: 2.19.0
- files_external: 1.23.0
- nextcloud_announcements: 3.0.0 (installed 1.9.0)
- support: 3.0.0 (installed 1.3.0)
- suspicious_login: 9.0.1
- twofactor_nextcloud_notification: 5.0.0
- twofactor_totp: 13.0.0-dev.0
- user_status: 1.11.0 (installed 1.0.1)Nextcloud Signing status
Nextcloud Logs
{"reqId":"nW48oYNxajrFkCYFyxQW","level":3,"time":"2025-09-21T15:44:32+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Database error when running migration 31000Date20240101084401 for app core\nAn exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_sec_signatory' already exists","userAgent":"--","version":"30.0.15.1","exception":{"Exception":"Exception","Message":"Database error when running migration 31000Date20240101084401 for app core\nAn exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_sec_signatory' already exists","Code":0,"Trace":[{"file":"/var/www/html/lib/private/Updater.php","line":287,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":225,"function":"doCoreUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["31.0.9.1","30.0.15.1"]},{"file":"/var/www/html/core/Command/Upgrade.php","line":192,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"OC\\Core\\Command\\Upgrade"},{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"}]},{"file":"/var/www/html/occ","line":33,"args":["/var/www/html/console.php"],"function":"require_once"}],"File":"/var/www/html/lib/private/DB/MigrationService.php","Line":399,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\TableExistsException","Message":"An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_sec_signatory' already exists","Code":1050,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1976,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1918,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1218,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},"CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB",[],[]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB",[],[]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":466,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->","args":["CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB",[],[]]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":142,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB"]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":47,"function":"applySchema","class":"OC\\DB\\Migrator","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":795,"function":"migrate","class":"OC\\DB\\Migrator","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":515,"function":"migrateToSchema","class":"OC\\DB\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":395,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["31000Date20240101084401",false]},{"file":"/var/www/html/lib/private/Updater.php","line":287,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":225,"function":"doCoreUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["31.0.9.1","30.0.15.1"]},{"file":"/var/www/html/core/Command/Upgrade.php","line":192,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"OC\\Core\\Command\\Upgrade"},{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"}]},{"file":"/var/www/html/occ","line":33,"args":["/var/www/html/console.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":45,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_sec_signatory' already exists","Code":1050,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php","line":39,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[{"__class__":"PDOException","errorInfo":["42S01",1050,"Table 'oc_sec_signatory' already exists"]}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1216,"function":"exec","class":"Doctrine\\DBAL\\Driver\\PDO\\Connection","type":"->","args":["CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB",[],[]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":466,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->","args":["CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB",[],[]]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":142,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB"]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":47,"function":"applySchema","class":"OC\\DB\\Migrator","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":795,"function":"migrate","class":"OC\\DB\\Migrator","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":515,"function":"migrateToSchema","class":"OC\\DB\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":395,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["31000Date20240101084401",false]},{"file":"/var/www/html/lib/private/Updater.php","line":287,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":225,"function":"doCoreUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["31.0.9.1","30.0.15.1"]},{"file":"/var/www/html/core/Command/Upgrade.php","line":192,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"OC\\Core\\Command\\Upgrade"},{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"}]},{"file":"/var/www/html/occ","line":33,"args":["/var/www/html/console.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":24,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_sec_signatory' already exists","Code":"42S01","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php","line":33,"function":"exec","class":"PDO","type":"->","args":["CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1216,"function":"exec","class":"Doctrine\\DBAL\\Driver\\PDO\\Connection","type":"->","args":["CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB",[],[]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":466,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->","args":["CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB",[],[]]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":142,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["CREATE TABLE oc_sec_signatory (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, key_id_sum VARCHAR(127) NOT NULL, key_id VARCHAR(512) NOT NULL, host VARCHAR(512) NOT NULL, provider_id VARCHAR(31) NOT NULL, account VARCHAR(127) DEFAULT '', public_key LONGTEXT DEFAULT '' NOT NULL, metadata LONGTEXT DEFAULT '[]' NOT NULL, type SMALLINT DEFAULT 9 NOT NULL, status SMALLINT DEFAULT 0 NOT NULL, creation INT UNSIGNED DEFAULT 0, last_updated INT UNSIGNED DEFAULT 0, UNIQUE INDEX sec_sig_unic (provider_id, host, account), INDEX sec_sig_key (key_id_sum, provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB"]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":47,"function":"applySchema","class":"OC\\DB\\Migrator","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":795,"function":"migrate","class":"OC\\DB\\Migrator","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":515,"function":"migrateToSchema","class":"OC\\DB\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":395,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["31000Date20240101084401",false]},{"file":"/var/www/html/lib/private/Updater.php","line":287,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":225,"function":"doCoreUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["31.0.9.1","30.0.15.1"]},{"file":"/var/www/html/core/Command/Upgrade.php","line":192,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"OC\\Core\\Command\\Upgrade"},{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"}]},{"file":"/var/www/html/occ","line":33,"args":["/var/www/html/console.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php","Line":33}}},"message":"Database error when running migration 31000Date20240101084401 for app core\nAn exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_sec_signatory' already exists","exception":{},"CustomMessage":"Database error when running migration 31000Date20240101084401 for app core\nAn exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_sec_signatory' already exists"}}
{"reqId":"MhJiZuHDKAwNZ27sLXI7","level":3,"time":"2025-09-21T15:45:22+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Database error when running migration 31000Date20241114171300 for app systemtags\nAn exception occurred while executing a query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'color'","userAgent":"--","version":"30.0.15.1","exception":{"Exception":"Exception","Message":"Database error when running migration 31000Date20241114171300 for app systemtags\nAn exception occurred while executing a query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'color'","Code":0,"Trace":[{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":694,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":325,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":236,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["31.0.9.1","30.0.15.1"]},{"file":"/var/www/html/core/Command/Upgrade.php","line":192,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"OC\\Core\\Command\\Upgrade"},{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"}]},{"file":"/var/www/html/occ","line":33,"args":["/var/www/html/console.php"],"function":"require_once"}],"File":"/var/www/html/lib/private/DB/MigrationService.php","Line":399,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\NonUniqueFieldNameException","Message":"An exception occurred while executing a query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'color'","Code":1060,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1976,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1918,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1218,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},"ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL",[],[]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL",[],[]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":466,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->","args":["ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL",[],[]]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":142,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL"]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":47,"function":"applySchema","class":"OC\\DB\\Migrator","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":795,"function":"migrate","class":"OC\\DB\\Migrator","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":515,"function":"migrateToSchema","class":"OC\\DB\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":395,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["31000Date20241114171300",false]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":694,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":325,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":236,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["31.0.9.1","30.0.15.1"]},{"file":"/var/www/html/core/Command/Upgrade.php","line":192,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"OC\\Core\\Command\\Upgrade"},{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"}]},{"file":"/var/www/html/occ","line":33,"args":["/var/www/html/console.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":72,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'color'","Code":1060,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php","line":39,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[{"__class__":"PDOException","errorInfo":["42S21",1060,"Duplicate column name 'color'"]}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1216,"function":"exec","class":"Doctrine\\DBAL\\Driver\\PDO\\Connection","type":"->","args":["ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL",[],[]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":466,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->","args":["ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL",[],[]]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":142,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL"]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":47,"function":"applySchema","class":"OC\\DB\\Migrator","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":795,"function":"migrate","class":"OC\\DB\\Migrator","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":515,"function":"migrateToSchema","class":"OC\\DB\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":395,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["31000Date20241114171300",false]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":694,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":325,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":236,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["31.0.9.1","30.0.15.1"]},{"file":"/var/www/html/core/Command/Upgrade.php","line":192,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"OC\\Core\\Command\\Upgrade"},{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"}]},{"file":"/var/www/html/occ","line":33,"args":["/var/www/html/console.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":24,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'color'","Code":"42S21","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php","line":33,"function":"exec","class":"PDO","type":"->","args":["ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1216,"function":"exec","class":"Doctrine\\DBAL\\Driver\\PDO\\Connection","type":"->","args":["ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL",[],[]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":466,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->","args":["ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL",[],[]]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":142,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["ALTER TABLE oc_systemtag ADD color VARCHAR(6) DEFAULT NULL"]},{"file":"/var/www/html/lib/private/DB/Migrator.php","line":47,"function":"applySchema","class":"OC\\DB\\Migrator","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":795,"function":"migrate","class":"OC\\DB\\Migrator","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":515,"function":"migrateToSchema","class":"OC\\DB\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Schema\\Schema"}]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":395,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["31000Date20241114171300",false]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":694,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":325,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":236,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["31.0.9.1","30.0.15.1"]},{"file":"/var/www/html/core/Command/Upgrade.php","line":192,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"OC\\Core\\Command\\Upgrade"},{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"},{"__class__":"Symfony\\Component\\Console\\Output\\ConsoleOutput"}]},{"file":"/var/www/html/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->","args":[{"__class__":"Symfony\\Component\\Console\\Input\\ArgvInput"}]},{"file":"/var/www/html/occ","line":33,"args":["/var/www/html/console.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php","Line":33}}},"message":"Database error when running migration 31000Date20241114171300 for app systemtags\nAn exception occurred while executing a query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'color'","exception":{},"CustomMessage":"Database error when running migration 31000Date20241114171300 for app systemtags\nAn exception occurred while executing a query: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'color'"}}
Additional info
No response