[sympa-fr] Pb sur upgrade sympa 5.1.2 to 5.2.1 avec mysql

["Luc VEILLON (DSI/SECU)" <adresse@cachée>]

Bonjour,

Je poste ce mail à la liste avant de remplir une déclaration de bug, au
cas où quelqu'un aurait rencontré la même difficulté et l'aurait résolue
(ou contournée).

Fonctionnant sur sympa 5.1.2, je viens de migrer en 5.2.1 ce matin.

La migration semble se passer correctement, mais au lancement de sympa
5.2.1, le démon task_manager.pl refuse de se lancer :

Starting module task_manager.pl:

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

failure

task_manager.pl started: success


Malgré le message de success, le processus task_manager n'est
effectivement pas lancé.

En parallèle, je reçois en tant que listmaster deux courriers successifs
intitulés :

La structure de la base de données a été mise à jour

(voir plus bas pour contenu complet)
puis

Listmaster / sympa_died 

avec comme contenu pour ce dernier :

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

La structure de la base sympa me semble effectivement modifiée (les
index, en particulier reflètent bien ce qui est inscrit dans le CR
d'upgrade).

Obéissant, je lance la procédure d'upgrade par sympa.pl telle que
réclamée au lancement du task_manager :
./sympa.pl  --upgrade --from=5.1.2 --to=5.2.1
Cela n'améliore rien (voir CR plus bas), le task_manager refuse toujours
de reconnaître la structure de la base.
Le reste des démons tourne, les abonnés semblent correctement
enregistrés. Sauf modif que je n'aurais pas repérée, je soupçonne la
routine de vérification de structure de se planter et de croire que la
base est non conforme alors qu'elle l'est.

Une idée ??

------------------
CR de l'upgrade envoyé par courrier à listmaster :
La structure de la base de données a été mise à jour ; consultez les
journaux pour plus de détails :
  Table netidmap_table created in database sympa
  Field 'included_admin'  (table 'admin_table' ; database 'sympa') 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 'sympa') was NOT
found. Attempting to add it...
  Field robot_admin added to table admin_table
  Field 'subscribed_admin'  (table 'admin_table' ; database 'sympa')
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
'sympa') was NOT found. Attempting to add it...
  Field bounce_address_subscriber added to table subscriber_table
  Field 'included_subscriber'  (table 'subscriber_table' ; database
'sympa') 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 'sympa')
was NOT found. Attempting to add it...
  Field robot_subscriber added to table subscriber_table
  Field 'subscribed_subscriber'  (table 'subscriber_table' ; database
'sympa') 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
'sympa') 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 'sympa') was
NOT found. Attempting to add it...
  Field email_netidmap added to table netidmap_table
  Field 'netid_netidmap' (table 'netidmap_table' ; database 'sympa') was
NOT found. Attempting to add it...
  Field netid_netidmap added to table netidmap_table
  Field 'robot_netidmap' (table 'netidmap_table' ; database 'sympa') was
NOT found. Attempting to add it...
  Field robot_netidmap added to table netidmap_table
  Field 'serviceid_netidmap' (table 'netidmap_table' ; database 'sympa')
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
  Table netidmap_table, INDEX set on
netid_netidmap,serviceid_netidmap,robot_netidmap

-------------------
CR de l'upgrade par sympa.pl :
</export/users/sympa/bin>valinor<root>: ./sympa.pl  --upgrade
--from=5.1.2 --to=5.2.1
Conf::_load_auth(/export/users/sympa/bin/etc/auth.conf)
Conf::_load_auth(/export/users/sympa/bin/etc/auth.conf)
Conf::_load_auth(/export/users/sympa/bin/etc/auth.conf)
Conf::_load_auth(/export/users/sympa/bin/etc/auth.conf)
Configuration file read, default log level  0
Sympa 5.2.1 started
List::upgrade(5.1.2, 5.2.1)
Updating the new robot_subscriber and robot_admin  Db fields...
Waiting for read lock on
/export/users/sympa/expl/aden00/include_admin_user.lock
Waiting for read lock on
/export/users/sympa/expl/aden00/include_admin_user.lock
Waiting for read lock on
/export/users/sympa/expl/aden00/include_admin_user.lock
Waiting for read lock on
/export/users/sympa/expl/aden00/include_admin_user.lock
Waiting for read lock on
/export/users/sympa/expl/aden00/include_admin_user.lock
Waiting for read lock on
/export/users/sympa/expl/aden00/include_admin_user.lock
Waiting for read lock on
/export/users/sympa/expl/aden00/include_admin_user.lock
Waiting for read lock on
/export/users/sympa/expl/aden00/include_admin_user.lock
Waiting for read lock on
/export/users/sympa/expl/aden00/include_admin_user.lock
Waiting for read lock on
/export/users/sympa/expl/aden00/include_admin_user.lock
Failed locking /export/users/sympa/expl/aden00/include_admin_user.lock:
DBD::mysql::db do failed: Duplicate entry

'adresse@cachée' for key
1 at

/export/users/sympa/bin/List.pm line 6684.
Unable to execute SQL statement "INSERT INTO admin_table (user_admin,
comment_admin,

list_admin, robot_admin, date_admin, update_admin,

reception_admin,subscribed_admin,included_admin,include_sources_admin,
role_admin, info_admin,

