Re: [sympa-fr] problème upgrade base mysql sympa

[Anne-Marie Philippon <adresse@cachée>]

Le 28/10/2011 17:50, Jérôme Zittoun a écrit :

Bonjour,

 

pour évaluer le nombre de doublons (a priori anormaux) dans la table user_table, vous pouvez lancer la requête suivante sur la base d'origine :

 

select email_user, count(email_user) from user_table group by email_user having count(email_user) > 1 order by count(pre_code) desc

 

Ca vous donnera la quantité d'enregistrements qui empêchent email_user d'être clé primaire sans être obligée de refaire toute la migration.

 

Vous pourrez alors les supprimer de la base de départ avant l'upgrade.

 

Bonne soirée

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

 

De : adresse@cachée [mailto:adresse@cachée] De la part de Anne-Marie Philippon
Envoyé : vendredi 28 octobre 2011 15:45
À : adresse@cachée
Objet : [sympa-fr] problème upgrade base mysql sympa

Bonjour
Je viens d'installer un nouveau serveur sympa en version 6.1.5
Après avoir récupéré la base sympa installée sur une version 5.2.4, je n'arrive pas à upgrader ma base:

Voici ce que j'obtiens:
/usr/sbin/sympa.pl --upgrade --from=5.2.4 --to=6.1.5
info Configuration file read, default log level 0
notice Upgrade::probe_db() Table conf_table created in database sympa
notice Upgrade::probe_db() Table logs_table created in database sympa
notice Upgrade::probe_db() Table exclusion_table created in database sympa
notice Upgrade::probe_db() Table session_table created in database sympa
notice Upgrade::probe_db() Table bulkspool_table created in database sympa
notice Upgrade::probe_db() Table one_time_ticket_table created in database sympa
notice Upgrade::probe_db() Table bulkmailer_table created in database sympa
info Upgrade::probe_db() Field 'label_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field label_conf added to table conf_table
info Upgrade::probe_db() Field 'robot_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field robot_conf added to table conf_table
info Upgrade::probe_db() Field 'value_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field value_conf added to table conf_table
info Upgrade::probe_db() Missing expected primary key : robot_conf
info Upgrade::probe_db() Missing expected primary key : label_conf
info Upgrade::probe_db() Table conf_table, PRIMARY KEY set on robot_conf,label_conf
info Upgrade::probe_db() Field 'action_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field action_logs added to table logs_table
info Upgrade::probe_db() Field 'client_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field client_logs added to table logs_table
info Upgrade::probe_db() Field 'daemon_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field daemon_logs added to table logs_table
info Upgrade::probe_db() Field 'date_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field date_logs added to table logs_table
info Upgrade::probe_db() Field 'error_type_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field error_type_logs added to table logs_table
info Upgrade::probe_db() Field 'id_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field id_logs added to table logs_table
info Upgrade::probe_db() Field 'list_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field list_logs added to table logs_table
info Upgrade::probe_db() Field 'msg_id_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field msg_id_logs added to table logs_table
info Upgrade::probe_db() Field 'parameters_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field parameters_logs added to table logs_table
info Upgrade::probe_db() Field 'robot_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field robot_logs added to table logs_table
info Upgrade::probe_db() Field 'status_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field status_logs added to table logs_table
info Upgrade::probe_db() Field 'target_email_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field target_email_logs added to table logs_table
info Upgrade::probe_db() Field 'user_email_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field user_email_logs added to table logs_table
info Upgrade::probe_db() Missing expected primary key : id_logs
info Upgrade::probe_db() Table logs_table, PRIMARY KEY set on id_logs
info Upgrade::probe_db() Field 'data_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field data_user added to table user_table
info Upgrade::probe_db() Field 'last_login_date_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field last_login_date_user added to table user_table
info Upgrade::probe_db() Field 'last_login_host_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field last_login_host_user added to table user_table
info Upgrade::probe_db() Field 'wrong_login_count_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field wrong_login_count_user added to table user_table
info Upgrade::probe_db() Missing expected primary key : email_user
DBD::mysql::db do failed: Duplicate entry 'adresse@cachée' for key 1 at /usr/share/sympa/lib/Upgrade.pm line 1309.
err Upgrade::probe_db() Could not set field 'email_user' as PRIMARY KEY, table'user_table'.
Database sympa defined in sympa.conf has not the right structure or is unreachable. verify db_xxx parameters in sympa.conf

Comment s'en sortir?
Les paramètres db_... de sympa.conf sont identiques à ceux de la version 5.2.4
Si je supprime une des 2 entrées  adresse@cachée, je tombe sur la suivante, etc

Merci de m'aider
Anne-Marie Philippon


Un grand merci!
Je ne reprends le dossier que maintenant car j'étais en congé.
Sur quel critère supprime-t-on le doublon?
Cela n'a peut-être pas d'importance?
ex:

mysql> select * from user_table where email_user like 'adresse@cachée';
+---------------------------+-------------------+---------------+----------------+-----------+-----------------+-----------+----------------------+----------------------+                     ------------------------+
| email_user                | cookie_delay_user | password_user | gecos_user     | lang_user | attributes_user | data_user | last_login_date_user | last_login_host_user |                      wrong_login_count_user |
+---------------------------+-------------------+---------------+----------------+-----------+-----------------+-----------+----------------------+----------------------+                     ------------------------+
| adresse@cachée |              NULL | NULL          | REBOUL Thierry | NULL      | NULL            | NULL      |                 NULL | NULL                 |                                        NULL |
| adresse@cachée |              NULL | tlr3107       | NULL           | fr        | NULL            | NULL      |                 NULL | NULL                 |                                        NULL |
+---------------------------+-------------------+---------------+----------------+-----------+-----------------+-----------+----------------------+----------------------+                     ------------------------+
2 rows in set (0.00 sec)

Cordialement
A.M. Philippon