database error on upgrade

How to use GitHub

• Please use the 👍 reaction to show that you are affected by the same issue.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

Steps to reproduce

regular upgrade/update with occ

Expected behaviour

No problems

Actual behaviour

Database error when running migration 3000Date20250120145647 for app call_summary_bot
An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'bbdbc67ad0d82bc429bc4ecdd2bf1968625da334' for key 'talk_bots_server_urlhash'

Server configuration

Web server: Apache/Nginx
Apache

Database: MySQL/Maria/SQLite/PostgreSQL
mysql
Version: 11.4.4

PHP version: 8.1/8.2/8.3
Version: 8.2.27

Nextcloud version: (see Nextcloud admin page)
31.0.0 RC1

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your Nextcloud installation folder

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your Nextcloud installation folder

Browser

Browser name: Firefox/Chrome/Safari/…

Browser version: 124/125/…

Operating system: Windows/Ubuntu/Mac/…

Insert your browser log here, this could for example include:
a) The javascript console log
b) The network log
c) ...

Start by reproducing a regular upgrade with occ on the reported Nextcloud 31.0.0 RC1, PHP 8.2.27, and MySQL 11.4.4 setup. Investigate migration 3000Date20250120145647 for app call_summary_bot and the duplicate talk_bots_server_urlhash entry. Done means the upgrade completes without the reported integrity-constraint violation.