[Bug]: InvalidArgumentException: Index name "timestamp" for table "oc_polls_options" collides with the constraint on table "oc_login_flow_v2".
⚠️ This issue respects the following points: ⚠️
- [X] This is a bug, not a question or a configuration/webserver/proxy issue.
- [X] This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
- [X] Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
- [X] I agree to follow Nextcloud's Code of Conduct.
Bug description
Wanted to update our Nextcloud from 28.08 to 29.04 upzudaten. (PHP (8.2) und MySQL (8.0)
Steps to reproduce
- not sure.
Expected behavior
Update going fine.
Installation method
None
Nextcloud Server version
28
Operating system
None
PHP engine version
PHP 8.2
Web server
None
Database engine version
MySQL
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
Preparing update
Set log level to debug
Turned on maintenance mode
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Updating database schema
Updated database
Updated "federation" to 1.19.0
Updated "lookup_server_connector" to 1.17.0
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Repair step: Update OAuth token expiration times
Updated "oauth2" to 1.17.0
Updated "password_policy" to 1.19.0
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Repair step: Update OAuth token expiration times
Repair step: init metadata
Updated "photos" to 2.5.0
Updated "files" to 2.1.0
Updated "activity" to 2.21.1
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Repair step: Update OAuth token expiration times
Repair step: init metadata
Repair step: Upgrading Circles App
Updated "circles" to 29.0.0-dev
Updated "cloud_federation_api" to 1.12.0
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Repair step: Update OAuth token expiration times
Repair step: init metadata
Repair step: Upgrading Circles App
Repair step: Fix component of birthday calendars
Repair info: 4 birthday calendars updated.
Repair step: Regenerating birthday calendars to use new icons and fix old birthday events without year
Repair info: Repair step already executed
Repair step: Fix broken values of calendar objects
\[0 / 0\]: Fix broken values of calendar objects
Repair step: Registering building of calendar search index as background job
Repair info: Repair step already executed
Repair step: Register building of social profile search index as background job
Repair info: Repair step already executed
Repair step: Registering background jobs to update cache for webcal calendars
Repair info: Added 0 background jobs to update webcal calendars
Repair step: Registering building of calendar reminder index as background job
Repair info: Repair step already executed
Repair step: Clean up orphan event and contact data
Repair info: 0 events without a calendar have been cleaned up
Repair info: 0 properties without an events have been cleaned up
Repair info: 0 changes without a calendar have been cleaned up
Repair info: 0 cached events without a calendar subscription have been cleaned up
Repair info: 0 changes without a calendar subscription have been cleaned up
Repair info: 0 contacts without an addressbook have been cleaned up
Repair info: 0 properties without a contact have been cleaned up
Repair info: 0 changes without an addressbook have been cleaned up
Repair step: Remove activity entries of private events
Repair info: Removed 0 activity entries
Repair step: Clean up old calendar subscriptions from deleted users that were not cleaned-up
\[0 / 0\]: Clean up old calendar subscriptions from deleted users that were not cleaned-up
Repair info: 0 calendar subscriptions without an user have been cleaned up
Repair step: Remove invalid object properties
Repair info: 0 invalid object properties removed.
Updated "dav" to 1.30.1
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Repair step: Update OAuth token expiration times
Repair step: init metadata
Repair step: Upgrading Circles App
Repair step: Fix component of birthday calendars
Repair info: 4 birthday calendars updated.
Repair step: Regenerating birthday calendars to use new icons and fix old birthday events without year
Repair info: Repair step already executed
Repair step: Fix broken values of calendar objects
\[0 / 0\]: Fix broken values of calendar objects
Repair step: Registering building of calendar search index as background job
Repair info: Repair step already executed
Repair step: Register building of social profile search index as background job
Repair info: Repair step already executed
Repair step: Registering background jobs to update cache for webcal calendars
Repair info: Added 0 background jobs to update webcal calendars
Repair step: Registering building of calendar reminder index as background job
Repair info: Repair step already executed
Repair step: Clean up orphan event and contact data
Repair info: 0 events without a calendar have been cleaned up
Repair info: 0 properties without an events have been cleaned up
Repair info: 0 changes without a calendar have been cleaned up
Repair info: 0 cached events without a calendar subscription have been cleaned up
Repair info: 0 changes without a calendar subscription have been cleaned up
Repair info: 0 contacts without an addressbook have been cleaned up
Repair info: 0 properties without a contact have been cleaned up
Repair info: 0 changes without an addressbook have been cleaned up
Repair step: Remove activity entries of private events
Repair info: Removed 0 activity entries
Repair step: Clean up old calendar subscriptions from deleted users that were not cleaned-up
\[0 / 0\]: Clean up old calendar subscriptions from deleted users that were not cleaned-up
Repair info: 0 calendar subscriptions without an user have been cleaned up
Repair step: Remove invalid object properties
Repair info: 0 invalid object properties removed.
Repair step: Fix the share type of guest shares when migrating from ownCloud
Repair step: Copy the share password into the dedicated column
Repair step: Set existing shares as accepted
Updated "files_sharing" to 1.21.0
Updated "files_trashbin" to 1.19.0
Updated "files_versions" to 1.22.0
Updated "sharebymail" to 1.19.0
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Repair step: Update OAuth token expiration times
Repair step: init metadata
Repair step: Upgrading Circles App
Repair step: Fix component of birthday calendars
Repair info: 4 birthday calendars updated.
Repair step: Regenerating birthday calendars to use new icons and fix old birthday events without year
Repair info: Repair step already executed
Repair step: Fix broken values of calendar objects
\[0 / 0\]: Fix broken values of calendar objects
Repair step: Registering building of calendar search index as background job
Repair info: Repair step already executed
Repair step: Register building of social profile search index as background job
Repair info: Repair step already executed
Repair step: Registering background jobs to update cache for webcal calendars
Repair info: Added 0 background jobs to update webcal calendars
Repair step: Registering building of calendar reminder index as background job
Repair info: Repair step already executed
Repair step: Clean up orphan event and contact data
Repair info: 0 events without a calendar have been cleaned up
Repair info: 0 properties without an events have been cleaned up
Repair info: 0 changes without a calendar have been cleaned up
Repair info: 0 cached events without a calendar subscription have been cleaned up
Repair info: 0 changes without a calendar subscription have been cleaned up
Repair info: 0 contacts without an addressbook have been cleaned up
Repair info: 0 properties without a contact have been cleaned up
Repair info: 0 changes without an addressbook have been cleaned up
Repair step: Remove activity entries of private events
Repair info: Removed 0 activity entries
Repair step: Clean up old calendar subscriptions from deleted users that were not cleaned-up
\[0 / 0\]: Clean up old calendar subscriptions from deleted users that were not cleaned-up
Repair info: 0 calendar subscriptions without an user have been cleaned up
Repair step: Remove invalid object properties
Repair info: 0 invalid object properties removed.
Repair step: Fix the share type of guest shares when migrating from ownCloud
Repair step: Copy the share password into the dedicated column
Repair step: Set existing shares as accepted
Repair step: Populating added database structures for workflows
Updated "workflowengine" to 2.11.0
Updated "comments" to 1.19.0
Updated "firstrunwizard" to 2.18.0
Updated "logreader" to 2.14.0
Updated "nextcloud_announcements" to 1.18.0
Updated "notifications" to 2.17.0
Updated "systemtags" to 1.19.0
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Repair step: Update OAuth token expiration times
Repair step: init metadata
Repair step: Upgrading Circles App
Repair step: Fix component of birthday calendars
Repair info: 4 birthday calendars updated.
Repair step: Regenerating birthday calendars to use new icons and fix old birthday events without year
Repair info: Repair step already executed
Repair step: Fix broken values of calendar objects
\[0 / 0\]: Fix broken values of calendar objects
Repair step: Registering building of calendar search index as background job
Repair info: Repair step already executed
Repair step: Register building of social profile search index as background job
Repair info: Repair step already executed
Repair step: Registering background jobs to update cache for webcal calendars
Repair info: Added 0 background jobs to update webcal calendars
Repair step: Registering building of calendar reminder index as background job
Repair info: Repair step already executed
Repair step: Clean up orphan event and contact data
Repair info: 0 events without a calendar have been cleaned up
Repair info: 0 properties without an events have been cleaned up
Repair info: 0 changes without a calendar have been cleaned up
Repair info: 0 cached events without a calendar subscription have been cleaned up
Repair info: 0 changes without a calendar subscription have been cleaned up
Repair info: 0 contacts without an addressbook have been cleaned up
Repair info: 0 properties without a contact have been cleaned up
Repair info: 0 changes without an addressbook have been cleaned up
Repair step: Remove activity entries of private events
Repair info: Removed 0 activity entries
Repair step: Clean up old calendar subscriptions from deleted users that were not cleaned-up
\[0 / 0\]: Clean up old calendar subscriptions from deleted users that were not cleaned-up
Repair info: 0 calendar subscriptions without an user have been cleaned up
Repair step: Remove invalid object properties
Repair info: 0 invalid object properties removed.
Repair step: Fix the share type of guest shares when migrating from ownCloud
Repair step: Copy the share password into the dedicated column
Repair step: Set existing shares as accepted
Repair step: Populating added database structures for workflows
Repair step: Initialize migration of background images from dashboard to theming app
Updated "theming" to 2.4.0
Updated "bruteforcesettings" to 2.9.0
Updated "contactsinteraction" to 1.10.0
Updated "dashboard" to 7.9.0
Updated "federatedfilesharing" to 1.19.0
Updated "files_pdfviewer" to 2.10.0
Updated "files_reminders" to 1.2.0
Updated "privacy" to 1.13.0
Updated "provisioning_api" to 1.19.0
Updated "recommendations" to 2.1.0
Updated "related_resources" to 1.4.0
Updated "serverinfo" to 1.19.0
Updated "settings" to 1.12.0
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Repair step: Update OAuth token expiration times
Repair step: init metadata
Repair step: Upgrading Circles App
Repair step: Fix component of birthday calendars
Repair info: 4 birthday calendars updated.
Repair step: Regenerating birthday calendars to use new icons and fix old birthday events without year
Repair info: Repair step already executed
Repair step: Fix broken values of calendar objects
\[0 / 0\]: Fix broken values of calendar objects
Repair step: Registering building of calendar search index as background job
Repair info: Repair step already executed
Repair step: Register building of social profile search index as background job
Repair info: Repair step already executed
Repair step: Registering background jobs to update cache for webcal calendars
Repair info: Added 0 background jobs to update webcal calendars
Repair step: Registering building of calendar reminder index as background job
Repair info: Repair step already executed
Repair step: Clean up orphan event and contact data
Repair info: 0 events without a calendar have been cleaned up
Repair info: 0 properties without an events have been cleaned up
Repair info: 0 changes without a calendar have been cleaned up
Repair info: 0 cached events without a calendar subscription have been cleaned up
Repair info: 0 changes without a calendar subscription have been cleaned up
Repair info: 0 contacts without an addressbook have been cleaned up
Repair info: 0 properties without a contact have been cleaned up
Repair info: 0 changes without an addressbook have been cleaned up
Repair step: Remove activity entries of private events
Repair info: Removed 0 activity entries
Repair step: Clean up old calendar subscriptions from deleted users that were not cleaned-up
\[0 / 0\]: Clean up old calendar subscriptions from deleted users that were not cleaned-up
Repair info: 0 calendar subscriptions without an user have been cleaned up
Repair step: Remove invalid object properties
Repair info: 0 invalid object properties removed.
Repair step: Fix the share type of guest shares when migrating from ownCloud
Repair step: Copy the share password into the dedicated column
Repair step: Set existing shares as accepted
Repair step: Populating added database structures for workflows
Repair step: Initialize migration of background images from dashboard to theming app
Repair step: Switches from default updater server to the customer one if a valid subscription is available
Repair info: Repair step already executed
Updated "support" to 1.12.0
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Repair step: Update OAuth token expiration times
Repair step: init metadata
Repair step: Upgrading Circles App
Repair step: Fix component of birthday calendars
Repair info: 4 birthday calendars updated.
Repair step: Regenerating birthday calendars to use new icons and fix old birthday events without year
Repair info: Repair step already executed
Repair step: Fix broken values of calendar objects
\[0 / 0\]: Fix broken values of calendar objects
Repair step: Registering building of calendar search index as background job
Repair info: Repair step already executed
Repair step: Register building of social profile search index as background job
Repair info: Repair step already executed
Repair step: Registering background jobs to update cache for webcal calendars
Repair info: Added 0 background jobs to update webcal calendars
Repair step: Registering building of calendar reminder index as background job
Repair info: Repair step already executed
Repair step: Clean up orphan event and contact data
Repair info: 0 events without a calendar have been cleaned up
Repair info: 0 properties without an events have been cleaned up
Repair info: 0 changes without a calendar have been cleaned up
Repair info: 0 cached events without a calendar subscription have been cleaned up
Repair info: 0 changes without a calendar subscription have been cleaned up
Repair info: 0 contacts without an addressbook have been cleaned up
Repair info: 0 properties without a contact have been cleaned up
Repair info: 0 changes without an addressbook have been cleaned up
Repair step: Remove activity entries of private events
Repair info: Removed 0 activity entries
Repair step: Clean up old calendar subscriptions from deleted users that were not cleaned-up
\[0 / 0\]: Clean up old calendar subscriptions from deleted users that were not cleaned-up
Repair info: 0 calendar subscriptions without an user have been cleaned up
Repair step: Remove invalid object properties
Repair info: 0 invalid object properties removed.
Repair step: Fix the share type of guest shares when migrating from ownCloud
Repair step: Copy the share password into the dedicated column
Repair step: Set existing shares as accepted
Repair step: Populating added database structures for workflows
Repair step: Initialize migration of background images from dashboard to theming app
Repair step: Switches from default updater server to the customer one if a valid subscription is available
Repair info: Repair step already executed
Repair step: Send an admin notification if monthly report is disabled
Updated "survey_client" to 1.17.0
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Repair step: Update OAuth token expiration times
Repair step: init metadata
Repair step: Upgrading Circles App
Repair step: Fix component of birthday calendars
Repair info: 4 birthday calendars updated.
Repair step: Regenerating birthday calendars to use new icons and fix old birthday events without year
Repair info: Repair step already executed
Repair step: Fix broken values of calendar objects
\[0 / 0\]: Fix broken values of calendar objects
Repair step: Registering building of calendar search index as background job
Repair info: Repair step already executed
Repair step: Register building of social profile search index as background job
Repair info: Repair step already executed
Repair step: Registering background jobs to update cache for webcal calendars
Repair info: Added 0 background jobs to update webcal calendars
Repair step: Registering building of calendar reminder index as background job
Repair info: Repair step already executed
Repair step: Clean up orphan event and contact data
Repair info: 0 events without a calendar have been cleaned up
Repair info: 0 properties without an events have been cleaned up
Repair info: 0 changes without a calendar have been cleaned up
Repair info: 0 cached events without a calendar subscription have been cleaned up
Repair info: 0 changes without a calendar subscription have been cleaned up
Repair info: 0 contacts without an addressbook have been cleaned up
Repair info: 0 properties without a contact have been cleaned up
Repair info: 0 changes without an addressbook have been cleaned up
Repair step: Remove activity entries of private events
Repair info: Removed 0 activity entries
Repair step: Clean up old calendar subscriptions from deleted users that were not cleaned-up
\[0 / 0\]: Clean up old calendar subscriptions from deleted users that were not cleaned-up
Repair info: 0 calendar subscriptions without an user have been cleaned up
Repair step: Remove invalid object properties
Repair info: 0 invalid object properties removed.
Repair step: Fix the share type of guest shares when migrating from ownCloud
Repair step: Copy the share password into the dedicated column
Repair step: Set existing shares as accepted
Repair step: Populating added database structures for workflows
Repair step: Initialize migration of background images from dashboard to theming app
Repair step: Switches from default updater server to the customer one if a valid subscription is available
Repair info: Repair step already executed
Repair step: Send an admin notification if monthly report is disabled
Repair step: Force-reset all Text document sessions
Updated "text" to 3.10.1
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Repair step: Update OAuth token expiration times
Repair step: init metadata
Repair step: Upgrading Circles App
Repair step: Fix component of birthday calendars
Repair info: 4 birthday calendars updated.
Repair step: Regenerating birthday calendars to use new icons and fix old birthday events without year
Repair info: Repair step already executed
Repair step: Fix broken values of calendar objects
\[0 / 0\]: Fix broken values of calendar objects
Repair step: Registering building of calendar search index as background job
Repair info: Repair step already executed
Repair step: Register building of social profile search index as background job
Repair info: Repair step already executed
Repair step: Registering background jobs to update cache for webcal calendars
Repair info: Added 0 background jobs to update webcal calendars
Repair step: Registering building of calendar reminder index as background job
Repair info: Repair step already executed
Repair step: Clean up orphan event and contact data
Repair info: 0 events without a calendar have been cleaned up
Repair info: 0 properties without an events have been cleaned up
Repair info: 0 changes without a calendar have been cleaned up
Repair info: 0 cached events without a calendar subscription have been cleaned up
Repair info: 0 changes without a calendar subscription have been cleaned up
Repair info: 0 contacts without an addressbook have been cleaned up
Repair info: 0 properties without a contact have been cleaned up
Repair info: 0 changes without an addressbook have been cleaned up
Repair step: Remove activity entries of private events
Repair info: Removed 0 activity entries
Repair step: Clean up old calendar subscriptions from deleted users that were not cleaned-up
\[0 / 0\]: Clean up old calendar subscriptions from deleted users that were not cleaned-up
Repair info: 0 calendar subscriptions without an user have been cleaned up
Repair step: Remove invalid object properties
Repair info: 0 invalid object properties removed.
Repair step: Fix the share type of guest shares when migrating from ownCloud
Repair step: Copy the share password into the dedicated column
Repair step: Set existing shares as accepted
Repair step: Populating added database structures for workflows
Repair step: Initialize migration of background images from dashboard to theming app
Repair step: Switches from default updater server to the customer one if a valid subscription is available
Repair info: Repair step already executed
Repair step: Send an admin notification if monthly report is disabled
Repair step: Force-reset all Text document sessions
Repair step: Add background job to check for backup codes
Updated "twofactor_backupcodes" to 1.18.0
Updated "updatenotification" to 1.19.1
Updated "user_status" to 1.9.0
Updated "viewer" to 2.3.0
Updated "weather_status" to 1.9.0
Update app "contacts" from App Store
Update app "deck" from App Store
Update app "files_fulltextsearch" from App Store
Update app "fulltextsearch" from App Store
Update app "groupfolders" from App Store
Update app "impersonate" from App Store
Update app "richdocuments" from App Store
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Copy data from accounts table when migrating from ownCloud
Repair step: Drop account terms table when migrating from ownCloud
Repair step: Update OAuth token expiration times
Repair step: init metadata
Repair step: Upgrading Circles App
Repair step: Fix component of birthday calendars
Repair info: 4 birthday calendars updated.
Repair step: Regenerating birthday calendars to use new icons and fix old birthday events without year
Repair info: Repair step already executed
Repair step: Fix broken values of calendar objects
\[0 / 0\]: Fix broken values of calendar objects
Repair step: Registering building of calendar search index as background job
Repair info: Repair step already executed
Repair step: Register building of social profile search index as background job
Repair info: Repair step already executed
Repair step: Registering background jobs to update cache for webcal calendars
Repair info: Added 0 background jobs to update webcal calendars
Repair step: Registering building of calendar reminder index as background job
Repair info: Repair step already executed
Repair step: Clean up orphan event and contact data
Repair info: 0 events without a calendar have been cleaned up
Repair info: 0 properties without an events have been cleaned up
Repair info: 0 changes without a calendar have been cleaned up
Repair info: 0 cached events without a calendar subscription have been cleaned up
Repair info: 0 changes without a calendar subscription have been cleaned up
Repair info: 0 contacts without an addressbook have been cleaned up
Repair info: 0 properties without a contact have been cleaned up
Repair info: 0 changes without an addressbook have been cleaned up
Repair step: Remove activity entries of private events
Repair info: Removed 0 activity entries
Repair step: Clean up old calendar subscriptions from deleted users that were not cleaned-up
\[0 / 0\]: Clean up old calendar subscriptions from deleted users that were not cleaned-up
Repair info: 0 calendar subscriptions without an user have been cleaned up
Repair step: Remove invalid object properties
Repair info: 0 invalid object properties removed.
Repair step: Fix the share type of guest shares when migrating from ownCloud
Repair step: Copy the share password into the dedicated column
Repair step: Set existing shares as accepted
Repair step: Populating added database structures for workflows
Repair step: Initialize migration of background images from dashboard to theming app
Repair step: Switches from default updater server to the customer one if a valid subscription is available
Repair info: Repair step already executed
Repair step: Send an admin notification if monthly report is disabled
Repair step: Force-reset all Text document sessions
Repair step: Add background job to check for backup codes
Repair step: Install default fonts
InvalidArgumentException: Index name "timestamp" for table "oc_polls_options" collides with the constraint on table "oc_login_flow_v2".
Additional info
No response
Any suggestions how to fix this?
Thank you very much.
edit: the Nextcloud is running on a Mittwald server.
cc @hamza221
A bit weird to see that error because the code leading to the error was reworked for 29 to only fail on installations but not on updates.
https://github.com/nextcloud/server/blob/f9d4becf60da69f272f6c5700bbdf5cb99761bc4/core/Migrations/Version16000Date20190212081545.php#L82
https://github.com/nextcloud/polls/blob/a073c67a6a89e0d02282fcc4aa514c3e109dc15a/lib/Migration/TableSchema.php#L58
Indeed, there's an index on both tables using timestamp, but the polls index goes over multiple columns.
As I assume, this is no app issue for polls. Should we move this to the server repo?
This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.