Skip to Content.
Sympa Menu

en - Re: [en@sympa] Duplicate entry error adding list owner (Sympa multi domain/robot)

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: IKEDA Soji <address@concealed>
  • To: "antonelli@cnaf" <address@concealed>
  • Cc: address@concealed
  • Subject: Re: [en@sympa] Duplicate entry error adding list owner (Sympa multi domain/robot)
  • Date: Fri, 16 Jun 2023 17:21:51 +0900

Hi Stefano,

On 2023/06/16 16:55, antonelli@cnaf wrote:
Hi Soji

thank you for your answer; I'm using mariadb 10.0.38

this is the output of the select query (SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 'my_sympa_db') (I attach the file too)

Perhaps removing the index named list_admin_2 would solve the problem. Please issue the following SQL statements then try adding owner again.

USE my_sympa_db;
DROP INDEX list_admin_2 ON admin_table;

This index was probably added in a very old version (maybe before 5.3)
and has not been deleted even though it is no longer needed.


Regards,
-- Soji


thank you
regards Stefano

+-----------------------+-----------------------+------------------------+
| TABLE_NAME            | INDEX_NAME            | COLUMN_NAME            |
+-----------------------+-----------------------+------------------------+
| admin_table           | PRIMARY               | list_admin             |
| admin_table           | PRIMARY               | user_admin             |
| admin_table           | PRIMARY               | robot_admin            |
| admin_table           | PRIMARY               | role_admin             |
| admin_table           | list_admin_2          | list_admin             |
| admin_table           | list_admin_2          | user_admin             |
| admin_table           | admin_user_index      | user_admin             |
| bulkmailer_table      | PRIMARY               | messagekey_bulkmailer  |
| bulkmailer_table      | PRIMARY               | packetid_bulkmailer    |
| bulkspool_table       | PRIMARY               | messagekey_bulkspool   |
| conf_table            | PRIMARY               | robot_conf             |
| conf_table            | PRIMARY               | label_conf             |
| exclusion_table       | PRIMARY               | user_exclusion         |
| exclusion_table       | PRIMARY               | robot_exclusion        |
| exclusion_table       | PRIMARY               | family_exclusion       |
| exclusion_table       | PRIMARY               | list_exclusion         |
| inclusion_table       | PRIMARY               | source_inclusion       |
| inclusion_table       | PRIMARY               | role_inclusion         |
| inclusion_table       | PRIMARY               | target_inclusion       |
| list_table            | PRIMARY               | name_list              |
| list_table            | PRIMARY               | robot_list             |
| netidmap_table        | PRIMARY               | netid_netidmap         |
| netidmap_table        | PRIMARY               | serviceid_netidmap     |
| netidmap_table        | PRIMARY               | robot_netidmap         |
| notification_table    | PRIMARY               | pk_notification        |
| one_time_ticket_table | PRIMARY               | ticket_one_time_ticket |
| session_table         | PRIMARY               | id_session             |
| session_table         | session_prev_id_index | prev_id_session        |
| stat_table            | stats_user_index      | email_stat             |
| subscriber_table      | PRIMARY               | list_subscriber        |
| subscriber_table      | PRIMARY               | user_subscriber        |
| subscriber_table      | PRIMARY               | robot_subscriber       |
| subscriber_table      | subscriber_user_index | user_subscriber        |
| user_table            | PRIMARY               | email_user             |
+-----------------------+-----------------------+------------------------+



Il 16/06/23 07:50, IKEDA Soji ha scritto:
WHERE TABLE_SCHEMA = '


--
株式会社 コンバージョン
ITソリューション部 システムソリューション1グループ 池田荘児
e-mail address@concealed
https://www.conversion.co.jp/



Archive powered by MHonArc 2.6.19+.

Top of Page