Bug #538
closed
Different files in different tapes with same metadata
0%
Description
Il y a eu un crash de TReqS et après l'information n'a pas été correct.
Après avoir regardé un peu la base de données, j'ai vu que plusieurs fichiers avaient la même position pour la même bande et par consequence la même queue.
| hpss_file | count(1) | position | cartridge | queue_id | creation_time |------------------------------------------------------------------------+----------+-----------+----------+---------------------+
| /hpss2/dcache2/atlas/mc12/00002F57E53377614B339FAAB01F905D613B | 1 | 721 | JT227300 | 2119 | 2010-04-26 02:14:37 |
| /hpss2/dcache2/atlas/mc12/00005CB7034DCF794CFE97C29CF26BB9C1C7 | 1 | 721 | JT227600 | 2114 | 2010-04-26 01:56:23 |
| /hpss2/dcache2/atlas/mc12/000065A4DBC2D8914B8A919186337CA28029 | 1 | 721 | JT228000 | 2125 | 2010-04-26 02:56:10 |
| /hpss2/dcache2/atlas/mc12/00008B36A5D753B1458EAD81E2863499CA1B | 1 | 721 | JT228100 | 2124 | 2010-04-26 03:14:47 |
| /hpss2/dcache2/atlas/mc12/000008D72DB8EABE471ABEF866C5450C350A | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:41 |
| /hpss2/dcache2/atlas/mc12/0000278B962C32134AFF8ABA934D1CD532D9 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:03 |
| /hpss2/dcache2/atlas/mc12/000026B28376958F4A74ADE43C8E334A5271 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:40 |
| /hpss2/dcache2/atlas/mc12/0000D9594CA6EC30490B83FD324775F69F57 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:59 |
| /hpss2/dcache2/atlas/mc12/00007ECB90A990E44B269CEB4944184626A2 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:28 |
| /hpss2/dcache2/atlas/mc12/0000B4EB1A4E952D4F7EAB590DCF02D1FA43 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:42 |
| /hpss2/dcache2/atlas/mc12/000094701DCA64C244EF87C36CD9A6DC69B8 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:39 |
| /hpss2/dcache2/atlas/mc12/00002B49153482074E6AAD90F4F2E4D53C17 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:55 |
| /hpss2/dcache2/atlas/mc12/0000927C9E6FB23C406D99EAF172B09C7A0F | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:11 |
| /hpss2/dcache2/atlas/mc12/0000343F558605DE45069369C3FB57E7B104 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:41 |
| /hpss2/dcache2/atlas/mc12/000042AA783B604C46AEBD0E7F9CC1A87F4B | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:00 |
| /hpss2/dcache2/atlas/mc12/000099271F5D2ACA4BBE8BCF694877BC01BF | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:50 |
| /hpss2/dcache2/atlas/mc12/0000B15EB2640C124628B890935A540BE65F | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:40 |
| /hpss2/dcache2/atlas/mc12/0000AB52CD5FD3C94F0AAB3FB7724BF7B842 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:59 |
| /hpss2/dcache2/atlas/mc12/00000996D1F0B7424EEDB3EAD89476496948 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:42 |
| /hpss2/dcache2/atlas/mc12/0000CA053BC7F179402AB712C70D8B3D7A30 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:02 |
| /hpss2/dcache2/atlas/mc12/000075BF2A077EF1479DA54ECEF9D5189432 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:39 |
| /hpss2/dcache2/atlas/mc12/000044863BA8FB8F4D2EA3DF3E774B63F014 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:56 |
| /hpss2/dcache2/atlas/mc12/0000D6CD13CD4F3B423499D3D94A3CC4FED5 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:12 |
| /hpss2/dcache2/atlas/mc12/0000BC72554410FD4AB2A8CE4595D30AC719 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:41 |
| /hpss2/dcache2/atlas/mc12/00003725317A2870456D89562DE1D5EBC542 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:51 |
| /hpss2/dcache2/atlas/mc12/00009A7A3397D11F4C78893E27DBCDD130F4 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:40 |
| /hpss2/dcache2/atlas/mc12/000003A8CABB01A34AC7BC0C927CA0B71FBF | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:00 |
| /hpss2/dcache2/atlas/mc12/0000B925D7F502E247D6A0C5BDCC89168A89 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:37 |
| /hpss2/dcache2/atlas/mc12/000070DF2781647B43E29ED5DD50D21F51F2 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:43 |
| /hpss2/dcache2/atlas/mc12/0000D151B96AFA184DB1AD37A85419843E34 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:02 |
| /hpss2/dcache2/atlas/mc12/0000BD7AA38521484D0DA356D21DB1616263 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:39 |
| /hpss2/dcache2/atlas/mc12/0000EF42A8731C99496BA5C02A8DB3F311B3 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:56 |
| /hpss2/dcache2/atlas/mc12/00004D076A555CE246638D83A65A76B4D12C | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:14 |
| /hpss2/dcache2/atlas/mc12/000018D4A65E705548C9AEB471A13EA59AA1 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:41 |
| /hpss2/dcache2/atlas/mc12/000090CED43E6F00496C826A515F5FC23221 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:01 |
| /hpss2/dcache2/atlas/mc12/0000E22125ED7A8343ABA8914421FCD883AF | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:52 |
| /hpss2/dcache2/atlas/mc12/0000AC62A28671294E52ACCC00575811531D | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:05 |
| /hpss2/dcache2/atlas/mc12/0000A3225434976A47C4957CF8B3A8C7B7C6 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:40 |
| /hpss2/dcache2/atlas/mc12/00002C24151607BA4BC1B0A3F35B2B9E1F26 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:46 |
| /hpss2/dcache2/atlas/mc12/0000C51B38F1738D47858AE5DC76BBC6B76B | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:39 |
| /hpss2/dcache2/atlas/mc12/00002BB5CE68D0E049158E1B356821021ADC | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:57 |
| /hpss2/dcache2/atlas/mc12/000088974EAF0D4D47D09BE9C65EC0DEE005 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:15 |
| /hpss2/dcache2/atlas/mc12/0000E35C44947845441D9F01B91589B03ABA | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:41 |
| /hpss2/dcache2/atlas/mc12/00001A65E5568ED94EC68973F7D2E8D4E6C0 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:01 |
| /hpss2/dcache2/atlas/mc12/0000DE5529FA086548CA8CF2164E1B5BF1F0 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:39 |
| /hpss2/dcache2/atlas/mc12/00002432051952F745BBA9A7B7BA4457EB12 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:54 |
| /hpss2/dcache2/atlas/mc12/0000030332BDBEB048FB8BAED7E2F4D89DC7 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:40 |
| /hpss2/dcache2/atlas/mc12/0000C5B643B262424195949C9D99D15CDB51 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:48 |
| /hpss2/dcache2/atlas/mc12/000007DFAEBE665845DFB4DDEC71259C90DD | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:03 |
| /hpss2/dcache2/atlas/mc12/00002E897677F2BC47AEBB046707C52242F9 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:40 |
| /hpss2/dcache2/atlas/mc12/0000EE40843C30924E20B132F808AA545887 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:57 |
| /hpss2/dcache2/atlas/mc12/00009C5B01F0FF514F10BAA7C22AEF918EDA | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:15 |
| /hpss2/dcache2/atlas/mc12/0000E4B50AE1A6FF4C43ADE7804C7A9CA939 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:41 |
| /hpss2/dcache2/atlas/mc12/000006BE625A35674EF699170D28EE9BF903 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:39 |
| /hpss2/dcache2/atlas/mc12/0000EBC045CC0B4448FBB7AAACCCFBDA6017 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:54 |
| /hpss2/dcache2/atlas/mc12/0000453336D09682455FBFFB1A551FFD1649 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:08 |
| /hpss2/dcache2/atlas/mc12/00003D3C4B6FC0C14E1B9CBDE2F21B2035B5 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:40 |
| /hpss2/dcache2/atlas/mc12/0000BC264C746F9D4BD5A9FDA74DFB422598 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:00 |
| /hpss2/dcache2/atlas/mc12/00000F334579E1F040569217AF8E40F35A76 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:49 |
| /hpss2/dcache2/atlas/mc12/00003FE69D9E557241BEB0D68846E5E909C4 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:03 |
| /hpss2/dcache2/atlas/mc12/00009EB80C45BCBC4BC5AA912551B23D128D | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:40 |
| /hpss2/dcache2/atlas/mc12/00004299EFE8FCE748BCBB929FC60E716B3C | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:58 |
| /hpss2/dcache2/atlas/mc12/00002D6DD6172617462D93486C3D18D1F72D | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:42 |
| /hpss2/dcache2/atlas/mc12/0000A13DA2671D324A55B567F7AA6B9F5F70 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:39 |
| /hpss2/dcache2/atlas/mc12/0000573435623BA7463588F1CEE450D349D9 | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:32:55 |
| /hpss2/dcache2/atlas/mc12/0000B9099D8DF6334D5BB33917AAB246EF0C | 2 | 721 | JT228300 | 2148 | 2010-04-26 04:33:09 |
| /hpss2/dcache2/atlas/mc12/0000F8829E60241249A1A048AAADECC36CC1 | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:00 |
| /hpss2/dcache2/atlas/mc12/00009AE53226E24843F69771581C7547F6DC | 1 | 721 | JT228300 | 2149 | 2010-04-26 08:33:01 |
| /hpss2/dcache2/atlas/mc12/0000BD6B0CAE920644E7A2655C2B55B98157 | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:32:49 |
| /hpss2/dcache2/atlas/mc12/0000C353D12A93374ECCBE9C9FAF36D025D8 | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:02 |
| /hpss2/dcache2/atlas/mc12/000035C11EE1D724453AA50571A56063E2D3 | 1 | 721 | JT228300 | 2149 | 2010-04-26 08:33:02 |
| /hpss2/dcache2/atlas/mc12/0000CA2A700A24C8449884F0EDB074DA3D69 | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:04 |
| /hpss2/dcache2/atlas/mc12/0000B13B27894282460F8EDDA742F8566E3F | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:34 |
| /hpss2/dcache2/atlas/mc12/0000237466FF42B94204BFEA93401D239E73 | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:01 |
| /hpss2/dcache2/atlas/mc12/0000231DF70F4D8D4EDF96563B7D2E5501C3 | 1 | 721 | JT228300 | 2149 | 2010-04-26 08:33:02 |
| /hpss2/dcache2/atlas/mc12/000076A0E6CAD5A24ED0B0B4B68D0F0BB33A | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:26:47 |
| /hpss2/dcache2/atlas/mc12/0000E9F6E5263D2248E7B4123EAD5D99E2FD | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:04 |
| /hpss2/dcache2/atlas/mc12/00003093AD85826E40DF92E5695C11CDD52E | 1 | 721 | JT228300 | 2149 | 2010-04-26 08:33:06 |
| /hpss2/dcache2/atlas/mc12/0000B0BADE58328044D1812F1795E6296192 | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:27:08 |
| /hpss2/dcache2/atlas/mc12/00009D59F706A66C443AAAE382315580F0D9 | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:00 |
| /hpss2/dcache2/atlas/mc12/0000C168FAC33E804AF79AF9327A6F2362B8 | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:02 |
| /hpss2/dcache2/atlas/mc12/00008C1DE5C043E84AC4B67525ADE101C1C3 | 1 | 721 | JT228300 | 2149 | 2010-04-26 08:33:36 |
| /hpss2/dcache2/atlas/mc12/0000731B61A0783A4709BDDBA247C18EA0DF | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:06 |
| /hpss2/dcache2/atlas/mc12/0000B84B3325C6F54907B4E4026514AB8604 | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:00 |
| /hpss2/dcache2/atlas/mc12/0000BBD029D240C84A48A021BA69B5B8C605 | 1 | 721 | JT228300 | 2149 | 2010-04-26 08:32:44 |
| /hpss2/dcache2/atlas/mc12/0000AA043EE372AE4158B683ACB88D926AAB | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:01 |
| /hpss2/dcache2/atlas/mc12/000006777133ACDF4552B9D594582299DCB5 | 1 | 721 | JT228300 | 2149 | 2010-04-26 08:33:45 |
| /hpss2/dcache2/atlas/mc12/00006F89964706404A7F94C7398496822422 | 1 | 721 | JT228300 | 2149 | 2010-04-26 08:33:01 |
| /hpss2/dcache2/atlas/mc12/0000F885D9D08D4F47D58B2AC78B000DD57C | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:26 |
| /hpss2/dcache2/atlas/mc12/0000F6C2257C2E3542CE93A099BF74E17BAC | 2 | 721 | JT228300 | 2149 | 2010-04-26 04:33:01 |
| /hpss2/dcache2/atlas/mc12/0000EA3D8191AA7E439094FAD71F20978772 | 1 | 721 | JT430300 | 2151 | 2010-04-26 06:32:43 |
| /hpss2/dcache2/atlas/mc12/000023282DA96A8642D990347AE25E81799C | 1 | 721 | JT430500 | 2158 | 2010-04-26 15:04:03 | ------------------------------------------------------------------------+----------+-----------+----------+---------------------+
92 rows in set (0.05 sec)
mysql> select hpss_file, count(1), position, cartridge, queue_id, creation_time from requests where position = 721 group by hpss_file order by cartridge, queue_id;
------------------------------------------------------------------------+----------+-----------+----------+---------------------+
Updated by Gomez Casanova Andres