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

[Luc VEILLON <adresse@cachée>]

Luc VEILLON a écrit :
> 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 ?
>   
Le check module sur la prod :
DBI                  DBI            OK (1.55   >= 1.48)
Le check module sur la recette :
DBI                  DBI            OK (1.601  >= 1.48)

Le passage de DBI 1.55 en DBI 1.611 a résolu le pb d'upgrade.

Cordialement





> 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