[sympa-fr] Mise a jour 5.3.3 en 5.4.7 : echec sur upgrade mysql

[Luc VEILLON <adresse@cachée>]

Bonsoir,

Je suis en train de migrer sympa de 5.3.3 en 5.4.7 (le saut direct à la
v6 ne me semblait pas judicieux).

La plateforme de recette a parfaitement migré.
La plateforme de production  vient d'échouer, et il ne me reste plus que
dix minutes sur le créneau de coupure que j'avais annoncé.

L'erreur concerne l'upgrade de la base, et tourne autour d'un pb
d'insert en duplicate entry et d'un pb de référence à un La question de
duplicate entry a été abordée dans la liste en janvier 2008, mais
l'explication qui en a été donnée était un administrateur impatient qui
lançait deux fois de suite une commande d'abonnement.
Ici, c'est le processus d'upgrade et je ne vois pas pourquoi il
lancerait deux insertions identiques.

Je n'ai pas trouvé d'autres erreurs analogues pour un upgrade de sympa :
1/ Si ça existe, pouvez vous m'indiquer l'archive qui en parle ?
2/ En lui même, ce pb vous dit il quelque chose ?

merci


Extrait des erreurs renvoyées à l'upgrade :
Upgrading from 5.3.3 to 5.4.7...
Upgrade::upgrade() Upgrade::upgrade(5.3.3, 5.4.7)
Upgrade::upgrade() Rebuilding config.bin files for ALL lists...it may
take a while...
DBD::mysql::db do failed: Duplicate entry
'adresse@cachée' for
key 1 at /export/data/sympa/bin/List.pm line 6455.
List::add_admin_user() Unable to execute SQL statement "INSERT INTO
admin_table (user_admin, comment_admin, list_admin, robot_admin,
date_admin, update_admin, reception_admin, visibility_admin,
subscribed_admin,included_admin,include_sources_admin, role_admin,
info_admin, profile_admin) VALUES ('adresse@cachée',
'Richard Koutounguimina DSI', 'acces_diff_ird', 'listes.ird.fr',
FROM_UNIXTIME(1278956489), FROM_UNIXTIME(1278956489), 'mail',
'noconceal', 1, 0, NULL, 'owner', NULL, 'privileged')" : Duplicate entry
'adresse@cachée' for key 1
List::sync_include_admin() List:sync_include_admin(owner): Failed to add
new acces_diff_irds
Attempt to free unreferenced scalar: SV 0x752f00 at
/export/data/sympa/bin/List.pm line 1489.
List::new() List::new() : sync_include_admin_failed
DBD::mysql::st fetchrow_hashref failed: Can't use attribute 'NAME_lc'
because it doesn't contain a reference to an array ('rf.dri@') at
/export/data/sympa/bin/List.pm line 5584.
Attempt to free unreferenced scalar: SV 0x752bc4 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x147e92c at
/export/data/sympa/bin/List.pm line 5486.
Attempt to free unreferenced scalar: SV 0x753380 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x753434 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x752dc8 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14961b8 at
/export/data/sympa/bin/List.pm line 5486.
DBD::mysql::st fetchrow_hashref failed: Can't use attribute 'NAME_lc'
because it doesn't contain a reference to an array ('rf.dri@') at
/export/data/sympa/bin/List.pm line 5584.
DBD::mysql::st fetchrow_hashref failed: Can't use attribute 'NAME_lc'
because it doesn't contain a reference to an array ('rf.dri@') at
/export/data/sympa/bin/List.pm line 5584.
Attempt to free unreferenced scalar: SV 0x1496110 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x1492f00 at
/export/data/sympa/bin/List.pm line 5486.
Attempt to free unreferenced scalar: SV 0x149d3a0 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x149611c at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0xff0c3c at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14a9484 at
/export/data/sympa/bin/List.pm line 5601.
DBD::mysql::st fetchrow_hashref failed: Can't use attribute 'NAME_lc'
because it doesn't contain a reference to an array ('ns.dri@') at
/export/data/sympa/bin/List.pm line 5584.
DBD::mysql::st fetchrow_hashref failed: Can't use attribute 'NAME_lc'
because it doesn't contain a reference to an array ('ns.dri@') at
/export/data/sympa/bin/List.pm line 5584.
Attempt to free unreferenced scalar: SV 0x149d694 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x149d3dc at
/export/data/sympa/bin/List.pm line 5486.
Attempt to free unreferenced scalar: SV 0x14a9598 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x1496104 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x149d688 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14ae8ac at
/export/data/sympa/bin/List.pm line 5601.
DBD::mysql::st fetchrow_hashref failed: Can't use attribute 'NAME_lc'
because it doesn't contain a reference to an array ('rf.dri@') at
/export/data/sympa/bin/List.pm line 5584.
DBD::mysql::st fetchrow_hashref failed: Can't use attribute 'NAME_lc'
because it doesn't contain a reference to an array ('rf.dri@') at
/export/data/sympa/bin/List.pm line 5584.
Attempt to free unreferenced scalar: SV 0x149d6c4 at
/export/data/sympa/bin/List.pm line 5601.
DBD::mysql::db do failed: Duplicate entry
'adresse@cachée' for key
1 at /export/data/sympa/bin/List.pm line 6455.
List::add_admin_user() Unable to execute SQL statement "INSERT INTO
admin_table (user_admin, comment_admin, list_admin, robot_admin,
date_admin, update_admin, reception_admin, visibility_admin,
subscribed_admin,included_admin,include_sources_admin, role_admin,
info_admin, profile_admin) VALUES ('adresse@cachée', NULL,
'administration-mercure', 'listes.ird.fr', FROM_UNIXTIME(1278956489),
FROM_UNIXTIME(1278956489), 'mail', 'noconceal', 1, 0, NULL, 'editor',
NULL, NULL)" : Duplicate entry
'adresse@cachée' for key 1
List::sync_include_admin() List:sync_include_admin(editor): Failed to
add new administration-mercures
List::new() List::new() : sync_include_admin_failed
DBD::mysql::st fetchrow_hashref failed: Can't use attribute 'NAME_lc'
because it doesn't contain a reference to an array ('ns.dri@') at
/export/data/sympa/bin/List.pm line 5584.
Attempt to free unreferenced scalar: SV 0x14ae7b0 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14b4020 at
/export/data/sympa/bin/List.pm line 5486.
Attempt to free unreferenced scalar: SV 0x14b396c at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14b4254 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14a952c at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14a9c40 at
/export/data/sympa/bin/List.pm line 5486.
Attempt to free unreferenced scalar: SV 0x14bc0d4 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14bb4d4 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14bbe34 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14bc0e0 at
/export/data/sympa/bin/List.pm line 5486.
Attempt to free unreferenced scalar: SV 0x14bd44c at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14b4254 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14bd230 at
/export/data/sympa/bin/List.pm line 5601.
Attempt to free unreferenced scalar: SV 0x14cafd4 at
/export/data/sympa/bin/List.pm line 5601.
DBD::mysql::st fetchrow_hashref failed: Can't use attribute 'NAME_lc'
because it doesn't contain a reference to an array ('rf.oohay@') at
/export/data/sympa/bin/List.pm line 5584.
DBD::mysql::st fetchrow_hashref failed: Can't use attribute 'NAME_lc'
because it doesn't contain a reference to an array ('rf.oohay@') at
/export/data/sympa/bin/List.pm line 5584.
DBD::mysql::db do failed: Duplicate entry
'adresse@cachée-' for
key 1 at /export/data/sympa/bin/List.pm line 6455.
List::add_admin_user() Unable to execute SQL statement "INSERT INTO
admin_table (user_admin, comment_admin, list_admin, robot_admin,
date_admin, update_admin, reception_admin, visibility_admin,
subscribed_admin,included_admin,include_sources_admin, role_admin,
info_admin, profile_admin) VALUES ('adresse@cachée',
'rietaire liste agents-ird-senegal', 'agents-ird-senegal',
'listes.ird.fr', FROM_UNIXTIME(1278956489), FROM_UNIXTIME(1278956489),
'mail', 'noconceal', 1, 0, NULL, 'owner', NULL, 'privileged')" :
Duplicate entry
'adresse@cachée-' for key 1
List::sync_include_admin() List:sync_include_admin(owner): Failed to add
new agents-ird-senegals
Attempt to free unreferenced scalar: SV 0x14bd254 at
/export/data/sympa/bin/List.pm line 1489.
List::new() List::new() : sync_include_admin_failed
DBD::mysql::st fetchrow_hashref failed: Can't use attribute 'NAME_lc'
because it doesn't contain a reference to an array ('rf.dri@') at
/export/data/sympa/bin/List.pm line 5584.
Attempt to free unreferenced scalar: SV 0x14bd17c at
/export/data/sympa/bin/List.pm line 8777.
Bizarre copy of HASH in sassign at /export/data/sympa/bin/List.pm line 8818.
Attempt to free unreferenced scalar: SV 0x14d0290.

-- 
Luc VEILLON 
RSSI 
DSI/Pôle APIT/Coordination technique


tel.:+33(0)2 38 49 95 95 - Fax :+33(0)2 38 49 95 10
courriel : adresse@cachée
site DSI : https://www.ird.fr/dsi

IRD - INSTITUT DE RECHERCHE POUR LE DEVELOPPEMENT
5, rue du carbone
45072 ORLEANS CEDEX 2  
http://www.ird.fr