database error on upgrade

[rcfa]

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

List of activated apps

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

Nextcloud configuration

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/…

Browser log

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

[nickvergessen]

Do you mind sharing a copy/backup of your oc_talk_bots_server?

[rcfa]

Uhm, shouldn’t be a problem, as it’s essentially unused. I was just installing various things to see if they can be installed on an arm64 platform (currently RasPi, in the future macMini). So there’s nothing sensitive anywhere.
What exactly do you need?

[nickvergessen]

If you don't use it at all, you can uninstall the app, make sure entries are removed from:

occ talk:bot:list

If it's still listed, use the uninstall command for each of the call_summary_bot entries:

occ talk:bot:uninstall <ID>

And then enable the app again.

[rcfa]

So interesting the list showed a bunch of what seemed duplicates:

# occ talk:bot:list
+----+-----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-------+—————————+
| id | name                  | description                                                                                                                                                                                     | error_count | state | features          |
+----+-----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-------+—————————+
| 1  | Call summary          | Call summary (British English) - The call summary bot posts an overview message after the call listing all participants and outlining tasks                                                     | 0           | 1     | event             |
| 2  | Protokoll             | Protokoll (Deutsch (Persönlich: Du)) - Der Anruf-Zusammenfassungs-Bot veröffentlicht nach der Unterhaltung eine Übersichtsnachricht, in der alle Teilnehmenden und die Aufgaben aufgeführt sind | 0           | 1     | event             |
| 3  | Resumen de la llamada | Resumen de la llamada (Español (España)) - El bot de resumen de llamada publica un mensaje de visión general listando a todos los participantes y delineando tareas                             | 0           | 1     | event             |
| 4  | Résumé de l'appel     | Résumé de l'appel (Français) - The call summary bot posts an overview message after the call listing all participants and outlining tasks                                                       | 0           | 1     | event             |
| 5  | ملخص المكالمة         | ملخص المكالمة (اللغة العربية) - يقوم روبوت "ملخص المكالمة"بنشر رسالة عامة بعد المكالمة يسرد فيها جميع المشاركين و يحدد المهام                                                                   | 0           | 1     | event             |
| 6  | Resumo da chamada     | Resumo da chamada (Português Brasileiro) - O bot de resumo da chamada publica uma mensagem de visão geral após a chamada, listando todos os participantes e descrevendo as tarefas              | 0           | 1     | event             |
| 7  | Çağrı özeti           | Çağrı özeti (Türkçe) - Çağrı özeti botu, çağrıdan sonra tüm katılımcıları listeleyen ve görevleri özetleyen bir özet iletisi gönderir.                                                          | 0           | 1     | event             |
| 8  | 通话摘要              | 通话摘要 (简体中文) - 通话摘要机器人会在通话结束后发布一条概述信息，列出所有与会者并概述各项任务                                                                                                | 0           | 1     | event             |
| 9  | Call summary          | Call summary (British English) - The call summary bot posts an overview message after the call listing all participants and outlining tasks                                                     | 0           | 1     | webhook, response |
| 10 | Protokoll             | Protokoll (Deutsch (Persönlich: Du)) - Der Anruf-Zusammenfassungs-Bot veröffentlicht nach der Unterhaltung eine Übersichtsnachricht, in der alle Teilnehmenden und die Aufgaben aufgeführt sind | 0           | 1     | webhook, response |
| 11 | Resumen de la llamada | Resumen de la llamada (Español (España)) - El bot de resumen de llamada publica un mensaje de visión general listando a todos los participantes y delineando tareas                             | 0           | 1     | webhook, response |
| 12 | Résumé de l'appel     | Résumé de l'appel (Français) - Le robot chargé de résumer l'appel publie un message de synthèse après l'appel, énumérant tous les participants et décrivant les tâches à accomplir.             | 0           | 1     | webhook, response |
| 13 | ملخص المكالمة         | ملخص المكالمة (اللغة العربية) - يقوم روبوت "ملخص المكالمة"بنشر رسالة عامة بعد المكالمة يسرد فيها جميع المشاركين و يحدد المهام                                                                   | 0           | 1     | webhook, response |
| 14 | Resumo da chamada     | Resumo da chamada (Português Brasileiro) - O bot de resumo da chamada publica uma mensagem de visão geral após a chamada, listando todos os participantes e descrevendo as tarefas              | 0           | 1     | webhook, response |
| 15 | Çağrı özeti           | Çağrı özeti (Türkçe) - Çağrı özeti botu, çağrıdan sonra tüm katılımcıları listeleyen ve görevleri özetleyen bir özet iletisi gönderir.                                                          | 0           | 1     | webhook, response |
| 16 | 通话摘要              | 通话摘要 (简体中文) - 通话摘要机器人会在通话结束后发布一条概述信息，列出所有与会者并概述各项任务                                                                                                | 0           | 1     | webhook, response |
| 73 | Call summary          | Call summary (British English) - The call summary bot posts an overview message after the call listing all participants and outlining tasks                                                     | 0           | 1     | webhook, response |
| 74 | Protokoll             | Protokoll (Deutsch (Persönlich: Du)) - Der Anruf-Zusammenfassungs-Bot veröffentlicht nach der Unterhaltung eine Übersichtsnachricht, in der alle Teilnehmenden und die Aufgaben aufgeführt sind | 0           | 1     | webhook, response |
| 75 | Resumen de la llamada | Resumen de la llamada (Español (España)) - El bot de resumen de llamada publica un mensaje de visión general listando a todos los participantes y delineando tareas                             | 0           | 1     | webhook, response |
| 76 | Résumé de l'appel     | Résumé de l'appel (Français) - Le robot chargé de résumer l'appel publie un message de synthèse après l'appel, énumérant tous les participants et décrivant les tâches à accomplir.             | 0           | 1     | webhook, response |
| 77 | ملخص المكالمة         | ملخص المكالمة (اللغة العربية) - يقوم روبوت "ملخص المكالمة"بنشر رسالة عامة بعد المكالمة يسرد فيها جميع المشاركين و يحدد المهام                                                                   | 0           | 1     | webhook, response |
| 78 | Resumo da chamada     | Resumo da chamada (Português Brasileiro) - O bot de resumo da chamada publica uma mensagem de visão geral após a chamada, listando todos os participantes e descrevendo as tarefas              | 0           | 1     | webhook, response |
| 79 | Çağrı özeti           | Çağrı özeti (Türkçe) - Çağrı özeti botu, çağrıdan sonra tüm katılımcıları listeleyen ve görevleri özetleyen bir özet iletisi gönderir.                                                          | 0           | 1     | webhook, response |
| 80 | 通话摘要              | 通话摘要 (简体中文) - 通话摘要机器人会在通话结束后发布一条概述信息，列出所有与会者并概述各项任务                                                                                                | 0           | 1     | webhook, response |
+----+-----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-------+—————————+

