Skip to Content.
Sympa Menu

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

Subject: Pour les administrateurs de serveurs de listes utilisant le logiciel Sympa

List archive

Chronological Thread  
  • From: Herve Brunet <address@concealed>
  • To: address@concealed
  • Subject: [sympa-fr] Problème migration sympa 5.1.2 vers 5.2
  • Date: Wed, 03 May 2006 17:40:25 +0200

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



Archive powered by MHonArc 2.6.19+.

Top of Page