Maintenance Repair fails with Nextcloud 29.0.11

[sorbaugh]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github (I've searched it).
• I agree to follow Nextcloud's Code of Conduct.

What went wrong, what did you observe?

There seems to be an issue related to the polls app when executing the occ mainenance:repair command. Reproduced in NC 29.0.11

occ maintenance:repair --include-expensive

ERROR: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3-jrehr-7ab0c03c544cd0e5cb6ec8928c57ce4d' for key 'UNIQ_votes'

Preliminary analysis shows that the issue is likely being thrown here:
https://github.com/nextcloud/polls/blob/master/lib/Migration/TableSchema.php#L56

What did you expect, how polls should behave instead?

maintenance repair step should run without errors.

What steps does it need to replay this bug?

1. Upgrade from NC 28 to NC 29.0.11
2. Run the following command: occ maintenance:repair --include-expensive

Installation method

Installed/updated from the appstore (Apps section of your site)

Installation type

Updated from a previous major version (27 to 29)

Affected polls version

7.2.9

Which browser did you use, when experiencing the bug?

• Firefox
• Chrome
• Chromium/Chromium based (i.e. Edge)
• Safari
• Other/Don't know

Other browser

No response

Add your browser log here

Additional client environment information

No response

NC version

Nextcloud 27

Other Nextcloud version

No response

PHP engine version

PHP 8.2

Other PHP version

No response

Database engine

MySQL

Database Engine version or other Database

No response

Which user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other/Don't know

Add your nextcloud server log here

Additional environment informations

No response

Configuration report

List of activated Apps

Nextcloud Signing status

Additional Information

No response

[dartcafe]

Your information is inconsistent

• Polls 7.2.9 does not support PHP 8.0
• A first time installation is unable to have duplicate entries inside the database.

Anyway, you seem to have tables from an old installation. I recommend to delete all oc_polls_* tables or call occ polls:db:rebuild which removes duplicate entries from the tables.