Message boards : ATLAS application : Old WU's in db
Message board moderation

To post messages, you must log in.

AuthorMessage
Toby Broom
Volunteer moderator

Send message
Joined: 27 Sep 08
Posts: 798
Credit: 644,721,856
RAC: 234,355
Message 40510 - Posted: 18 Nov 2019, 22:15:29 UTC

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
ID: 40510 · Report as offensive     Reply Quote
maeax

Send message
Joined: 2 May 07
Posts: 2071
Credit: 156,091,089
RAC: 103,567
Message 40513 - Posted: 19 Nov 2019, 6:52:34 UTC

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.
ID: 40513 · Report as offensive     Reply Quote
computezrmle
Volunteer moderator
Volunteer developer
Volunteer tester
Help desk expert
Avatar

Send message
Joined: 15 Jun 08
Posts: 2386
Credit: 222,922,522
RAC: 137,981
Message 40849 - Posted: 8 Dec 2019, 16:24:08 UTC

ID: 40849 · Report as offensive     Reply Quote
David Cameron
Project administrator
Project developer
Project scientist

Send message
Joined: 13 May 14
Posts: 387
Credit: 15,314,184
RAC: 0
Message 40918 - Posted: 12 Dec 2019, 13:02:28 UTC - in response to Message 40849.  

> 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.
ID: 40918 · Report as offensive     Reply Quote
maeax

Send message
Joined: 2 May 07
Posts: 2071
Credit: 156,091,089
RAC: 103,567
Message 40919 - Posted: 12 Dec 2019, 13:16:06 UTC - in response to Message 40918.  

David, thank you so much from the most Volunteers....
ID: 40919 · Report as offensive     Reply Quote
computezrmle
Volunteer moderator
Volunteer developer
Volunteer tester
Help desk expert
Avatar

Send message
Joined: 15 Jun 08
Posts: 2386
Credit: 222,922,522
RAC: 137,981
Message 40922 - Posted: 12 Dec 2019, 14:56:31 UTC - in response to Message 40919.  

David, thank you so much from the most Volunteers....

+1
ID: 40922 · Report as offensive     Reply Quote

Message boards : ATLAS application : Old WU's in db


©2024 CERN