Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: Database error when running migration 1027Date20230504122946 for app dav: Duplicate entry '58' for key 'PRIMARY' #38873

Open
5 of 8 tasks
mod25 opened this issue Jun 18, 2023 · 8 comments
Labels
1. to develop Accepted and waiting to be taken care of 27-feedback bug feature: carddav Related to CardDAV internals feature: dav

Comments

@mod25
Copy link

mod25 commented Jun 18, 2023

⚠️ This issue respects the following points: ⚠️

Bug description

Hey community,
i use nextcloud on raspberry 4 with ubuntu. Last week watchtower updated NC docker image to Version 27.0.0. After opening website i get following issue on update:

Exception: Database error when running migration 1027Date20230504122946 for app dav An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '58' for key 'PRIMARY'

Detaillierte Protokollmeldungen
Das Update ist fehlgeschlagen. Bitte melden Sie dieses Problem an die Nextcloud Community.

Maybe someone know how to get back online with my nc instance.

thank you

Steps to reproduce

run on website update assistant

Expected behavior

run Version 27.0.0

Installation method

Community Docker image

Nextcloud Server version

27

Operating system

None

PHP engine version

None

Web server

None

Database engine version

MariaDB 11.0.2

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

  • Default user-backend (database)
  • LDAP/ Active Directory
  • SSO - SAML
  • Other

Configuration report

No response

List of activated Apps

No response

Nextcloud Signing status

No response

Nextcloud Logs

