The mailing list for listmasters using Sympa

[IKEDA Soji <address@concealed>]

Hi Stefano,

On 2023/06/15 22:49, antonelli@cnaf wrote:
> Dear Sympa,
> I have a multi domain/robot Sympa 6.2.70 on CentOS 7.9.2009 and I'm facing 
> this error:
> I have two lists same-name@domain1 and same-name@domain2 and when I try to 
> add the (yet) owner address@concealed of same-name@domain1 as owner of 
> same-name@domain2 I get an error from database. I attach the output at the 
> end.
> Am I doing anything wrong (like configuration?) or how can I bypass this 
> (provided that we authenticate only via an IdP/CAS and each user has one 
> email)?

Unnecessary index seems to exist.

You are using MySQL or MariaDB.  Could you please connect to the
database, issue the following SQL statement and show all the results?

SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = '[db_name]';

In above, [db_name] has to be replaced with the value of db_name
parameter in sympa.conf configuration file.


Regards,
-- Soji


> Thank you
> cheers Stefano
> ###
> This is the query showing the existence of address@concealed as owner of 
> same-name@domain1
> MariaDB [sympa]> select list_admin,user_admin,robot_admin,role_admin from 
> admin_table where user_admin like '%address@concealed%';
> | same-name              | address@concealed | domain1 | owner      |
> and this is the error from wwsympa.log
> 2023-06-15T15:17:49.054246+02:00 **** wwsympa[3678]: err main::#1557 > 
> main::do_review#4494 > main::_review_user#4632 > Sympa::Spindle::spin#95  > 
> Sympa::Request::Handler::add
> ::_twist#87 > Sympa::List::add_list_admin#3313 > 
> Sympa::List::_add_list_admin#3432 > Sympa::Database::do_prepared_query#382 
> Unable to execute SQL statement "INSERT INTO admin_
> table (date_epoch_admin, comment_admin, inclusion_admin, 
> inclusion_ext_admin, inclusion_label_admin, info_admin, profile_admin, 
> reception_admin, subscribed_admin, update_epoch
> _admin, visibility_admin, role_admin, user_admin, list_admin, robot_admin) 
> SELECT ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? FROM dual WHERE NOT 
> EXISTS ( SELECT 1 FROM admin_
> table WHERE role_admin = ? AND user_admin = ? AND list_admin = ? AND 
> robot_admin = ? )": (23000) Duplicate entry 'address@concealed' 
> for key 'list_admin_2'
> 2023-06-15T15:17:49.054355+02:00 lists wwsympa[3678]: err main::#1557 > 
> main::do_review#4494 > main::_review_user#4632 > Sympa::Spindle::spin#95  > 
> Sympa::Request::Handler::add
> ::_twist#87 > Sympa::List::add_list_admin#3313 > 
> Sympa::List::_add_list_admin#3461 Unable to add owner address@concealed to 
> the list Sympa::List <same-name@domain2>

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