[Bug]: Update to 30.0.14 / 31.0.8 database issue: Database error when running migration 31000Date20250731062008 #54432
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
Hi,
I just updated Nextcloud on my standalone server (Ubuntu , PHP 8.4)
And this error appeared... I couldn't fix it or go around it... I've searched for a while.
Does anyone have a clue ? Thanks a lot !
IMPORTANT : Restored from a backup (everything works back) , did the update , had the same issue.....
Mettre à jour vers 31.0.8
Exception: Database error when running migration 31000Date20250731062008 for app core An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1121523-files' for key 'PRIMARY'
Journaux détaillés
Préparation de la mise à jour
Réglage du niveau de journalisation à « débogage »
Mode de maintenance activé
Étape de réparation : Repair MySQL collation
Informations de réparation : All tables already have the correct collation -> nothing to do
Étape de réparation : Copy data from accounts table when migrating from ownCloud
Étape de réparation : Drop account terms table when migrating from ownCloud
Mise à jour du schéma de la base de données
Exception: Database error when running migration 31000Date20250731062008 for app core An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1121523-files' for key 'PRIMARY'
Steps to reproduce
1.Using integrated updater to update from NC 31.0.7.1 to 31.0.8
2.using "occ upgrade"
3.error appears
Expected behavior
Expected to see my files list
Nextcloud Server version
31
Operating system
Debian/Ubuntu
PHP engine version
PHP 8.4
Web server
Apache (supported)
Database engine version
MariaDB
Is this bug present after an update or on a fresh install?
Updated from a MINOR version (ex. 32.0.1 to 32.0.2)
Are you using the Nextcloud Server Encryption module?
Encryption is Disabled
What user-backends are you using?
- Default user-backend (database)
- LDAP/ Active Directory
- SSO - SAML
- Other
Configuration report
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
{
"system": {
"instanceid": "***REMOVED SENSITIVE VALUE***",
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"192.168.0.250",
"bernardstef.ddns.net",
"stefcloud.bernardstef.fr"
],
"trusted_proxies": "***REMOVED SENSITIVE VALUE***",
"overwritehost": "stefcloud.bernardstef.fr",
"overwriteprotocol": "https",
"overwrite.cli.url": "https:\/\/stefcloud.bernardstef.fr\/nextcloud",
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "31.0.7.1",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"memories.db.triggers.fcu": true,
"memories.exiftool": "\/var\/www\/html\/nextcloud\/apps\/memories\/bin-ext\/exiftool-amd64-glibc",
"memories.vod.path": "\/var\/www\/html\/nextcloud\/apps\/memories\/bin-ext\/go-vod-amd64",
"memories.vod.ffmpeg": "\/usr\/bin\/ffmpeg",
"memories.vod.ffprobe": "\/usr\/bin\/ffprobe",
"app_install_overwrite": [
"facerecognition",
"camerarawpreviews"
],
"memories.gis_type": 1,
"enable_previews": true,
"enabledPreviewProviders": [
"OC\\Preview\\TXT",
"OC\\Preview\\MarkDown",
"OC\\Preview\\OpenDocument",
"OC\\Preview\\PDF",
"OC\\Preview\\MSOffice2003",
"OC\\Preview\\MSOfficeDoc",
"OC\\Preview\\PDF",
"OC\\Preview\\Image",
"OC\\Preview\\Photoshop",
"OC\\Preview\\TIFF",
"OC\\Preview\\SVG",
"OC\\Preview\\Font",
"OC\\Preview\\MP3",
"OC\\Preview\\Movie",
"OC\\Preview\\MKV",
"OC\\Preview\\MP4",
"OC\\Preview\\AVI",
"OC\\Preview\\HEIC"
],
"memories.vod.disable": false,
"maintenance": false,
"maintenance_window_start": 1,
"theme": "",
"loglevel": 2,
"preview_max_x": 1024,
"preview_max_y": 1024,
"twofactor_enforced": "false",
"twofactor_enforced_groups": [],
"twofactor_enforced_excluded_groups": [],
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_smtpmode": "smtp",
"mail_sendmailmode": "smtp",
"mail_smtpauth": true,
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "465",
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"updater.secret": "***REMOVED SENSITIVE VALUE***"
}
}List of activated Apps
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
Enabled:
- activity: 4.0.0
- app_api: 5.0.2
- bruteforcesettings: 4.0.0
- cloud_federation_api: 1.14.0
- comments: 1.21.0
- contactsinteraction: 1.12.0
- dav: 1.33.0
- federatedfilesharing: 1.21.0
- federation: 1.21.0
- files: 2.3.1
- files_downloadlimit: 4.0.0
- files_external: 1.23.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
- logreader: 4.0.0
- lookup_server_connector: 1.19.0
- memories: 7.6.1
- nextcloud_announcements: 3.0.0
- notifications: 4.0.0
- oauth2: 1.19.1
- password_policy: 3.0.0
- photos: 4.0.0
- previewgenerator: 5.9.0
- privacy: 3.0.0
- profile: 1.0.0
- provisioning_api: 1.21.0
- recognize: 9.0.3
- recommendations: 4.0.0
- related_resources: 2.0.0
- richdocumentscode: 25.4.202
- serverinfo: 3.0.0
- settings: 1.14.0
- sharebymail: 1.21.0
- suspicious_login: 9.0.1
- systemtags: 1.21.1
- text: 5.0.0
- theming: 2.6.1
- twofactor_backupcodes: 1.20.0
- updatenotification: 1.21.0
- user_status: 1.11.0
- viewer: 4.0.0
- weather_status: 1.11.0
- webhook_listeners: 1.2.0
- workflowengine: 2.13.0
Disabled:
- admin_audit: 1.21.0
- camerarawpreviews: 0.8.7 (installed 0.8.7)
- circles: 31.0.0 (installed 28.0.0)
- dashboard: 7.11.0 (installed 7.9.0)
- encryption: 2.19.0
- facerecognition: 0.9.70 (installed 0.9.70)
- maps: 1.6.0 (installed 1.6.0)
- passwords: 2025.7.20 (installed 2025.7.20)
- support: 3.0.0 (installed 1.11.1)
- survey_client: 3.0.0 (installed 1.16.0)
- twofactor_nextcloud_notification: 5.0.0
- twofactor_totp: 13.0.0-dev.0
- user_ldap: 1.22.0Nextcloud Signing status
Nextcloud Logs
{"reqId":"8gt8QwYnHJJSgsyfC4OQ","level":1,"time":"2025-08-15T08:38:18+00:00","remoteAddr":"2a02:842a:6320:fd01:1014:2487:9799:abf9","user":"--","app":"updater","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=x9aAtKzpQnapryNC8s%2BR7JepeS7nRbLEV1ySC%2FlYlJY%3D%3AnuP62M%2BKBT3zgBYw3a7g2tSQEVquHYewPhDQILwQ9vQ%3D","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Copy data from accounts table when migrating from ownCloud","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0","version":"31.0.7.1","data":{"app":"updater"}}
{"reqId":"8gt8QwYnHJJSgsyfC4OQ","level":1,"time":"2025-08-15T08:38:18+00:00","remoteAddr":"2a02:842a:6320:fd01:1014:2487:9799:abf9","user":"--","app":"updater","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=x9aAtKzpQnapryNC8s%2BR7JepeS7nRbLEV1ySC%2FlYlJY%3D%3AnuP62M%2BKBT3zgBYw3a7g2tSQEVquHYewPhDQILwQ9vQ%3D","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Drop account terms table when migrating from ownCloud","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0","version":"31.0.7.1","data":{"app":"updater"}}
{"reqId":"8gt8QwYnHJJSgsyfC4OQ","level":1,"time":"2025-08-15T08:38:18+00:00","remoteAddr":"2a02:842a:6320:fd01:1014:2487:9799:abf9","user":"--","app":"updater","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=x9aAtKzpQnapryNC8s%2BR7JepeS7nRbLEV1ySC%2FlYlJY%3D%3AnuP62M%2BKBT3zgBYw3a7g2tSQEVquHYewPhDQILwQ9vQ%3D","message":"\\OC\\Updater::dbUpgradeBefore: Updating database schema","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0","version":"31.0.7.1","data":{"app":"updater"}}
{"reqId":"8gt8QwYnHJJSgsyfC4OQ","level":1,"time":"2025-08-15T08:38:18+00:00","remoteAddr":"2a02:842a:6320:fd01:1014:2487:9799:abf9","user":"--","app":"core","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=x9aAtKzpQnapryNC8s%2BR7JepeS7nRbLEV1ySC%2FlYlJY%3D%3AnuP62M%2BKBT3zgBYw3a7g2tSQEVquHYewPhDQILwQ9vQ%3D","message":"Starting cleanup of duplicate vcategory records...","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0","version":"31.0.7.1","data":{"app":"core"}}
{"reqId":"8gt8QwYnHJJSgsyfC4OQ","level":1,"time":"2025-08-15T08:38:18+00:00","remoteAddr":"2a02:842a:6320:fd01:1014:2487:9799:abf9","user":"--","app":"core","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=x9aAtKzpQnapryNC8s%2BR7JepeS7nRbLEV1ySC%2FlYlJY%3D%3AnuP62M%2BKBT3zgBYw3a7g2tSQEVquHYewPhDQILwQ9vQ%3D","message":"Found duplicate: keeping ID 2, removing ID 3","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0","version":"31.0.7.1","data":{"app":"core"}}
{"reqId":"8gt8QwYnHJJSgsyfC4OQ","level":3,"time":"2025-08-15T08:38:18+00:00","remoteAddr":"2a02:842a:6320:fd01:1014:2487:9799:abf9","user":"--","app":"no app in context","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=x9aAtKzpQnapryNC8s%2BR7JepeS7nRbLEV1ySC%2FlYlJY%3D%3AnuP62M%2BKBT3zgBYw3a7g2tSQEVquHYewPhDQILwQ9vQ%3D","message":"Database error when running migration 31000Date20250731062008 for app core\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1121523-files' for key 'PRIMARY'","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0","version":"31.0.7.1","exception":{"Exception":"Exception","Message":"Database error when running migration 31000Date20250731062008 for app core\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1121523-files' for key 'PRIMARY'","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":287,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":225,"function":"doCoreUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/core/ajax/update.php","line":169,"function":"upgrade","class":"OC\\Updater","type":"->"}],"File":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","Line":399,"Previous":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1121523-files' for key 'PRIMARY'","Code":1062,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":69,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/core/Migrations/Version31000Date20250731062008.php","line":83,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/core/Migrations/Version31000Date20250731062008.php","line":38,"function":"cleanupDuplicateCategories","class":"OC\\Core\\Migrations\\Version31000Date20250731062008","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":499,"function":"preSchemaChange","class":"OC\\Core\\Migrations\\Version31000Date20250731062008","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":395,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":287,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":225,"function":"doCoreUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/core/ajax/update.php","line":169,"function":"upgrade","class":"OC\\Updater","type":"->"}],"File":"/var/www/html/nextcloud/lib/private/DB/Exceptions/DbalException.php","Line":56,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException","Message":"An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1121523-files' for key 'PRIMARY'","Code":1062,"Trace":[{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1976,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1918,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1218,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/Connection.php","line":466,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/core/Migrations/Version31000Date20250731062008.php","line":83,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/core/Migrations/Version31000Date20250731062008.php","line":38,"function":"cleanupDuplicateCategories","class":"OC\\Core\\Migrations\\Version31000Date20250731062008","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":499,"function":"preSchemaChange","class":"OC\\Core\\Migrations\\Version31000Date20250731062008","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":395,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":287,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":225,"function":"doCoreUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/core/ajax/update.php","line":169,"function":"upgrade","class":"OC\\Updater","type":"->"}],"File":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":62,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1121523-files' for key 'PRIMARY'","Code":1062,"Trace":[{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1212,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/Connection.php","line":466,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/core/Migrations/Version31000Date20250731062008.php","line":83,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/core/Migrations/Version31000Date20250731062008.php","line":38,"function":"cleanupDuplicateCategories","class":"OC\\Core\\Migrations\\Version31000Date20250731062008","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":499,"function":"preSchemaChange","class":"OC\\Core\\Migrations\\Version31000Date20250731062008","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":395,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":287,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":225,"function":"doCoreUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/core/ajax/update.php","line":169,"function":"upgrade","class":"OC\\Updater","type":"->"}],"File":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":24,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1121523-files' for key 'PRIMARY'","Code":"23000","Trace":[{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1212,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/Connection.php","line":466,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/core/Migrations/Version31000Date20250731062008.php","line":83,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/core/Migrations/Version31000Date20250731062008.php","line":38,"function":"cleanupDuplicateCategories","class":"OC\\Core\\Migrations\\Version31000Date20250731062008","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":499,"function":"preSchemaChange","class":"OC\\Core\\Migrations\\Version31000Date20250731062008","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/MigrationService.php","line":395,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":287,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":225,"function":"doCoreUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/core/ajax/update.php","line":169,"function":"upgrade","class":"OC\\Updater","type":"->"}],"File":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}}},"message":"Database error when running migration 31000Date20250731062008 for app core\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1121523-files' for key 'PRIMARY'","exception":{},"CustomMessage":"Database error when running migration 31000Date20250731062008 for app core\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1121523-files' for key 'PRIMARY'"}}
{"reqId":"8gt8QwYnHJJSgsyfC4OQ","level":3,"time":"2025-08-15T08:38:18+00:00","remoteAddr":"2a02:842a:6320:fd01:1014:2487:9799:abf9","user":"--","app":"updater","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=x9aAtKzpQnapryNC8s%2BR7JepeS7nRbLEV1ySC%2FlYlJY%3D%3AnuP62M%2BKBT3zgBYw3a7g2tSQEVquHYewPhDQILwQ9vQ%3D","message":"\\OC\\Updater::failure: Exception: Database error when running migration 31000Date20250731062008 for app core\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1121523-files' for key 'PRIMARY'","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0","version":"31.0.7.1","data":{"app":"updater"}}
{"reqId":"8gt8QwYnHJJSgsyfC4OQ","level":3,"time":"2025-08-15T08:38:18+00:00","remoteAddr":"2a02:842a:6320:fd01:1014:2487:9799:abf9","user":"--","app":"updater","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=x9aAtKzpQnapryNC8s%2BR7JepeS7nRbLEV1ySC%2FlYlJY%3D%3AnuP62M%2BKBT3zgBYw3a7g2tSQEVquHYewPhDQILwQ9vQ%3D","message":"\\OC\\Updater::updateEnd: Update failed","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0","version":"31.0.7.1","data":{"app":"updater"}}
{"reqId":"8gt8QwYnHJJSgsyfC4OQ","level":1,"time":"2025-08-15T08:38:18+00:00","remoteAddr":"2a02:842a:6320:fd01:1014:2487:9799:abf9","user":"--","app":"updater","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=x9aAtKzpQnapryNC8s%2BR7JepeS7nRbLEV1ySC%2FlYlJY%3D%3AnuP62M%2BKBT3zgBYw3a7g2tSQEVquHYewPhDQILwQ9vQ%3D","message":"\\OC\\Updater::maintenanceActive: Maintenance mode is kept active","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0","version":"31.0.7.1","data":{"app":"updater"}}
{"reqId":"8gt8QwYnHJJSgsyfC4OQ","level":1,"time":"2025-08-15T08:38:18+00:00","remoteAddr":"2a02:842a:6320:fd01:1014:2487:9799:abf9","user":"--","app":"updater","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=x9aAtKzpQnapryNC8s%2BR7JepeS7nRbLEV1ySC%2FlYlJY%3D%3AnuP62M%2BKBT3zgBYw3a7g2tSQEVquHYewPhDQILwQ9vQ%3D","message":"\\OC\\Updater::resetLogLevel: Reset log level to Warning(2)","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0","version":"31.0.7.1","data":{"app":"updater"}}Additional info
No response