{"reqId":"KKLSOPRu82VsNk9MIS6P","level":1,"time":"2023-06-19T19:39:21+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"\\OC\\Updater::maintenanceEnabled: Turned on maintenance mode","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":0,"time":"2023-06-19T19:39:21+00:00","remoteAddr":"192.168.178.3","user":"--","app":"core","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"starting upgrade from 26.0.2.1 to 27.0.0.8","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"core"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":1,"time":"2023-06-19T19:39:21+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Repair MySQL collation","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":1,"time":"2023-06-19T19:39:21+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"OC\\Repair\\Events\\RepairInfoEvent: Repair info: All tables already have the correct collation -> nothing to do","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":1,"time":"2023-06-19T19:39:21+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Repair SQLite autoincrement","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":1,"time":"2023-06-19T19:39:21+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Copy data from accounts table when migrating from ownCloud","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":1,"time":"2023-06-19T19:39:23+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Drop account terms table when migrating from ownCloud","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":1,"time":"2023-06-19T19:39:23+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"\\OC\\Updater::dbUpgradeBefore: Updating database schema","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":1,"time":"2023-06-19T19:39:23+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"\\OC\\Updater::dbUpgrade: Updated database","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":1,"time":"2023-06-19T19:39:23+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"\\OC\\Updater::appUpgradeStarted: Updating <dav> ...","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":3,"time":"2023-06-19T19:39:23+00:00","remoteAddr":"192.168.178.3","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","exception":{"Exception":"Exception","Message":"Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'","Code":0,"Trace":[{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":359,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":271,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":139,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["27.0.0.8","26.0.2.1"]},{"file":"/var/www/html/core/ajax/update.php","line":185,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]}],"File":"/var/www/html/lib/private/DB/MigrationService.php","Line":421,"Previous":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'","Code":1062,"Trace":[{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":328,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[["Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":994,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":977,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":739,"function":"addChange","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":718,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":241,"function":"updateCard","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":229,"function":"atomic","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":278,"function":"updateUser","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Manager.php","line":527,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":277,"function":"callForAllUsers","class":"OC\\User\\Manager","type":"->","args":[["Closure"]]},{"file":"/var/www/html/apps/dav/lib/Migration/Version1027Date20230504122946.php","line":52,"function":"syncInstance","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":537,"function":"postSchemaChange","class":"OCA\\DAV\\Migration\\Version1027Date20230504122946","type":"->","args":[["OC\\Migration\\SimpleOutput"],["Closure"],["oc_"]]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":417,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["1027Date20230504122946",false]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":359,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":271,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":139,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["27.0.0.8","26.0.2.1"]},{"file":"/var/www/html/core/ajax/update.php","line":185,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]}],"File":"/var/www/html/lib/private/DB/Exceptions/DbalException.php","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException","Message":"An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'","Code":1062,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1814,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1749,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1163,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],"INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(?, ?, ?, ?)",["*** sensitive parameters replaced ***",32,"*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":295,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(?, ?, ?, ?)",["*** sensitive parameters replaced ***",32,"*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4)",["*** sensitive parameters replaced ***",32,"*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":326,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":994,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":977,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":739,"function":"addChange","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":718,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":241,"function":"updateCard","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":229,"function":"atomic","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":278,"function":"updateUser","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Manager.php","line":527,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":277,"function":"callForAllUsers","class":"OC\\User\\Manager","type":"->","args":[["Closure"]]},{"file":"/var/www/html/apps/dav/lib/Migration/Version1027Date20230504122946.php","line":52,"function":"syncInstance","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":537,"function":"postSchemaChange","class":"OCA\\DAV\\Migration\\Version1027Date20230504122946","type":"->","args":[["OC\\Migration\\SimpleOutput"],["Closure"],["oc_"]]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":417,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["1027Date20230504122946",false]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":359,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":271,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":139,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["27.0.0.8","26.0.2.1"]},{"file":"/var/www/html/core/ajax/update.php","line":185,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":64,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'","Code":1062,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":103,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[["PDOException",["23000",1062,"Duplicate entry '60' for key 'PRIMARY'"]]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1153,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":295,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(?, ?, ?, ?)",["*** sensitive parameters replaced ***",32,"*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4)",["*** sensitive parameters replaced ***",32,"*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":326,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":994,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":977,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":739,"function":"addChange","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":718,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":241,"function":"updateCard","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":229,"function":"atomic","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":278,"function":"updateUser","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Manager.php","line":527,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":277,"function":"callForAllUsers","class":"OC\\User\\Manager","type":"->","args":[["Closure"]]},{"file":"/var/www/html/apps/dav/lib/Migration/Version1027Date20230504122946.php","line":52,"function":"syncInstance","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":537,"function":"postSchemaChange","class":"OCA\\DAV\\Migration\\Version1027Date20230504122946","type":"->","args":[["OC\\Migration\\SimpleOutput"],["Closure"],["oc_"]]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":417,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["1027Date20230504122946",false]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":359,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":271,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":139,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["27.0.0.8","26.0.2.1"]},{"file":"/var/www/html/core/ajax/update.php","line":185,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":30,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'","Code":"23000","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":101,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1153,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":295,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(?, ?, ?, ?)",["*** sensitive parameters replaced ***",32,"*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4)",["*** sensitive parameters replaced ***",32,"*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":326,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":994,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":977,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":739,"function":"addChange","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":718,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":241,"function":"updateCard","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":229,"function":"atomic","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":278,"function":"updateUser","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Manager.php","line":527,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":277,"function":"callForAllUsers","class":"OC\\User\\Manager","type":"->","args":[["Closure"]]},{"file":"/var/www/html/apps/dav/lib/Migration/Version1027Date20230504122946.php","line":52,"function":"syncInstance","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":537,"function":"postSchemaChange","class":"OCA\\DAV\\Migration\\Version1027Date20230504122946","type":"->","args":[["OC\\Migration\\SimpleOutput"],["Closure"],["oc_"]]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":417,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["1027Date20230504122946",false]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":359,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":271,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":139,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["27.0.0.8","26.0.2.1"]},{"file":"/var/www/html/core/ajax/update.php","line":185,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":101}}}},"message":"Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'","exception":{},"CustomMessage":"Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":3,"time":"2023-06-19T19:39:23+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"\\OC\\Updater::failure: Exception: Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":3,"time":"2023-06-19T19:39:23+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"\\OC\\Updater::updateEnd: Update failed","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":1,"time":"2023-06-19T19:39:23+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"\\OC\\Updater::maintenanceActive: Maintenance mode is kept active","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KKLSOPRu82VsNk9MIS6P","level":1,"time":"2023-06-19T19:39:23+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D","message":"\\OC\\Updater::resetLogLevel: Reset log level to Warning(2)","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}

i guess this is the one

{
    "reqId": "KKLSOPRu82VsNk9MIS6P",
    "level": 3,
    "time": "2023-06-19T19:39:23+00:00",
    "remoteAddr": "192.168.178.3",
    "user": "--",
    "app": "no app in context",
    "method": "GET",
    "url": "/core/ajax/update.php?requesttoken=7ZrPOK8t6kg1HFveAa7f00%2F6s22qF73YQppdnUpqRHM%3D%3Au9SfU94fgn1lSiyEaZ%2B6sCKJiljhZMiAdssk8H4aFRU%3D",
    "message": "Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36",
    "version": "26.0.2.1",
    "exception": {
        "Exception": "Exception",
        "Message": "Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'",
        "Code": 0,
        "Trace": [
            {
                "file": "/var/www/html/lib/private/legacy/OC_App.php",
                "line": 844,
                "function": "migrate",
                "class": "OC\\DB\\MigrationService",
                "type": "->",
                "args": []
            },
            {
                "file": "/var/www/html/lib/private/Updater.php",
                "line": 359,
                "function": "updateApp",
                "class": "OC_App",
                "type": "::",
                "args": [
                    "*** sensitive parameters replaced ***"
                ]
            },
            {
                "file": "/var/www/html/lib/private/Updater.php",
                "line": 271,
                "function": "doAppUpgrade",
                "class": "OC\\Updater",
                "type": "->",
                "args": []
            },
            {
                "file": "/var/www/html/lib/private/Updater.php",
                "line": 139,
                "function": "doUpgrade",
                "class": "OC\\Updater",
                "type": "->",
                "args": [
                    "27.0.0.8",
                    "26.0.2.1"
                ]
            },
            {
                "file": "/var/www/html/core/ajax/update.php",
                "line": 185,
                "function": "upgrade",
                "class": "OC\\Updater",
                "type": "->",
                "args": []
            }
        ],
        "File": "/var/www/html/lib/private/DB/MigrationService.php",
        "Line": 421,
        "Previous": {
            "Exception": "OC\\DB\\Exceptions\\DbalException",
            "Message": "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'",
            "Code": 1062,
            "Trace": [
                {
                    "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
                    "line": 328,
                    "function": "wrap",
                    "class": "OC\\DB\\Exceptions\\DbalException",
                    "type": "::",
                    "args": [
                        [
                            "Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException"
                        ]
                    ]
                },
                {
                    "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                    "line": 994,
                    "function": "executeStatement",
                    "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
                    "type": "->",
                    "args": []
                },
                {
                    "file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
                    "line": 63,
                    "function": "OCA\\DAV\\CardDAV\\{closure}",
                    "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                    "type": "->",
                    "args": [
                        "*** sensitive parameters replaced ***"
                    ]
                },
                {
                    "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                    "line": 977,
                    "function": "atomic",
                    "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                    "type": "->",
                    "args": [
                        [
                            "Closure"
                        ],
                        [
                            "OC\\DB\\ConnectionAdapter"
                        ]
                    ]
                },
                {
                    "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                    "line": 739,
                    "function": "addChange",
                    "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                    "type": "->",
                    "args": [
                        "*** sensitive parameters replaced ***",
                        "*** sensitive parameters replaced ***",
                        "*** sensitive parameters replaced ***"
                    ]
                },
                {
                    "file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
                    "line": 63,
                    "function": "OCA\\DAV\\CardDAV\\{closure}",
                    "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                    "type": "->",
                    "args": [
                        "*** sensitive parameters replaced ***"
                    ]
                },
                {
                    "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                    "line": 718,
                    "function": "atomic",
                    "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                    "type": "->",
                    "args": [
                        [
                            "Closure"
                        ],
                        [
                            "OC\\DB\\ConnectionAdapter"
                        ]
                    ]
                },
                {
                    "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                    "line": 241,
                    "function": "updateCard",
                    "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                    "type": "->",
                    "args": [
                        "*** sensitive parameters replaced ***"
                    ]
                },
                {
                    "file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
                    "line": 63,
                    "function": "OCA\\DAV\\CardDAV\\{closure}",
                    "class": "OCA\\DAV\\CardDAV\\SyncService",
                    "type": "->",
                    "args": [
                        "*** sensitive parameters replaced ***"
                    ]
                },
                {
                    "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                    "line": 229,
                    "function": "atomic",
                    "class": "OCA\\DAV\\CardDAV\\SyncService",
                    "type": "->",
                    "args": [
                        [
                            "Closure"
                        ],
                        [
                            "OC\\DB\\ConnectionAdapter"
                        ]
                    ]
                },
                {
                    "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                    "line": 278,
                    "function": "updateUser",
                    "class": "OCA\\DAV\\CardDAV\\SyncService",
                    "type": "->",
                    "args": [
                        "*** sensitive parameters replaced ***"
                    ]
                },
                {
                    "file": "/var/www/html/lib/private/User/Manager.php",
                    "line": 527,
                    "function": "OCA\\DAV\\CardDAV\\{closure}",
                    "class": "OCA\\DAV\\CardDAV\\SyncService",
                    "type": "->",
                    "args": [
                        "*** sensitive parameters replaced ***"
                    ]
                },
                {
                    "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                    "line": 277,
                    "function": "callForAllUsers",
                    "class": "OC\\User\\Manager",
                    "type": "->",
                    "args": [
                        [
                            "Closure"
                        ]
                    ]
                },
                {
                    "file": "/var/www/html/apps/dav/lib/Migration/Version1027Date20230504122946.php",
                    "line": 52,
                    "function": "syncInstance",
                    "class": "OCA\\DAV\\CardDAV\\SyncService",
                    "type": "->",
                    "args": [
                        "*** sensitive parameters replaced ***"
                    ]
                },
                {
                    "file": "/var/www/html/lib/private/DB/MigrationService.php",
                    "line": 537,
                    "function": "postSchemaChange",
                    "class": "OCA\\DAV\\Migration\\Version1027Date20230504122946",
                    "type": "->",
                    "args": [
                        [
                            "OC\\Migration\\SimpleOutput"
                        ],
                        [
                            "Closure"
                        ],
                        [
                            "oc_"
                        ]
                    ]
                },
                {
                    "file": "/var/www/html/lib/private/DB/MigrationService.php",
                    "line": 417,
                    "function": "executeStep",
                    "class": "OC\\DB\\MigrationService",
                    "type": "->",
                    "args": [
                        "1027Date20230504122946",
                        false
                    ]
                },
                {
                    "file": "/var/www/html/lib/private/legacy/OC_App.php",
                    "line": 844,
                    "function": "migrate",
                    "class": "OC\\DB\\MigrationService",
                    "type": "->",
                    "args": []
                },
                {
                    "file": "/var/www/html/lib/private/Updater.php",
                    "line": 359,
                    "function": "updateApp",
                    "class": "OC_App",
                    "type": "::",
                    "args": [
                        "*** sensitive parameters replaced ***"
                    ]
                },
                {
                    "file": "/var/www/html/lib/private/Updater.php",
                    "line": 271,
                    "function": "doAppUpgrade",
                    "class": "OC\\Updater",
                    "type": "->",
                    "args": []
                },
                {
                    "file": "/var/www/html/lib/private/Updater.php",
                    "line": 139,
                    "function": "doUpgrade",
                    "class": "OC\\Updater",
                    "type": "->",
                    "args": [
                        "27.0.0.8",
                        "26.0.2.1"
                    ]
                },
                {
                    "file": "/var/www/html/core/ajax/update.php",
                    "line": 185,
                    "function": "upgrade",
                    "class": "OC\\Updater",
                    "type": "->",
                    "args": []
                }
            ],
            "File": "/var/www/html/lib/private/DB/Exceptions/DbalException.php",
            "Line": 71,
            "Previous": {
                "Exception": "Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException",
                "Message": "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'",
                "Code": 1062,
                "Trace": [
                    {
                        "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
                        "line": 1814,
                        "function": "convert",
                        "class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
                        "type": "->",
                        "args": [
                            [
                                "Doctrine\\DBAL\\Driver\\PDO\\Exception"
                            ],
                            [
                                "Doctrine\\DBAL\\Query"
                            ]
                        ]
                    },
                    {
                        "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
                        "line": 1749,
                        "function": "handleDriverException",
                        "class": "Doctrine\\DBAL\\Connection",
                        "type": "->",
                        "args": [
                            [
                                "Doctrine\\DBAL\\Driver\\PDO\\Exception"
                            ],
                            [
                                "Doctrine\\DBAL\\Query"
                            ]
                        ]
                    },
                    {
                        "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
                        "line": 1163,
                        "function": "convertExceptionDuringQuery",
                        "class": "Doctrine\\DBAL\\Connection",
                        "type": "->",
                        "args": [
                            [
                                "Doctrine\\DBAL\\Driver\\PDO\\Exception"
                            ],
                            "INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(?, ?, ?, ?)",
                            [
                                "*** sensitive parameters replaced ***",
                                32,
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***"
                            ],
                            [
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***"
                            ]
                        ]
                    },
                    {
                        "file": "/var/www/html/lib/private/DB/Connection.php",
                        "line": 295,
                        "function": "executeStatement",
                        "class": "Doctrine\\DBAL\\Connection",
                        "type": "->",
                        "args": [
                            "INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(?, ?, ?, ?)",
                            [
                                "*** sensitive parameters replaced ***",
                                32,
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***"
                            ],
                            [
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***"
                            ]
                        ]
                    },
                    {
                        "file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
                        "line": 354,
                        "function": "executeStatement",
                        "class": "OC\\DB\\Connection",
                        "type": "->",
                        "args": [
                            "INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4)",
                            [
                                "*** sensitive parameters replaced ***",
                                32,
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***"
                            ],
                            [
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***"
                            ]
                        ]
                    },
                    {
                        "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
                        "line": 280,
                        "function": "execute",
                        "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
                        "type": "->",
                        "args": []
                    },
                    {
                        "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
                        "line": 326,
                        "function": "execute",
                        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
                        "type": "->",
                        "args": []
                    },
                    {
                        "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                        "line": 994,
                        "function": "executeStatement",
                        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
                        "type": "->",
                        "args": []
                    },
                    {
                        "file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
                        "line": 63,
                        "function": "OCA\\DAV\\CardDAV\\{closure}",
                        "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                        "type": "->",
                        "args": [
                            "*** sensitive parameters replaced ***"
                        ]
                    },
                    {
                        "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                        "line": 977,
                        "function": "atomic",
                        "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                        "type": "->",
                        "args": [
                            [
                                "Closure"
                            ],
                            [
                                "OC\\DB\\ConnectionAdapter"
                            ]
                        ]
                    },
                    {
                        "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                        "line": 739,
                        "function": "addChange",
                        "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                        "type": "->",
                        "args": [
                            "*** sensitive parameters replaced ***",
                            "*** sensitive parameters replaced ***",
                            "*** sensitive parameters replaced ***"
                        ]
                    },
                    {
                        "file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
                        "line": 63,
                        "function": "OCA\\DAV\\CardDAV\\{closure}",
                        "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                        "type": "->",
                        "args": [
                            "*** sensitive parameters replaced ***"
                        ]
                    },
                    {
                        "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                        "line": 718,
                        "function": "atomic",
                        "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                        "type": "->",
                        "args": [
                            [
                                "Closure"
                            ],
                            [
                                "OC\\DB\\ConnectionAdapter"
                            ]
                        ]
                    },
                    {
                        "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                        "line": 241,
                        "function": "updateCard",
                        "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                        "type": "->",
                        "args": [
                            "*** sensitive parameters replaced ***"
                        ]
                    },
                    {
                        "file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
                        "line": 63,
                        "function": "OCA\\DAV\\CardDAV\\{closure}",
                        "class": "OCA\\DAV\\CardDAV\\SyncService",
                        "type": "->",
                        "args": [
                            "*** sensitive parameters replaced ***"
                        ]
                    },
                    {
                        "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                        "line": 229,
                        "function": "atomic",
                        "class": "OCA\\DAV\\CardDAV\\SyncService",
                        "type": "->",
                        "args": [
                            [
                                "Closure"
                            ],
                            [
                                "OC\\DB\\ConnectionAdapter"
                            ]
                        ]
                    },
                    {
                        "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                        "line": 278,
                        "function": "updateUser",
                        "class": "OCA\\DAV\\CardDAV\\SyncService",
                        "type": "->",
                        "args": [
                            "*** sensitive parameters replaced ***"
                        ]
                    },
                    {
                        "file": "/var/www/html/lib/private/User/Manager.php",
                        "line": 527,
                        "function": "OCA\\DAV\\CardDAV\\{closure}",
                        "class": "OCA\\DAV\\CardDAV\\SyncService",
                        "type": "->",
                        "args": [
                            "*** sensitive parameters replaced ***"
                        ]
                    },
                    {
                        "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                        "line": 277,
                        "function": "callForAllUsers",
                        "class": "OC\\User\\Manager",
                        "type": "->",
                        "args": [
                            [
                                "Closure"
                            ]
                        ]
                    },
                    {
                        "file": "/var/www/html/apps/dav/lib/Migration/Version1027Date20230504122946.php",
                        "line": 52,
                        "function": "syncInstance",
                        "class": "OCA\\DAV\\CardDAV\\SyncService",
                        "type": "->",
                        "args": [
                            "*** sensitive parameters replaced ***"
                        ]
                    },
                    {
                        "file": "/var/www/html/lib/private/DB/MigrationService.php",
                        "line": 537,
                        "function": "postSchemaChange",
                        "class": "OCA\\DAV\\Migration\\Version1027Date20230504122946",
                        "type": "->",
                        "args": [
                            [
                                "OC\\Migration\\SimpleOutput"
                            ],
                            [
                                "Closure"
                            ],
                            [
                                "oc_"
                            ]
                        ]
                    },
                    {
                        "file": "/var/www/html/lib/private/DB/MigrationService.php",
                        "line": 417,
                        "function": "executeStep",
                        "class": "OC\\DB\\MigrationService",
                        "type": "->",
                        "args": [
                            "1027Date20230504122946",
                            false
                        ]
                    },
                    {
                        "file": "/var/www/html/lib/private/legacy/OC_App.php",
                        "line": 844,
                        "function": "migrate",
                        "class": "OC\\DB\\MigrationService",
                        "type": "->",
                        "args": []
                    },
                    {
                        "file": "/var/www/html/lib/private/Updater.php",
                        "line": 359,
                        "function": "updateApp",
                        "class": "OC_App",
                        "type": "::",
                        "args": [
                            "*** sensitive parameters replaced ***"
                        ]
                    },
                    {
                        "file": "/var/www/html/lib/private/Updater.php",
                        "line": 271,
                        "function": "doAppUpgrade",
                        "class": "OC\\Updater",
                        "type": "->",
                        "args": []
                    },
                    {
                        "file": "/var/www/html/lib/private/Updater.php",
                        "line": 139,
                        "function": "doUpgrade",
                        "class": "OC\\Updater",
                        "type": "->",
                        "args": [
                            "27.0.0.8",
                            "26.0.2.1"
                        ]
                    },
                    {
                        "file": "/var/www/html/core/ajax/update.php",
                        "line": 185,
                        "function": "upgrade",
                        "class": "OC\\Updater",
                        "type": "->",
                        "args": []
                    }
                ],
                "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
                "Line": 64,
                "Previous": {
                    "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
                    "Message": "SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'",
                    "Code": 1062,
                    "Trace": [
                        {
                            "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
                            "line": 103,
                            "function": "new",
                            "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
                            "type": "::",
                            "args": [
                                [
                                    "PDOException",
                                    [
                                        "23000",
                                        1062,
                                        "Duplicate entry '60' for key 'PRIMARY'"
                                    ]
                                ]
                            ]
                        },
                        {
                            "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
                            "line": 1153,
                            "function": "execute",
                            "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
                            "type": "->",
                            "args": []
                        },
                        {
                            "file": "/var/www/html/lib/private/DB/Connection.php",
                            "line": 295,
                            "function": "executeStatement",
                            "class": "Doctrine\\DBAL\\Connection",
                            "type": "->",
                            "args": [
                                "INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(?, ?, ?, ?)",
                                [
                                    "*** sensitive parameters replaced ***",
                                    32,
                                    "*** sensitive parameters replaced ***",
                                    "*** sensitive parameters replaced ***"
                                ],
                                [
                                    "*** sensitive parameters replaced ***",
                                    "*** sensitive parameters replaced ***",
                                    "*** sensitive parameters replaced ***",
                                    "*** sensitive parameters replaced ***"
                                ]
                            ]
                        },
                        {
                            "file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
                            "line": 354,
                            "function": "executeStatement",
                            "class": "OC\\DB\\Connection",
                            "type": "->",
                            "args": [
                                "INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4)",
                                [
                                    "*** sensitive parameters replaced ***",
                                    32,
                                    "*** sensitive parameters replaced ***",
                                    "*** sensitive parameters replaced ***"
                                ],
                                [
                                    "*** sensitive parameters replaced ***",
                                    "*** sensitive parameters replaced ***",
                                    "*** sensitive parameters replaced ***",
                                    "*** sensitive parameters replaced ***"
                                ]
                            ]
                        },
                        {
                            "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
                            "line": 280,
                            "function": "execute",
                            "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
                            "type": "->",
                            "args": []
                        },
                        {
                            "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
                            "line": 326,
                            "function": "execute",
                            "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
                            "type": "->",
                            "args": []
                        },
                        {
                            "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                            "line": 994,
                            "function": "executeStatement",
                            "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
                            "type": "->",
                            "args": []
                        },
                        {
                            "file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
                            "line": 63,
                            "function": "OCA\\DAV\\CardDAV\\{closure}",
                            "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                            "type": "->",
                            "args": [
                                "*** sensitive parameters replaced ***"
                            ]
                        },
                        {
                            "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                            "line": 977,
                            "function": "atomic",
                            "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                            "type": "->",
                            "args": [
                                [
                                    "Closure"
                                ],
                                [
                                    "OC\\DB\\ConnectionAdapter"
                                ]
                            ]
                        },
                        {
                            "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                            "line": 739,
                            "function": "addChange",
                            "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                            "type": "->",
                            "args": [
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***",
                                "*** sensitive parameters replaced ***"
                            ]
                        },
                        {
                            "file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
                            "line": 63,
                            "function": "OCA\\DAV\\CardDAV\\{closure}",
                            "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                            "type": "->",
                            "args": [
                                "*** sensitive parameters replaced ***"
                            ]
                        },
                        {
                            "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                            "line": 718,
                            "function": "atomic",
                            "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                            "type": "->",
                            "args": [
                                [
                                    "Closure"
                                ],
                                [
                                    "OC\\DB\\ConnectionAdapter"
                                ]
                            ]
                        },
                        {
                            "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                            "line": 241,
                            "function": "updateCard",
                            "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                            "type": "->",
                            "args": [
                                "*** sensitive parameters replaced ***"
                            ]
                        },
                        {
                            "file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
                            "line": 63,
                            "function": "OCA\\DAV\\CardDAV\\{closure}",
                            "class": "OCA\\DAV\\CardDAV\\SyncService",
                            "type": "->",
                            "args": [
                                "*** sensitive parameters replaced ***"
                            ]
                        },
                        {
                            "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                            "line": 229,
                            "function": "atomic",
                            "class": "OCA\\DAV\\CardDAV\\SyncService",
                            "type": "->",
                            "args": [
                                [
                                    "Closure"
                                ],
                                [
                                    "OC\\DB\\ConnectionAdapter"
                                ]
                            ]
                        },
                        {
                            "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                            "line": 278,
                            "function": "updateUser",
                            "class": "OCA\\DAV\\CardDAV\\SyncService",
                            "type": "->",
                            "args": [
                                "*** sensitive parameters replaced ***"
                            ]
                        },
                        {
                            "file": "/var/www/html/lib/private/User/Manager.php",
                            "line": 527,
                            "function": "OCA\\DAV\\CardDAV\\{closure}",
                            "class": "OCA\\DAV\\CardDAV\\SyncService",
                            "type": "->",
                            "args": [
                                "*** sensitive parameters replaced ***"
                            ]
                        },
                        {
                            "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                            "line": 277,
                            "function": "callForAllUsers",
                            "class": "OC\\User\\Manager",
                            "type": "->",
                            "args": [
                                [
                                    "Closure"
                                ]
                            ]
                        },
                        {
                            "file": "/var/www/html/apps/dav/lib/Migration/Version1027Date20230504122946.php",
                            "line": 52,
                            "function": "syncInstance",
                            "class": "OCA\\DAV\\CardDAV\\SyncService",
                            "type": "->",
                            "args": [
                                "*** sensitive parameters replaced ***"
                            ]
                        },
                        {
                            "file": "/var/www/html/lib/private/DB/MigrationService.php",
                            "line": 537,
                            "function": "postSchemaChange",
                            "class": "OCA\\DAV\\Migration\\Version1027Date20230504122946",
                            "type": "->",
                            "args": [
                                [
                                    "OC\\Migration\\SimpleOutput"
                                ],
                                [
                                    "Closure"
                                ],
                                [
                                    "oc_"
                                ]
                            ]
                        },
                        {
                            "file": "/var/www/html/lib/private/DB/MigrationService.php",
                            "line": 417,
                            "function": "executeStep",
                            "class": "OC\\DB\\MigrationService",
                            "type": "->",
                            "args": [
                                "1027Date20230504122946",
                                false
                            ]
                        },
                        {
                            "file": "/var/www/html/lib/private/legacy/OC_App.php",
                            "line": 844,
                            "function": "migrate",
                            "class": "OC\\DB\\MigrationService",
                            "type": "->",
                            "args": []
                        },
                        {
                            "file": "/var/www/html/lib/private/Updater.php",
                            "line": 359,
                            "function": "updateApp",
                            "class": "OC_App",
                            "type": "::",
                            "args": [
                                "*** sensitive parameters replaced ***"
                            ]
                        },
                        {
                            "file": "/var/www/html/lib/private/Updater.php",
                            "line": 271,
                            "function": "doAppUpgrade",
                            "class": "OC\\Updater",
                            "type": "->",
                            "args": []
                        },
                        {
                            "file": "/var/www/html/lib/private/Updater.php",
                            "line": 139,
                            "function": "doUpgrade",
                            "class": "OC\\Updater",
                            "type": "->",
                            "args": [
                                "27.0.0.8",
                                "26.0.2.1"
                            ]
                        },
                        {
                            "file": "/var/www/html/core/ajax/update.php",
                            "line": 185,
                            "function": "upgrade",
                            "class": "OC\\Updater",
                            "type": "->",
                            "args": []
                        }
                    ],
                    "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
                    "Line": 30,
                    "Previous": {
                        "Exception": "PDOException",
                        "Message": "SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'",
                        "Code": "23000",
                        "Trace": [
                            {
                                "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
                                "line": 101,
                                "function": "execute",
                                "class": "PDOStatement",
                                "type": "->",
                                "args": [
                                    null
                                ]
                            },
                            {
                                "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
                                "line": 1153,
                                "function": "execute",
                                "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
                                "type": "->",
                                "args": []
                            },
                            {
                                "file": "/var/www/html/lib/private/DB/Connection.php",
                                "line": 295,
                                "function": "executeStatement",
                                "class": "Doctrine\\DBAL\\Connection",
                                "type": "->",
                                "args": [
                                    "INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(?, ?, ?, ?)",
                                    [
                                        "*** sensitive parameters replaced ***",
                                        32,
                                        "*** sensitive parameters replaced ***",
                                        "*** sensitive parameters replaced ***"
                                    ],
                                    [
                                        "*** sensitive parameters replaced ***",
                                        "*** sensitive parameters replaced ***",
                                        "*** sensitive parameters replaced ***",
                                        "*** sensitive parameters replaced ***"
                                    ]
                                ]
                            },
                            {
                                "file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
                                "line": 354,
                                "function": "executeStatement",
                                "class": "OC\\DB\\Connection",
                                "type": "->",
                                "args": [
                                    "INSERT INTO `oc_addressbookchanges` (`uri`, `synctoken`, `addressbookid`, `operation`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4)",
                                    [
                                        "*** sensitive parameters replaced ***",
                                        32,
                                        "*** sensitive parameters replaced ***",
                                        "*** sensitive parameters replaced ***"
                                    ],
                                    [
                                        "*** sensitive parameters replaced ***",
                                        "*** sensitive parameters replaced ***",
                                        "*** sensitive parameters replaced ***",
                                        "*** sensitive parameters replaced ***"
                                    ]
                                ]
                            },
                            {
                                "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
                                "line": 280,
                                "function": "execute",
                                "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
                                "type": "->",
                                "args": []
                            },
                            {
                                "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
                                "line": 326,
                                "function": "execute",
                                "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
                                "type": "->",
                                "args": []
                            },
                            {
                                "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                                "line": 994,
                                "function": "executeStatement",
                                "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
                                "type": "->",
                                "args": []
                            },
                            {
                                "file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
                                "line": 63,
                                "function": "OCA\\DAV\\CardDAV\\{closure}",
                                "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                                "type": "->",
                                "args": [
                                    "*** sensitive parameters replaced ***"
                                ]
                            },
                            {
                                "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                                "line": 977,
                                "function": "atomic",
                                "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                                "type": "->",
                                "args": [
                                    [
                                        "Closure"
                                    ],
                                    [
                                        "OC\\DB\\ConnectionAdapter"
                                    ]
                                ]
                            },
                            {
                                "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                                "line": 739,
                                "function": "addChange",
                                "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                                "type": "->",
                                "args": [
                                    "*** sensitive parameters replaced ***",
                                    "*** sensitive parameters replaced ***",
                                    "*** sensitive parameters replaced ***"
                                ]
                            },
                            {
                                "file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
                                "line": 63,
                                "function": "OCA\\DAV\\CardDAV\\{closure}",
                                "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                                "type": "->",
                                "args": [
                                    "*** sensitive parameters replaced ***"
                                ]
                            },
                            {
                                "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
                                "line": 718,
                                "function": "atomic",
                                "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                                "type": "->",
                                "args": [
                                    [
                                        "Closure"
                                    ],
                                    [
                                        "OC\\DB\\ConnectionAdapter"
                                    ]
                                ]
                            },
                            {
                                "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                                "line": 241,
                                "function": "updateCard",
                                "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
                                "type": "->",
                                "args": [
                                    "*** sensitive parameters replaced ***"
                                ]
                            },
                            {
                                "file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
                                "line": 63,
                                "function": "OCA\\DAV\\CardDAV\\{closure}",
                                "class": "OCA\\DAV\\CardDAV\\SyncService",
                                "type": "->",
                                "args": [
                                    "*** sensitive parameters replaced ***"
                                ]
                            },
                            {
                                "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                                "line": 229,
                                "function": "atomic",
                                "class": "OCA\\DAV\\CardDAV\\SyncService",
                                "type": "->",
                                "args": [
                                    [
                                        "Closure"
                                    ],
                                    [
                                        "OC\\DB\\ConnectionAdapter"
                                    ]
                                ]
                            },
                            {
                                "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                                "line": 278,
                                "function": "updateUser",
                                "class": "OCA\\DAV\\CardDAV\\SyncService",
                                "type": "->",
                                "args": [
                                    "*** sensitive parameters replaced ***"
                                ]
                            },
                            {
                                "file": "/var/www/html/lib/private/User/Manager.php",
                                "line": 527,
                                "function": "OCA\\DAV\\CardDAV\\{closure}",
                                "class": "OCA\\DAV\\CardDAV\\SyncService",
                                "type": "->",
                                "args": [
                                    "*** sensitive parameters replaced ***"
                                ]
                            },
                            {
                                "file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
                                "line": 277,
                                "function": "callForAllUsers",
                                "class": "OC\\User\\Manager",
                                "type": "->",
                                "args": [
                                    [
                                        "Closure"
                                    ]
                                ]
                            },
                            {
                                "file": "/var/www/html/apps/dav/lib/Migration/Version1027Date20230504122946.php",
                                "line": 52,
                                "function": "syncInstance",
                                "class": "OCA\\DAV\\CardDAV\\SyncService",
                                "type": "->",
                                "args": [
                                    "*** sensitive parameters replaced ***"
                                ]
                            },
                            {
                                "file": "/var/www/html/lib/private/DB/MigrationService.php",
                                "line": 537,
                                "function": "postSchemaChange",
                                "class": "OCA\\DAV\\Migration\\Version1027Date20230504122946",
                                "type": "->",
                                "args": [
                                    [
                                        "OC\\Migration\\SimpleOutput"
                                    ],
                                    [
                                        "Closure"
                                    ],
                                    [
                                        "oc_"
                                    ]
                                ]
                            },
                            {
                                "file": "/var/www/html/lib/private/DB/MigrationService.php",
                                "line": 417,
                                "function": "executeStep",
                                "class": "OC\\DB\\MigrationService",
                                "type": "->",
                                "args": [
                                    "1027Date20230504122946",
                                    false
                                ]
                            },
                            {
                                "file": "/var/www/html/lib/private/legacy/OC_App.php",
                                "line": 844,
                                "function": "migrate",
                                "class": "OC\\DB\\MigrationService",
                                "type": "->",
                                "args": []
                            },
                            {
                                "file": "/var/www/html/lib/private/Updater.php",
                                "line": 359,
                                "function": "updateApp",
                                "class": "OC_App",
                                "type": "::",
                                "args": [
                                    "*** sensitive parameters replaced ***"
                                ]
                            },
                            {
                                "file": "/var/www/html/lib/private/Updater.php",
                                "line": 271,
                                "function": "doAppUpgrade",
                                "class": "OC\\Updater",
                                "type": "->",
                                "args": []
                            },
                            {
                                "file": "/var/www/html/lib/private/Updater.php",
                                "line": 139,
                                "function": "doUpgrade",
                                "class": "OC\\Updater",
                                "type": "->",
                                "args": [
                                    "27.0.0.8",
                                    "26.0.2.1"
                                ]
                            },
                            {
                                "file": "/var/www/html/core/ajax/update.php",
                                "line": 185,
                                "function": "upgrade",
                                "class": "OC\\Updater",
                                "type": "->",
                                "args": []
                            }
                        ],
                        "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
                        "Line": 101
                    }
                }
            }
        },
        "message": "Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'",
        "exception": {},
        "CustomMessage": "Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '60' for key 'PRIMARY'"
    }
}

Additional info

No response

@mod25 mod25 added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels Jun 18, 2023
@solracsf solracsf changed the title [Bug]: NC 27 Update failed from 26.0.2.1 [Bug]: NC 27 Update failed from 26.0.2.1 - Database error when running migration 1027Date20230504122946 for app 'dav' Jun 19, 2023
@solracsf

This comment was marked as outdated.

@ChristophWurst
Copy link
Member

I don't think it's the same as #38902. Reopening.

@ChristophWurst ChristophWurst added feature: dav regression feature: carddav Related to CardDAV internals 1. to develop Accepted and waiting to be taken care of and removed regression 0. Needs triage Pending check for reproducibility or if it fits our roadmap labels Jun 26, 2023
@ChristophWurst ChristophWurst changed the title [Bug]: NC 27 Update failed from 26.0.2.1 - Database error when running migration 1027Date20230504122946 for app 'dav' [Bug]: Database error when running migration 1027Date20230504122946 for app 'dav': Duplicate entry '58' for key 'PRIMARY' Jun 26, 2023
@ChristophWurst ChristophWurst changed the title [Bug]: Database error when running migration 1027Date20230504122946 for app 'dav': Duplicate entry '58' for key 'PRIMARY' [Bug]: Database error when running migration 1027Date20230504122946 for app dav: Duplicate entry '58' for key 'PRIMARY' Jun 26, 2023
@ChristophWurst
Copy link
Member

The problematic INSERT happens at https://github.com/nextcloud/server/blob/v27.0.0/apps/dav/lib/CardDAV/CardDavBackend.php#L986-L994.

It writes to the table (oc_)addressbookchanges. The table's primary key is id. The id is defined as 'autoincrement' => true,.

The INSERT does not specify a value for id. The database should assign one.

@ChristophWurst
Copy link
Member

ChristophWurst commented Jun 26, 2023

https://jira.mariadb.org/browse/MDEV-8827 sounds similar. @mod25 could you check if your DB has that issue?

What happens if you run

INSERT INTO oc_addressbookchanges (uri, synctoken, addressbookid, operation) VALUES ('test', 13, 99999999, 1);
INSERT INTO oc_addressbookchanges (uri, synctoken, addressbookid, operation) VALUES ('test', 13, 99999999, 1);
INSERT INTO oc_addressbookchanges (uri, synctoken, addressbookid, operation) VALUES ('test', 13, 99999999, 1);

?

@ChristophWurst
Copy link
Member

If anyone is stuck in the upgrade please apply #39005 and try again.

@mod25
Copy link
Author

mod25 commented Jun 26, 2023

@ChristophWurst here you go

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 29614
Server version: 11.0.2-MariaDB-1:11.0.2+maria~ubu2204 mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [nextcloud]> INSERT INTO oc_addressbookchanges (uri, synctoken, addressbookid, operation) VALUES ('test', 13, 99999999, 1);
Query OK, 1 row affected (0.002 sec)

MariaDB [nextcloud]> INSERT INTO oc_addressbookchanges (uri, synctoken, addressbookid, operation) VALUES ('test', 13, 99999999, 1);
Query OK, 1 row affected (0.002 sec)

MariaDB [nextcloud]> INSERT INTO oc_addressbookchanges (uri, synctoken, addressbookid, operation) VALUES ('test', 13, 99999999, 1);
Query OK, 1 row affected (0.002 sec)

MariaDB [nextcloud]> 

@mod25
Copy link
Author

mod25 commented Jun 26, 2023

@ChristophWurst new Version1027Date20230504122946.php #39005 fixed my issue. Upgrade to Version 27.0 (web version not cli) has been completed.

@lbegault
Copy link

Hello
I have the same issue when trying to upate a contact in my calendar (while syncing trough davx5 or using nextcloud interface) or when trying the upgrade from 27.0.1 to 27.1.3.
log extract:
`OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '17' for key 'PRIMARY'

/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 328:

OC\DB\Exceptions\DbalException::wrap()

/var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 994:

OC\DB\QueryBuilder\QueryBuilder->executeStatement()

/var/www/nextcloud/lib/public/AppFramework/Db/TTransactional.php - line 63:

OCA\DAV\CardDAV\CardDavBackend->OCA\DAV\CardDAV\{closure}("*** sensiti ... *")

/var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 977:

OCA\DAV\CardDAV\CardDavBackend->atomic()

/var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 739:

OCA\DAV\CardDAV\CardDavBackend->addChange()

/var/www/nextcloud/lib/public/AppFramework/Db/TTransactional.php - line 63:

OCA\DAV\CardDAV\CardDavBackend->OCA\DAV\CardDAV\{closure}("*** sensiti ... *")

/var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 718:

OCA\DAV\CardDAV\CardDavBackend->atomic()

/var/www/nextcloud/3rdparty/sabre/dav/lib/CardDAV/Card.php - line 94:

OCA\DAV\CardDAV\CardDavBackend->updateCard("*** sensiti ... *")

/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 1137:

Sabre\CardDAV\Card->put()

/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php - line 492:

Sabre\DAV\Server->updateFile("*** sensiti ... *")

/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php - line 89:

Sabre\DAV\CorePlugin->httpPut()`

The same insert at line 994 of /var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php as mod25.

Regards,
Luc B.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
1. to develop Accepted and waiting to be taken care of 27-feedback bug feature: carddav Related to CardDAV internals feature: dav
Projects
Status: 📄 To do
Development

No branches or pull requests

5 participants