[sympa-fr] [Upgrade de 5.1 en 5.2.4] duplicate entry

[Serge ALGAROTTI <adresse@cachée>]

Bonjour,

je comptais mettre à jour (à partir des sources) notre sympa de la version
5.1 en 5.2.4  et ça s'est mal passé ;-)

Je viens de revenir en 5.1 avec un backup de la base précédente, tout
refonctionne comme avant pour le moment.

Il semble que j'ai eu le même problème décrit en

http://sourcesup.cru.fr/tracker/index.php?func=detail&aid=709&group_id=23&atid=167

c'est à dire dans les logs:

+++
 Updating the new robot_subscriber and robot_admin  Db fields...
 Unable to execute SQL statement "UPDATE admin_table SET
robot_admin='sympa.cemef.ensmp.fr' WHERE (list_admin='agenda')" : Duplicate
entry 'adresse@cachée' f
or key 1
+++

J'ai lu:

> It might be wwsympa.fcgi or another process' fault.

mais j'avais arrêté apache et sendmail.

J'ai lu et essayé manuellement

> Can you try running the following SQL query via the mysql command
> line client :

même erreur

au premier démarrage après la mise à jour, j'ai:

+++
/etc/init.d/sympa  start
Starting Sympa subsystem:
Starting module sympa.pl: DBD::mysql::db do failed: Can't DROP 'list_admin'.
Check that column/key exists at /home/sympa/bin/List.pm line 11003.
DBD::mysql::db do failed: Can't DROP 'robot_admin'. Check that column/key
exists at /home/sympa/bin/List.pm line 11003.
DBD::mysql::db do failed: Can't DROP 'list_subscriber'. Check that
column/key exists at /home/sympa/bin/List.pm line 11003.
DBD::mysql::db do failed: Can't DROP 'robot_subscriber'. Check that
column/key exists at /home/sympa/bin/List.pm line 11003.
DBD::mysql::db do failed: Can't DROP 'netid_netidmap'. Check that column/key
exists at /home/sympa/bin/List.pm line 11003.
DBD::mysql::db do failed: Can't DROP 'serviceid_netidmap'. Check that
column/key exists at /home/sympa/bin/List.pm line 11003.
DBD::mysql::db do failed: Can't DROP 'robot_netidmap'. Check that column/key
exists at /home/sympa/bin/List.pm line 11003.
success

Starting module archived.pl: success

Starting module bounced.pl: success

Starting module task_manager.pl: error : data structure was not updated ;
you should run sympa.pl to run the upgrade process.
failure

++++

notre configuration:
sympa compilé 5.1 sous Debian Sarge
BD: MySQL 4.0.20 compilée sous Debian Sarge


J'ai retenté 2 fois la mise à jour en repartant chaque fois de la base mysql
correspondant à la version 5.1 de sympa, j'ai eu le même problème.


Je joins les logs en attaché.

merci de votre aide,


cordialement,

