The mailing list for listmasters using Sympa

[Jérôme Zittoun <address@concealed>]

Hello,

 

usually, when DB can't create a primary key, it's because some records are in double.

 

You can check this with the query :

select count(concat(robot_subscriber, ' | ' , list_subscriber, ' | ' , user_subscriber)) as num, concat(robot_subscriber, ' | ' , list_subscriber, ' | ' , user_subscriber) from subscriber_table group by concat(robot_subscriber, ' | ' , list_subscriber, ' | ' , user_subscriber) having num > 1

 

If this query returns at least 1 record, that's why you can't define a primary key.

 

Hope this helps

 

BR,

Jérôme

--
Jérôme Zittoun
Erigne Informatique / DZ2
http://www.erigne.com
http://www.aidoveto.com

 

---

De : address@concealed [mailto:address@concealed] De la part de Amos
Envoyé : vendredi 24 octobre 2014 22:35
À : address@concealed
Objet : [sympa-users] migrating db from postgresql to mysql

It was decided that the db should be migrated from PostgreSQL to MySQL.  The DBA team imported the data from the PostgreSQL db into MySQL.  I then proceeded to bring up Sympa 6.1.23.  

Overall things go well.  Sympa updates the db structure to match the mysql settings.  However, the following error message is logged:

Oct 24 15:23:20 localhost sympa[27509]: err Upgrade::probe_db() Could not set field 'robot_subscriber,list_subscriber,user_subscriber' as PRIMARY KEY, table'subscriber_table'.

Is this serious, anything to worry about?  Should something be done manually? 

Attachment: att64cf4.jpg
Description: JPEG image

Attachment: att64d04.jpg
Description: JPEG image

Attachment: att64d05.jpg
Description: JPEG image