Message boards : Number crunching : DB error - can't find workunit
Message board moderation

To post messages, you must log in.

AuthorMessage
computezrmle
Volunteer moderator
Volunteer developer
Volunteer tester
Avatar

Send message
Joined: 15 Jun 08
Posts: 1608
Credit: 94,638,862
RAC: 98,802
Message 35189 - Posted: 8 May 2018, 7:19:13 UTC

Have again lots of orphaned task entries.
Be so kind as to clean the DB records.

https://lhcathome.cern.ch/lhcathome/result.php?resultid=188378672
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188383093
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288443
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288444
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188274649
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188262792
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188264181
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252209
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252391
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188242957
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188578873
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188552402
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188546002
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188526788
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188522362
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188509943
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188477205
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188475003
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188469402
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188468668
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188437615
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188429853
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188369942
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188369912
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188304903
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188294270
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288525
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288283
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288501
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288502
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288503
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288504
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188268898
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188259188
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188259197
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252132
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252141
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252210
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252211
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188251764
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252392
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188237528
https://lhcathome.cern.ch/lhcathome/result.php?resultid=153992649
https://lhcathome.cern.ch/lhcathome/result.php?resultid=153992650
ID: 35189 · Report as offensive     Reply Quote
computezrmle
Volunteer moderator
Volunteer developer
Volunteer tester
Avatar

Send message
Joined: 15 Jun 08
Posts: 1608
Credit: 94,638,862
RAC: 98,802
Message 35279 - Posted: 16 May 2018, 8:29:27 UTC

Meanwhile there are hundreds of tasks with a missing WU link listed on my account page.
I don't believe I'm the only one who is affected by this.
ID: 35279 · Report as offensive     Reply Quote
Profile Nils Høimyr
Volunteer moderator
Project administrator
Project developer
Project tester

Send message
Joined: 15 Jul 05
Posts: 225
Credit: 5,212,690
RAC: 320
Message 35390 - Posted: 28 May 2018, 9:32:43 UTC - in response to Message 35279.  

These tasks were linked to the failed Sixtrack batch end of April, ref. https://lhcathome.cern.ch/lhcathome/forum_thread.php?id=4690. All the corresponding WUs were deleted.
ID: 35390 · Report as offensive     Reply Quote
computezrmle
Volunteer moderator
Volunteer developer
Volunteer tester
Avatar

Send message
Joined: 15 Jun 08
Posts: 1608
Credit: 94,638,862
RAC: 98,802
Message 35391 - Posted: 28 May 2018, 10:33:19 UTC - in response to Message 35390.  

... All the corresponding WUs were deleted.

That's what I noticed.
But what about the tasks?
2 of mine are from August 2017, others from January 2018.
It seems that they will never be removed from the DB.
And there are tasks from CMS, SixTrack and Theory (in my case; see below).

What about other users?
I wonder if those orphaned tasks could be identified by a few DB queries.



CMS

https://lhcathome.cern.ch/lhcathome/result.php?resultid=176783716
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176782599
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176781278
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176780060
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176780369
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176780149
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176778943
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176777776
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176766230
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176764860
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176764841
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176764138
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176764198
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176763554
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176763521
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176762887
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176755135
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176755136
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176755138
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176755755
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176755756
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176755757
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176753098
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176753767
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176752388
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176752495
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176753762
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176752320
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176753766
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176753765
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176722216
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176720264
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176720225
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176720227
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176720273
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176720274


SixTrack

https://lhcathome.cern.ch/lhcathome/result.php?resultid=188578873
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188552402
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188546002
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188526788
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188522362
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188509943
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188477205
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188475003
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188469402
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188468668
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188437615
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188429853
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188369942
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188369912
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188304903
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188294270
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288525
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288283
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288501
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288502
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288503
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288504
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188268898
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188259188
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188259197
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252132
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252141
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252210
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252211
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188251764
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252392
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188237528
https://lhcathome.cern.ch/lhcathome/result.php?resultid=153992649
https://lhcathome.cern.ch/lhcathome/result.php?resultid=153992650
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188378672
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188383093
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288443
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188288444
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188274649
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188262792
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188264181
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252209
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188252391
https://lhcathome.cern.ch/lhcathome/result.php?resultid=188242957


Theory