-- 
Serge ALGAROTTI                             [http://www.cemef.ensmp.fr/]
Ecole des Mines de Paris-CEMEF UMR CNRS n° 7635
Configuration file read, default log level  0 
Table netidmap_table created in database sympa51old 
Field 'included_admin'  (table 'admin_table' ; database 'sympa51old') does NOT have awaited type (int(1)). Attempting to change it... 
ALTER TABLE admin_table CHANGE included_admin included_admin int(1)  
Field included_admin in table admin_table, structur updated 
Field 'robot_admin' (table 'admin_table' ; database 'sympa51old') was NOT found. Attempting to add it... 
Field robot_admin added to table admin_table 
Field 'subscribed_admin'  (table 'admin_table' ; database 'sympa51old') does NOT have awaited type (int(1)). Attempting to change it... 
ALTER TABLE admin_table CHANGE subscribed_admin subscribed_admin int(1)  
Field subscribed_admin in table admin_table, structur updated 
Table admin_table, PRIMARY KEY dropped 
Table admin_table, PRIMARY KEY set on list_admin,robot_admin,user_admin,role_admin 
Table admin_table, INDEX dropped 
Table admin_table, INDEX set on list_admin,robot_admin,user_admin,role_admin 
Field 'bounce_address_subscriber' (table 'subscriber_table' ; database 'sympa51old') was NOT found. Attempting to add it... 
Field bounce_address_subscriber added to table subscriber_table 
Field 'included_subscriber'  (table 'subscriber_table' ; database 'sympa51old') does NOT have awaited type (int(1)). Attempting to change it... 
ALTER TABLE subscriber_table CHANGE included_subscriber included_subscriber int(1)  
Field included_subscriber in table subscriber_table, structur updated 
Field 'robot_subscriber' (table 'subscriber_table' ; database 'sympa51old') was NOT found. Attempting to add it... 
Field robot_subscriber added to table subscriber_table 
Field 'subscribed_subscriber'  (table 'subscriber_table' ; database 'sympa51old') does NOT have awaited type (int(1)). Attempting to change it... 
ALTER TABLE subscriber_table CHANGE subscribed_subscriber subscribed_subscriber int(1)  
Field subscribed_subscriber in table subscriber_table, structur updated 
Field 'topics_subscriber' (table 'subscriber_table' ; database 'sympa51old') was NOT found. Attempting to add it... 
Field topics_subscriber added to table subscriber_table 
Table subscriber_table, PRIMARY KEY dropped 
Table subscriber_table, PRIMARY KEY set on list_subscriber,robot_subscriber,user_subscriber 
Table subscriber_table, INDEX dropped 
Table subscriber_table, INDEX set on list_subscriber,robot_subscriber,user_subscriber 
Field 'email_netidmap' (table 'netidmap_table' ; database 'sympa51old') was NOT found. Attempting to add it... 
Field email_netidmap added to table netidmap_table 
Field 'netid_netidmap' (table 'netidmap_table' ; database 'sympa51old') was NOT found. Attempting to add it... 
Field netid_netidmap added to table netidmap_table 
Field 'robot_netidmap' (table 'netidmap_table' ; database 'sympa51old') was NOT found. Attempting to add it... 
Field robot_netidmap added to table netidmap_table 
Field 'serviceid_netidmap' (table 'netidmap_table' ; database 'sympa51old') was NOT found. Attempting to add it... 
Field serviceid_netidmap added to table netidmap_table 
Table netidmap_table, PRIMARY KEY dropped 
Table netidmap_table, PRIMARY KEY set on netid_netidmap,serviceid_netidmap,robot_netidmap 
Could not drop INDEX, table'netidmap_table'. 
Table netidmap_table, INDEX set on netid_netidmap,serviceid_netidmap,robot_netidmap 
Sympa not setup to use DBI 
Language::SetLang(), missing locale parameter 
Sympa 5.2.4 started 
Upgrading from Sympa version 5.1 to 5.2.4 
List::upgrade(5.1, 5.2.4) 
Rename archives/log. files... 
Server started, pid 29367 
Expecting a paragraph for "editor" parameter in /home/sympa/expl/sympa-sec.cemef.ensmp.fr/gfr2005liste/config, ignore it 
Expecting a paragraph for "editor" parameter in /home/sympa/expl/sympa-sec.cemef.ensmp.fr/gfr2005liste/config, ignore it 
Expecting a paragraph for "owner" parameter in /home/sympa/expl/sympa-sec.cemef.ensmp.fr/gfr2005liste/config, ignore it 
Expecting a paragraph for "owner" parameter in /home/sympa/expl/sympa-sec.cemef.ensmp.fr/gfr2005liste/config, ignore it 
Expecting a paragraph for "editor" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/cimlib/config, ignore it 
Expecting a paragraph for "owner" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/cimlib/config, ignore it 
Expecting a paragraph for "editor" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/cs_hsimp/config, ignore it 
epeated 3 times
Expecting a paragraph for "owner" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/cs_hsimp/config, ignore it 
epeated 3 times
Expecting a paragraph for "editor" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/gfr2005liste/config, ignore it 
Expecting a paragraph for "owner" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/gfr2005liste/config, ignore it 
Expecting a paragraph for "owner" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/gt-web/config, ignore it 
Expecting a paragraph for "owner" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/gt-web/config, ignore it 
Expecting a paragraph for "creation" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/msv-sophia/config, ignore it 
Expecting a paragraph for "editor" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/support-verif/config, ignore it 
Expecting a paragraph for "owner" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/support-verif/config, ignore it 
Expecting a paragraph for "editor" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/tout_cemef/config, ignore it 
Expecting a paragraph for "editor" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/tout_cemef/config, ignore it 
Expecting a paragraph for "owner" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/tout_cemef/config, ignore it 
Expecting a paragraph for "owner" parameter in /home/sympa/expl/sympa.cemef.ensmp.fr/tout_cemef/config, ignore it 
Updating the new robot_subscriber and robot_admin  Db fields... 
Unable to execute SQL statement "UPDATE admin_table SET robot_admin='sympa.cemef.ensmp.fr' WHERE (list_admin='agenda')" : Duplicate entry 'adresse@cachée' for key 1 
]: archived 5.2.4 Started 
: bounced Started 
: bounced exited normally due to signal 
]: archived exited normally due to signal 
signal TERM received, still processing current task 
Sympa exited normally due to signal