profile_admin) VALUES ('adresse@cachée', 'Luc Veillon',
'aden00',

'listes.orleans.ird.fr', FROM_UNIXTIME(1149589507),
FROM_UNIXTIME(1149589507), 'mail', 1, 0,

NULL, 'owner', NULL, 'normal')" : Duplicate entry

'adresse@cachée' for key 1
List:sync_include_admin(owner): Failed to add new aden00s
List::new() : sync_include_admin_failed
Renaming web archive directories with the list domain...
Missing directory (/export/users/sympa/expl/nouveaualias) or config file
for nouveaualias
Skipping unknown list nouveaualias
Fixing DB field included_subscriber ; turning 1 to 0...
Updated 0 rows
Fixing DB field included_subscriber ; turning 2 to 1...
Updated 158 rows
Fixing DB field subscribed_subscriber ; turning 1 to 0...
Updated 0 rows
Fixing DB field subscribed_subscriber ; turning 2 to 1...
Updated 9872 rows
Renaming bounce sub-directories adding list domain...
Renamed /export/users/sympa/bounce/aden00 to

/adresse@cachée
Renamed /export/users/sympa/bounce/aden01 to

/adresse@cachée
Renamed /export/users/sympa/bounce/aden02 to

/adresse@cachée
Renamed /export/users/sympa/bounce/agents-tous to

/adresse@cachée
Renamed /export/users/sympa/bounce/aires_protegees to

/adresse@cachée
Renamed /export/users/sympa/bounce/anapirate to

/adresse@cachée
Renamed /export/users/sympa/bounce/anciens-ird to

/adresse@cachée
Renamed /export/users/sympa/bounce/cisco to

/adresse@cachée
Renamed /export/users/sympa/bounce/cizs-14 to

/adresse@cachée
Renamed /export/users/sympa/bounce/corus to
/adresse@cachée
Renamed /export/users/sympa/bounce/cssi to

/adresse@cachée
Renamed /export/users/sympa/bounce/deplacemoi to

/adresse@cachée
Renamed /export/users/sympa/bounce/dic-tous to

/adresse@cachée
Renamed /export/users/sympa/bounce/dsi-tous to

/adresse@cachée
Renamed /export/users/sympa/bounce/du to
/adresse@cachée
Renamed /export/users/sympa/bounce/envisud to

/adresse@cachée
Renamed /export/users/sympa/bounce/essai_ldap to

/adresse@cachée
Renamed /export/users/sympa/bounce/estime to

/adresse@cachée
Renamed /export/users/sympa/bounce/forummur to

/adresse@cachée
Renamed /export/users/sympa/bounce/geomatique to

/adresse@cachée
Renamed /export/users/sympa/bounce/intranet-dsi to

/adresse@cachée
Renamed /export/users/sympa/bounce/ird-tous to

/adresse@cachée
Renamed /export/users/sympa/bounce/ird-tous-ext to

/adresse@cachée
Renamed /export/users/sympa/bounce/irdal to

/adresse@cachée
Renamed /export/users/sympa/bounce/irdbko to

/adresse@cachée
Renamed /export/users/sympa/bounce/ldap-ird to

/adresse@cachée
Renamed /export/users/sympa/bounce/lettredinfopcst to

/adresse@cachée
Missing robot parameter, cannot create list object for macos
Skipping unknown list macos
Renamed /export/users/sympa/bounce/macosx to

/adresse@cachée
Renamed /export/users/sympa/bounce/mandrake to

/adresse@cachée
Renamed /export/users/sympa/bounce/matinfo.epst to

/adresse@cachée
Renamed /export/users/sympa/bounce/microtrop to

/adresse@cachée
Renamed /export/users/sympa/bounce/nis to
/adresse@cachée
Renamed /export/users/sympa/bounce/proprietaires to

/adresse@cachée
Renamed /export/users/sympa/bounce/redhat to

/adresse@cachée
Renamed /export/users/sympa/bounce/representants to

/adresse@cachée
Renamed /export/users/sympa/bounce/representants_chainons to

/adresse@cachée
Renamed /export/users/sympa/bounce/riha to

/adresse@cachée
Renamed /export/users/sympa/bounce/sil-tous to

/adresse@cachée
Renamed /export/users/sympa/bounce/solaris to

/adresse@cachée
Renamed /export/users/sympa/bounce/strate to
/adresse@cachée
Renamed /export/users/sympa/bounce/sysevol to

/adresse@cachée
Renamed /export/users/sympa/bounce/test-include to

/adresse@cachée
Renamed /export/users/sympa/bounce/tous-bondy to

/adresse@cachée
Renamed /export/users/sympa/bounce/tous-idf to

/adresse@cachée
Renamed /export/users/sympa/bounce/tous-orleans to

/adresse@cachée
Renamed /export/users/sympa/bounce/umr7138 to

/adresse@cachée
Renamed /export/users/sympa/bounce/valise to

/adresse@cachée
Renamed /export/users/sympa/bounce/webmail-ird to

/adresse@cachée
Renamed /export/users/sympa/bounce/windows to

/adresse@cachée
Update lists config using include_list parameter...

-- 
     Luc VEILLON              | IRD/Délégation aux systèmes d'information/
     tel.:+33(0)2 38 49 95 95 | RSSI - Pôle APPUI RECHERCHE/coord. technique
     Fax :+33(0)2 38 49 95 76 | 5, rue du carbone                       
     adresse@cachée   | 45072 ORLEANS CEDEX 2
     gpg : 0x237A4AD7         | AC signature : http://igc.cru.fr/ac-racine/