https://lhcathome.cern.ch/lhcathome/result.php?resultid=176779489
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176775642
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176769801
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176767941
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176768494
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176765267
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176758257
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176754343
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176739637
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176639416
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176638089
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176638107
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176144559
https://lhcathome.cern.ch/lhcathome/result.php?resultid=176169403
https://lhcathome.cern.ch/lhcathome/result.php?resultid=175894326
https://lhcathome.cern.ch/lhcathome/result.php?resultid=175897821
https://lhcathome.cern.ch/lhcathome/result.php?resultid=175883186
https://lhcathome.cern.ch/lhcathome/result.php?resultid=175851783
https://lhcathome.cern.ch/lhcathome/result.php?resultid=175464848
https://lhcathome.cern.ch/lhcathome/result.php?resultid=174217404
https://lhcathome.cern.ch/lhcathome/result.php?resultid=174203150
https://lhcathome.cern.ch/lhcathome/result.php?resultid=174189664
https://lhcathome.cern.ch/lhcathome/result.php?resultid=174151772
https://lhcathome.cern.ch/lhcathome/result.php?resultid=174146278
https://lhcathome.cern.ch/lhcathome/result.php?resultid=174144168
https://lhcathome.cern.ch/lhcathome/result.php?resultid=174140833
https://lhcathome.cern.ch/lhcathome/result.php?resultid=174141247
https://lhcathome.cern.ch/lhcathome/result.php?resultid=174141272
https://lhcathome.cern.ch/lhcathome/result.php?resultid=174141263
ID: 35391 · Report as offensive     Reply Quote
Profile Ray Murray
Volunteer moderator
Avatar

Send message
Joined: 29 Sep 04
Posts: 254
Credit: 11,239,046
RAC: 651
Message 35395 - Posted: 28 May 2018, 18:15:02 UTC - in response to Message 35391.  
Last modified: 28 May 2018, 18:22:33 UTC

Other than the 6 Theorys at the top of my Errors page, which are simple No-Subtasks errors which should ultimately clear, I have 10 orphan Sixtracks from 28 Apr, 4 Theorys from 3-4 Feb and 3 Invalids from August '17

Valid, credited tasks seem to get purged after some period of time (my oldest Valid is 30th Jan'18) but Errors and Invalids seem to hang about for longer than necessary.
ID: 35395 · Report as offensive     Reply Quote
maeax

Send message
Joined: 2 May 07
Posts: 1071
Credit: 36,371,474
RAC: 5,031
Message 36936 - Posted: 2 Oct 2018, 4:20:11 UTC

Have fourtyfour WorkUnits from July with download-failure from Atlas.
The message for the WU is "WorkUnit not found".
Is it possible to delete the entries in the database?
Otherwhise it is not easy to see if there are Errors from today, because Error-entry is not Zero.

Thank you.
ID: 36936 · Report as offensive     Reply Quote
computezrmle
Volunteer moderator
Volunteer developer
Volunteer tester
Avatar

Send message
Joined: 15 Jun 08
Posts: 1608
Credit: 94,638,862
RAC: 98,802
Message 36937 - Posted: 2 Oct 2018, 6:42:49 UTC - in response to Message 36936.  

ID: 36937 · Report as offensive     Reply Quote
maeax

Send message
Joined: 2 May 07
Posts: 1071
Credit: 36,371,474
RAC: 5,031
Message 37010 - Posted: 12 Oct 2018, 8:06:50 UTC

At the moment, some download failure or confirmation error for Atlas.

Is it possible to delete the Task-entries for Atlas with "WorkUnit not found" from July!
Thank you.
ID: 37010 · Report as offensive     Reply Quote
Profile Ray Murray
Volunteer moderator
Avatar

Send message
Joined: 29 Sep 04
Posts: 254
Credit: 11,239,046
RAC: 651
Message 37011 - Posted: 12 Oct 2018, 21:04:04 UTC - in response to Message 35395.  

All my previously-reported ophans have gone :-) so maybe they do indeed need to be manually purged. Probably not a high priority for the guys until there gets to be too many of them and might then get done en-masse.
ID: 37011 · Report as offensive     Reply Quote
computezrmle
Volunteer moderator
Volunteer developer
Volunteer tester
Avatar

Send message
Joined: 15 Jun 08
Posts: 1608
Credit: 94,638,862
RAC: 98,802
Message 37734 - Posted: 10 Jan 2019, 10:41:15 UTC - in response to Message 36937.  

ID: 37734 · Report as offensive     Reply Quote
bronco

Send message
Joined: 13 Apr 18
Posts: 443
Credit: 8,438,885
RAC: 0
Message 37736 - Posted: 10 Jan 2019, 12:54:38 UTC

I also have tasks from July 2018 that seem to be stuck. See here
ID: 37736 · Report as offensive     Reply Quote

Message boards : Number crunching : DB error - can't find workunit


©2021 CERN