search

SysFera / vishnu

Modular and high-level middleware for tasks, files and information management in heterogeneous and distributed HPC environments
http://sysfera.github.com/vishnu.html
Other
4 stars 12 forks source link

[WebBoard | MySQL] Les identifiants des FileTransfer ne sont pas uniques. (Bugzilla #379) #259

Closed bdepardo closed 11 years ago

bdepardo commented 11 years ago

major bug in component FMS Reported in version 1.3.0 on platform All

bdepardo commented 11 years ago

On 2012-06-25 16:11:23 +0200, 'Bard Nicolas (nicolas.bard@sysfera.com) wrote: Hello,

Dans le cadre du WebBoard j'utilise FMS (avec la base de données MySQL) pour transférer des fichiers. Lorsque le service MySQL est redémarré (par exemple quand j’éteins ma machine) cela fait revenir en arrière les identifiants des nouveaux transferts.

mysql> select numfiletransferid, transferid, starttime from filetransfer where numfiletransferid>'60'; +-------------------+------------+---------------------+ | numfiletransferid | transferid | starttime | +-------------------+------------+---------------------+ | 61 | FT_17 | 2012-06-18 18:16:26 | | 62 | FT_18 | 2012-06-18 18:17:02 | | 63 | FT_19 | 2012-06-18 18:17:15 | | 64 | FT_20 | 2012-06-18 18:17:45 | | 65 | FT_21 | 2012-06-18 18:17:46 | | 66 | FT_22 | 2012-06-18 18:17:46 | | 67 | FT_2 | 2012-06-19 15:23:51 | | 68 | FT_3 | 2012-06-19 15:24:13 | | 69 | FT_4 | 2012-06-19 15:28:23 | | 70 | FT_5 | 2012-06-19 16:57:32 | | 71 | FT_6 | 2012-06-19 16:58:05 | | 72 | FT_2 | 2012-06-22 17:23:00 | | 73 | FT_3 | 2012-06-22 17:23:51 | | 74 | FT_2 | 2012-06-25 11:12:32 | | 75 | FT_3 | 2012-06-25 11:15:52 | | 76 | FT_4 | 2012-06-25 11:19:57 | | 77 | FT_5 | 2012-06-25 11:19:58 | | 78 | FT_6 | 2012-06-25 11:19:58 | | 79 | FT_7 | 2012-06-25 15:04:26 | | 80 | FT_2 | 2012-06-25 15:09:35 | +-------------------+------------+---------------------+ 20 rows in set (0.00 sec)

On voit bien (colonne 2 "transferid") que chaque jour (après extinction de ma machine) les identifiants sont revenus à FT_2. le 25/06/2012 a 15h07 j'ai testé la commande :

nbard@nicoboard:~$ sudo restart mysql

Et cela a effectivement causé une reprise à FT_2 comme on le voit sur la dernière ligne.

Évidemment cela perturbe toutes les commandes qui font appel à ces identifiants (par exemple cela nous renvoie deux résultats alors qu'on en attend un seul) :

nbard@nicoboard:~/Desktop/nb_vishnu_deploy/cli$ vishnu_list_file_transfers -t FT_8 DIET WARNING: OmniORB maxGIOPConnectionPerServer is set to 5. Usually, DIET recommends that you set it to at least 1000. You should request your sysadmin to increase its value if you experience any troubles MA NAME PARSING = MA0 DIET WARNING: useLogService disabled.

Launch Dagda data manager DAGDA-client-nicoboard-775

The Master Agent found the following server(s): nicoboard:0 Calling the ref Corba of the SeD ------------ transfer infomation for file FT_8 transferId: FT_8 status: COMPLETED errorMsg: userId: admin clientMachineId: Webboard sourceMachineId: MA_11 destinationMachineId: MA_11 sourceFilePath: /home/nbard/FMS/petit/DDDD.txt destinationFilePath: /home/nbard/FMS/petit/DDD.txt size: 93 start_time: 2012-Jun-11 16:52:07 trCommand: SCP ------------ transfer infomation for file FT_8 transferId: FT_8 status: COMPLETED errorMsg: userId: admin clientMachineId: Webboard sourceMachineId: MA_11 destinationMachineId: nicoboard sourceFilePath: /home/nbard/FMS-sandbox/manyFiles/fichier-10.txt destinationFilePath: /opt/sysfera/fmstmp/fichier-10.txt size: 5 start_time: 2012-Jun-18 12:54:28 trCommand: SCP