I’m trying to migrate off of postgres back to mysql (mariadb) using 24.0.4, and having a difficult time with it completing. It fails with the error below:
php8 occ db:convert-type --port 3306 --password password --all-apps mysql nextcloud 192.168.50.50 nextcloud
- files_versions - federatedfilesharing - ransomware_protection - dav - serverinfo - accessibility - twofactor_backupcodes - comments - activity - weather_status - admin_audit - oc_accounts 0/13 [>---------------------------] 0% < 1 sec/< 1 sec In ExceptionConverter.php line 60: An exception occurred while executing a query: SQLSTATE: Integrity constraint violation: 1062 Duplicate entry 'admin' for key 'PRIMARY' In Exception.php line 26: SQLSTATE: Integrity constraint violation: 1062 Duplicate entry 'admin' for key 'PRIMARY' In Statement.php line 92: SQLSTATE: Integrity constraint violation: 1062 Duplicate entry 'admin' for key 'PRIMARY'
Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can
Nextcloud version (eg, 20.0.5): 24.0.4
Operating system and version (eg, Ubuntu 20.04): docker contrainer
Apache or nginx version (eg, Apache 2.4.25): nginx, but unknown
PHP version (eg, 7.4): 8.something
The issue you are facing:
Is this the first time you’ve seen this error? (Y/N):
Steps to replicate it:
- execute php occ migration (step above)
- migration starts, fails after the oc_accounts table)
It seems that there are 2 of every account in the oc_accounts table, one with some “v2-federated” stuff and one without. can i delete one of these?