[sympa-fr] Problème migration sympa 5.1.2 vers 5.2

[Herve Brunet <adresse@cachée>]

Bonjours,

J'ai migré notre serveur sympa 5.1.2 sous debian sarge vers la 5.2 et 
j'ai obtenu un comportement étrange.

Après la mise à jour en 5.2 j'ai une trentaine de liste ( sur plus de 
400 )avec 0 abonné
affiché dans l'interface Web . Or les requêtes SQL directes dans la base 
Mysql de sympa affichent bien la liste des abonnés.

A savoir que toutes ces listes sont configurées en mode:
user_data_source database

J'ai d'autre listes configurées dans le mêm mode qui ne posent aucun 
problème.



Voici un extrait des log  au démarrage :

3 11:08:16 pouacre sympa[2150]: Sympa 5.2 started
May  3 11:08:16 pouacre sympa[2150]: Upgrading from Sympa version 5.1.2 
to 5.2
May  3 11:08:16 pouacre sympa[2150]: List::upgrade(5.1.2, 5.2)
May  3 11:08:16 pouacre sympa[2150]: Updating the new robot_subscriber 
and robot_admin  Db fields...
May  3 11:08:16 pouacre sympa[2150]: Unable to execute SQL statement 
"UPDATE subscriber_table SET robot_subscriber='listes.ens-lyon.fr' WHERE 
(list_subscriber='3icpop')" : MySQL server has gone away


En mode plus verbeux je n'ai pas plus d'information.

Sympa m'a bien envoyé un message comme quoi la mise à jour de la 
structure de la base mysql s'est correctement passée.


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 sympa2
  Field 'included_admin'  (table 'admin_table' ; database 'sympa2') 
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 'sympa2') was NOT 
found. Attempting to add it...
  Field robot_admin added to table admin_table
  Field 'subscribed_admin'  (table 'admin_table' ; database 'sympa2') 
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, PRIMARY KEY dropped
  Table admin_table, INDEX set on 
list_admin,robot_admin,user_admin,role_admin
  Field 'bounce_address_subscriber' (table 'subscriber_table' ; 
database 'sympa2') was NOT found. Attempting to add it...
  Field bounce_address_subscriber added to table subscriber_table
  Field 'included_subscriber'  (table 'subscriber_table' ; database 
'sympa2') 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 
'sympa2') was NOT found. Attempting to add it...
  Field robot_subscriber added to table subscriber_table
  Field 'subscribed_subscriber'  (table 'subscriber_table' ; database 
'sympa2') 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 
'sympa2') 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, PRIMARY KEY dropped
  Table subscriber_table, INDEX set on 
list_subscriber,robot_subscriber,user_subscriber
  Field 'email_netidmap' (table 'netidmap_table' ; database 'sympa2') 
was NOT found. Attempting to add it...
  Field email_netidmap added to table netidmap_table
  Field 'netid_netidmap' (table 'netidmap_table' ; database 'sympa2') 
was NOT found. Attempting to add it...
  Field netid_netidmap added to table netidmap_table
  Field 'robot_netidmap' (table 'netidmap_table' ; database 'sympa2') 
was NOT found. Attempting to add it...
  Field robot_netidmap added to table netidmap_table
  Field 'serviceid_netidmap' (table 'netidmap_table' ; database 
'sympa2') 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



Quelqu'un a t-il rencontré ce genre de problème ?



Hervé Brunet
Centre de Ressources Informatiques
École Normale Supérieure