Message boards :
ATLAS application :
Old WU's in db
Message board moderation
Author | Message |
---|---|
Send message Joined: 27 Sep 08 Posts: 798 Credit: 644,869,634 RAC: 226,175 |
Hi, I see in my account some tasks from 2018, can you purge these out of db? the Wu's are already gone. 199994401, 199994547,199993376,199994812,199994666,199994440,199994460,199993826,199994778,199981610,199958576,199958043,199948708,199950708,,199950660,199940314,199949376,199951921,199948122,,199931412,199946312,199943948,199937046,199918535,199933744,199935040,199895443,199927334,199895027,199923199,199910287,199911146,199925052,199896388,199890281,199883717,199878220 |
Send message Joined: 2 May 07 Posts: 2071 Credit: 156,193,290 RAC: 103,108 |
This old Atlas Download-Error tasks (no subtasks) have: 1. a Creation-Day from 2018 2. a Task Number less 200.000.000. So, it must be possible to find them in the db, we hope so. |
Send message Joined: 15 Jun 08 Posts: 2386 Credit: 223,047,997 RAC: 136,816 |
All tasks below are from July 2018 and I guess they will never be removed from the DB by automatic garbage collection. I also suspect the DB holds lots of those zombies from other users. Can anybody from the project team please go through the DB and remove them? https://lhcathome.cern.ch/lhcathome/result.php?resultid=199993516 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199991815 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199991086 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199983818 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199977821 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199979998 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199956573 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199927885 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199952535 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199952697 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199908661 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199908641 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199895450 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199890839 https://lhcathome.cern.ch/lhcathome/result.php?resultid=199890836 |
Send message Joined: 13 May 14 Posts: 387 Credit: 15,314,184 RAC: 0 |
> delete from result where id<210779601 and appid=14; Query OK, 8292 rows affected (3.62 sec) These were results from 8-9 July 2018 when there were some big database issues. |
Send message Joined: 2 May 07 Posts: 2071 Credit: 156,193,290 RAC: 103,108 |
David, thank you so much from the most Volunteers.... |
Send message Joined: 15 Jun 08 Posts: 2386 Credit: 223,047,997 RAC: 136,816 |
David, thank you so much from the most Volunteers.... +1 |
©2024 CERN