after deleting the entries, and disabling/removing the app, I could reinstall it (both didn’t work before likely due to the duplicate db entries. Unfortuately, the IDs keep monotonically increasing, so now I have bot IDs in the 90s instead of starting with 1

# occ app:remove call_summary_bot
call_summary_bot disabled
call_summary_bot 3.0.1 removed
                                                                                                                                                                                                                                                                           
# ncrestart         
                                                                                                                                                                                                                                                                           
# occ talk:bot:list              
                                                                                                                                                                                                                                                                           
# occ app:install call_summary_bot
call_summary_bot 3.0.1 installed
call_summary_bot enabled
                                                                                                                                                                                                                                                                           
# occ talk:bot:list               
+----+-----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-------+----------+
| id | name                  | description                                                                                                                                                                                     | error_count | state | features |
+----+-----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-------+----------+
| 89 | Call summary          | Call summary (British English) - The call summary bot posts an overview message after the call listing all participants and outlining tasks                                                     | 0           | 1     | event    |
| 90 | Protokoll             | Protokoll (Deutsch (Persönlich: Du)) - Der Anruf-Zusammenfassungs-Bot veröffentlicht nach der Unterhaltung eine Übersichtsnachricht, in der alle Teilnehmenden und die Aufgaben aufgeführt sind | 0           | 1     | event    |
| 91 | Resumen de la llamada | Resumen de la llamada (Español (España)) - El bot de resumen de llamada publica un mensaje de visión general listando a todos los participantes y delineando tareas                             | 0           | 1     | event    |
| 92 | Résumé de l'appel     | Résumé de l'appel (Français) - Le robot chargé de résumer l'appel publie un message de synthèse après l'appel, énumérant tous les participants et décrivant les tâches à accomplir.             | 0           | 1     | event    |
| 93 | ملخص المكالمة         | ملخص المكالمة (اللغة العربية) - يقوم روبوت "ملخص المكالمة"بنشر رسالة عامة بعد المكالمة يسرد فيها جميع المشاركين و يحدد المهام                                                                   | 0           | 1     | event    |
| 94 | Resumo da chamada     | Resumo da chamada (Português Brasileiro) - O bot de resumo da chamada publica uma mensagem de visão geral após a chamada, listando todos os participantes e descrevendo as tarefas              | 0           | 1     | event    |
| 95 | Çağrı özeti           | Çağrı özeti (Türkçe) - Çağrı özeti botu, çağrıdan sonra tüm katılımcıları listeleyen ve görevleri özetleyen bir özet iletisi gönderir.                                                          | 0           | 1     | event    |
| 96 | 通话摘要              | 通话摘要 (简体中文) - 通话摘要机器人会在通话结束后发布一条概述信息，列出所有与会者并概述各项任务                                                                                                | 0           | 1     | event    |
+----+-----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-------+----------+
                                                                                                                                                                                                                                                                           

So while my immediate problem is solved, the bigger question is, why were there duplicate entries in the first place? I assume it should simply have recognized/updated existing entries, right?

[nickvergessen]

Unfortuately, the IDs keep monotonically increasing, so now I have bot IDs in the 90s instead of starting with 1

This is no problem at all, just less beautiful on this admin command line view, the user never sees it and it has no influence on functionatily

So while my immediate problem is solved, the bigger question is, why were there duplicate entries in the first place? I assume it should simply have recognized/updated existing entries, right?

That's a good question. Most likely they had different domains associated with them, but since you removed them now already (sorry didn't think about it before), we can't know anymore, unless you have a backup.

[nickvergessen]

However it's a good indication and I will try to harden it a bit against this.