nextcloud / server

☁️ Nextcloud server, a safe home for all your data
https://nextcloud.com
GNU Affero General Public License v3.0
26.63k stars 3.99k forks source link

[Bug]: InvalidArgumentException: Index name "timestamp" for table "oc_polls_options" collides with the constraint on table "oc_login_flow_v2". #46701

Open hansimausisteffiwurstbrot opened 1 month ago

hansimausisteffiwurstbrot commented 1 month ago

⚠️ This issue respects the following points: ⚠️

Bug description

Wanted to update our Nextcloud from 28.08 to 29.04 upzudaten. (PHP (8.2) und MySQL (8.0)

Steps to reproduce

  1. 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?

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

hansimausisteffiwurstbrot commented 1 month ago

Any suggestions how to fix this?

Thank you very much.

edit: the Nextcloud is running on a Mittwald server.

kesselb commented 1 month ago

cc @hamza221

kesselb commented 1 month ago

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.