Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

published histories do not load #17622

Closed
martenson opened this issue Mar 6, 2024 · 8 comments
Closed

published histories do not load #17622

martenson opened this issue Mar 6, 2024 · 8 comments
Assignees
Labels
area/database Galaxy's database or data access layer release-testing-24.0

Comments

@martenson
Copy link
Member

getting 500 from https://usegalaxy.org/api/histories?limit=25&offset=0&search=&sort_by=update_time&sort_desc=true&show_own=false&show_published=true&show_shared=false

Screenshot 2024-03-06 at 1 06 04 PM

Galaxy Version and/or server at which you observed the bug
Galaxy Version: Main 24.0
Commit: 8b44fde05fe0a2aab1fb7f7e164f2adf96ce2387

To Reproduce
Steps to reproduce the behavior:

  1. Go to https://usegalaxy.org/histories/list_published
  2. observe the error
@guerler
Copy link
Contributor

guerler commented Mar 6, 2024

I was not able to reproduce it locally, yet. I tried to track it down on sentry, it might be related to:
https://sentry.galaxyproject.org/organizations/galaxy/issues/144637/?project=3&query=is%3Aunresolved&referrer=issue-stream
image

Looking at the dataset states in the schema, it seems that deleted is not a valid state, but I am not sure why: https://github.com/galaxyproject/galaxy/blob/dev/lib/galaxy/schema/schema.py#L67

@martenson
Copy link
Member Author

I think deleted is only a property on the object, not an hda state. (valid job state though)

We might have some broken/ancient data in database?

Carl's comment on that method 🫣

@mvdbeek mvdbeek self-assigned this Mar 7, 2024
@mvdbeek
Copy link
Member

mvdbeek commented Mar 7, 2024

Yes, #17475. I'll take a look.

@mvdbeek
Copy link
Member

mvdbeek commented Mar 7, 2024

Hmm, so deleted isn't actually a valid state, at all , and instead a boolean column. We have a bunch of datasets from 2008 doing that, but also a few from february of this year:

galaxy_main=> select id, state, deleted, create_time from dataset where state = 'deleted';
    id     |  state  | deleted |        create_time
-----------+---------+---------+----------------------------
    312357 | deleted | t       | 2008-05-15 19:15:51.355197
    339904 | deleted | t       | 2008-06-18 15:20:33.000935
    357531 | deleted | t       | 2008-07-11 16:19:40.010342
    343993 | deleted | t       | 2008-06-24 07:52:30.738561
    344011 | deleted | t       | 2008-06-24 08:15:06.082917
    315344 | deleted | t       | 2008-05-18 19:52:38.655118
    354918 | deleted | t       | 2008-07-08 16:54:56.830593
    372691 | deleted | t       | 2008-07-31 05:32:34.749399
    308134 | deleted | t       | 2008-05-09 10:19:52.867692
    308133 | deleted | t       | 2008-05-09 10:19:27.953365
    313123 | deleted | t       | 2008-05-16 06:38:45.144262
    313745 | deleted | t       | 2008-05-16 19:02:27.158624
    309388 | deleted | t       | 2008-05-11 20:15:43.178867
    312784 | deleted | t       | 2008-05-16 05:54:44.379309
    309401 | deleted | t       | 2008-05-11 20:30:38.394604
    312884 | deleted | t       | 2008-05-16 06:07:59.462738
    313160 | deleted | t       | 2008-05-16 06:54:27.02266
    316223 | deleted | t       | 2008-05-19 12:44:27.737532
    315940 | deleted | t       | 2008-05-19 09:22:41.661456
    315348 | deleted | t       | 2008-05-18 20:00:08.111624
    315358 | deleted | t       | 2008-05-18 20:15:07.801015
    315366 | deleted | t       | 2008-05-18 20:22:46.341665
    315428 | deleted | t       | 2008-05-18 21:45:21.175288
    315435 | deleted | t       | 2008-05-18 21:53:07.90531
    315438 | deleted | t       | 2008-05-18 22:00:08.98323
    330814 | deleted | t       | 2008-06-06 07:22:05.02446
    343917 | deleted | t       | 2008-06-24 05:58:40.695151
    343960 | deleted | t       | 2008-06-24 07:13:55.041299
    343966 | deleted | t       | 2008-06-24 07:20:45.764323
    293437 | deleted | t       | 2008-04-17 13:54:59.63509
    293293 | deleted | t       | 2008-04-17 12:42:18.98993
    293313 | deleted | t       | 2008-04-17 12:48:58.577344
    296441 | deleted | t       | 2008-04-22 11:43:29.099892
    296442 | deleted | t       | 2008-04-22 11:43:29.176714
    301309 | deleted | t       | 2008-04-29 16:49:04.028348
    295665 | deleted | t       | 2008-04-21 11:04:49.535417
    297872 | deleted | t       | 2008-04-24 07:51:04.863718
    293232 | deleted | t       | 2008-04-17 12:24:15.236901
    291639 | deleted | t       | 2008-04-14 22:08:33.188592
    300294 | deleted | t       | 2008-04-28 11:56:19.583374
    291826 | deleted | t       | 2008-04-15 06:21:12.342939
    294267 | deleted | t       | 2008-04-18 14:52:57.168039
    301432 | deleted | t       | 2008-04-29 18:46:20.801685
    294292 | deleted | t       | 2008-04-18 15:32:01.047087
    291946 | deleted | t       | 2008-04-15 10:24:59.924116
    300311 | deleted | t       | 2008-04-28 12:16:52.560882
    304228 | deleted | t       | 2008-05-04 13:45:46.752128
    291314 | deleted | t       | 2008-04-14 13:00:24.437568
    294296 | deleted | t       | 2008-04-18 15:37:40.453
    292449 | deleted | t       | 2008-04-16 07:50:28.355832
    292850 | deleted | t       | 2008-04-16 22:55:33.968081
    296023 | deleted | t       | 2008-04-21 22:25:24.007203
    305549 | deleted | t       | 2008-05-06 12:18:34.628746
    305552 | deleted | t       | 2008-05-06 12:18:51.775898
    304435 | deleted | t       | 2008-05-04 23:34:46.057257
    305789 | deleted | t       | 2008-05-06 13:58:15.181186
    304816 | deleted | t       | 2008-05-05 18:27:32.517118
    305692 | deleted | t       | 2008-05-06 12:50:54.046714
    305695 | deleted | t       | 2008-05-06 12:51:13.659253
    306592 | deleted | t       | 2008-05-07 15:02:31.338853
    303143 | deleted | t       | 2008-05-02 06:11:56.021447
    305136 | deleted | t       | 2008-05-06 02:28:40.819743
    305939 | deleted | t       | 2008-05-06 16:56:59.692174
    307967 | deleted | t       | 2008-05-09 07:31:17.181125
    312890 | deleted | t       | 2008-05-16 06:08:52.277345
    311407 | deleted | t       | 2008-05-14 17:15:23.225322
    312906 | deleted | t       | 2008-05-16 06:10:22.952169
    312914 | deleted | t       | 2008-05-16 06:11:11.951585
    313866 | deleted | t       | 2008-05-16 21:47:53.199788
    312520 | deleted | t       | 2008-05-15 22:34:53.592559
    313012 | deleted | t       | 2008-05-16 06:21:36.715816
    315248 | deleted | t       | 2008-05-18 18:28:05.766022
    315387 | deleted | t       | 2008-05-18 20:52:46.093072
    315388 | deleted | t       | 2008-05-18 20:54:39.905668
    315441 | deleted | t       | 2008-05-18 22:07:43.606857
    315893 | deleted | t       | 2008-05-19 08:50:38.756908
    316082 | deleted | t       | 2008-05-19 11:21:29.619738
    316091 | deleted | t       | 2008-05-19 11:27:00.364416
    316123 | deleted | t       | 2008-05-19 11:42:16.551865
    316334 | deleted | t       | 2008-05-19 13:46:10.548959
    358469 | deleted | t       | 2008-07-13 12:28:25.709713
    315199 | deleted | t       | 2008-05-18 17:32:02.764636
    315216 | deleted | t       | 2008-05-18 17:49:17.836009
    315250 | deleted | t       | 2008-05-18 18:28:36.307678
    315307 | deleted | t       | 2008-05-18 19:32:01.388585
    315322 | deleted | t       | 2008-05-18 19:42:22.63124
    315359 | deleted | t       | 2008-05-18 20:17:37.381313
    315360 | deleted | t       | 2008-05-18 20:18:06.636401
    315361 | deleted | t       | 2008-05-18 20:18:31.222157
    315391 | deleted | t       | 2008-05-18 21:00:10.870866
    315394 | deleted | t       | 2008-05-18 21:03:12.703224
    315444 | deleted | t       | 2008-05-18 22:15:08.337762
    315447 | deleted | t       | 2008-05-18 22:22:38.81245
    315450 | deleted | t       | 2008-05-18 22:30:08.031005
    315453 | deleted | t       | 2008-05-18 22:37:53.921144
    315456 | deleted | t       | 2008-05-18 22:45:21.735794
    316354 | deleted | t       | 2008-05-19 13:56:32.365388
    316563 | deleted | t       | 2008-05-19 15:55:31.924464
    316566 | deleted | t       | 2008-05-19 15:56:00.401969
    315911 | deleted | t       | 2008-05-19 09:09:55.746893
    315918 | deleted | t       | 2008-05-19 09:15:09.193566
    315945 | deleted | t       | 2008-05-19 09:30:14.155633
    315948 | deleted | t       | 2008-05-19 09:33:20.335886
    315950 | deleted | t       | 2008-05-19 09:33:36.563539
    315953 | deleted | t       | 2008-05-19 09:36:04.561955
    315956 | deleted | t       | 2008-05-19 09:37:56.919783
    315969 | deleted | t       | 2008-05-19 09:46:15.224569
    316062 | deleted | t       | 2008-05-19 10:58:18.667436
    316072 | deleted | t       | 2008-05-19 11:07:36.61217
    316076 | deleted | t       | 2008-05-19 11:15:46.265212
    316087 | deleted | t       | 2008-05-19 11:23:47.40943
    316090 | deleted | t       | 2008-05-19 11:24:39.944501
    316093 | deleted | t       | 2008-05-19 11:29:25.808058
    316094 | deleted | t       | 2008-05-19 11:29:44.044388
    316101 | deleted | t       | 2008-05-19 11:34:30.011498
    316121 | deleted | t       | 2008-05-19 11:41:22.103533
    316124 | deleted | t       | 2008-05-19 11:43:17.727053
    316140 | deleted | t       | 2008-05-19 11:54:33.292589
    316153 | deleted | t       | 2008-05-19 12:07:46.645328
    316157 | deleted | t       | 2008-05-19 12:11:45.261361
    316158 | deleted | t       | 2008-05-19 12:11:46.692842
    316204 | deleted | t       | 2008-05-19 12:33:12.158427
    316612 | deleted | t       | 2008-05-19 16:18:58.465957
    316621 | deleted | t       | 2008-05-19 16:22:40.525527
    317093 | deleted | t       | 2008-05-20 00:04:15.388693
    317095 | deleted | t       | 2008-05-20 00:05:46.626206
    317096 | deleted | t       | 2008-05-20 00:06:04.111255
    329749 | deleted | t       | 2008-06-04 20:27:41.392984
    374409 | deleted | t       | 2008-08-02 17:15:05.473521
    316567 | deleted | t       | 2008-05-19 15:56:02.732968
    317872 | deleted | t       | 2008-05-20 07:58:40.477515
    318230 | deleted | t       | 2008-05-20 12:34:16.635807
    319320 | deleted | t       | 2008-05-21 08:51:12.181706
    305689 | deleted | t       | 2008-05-06 12:50:09.304315
    317140 | deleted | t       | 2008-05-20 00:44:17.525255
    320142 | deleted | t       | 2008-05-22 07:11:47.739729
    316989 | deleted | t       | 2008-05-19 22:23:24.638064
    317458 | deleted | t       | 2008-05-20 05:47:35.968512
    317459 | deleted | t       | 2008-05-20 05:47:39.623875
    317545 | deleted | t       | 2008-05-20 06:15:10.812698
    317692 | deleted | t       | 2008-05-20 06:49:33.073473
    317856 | deleted | t       | 2008-05-20 07:45:18.467316
    317857 | deleted | t       | 2008-05-20 07:47:57.719513
    317864 | deleted | t       | 2008-05-20 07:52:34.483556
    317867 | deleted | t       | 2008-05-20 07:53:18.045087
    317891 | deleted | t       | 2008-05-20 08:08:09.144997
    317896 | deleted | t       | 2008-05-20 08:13:37.044635
    319074 | deleted | t       | 2008-05-21 01:56:52.974381
    317706 | deleted | t       | 2008-05-20 06:52:57.21166
    317734 | deleted | t       | 2008-05-20 07:01:20.034185
    317736 | deleted | t       | 2008-05-20 07:02:16.203335
    318293 | deleted | t       | 2008-05-20 13:15:26.132272
    323060 | deleted | t       | 2008-05-27 11:03:23.181949
    317900 | deleted | t       | 2008-05-20 08:15:35.203855
    317905 | deleted | t       | 2008-05-20 08:20:55.078047
    318172 | deleted | t       | 2008-05-20 12:08:20.117952
    319152 | deleted | t       | 2008-05-21 03:53:06.818027
    318208 | deleted | t       | 2008-05-20 12:23:16.819494
    318222 | deleted | t       | 2008-05-20 12:30:24.863268
    318225 | deleted | t       | 2008-05-20 12:32:44.738927
    318231 | deleted | t       | 2008-05-20 12:35:23.994497
    322536 | deleted | t       | 2008-05-26 15:37:39.127498
    322537 | deleted | t       | 2008-05-26 15:38:01.556322
    323579 | deleted | t       | 2008-05-27 18:46:30.117723
    323380 | deleted | t       | 2008-05-27 16:09:45.801086
    323495 | deleted | t       | 2008-05-27 17:53:06.066041
    324830 | deleted | t       | 2008-05-28 20:52:59.744518
    327325 | deleted | t       | 2008-05-31 20:08:22.134605
    325023 | deleted | t       | 2008-05-29 03:44:58.070608
    329030 | deleted | t       | 2008-06-03 22:11:23.332847
    328427 | deleted | t       | 2008-06-03 08:17:40.119786
    328507 | deleted | t       | 2008-06-03 10:02:53.428855
    329722 | deleted | t       | 2008-06-04 19:46:44.469367
    328842 | deleted | t       | 2008-06-03 18:28:00.38986
    330261 | deleted | t       | 2008-06-05 17:40:59.047532
    374898 | deleted | t       | 2008-08-03 19:24:40.142509
    375351 | deleted | t       | 2008-08-04 10:21:18.92968
    330006 | deleted | t       | 2008-06-05 09:01:09.76761
    334123 | deleted | t       | 2008-06-11 17:12:20.073951
    333686 | deleted | t       | 2008-06-11 08:18:47.270391
    335186 | deleted | t       | 2008-06-12 22:42:30.530025
    336589 | deleted | t       | 2008-06-14 12:47:00.729584
    378215 | deleted | t       | 2008-08-07 00:28:55.447262
    377791 | deleted | t       | 2008-08-06 15:10:11.532184
    377810 | deleted | t       | 2008-08-06 15:18:49.450232
    377976 | deleted | t       | 2008-08-06 18:17:34.499643
    378478 | deleted | t       | 2008-08-07 10:34:00.754073
    378487 | deleted | t       | 2008-08-07 10:46:44.307342
    334730 | deleted | t       | 2008-06-12 11:47:35.669081
    377792 | deleted | t       | 2008-08-06 15:10:22.018268
    377793 | deleted | t       | 2008-08-06 15:10:35.236286
    377794 | deleted | t       | 2008-08-06 15:12:23.151865
    316602 | deleted | t       | 2008-05-19 16:16:23.137588
    316609 | deleted | t       | 2008-05-19 16:18:05.818809
    337769 | deleted | t       | 2008-06-16 06:11:49.253358
    337141 | deleted | t       | 2008-06-15 10:36:26.54199
    337506 | deleted | t       | 2008-06-15 19:53:19.990963
    337507 | deleted | t       | 2008-06-15 19:53:26.069822
    330963 | deleted | t       | 2008-06-06 11:26:00.722269
    338624 | deleted | t       | 2008-06-16 23:44:56.35575
    292137 | deleted | t       | 2008-04-15 15:58:16.217253
    339239 | deleted | t       | 2008-06-17 17:23:13.52314
    343903 | deleted | t       | 2008-06-24 05:30:03.786328
    343907 | deleted | t       | 2008-06-24 05:37:24.633387
    351996 | deleted | t       | 2008-07-04 01:22:38.295124
    339831 | deleted | t       | 2008-06-18 13:32:54.859696
    343929 | deleted | t       | 2008-06-24 06:22:28.463599
    343931 | deleted | t       | 2008-06-24 06:26:24.964854
    339650 | deleted | t       | 2008-06-18 09:49:07.376692
    339779 | deleted | t       | 2008-06-18 11:58:02.572577
    339988 | deleted | t       | 2008-06-18 16:31:32.209623
    355988 | deleted | t       | 2008-07-09 21:24:23.369682
    313146 | deleted | t       | 2008-05-16 06:47:20.515612
    344095 | deleted | t       | 2008-06-24 10:37:36.755358
    344769 | deleted | t       | 2008-06-24 23:05:59.449191
    343220 | deleted | t       | 2008-06-23 05:25:23.365322
    343972 | deleted | t       | 2008-06-24 07:27:02.130695
    343985 | deleted | t       | 2008-06-24 07:45:05.953413
    343995 | deleted | t       | 2008-06-24 07:53:36.501705
    310541 | deleted | t       | 2008-05-13 14:02:50.387603
    344018 | deleted | t       | 2008-06-24 08:22:33.839974
    344019 | deleted | t       | 2008-06-24 08:28:28.850269
    344021 | deleted | t       | 2008-06-24 08:29:27.368143
    344024 | deleted | t       | 2008-06-24 08:30:07.575342
    344031 | deleted | t       | 2008-06-24 08:45:34.226667
    344033 | deleted | t       | 2008-06-24 08:48:22.519501
    348579 | deleted | t       | 2008-06-30 17:21:19.108204
    349232 | deleted | t       | 2008-07-01 09:30:53.68687
    359781 | deleted | t       | 2008-07-15 07:18:36.618101
    351796 | deleted | t       | 2008-07-03 18:55:56.424652
    351237 | deleted | t       | 2008-07-03 08:39:44.96244
    354102 | deleted | t       | 2008-07-07 16:29:55.418881
    354107 | deleted | t       | 2008-07-07 16:30:09.028852
    356744 | deleted | t       | 2008-07-10 17:28:12.936344
    358140 | deleted | t       | 2008-07-12 16:38:57.965263
    362835 | deleted | t       | 2008-07-18 15:03:15.408238
    365259 | deleted | t       | 2008-07-22 04:37:05.343897
    365260 | deleted | t       | 2008-07-22 04:37:54.250753
    365725 | deleted | t       | 2008-07-22 16:46:11.817115
    314417 | deleted | t       | 2008-05-17 15:55:23.584956
    316026 | deleted | t       | 2008-05-19 10:30:05.878467
    307994 | deleted | t       | 2008-05-09 07:59:33.045584
    354864 | deleted | t       | 2008-07-08 15:33:35.820326
    365747 | deleted | t       | 2008-07-22 17:19:52.862908
    365750 | deleted | t       | 2008-07-22 17:21:35.552695
    365751 | deleted | t       | 2008-07-22 17:21:45.039364
    309875 | deleted | t       | 2008-05-12 16:14:03.151646
    370409 | deleted | t       | 2008-07-28 21:27:30.448844
    314874 | deleted | t       | 2008-05-18 11:36:38.945684
    314875 | deleted | t       | 2008-05-18 11:36:46.624703
    314876 | deleted | t       | 2008-05-18 11:37:18.280186
    371138 | deleted | t       | 2008-07-29 15:33:58.273291
    371388 | deleted | t       | 2008-07-29 20:39:33.272832
    371642 | deleted | t       | 2008-07-30 07:00:41.59072
    368170 | deleted | t       | 2008-07-25 15:49:07.36672
    369341 | deleted | t       | 2008-07-27 11:15:39.750845
    313915 | deleted | t       | 2008-05-16 23:10:41.680533
    372338 | deleted | t       | 2008-07-30 22:37:25.009264
    308638 | deleted | t       | 2008-05-09 22:12:24.587651
    308393 | deleted | t       | 2008-05-09 16:01:28.958618
    315074 | deleted | t       | 2008-05-18 14:51:45.438205
    372111 | deleted | t       | 2008-07-30 19:03:03.160764
    372169 | deleted | t       | 2008-07-30 20:04:19.24383
    372218 | deleted | t       | 2008-07-30 20:58:18.80187
    372781 | deleted | t       | 2008-07-31 07:58:43.150888
    315855 | deleted | t       | 2008-05-19 08:04:34.449385
    308611 | deleted | t       | 2008-05-09 21:31:11.229515
    308183 | deleted | t       | 2008-05-09 11:49:00.026607
    314880 | deleted | t       | 2008-05-18 11:38:32.335464
    315816 | deleted | t       | 2008-05-19 07:32:09.991821
    315817 | deleted | t       | 2008-05-19 07:32:52.950207
    315818 | deleted | t       | 2008-05-19 07:33:12.023173
    315820 | deleted | t       | 2008-05-19 07:34:43.549421
    315821 | deleted | t       | 2008-05-19 07:35:44.147022
    315835 | deleted | t       | 2008-05-19 07:50:04.876166
    315836 | deleted | t       | 2008-05-19 07:50:20.71616
    315837 | deleted | t       | 2008-05-19 07:50:39.607671
    315838 | deleted | t       | 2008-05-19 07:51:21.062065
    315839 | deleted | t       | 2008-05-19 07:51:38.360872
    315840 | deleted | t       | 2008-05-19 07:52:16.461247
    315841 | deleted | t       | 2008-05-19 07:52:36.385417
    315845 | deleted | t       | 2008-05-19 07:53:11.027525
    315846 | deleted | t       | 2008-05-19 07:53:21.893788
    315851 | deleted | t       | 2008-05-19 08:00:23.824885
    315853 | deleted | t       | 2008-05-19 08:03:46.897425
    315854 | deleted | t       | 2008-05-19 08:04:04.524888
    312009 | deleted | t       | 2008-05-15 12:02:43.850258
    369342 | deleted | t       | 2008-07-27 11:16:02.741045
    370650 | deleted | t       | 2008-07-29 05:07:00.686502
    312222 | deleted | t       | 2008-05-15 16:32:23.113012
    311524 | deleted | t       | 2008-05-14 19:45:40.319769
    311525 | deleted | t       | 2008-05-14 19:46:42.473439
    313751 | deleted | t       | 2008-05-16 19:04:39.687117
    311528 | deleted | t       | 2008-05-14 19:51:12.98959
    311539 | deleted | t       | 2008-05-14 20:01:19.004397
    312821 | deleted | t       | 2008-05-16 05:59:33.741549
    309594 | deleted | t       | 2008-05-12 05:57:15.054222
    309595 | deleted | t       | 2008-05-12 05:57:53.737679
    313120 | deleted | t       | 2008-05-16 06:38:10.152562
    313133 | deleted | t       | 2008-05-16 06:44:07.783428
    314895 | deleted | t       | 2008-05-18 11:52:57.572509
    312868 | deleted | t       | 2008-05-16 06:05:41.927628
    313827 | deleted | t       | 2008-05-16 21:00:03.60456
    312866 | deleted | t       | 2008-05-16 06:05:28.887602
    313547 | deleted | t       | 2008-05-16 14:40:29.210867
    315405 | deleted | t       | 2008-05-18 21:15:26.76055
    315407 | deleted | t       | 2008-05-18 21:18:35.717098
    315410 | deleted | t       | 2008-05-18 21:22:59.480393
    315413 | deleted | t       | 2008-05-18 21:30:10.324634
    315594 | deleted | t       | 2008-05-19 03:23:59.886615
    316005 | deleted | t       | 2008-05-19 10:14:58.723718
    316010 | deleted | t       | 2008-05-19 10:16:37.750695
    316022 | deleted | t       | 2008-05-19 10:25:35.280933
    316034 | deleted | t       | 2008-05-19 10:37:46.279815
    316132 | deleted | t       | 2008-05-19 11:47:30.406985
    314220 | deleted | t       | 2008-05-17 09:22:57.643646
    314831 | deleted | t       | 2008-05-18 10:15:53.284216
    315002 | deleted | t       | 2008-05-18 13:11:14.115184
    315913 | deleted | t       | 2008-05-19 09:13:43.488781
    314067 | deleted | t       | 2008-05-17 03:07:36.059265
    315355 | deleted | t       | 2008-05-18 20:07:37.192261
    315416 | deleted | t       | 2008-05-18 21:37:42.216139
    330274 | deleted | t       | 2008-06-05 18:00:18.07765
    315183 | deleted | t       | 2008-05-18 17:18:36.709837
    315362 | deleted | t       | 2008-05-18 20:18:53.961448
    315499 | deleted | t       | 2008-05-19 00:55:24.639624
    315859 | deleted | t       | 2008-05-19 08:08:29.32347
    316049 | deleted | t       | 2008-05-19 10:45:21.922406
    316099 | deleted | t       | 2008-05-19 11:30:14.119043
    316110 | deleted | t       | 2008-05-19 11:37:25.002899
    316233 | deleted | t       | 2008-05-19 12:48:51.493173
    315502 | deleted | t       | 2008-05-19 00:59:36.568304
    315965 | deleted | t       | 2008-05-19 09:45:05.759967
    315371 | deleted | t       | 2008-05-18 20:30:16.720711
    315374 | deleted | t       | 2008-05-18 20:37:52.117004
    315377 | deleted | t       | 2008-05-18 20:43:13.143688
    315381 | deleted | t       | 2008-05-18 20:45:10.467439
    315384 | deleted | t       | 2008-05-18 20:49:45.586822
    315399 | deleted | t       | 2008-05-18 21:08:26.338365
    315860 | deleted | t       | 2008-05-19 08:12:31.506738
    315983 | deleted | t       | 2008-05-19 09:56:36.14936
    316245 | deleted | t       | 2008-05-19 12:53:39.785992
    315863 | deleted | t       | 2008-05-19 08:15:06.86511
    315869 | deleted | t       | 2008-05-19 08:22:36.885811
    315870 | deleted | t       | 2008-05-19 08:23:23.207743
    315977 | deleted | t       | 2008-05-19 09:52:39.094798
    322498 | deleted | t       | 2008-05-26 14:15:05.182353
    322530 | deleted | t       | 2008-05-26 15:30:11.180503
    315856 | deleted | t       | 2008-05-19 08:06:53.972697
    315868 | deleted | t       | 2008-05-19 08:22:34.310779
    315872 | deleted | t       | 2008-05-19 08:24:04.379981
    315876 | deleted | t       | 2008-05-19 08:30:05.575508
    315989 | deleted | t       | 2008-05-19 10:00:05.321728
    316119 | deleted | t       | 2008-05-19 11:40:27.978781
    316148 | deleted | t       | 2008-05-19 12:00:08.753701
    315865 | deleted | t       | 2008-05-19 08:21:17.138378
    315871 | deleted | t       | 2008-05-19 08:23:41.601925
    315880 | deleted | t       | 2008-05-19 08:37:37.673409
    315889 | deleted | t       | 2008-05-19 08:45:04.634913
    315914 | deleted | t       | 2008-05-19 09:14:12.204551
    307687 | deleted | t       | 2008-05-08 22:06:05.477963
    297486 | deleted | t       | 2008-04-23 17:12:04.81659
    303527 | deleted | t       | 2008-05-02 22:44:53.410249
    308217 | deleted | t       | 2008-05-09 12:17:51.216288
    297487 | deleted | t       | 2008-04-23 17:13:07.722089
    305663 | deleted | t       | 2008-05-06 12:45:41.028744
    305675 | deleted | t       | 2008-05-06 12:48:03.322009
    305681 | deleted | t       | 2008-05-06 12:48:13.571159
    371836 | deleted | t       | 2008-07-30 13:22:03.186845
    372945 | deleted | t       | 2008-07-31 12:22:56.465549
    373316 | deleted | t       | 2008-07-31 22:38:55.436002
    373454 | deleted | t       | 2008-08-01 05:41:46.33912
    373514 | deleted | t       | 2008-08-01 07:02:36.650355
    373532 | deleted | t       | 2008-08-01 07:29:00.46571
    306103 | deleted | t       | 2008-05-06 22:17:30.626054
    312888 | deleted | t       | 2008-05-16 06:08:47.025885
    373637 | deleted | t       | 2008-08-01 09:27:54.802419
    373672 | deleted | t       | 2008-08-01 09:49:49.276139
    289473 | deleted | t       | 2008-04-10 14:37:35.283257
    305691 | deleted | t       | 2008-05-06 12:50:42.816733
    306128 | deleted | t       | 2008-05-06 23:16:43.337776
    306129 | deleted | t       | 2008-05-06 23:16:51.260498
    308244 | deleted | t       | 2008-05-09 12:36:15.559281
    289548 | deleted | t       | 2008-04-10 14:58:02.913108
    293423 | deleted | t       | 2008-04-17 13:53:05.693728
    294022 | deleted | t       | 2008-04-18 03:48:01.537328
    303221 | deleted | t       | 2008-05-02 10:16:03.335265
    305612 | deleted | t       | 2008-05-06 12:33:24.665262
    306180 | deleted | t       | 2008-05-07 01:27:03.531553
    294326 | deleted | t       | 2008-04-18 16:40:04.850756
    296053 | deleted | t       | 2008-04-21 23:51:59.906961
    301274 | deleted | t       | 2008-04-29 16:01:09.466697
    301279 | deleted | t       | 2008-04-29 16:07:24.442538
    301280 | deleted | t       | 2008-04-29 16:07:46.456305
    289627 | deleted | t       | 2008-04-10 19:00:48.762902
    300844 | deleted | t       | 2008-04-29 04:29:48.308816
    292724 | deleted | t       | 2008-04-16 18:38:07.866472
    293320 | deleted | t       | 2008-04-17 12:51:46.434627
    296420 | deleted | t       | 2008-04-22 11:23:04.980489
    297058 | deleted | t       | 2008-04-23 06:10:27.273691
    308249 | deleted | t       | 2008-05-09 12:44:03.99311
    289691 | deleted | t       | 2008-04-10 22:20:19.316324
    292457 | deleted | t       | 2008-04-16 07:53:23.305396
    298398 | deleted | t       | 2008-04-25 01:45:43.807283
    289703 | deleted | t       | 2008-04-11 01:52:14.970564
    289704 | deleted | t       | 2008-04-11 01:52:44.82839
    289705 | deleted | t       | 2008-04-11 01:53:02.284267
    293460 | deleted | t       | 2008-04-17 14:05:48.275989
    293468 | deleted | t       | 2008-04-17 14:08:53.123718
    296869 | deleted | t       | 2008-04-22 21:46:02.701341
    298397 | deleted | t       | 2008-04-25 01:45:43.426729
    294202 | deleted | t       | 2008-04-18 12:36:34.429354
    297092 | deleted | t       | 2008-04-23 07:11:12.369825
    301339 | deleted | t       | 2008-04-29 17:26:36.61249
    290464 | deleted | t       | 2008-04-12 19:43:25.275209
    290472 | deleted | t       | 2008-04-12 20:01:46.619439
    290477 | deleted | t       | 2008-04-12 20:17:21.725709
    291303 | deleted | t       | 2008-04-14 12:50:34.486839
    295160 | deleted | t       | 2008-04-20 15:05:58.996375
    291316 | deleted | t       | 2008-04-14 13:02:39.334718
    292456 | deleted | t       | 2008-04-16 07:53:22.865214
    295083 | deleted | t       | 2008-04-20 10:53:44.269257
    296560 | deleted | t       | 2008-04-22 13:05:00.711954
    291079 | deleted | t       | 2008-04-14 08:10:40.456316
    291589 | deleted | t       | 2008-04-14 21:31:19.892758
    291595 | deleted | t       | 2008-04-14 21:43:14.395767
    296615 | deleted | t       | 2008-04-22 14:33:56.740763
    289807 | deleted | t       | 2008-04-11 11:38:19.3293
    289813 | deleted | t       | 2008-04-11 12:18:16.010404
    289853 | deleted | t       | 2008-04-11 13:38:35.695637
    292122 | deleted | t       | 2008-04-15 15:43:11.673398
    373914 | deleted | t       | 2008-08-01 15:18:18.901398
    293361 | deleted | t       | 2008-04-17 13:34:30.904728
    296176 | deleted | t       | 2008-04-22 05:45:17.391724
    298143 | deleted | t       | 2008-04-24 17:33:06.363821
    295851 | deleted | t       | 2008-04-21 16:29:08.3261
    296215 | deleted | t       | 2008-04-22 07:04:59.072094
    297297 | deleted | t       | 2008-04-23 12:51:06.431074
    305678 | deleted | t       | 2008-05-06 12:48:04.570894
    293243 | deleted | t       | 2008-04-17 12:27:33.229338
    293792 | deleted | t       | 2008-04-17 22:32:35.278614
    293793 | deleted | t       | 2008-04-17 22:32:53.297437
    296246 | deleted | t       | 2008-04-22 08:13:02.076003
    293379 | deleted | t       | 2008-04-17 13:42:13.742576
    293628 | deleted | t       | 2008-04-17 18:54:00.199243
    290024 | deleted | t       | 2008-04-11 16:54:17.31274
    298458 | deleted | t       | 2008-04-25 03:02:42.148479
    301365 | deleted | t       | 2008-04-29 17:44:08.368972
    293230 | deleted | t       | 2008-04-17 12:23:59.934207
    292108 | deleted | t       | 2008-04-15 14:34:15.622845
    297789 | deleted | t       | 2008-04-24 04:31:08.494351
    290147 | deleted | t       | 2008-04-11 22:45:53.463859
    295309 | deleted | t       | 2008-04-20 20:23:30.084889
    291141 | deleted | t       | 2008-04-14 09:08:45.805098
    293352 | deleted | t       | 2008-04-17 13:29:15.527107
    297952 | deleted | t       | 2008-04-24 10:56:43.410546
    299586 | deleted | t       | 2008-04-27 05:19:49.95925
    299720 | deleted | t       | 2008-04-27 11:14:21.003268
    292332 | deleted | t       | 2008-04-16 02:29:50.594028
    301886 | deleted | t       | 2008-04-30 09:10:54.138127
    295310 | deleted | t       | 2008-04-20 20:25:04.683049
    299805 | deleted | t       | 2008-04-27 15:58:15.435003
    294129 | deleted | t       | 2008-04-18 08:38:07.715127
    294368 | deleted | t       | 2008-04-18 17:34:54.988887
    291020 | deleted | t       | 2008-04-14 05:47:29.51285
    291981 | deleted | t       | 2008-04-15 11:02:52.99981
    293240 | deleted | t       | 2008-04-17 12:27:03.221196
    294149 | deleted | t       | 2008-04-18 09:40:39.676198
    296004 | deleted | t       | 2008-04-21 21:36:03.260725
    297976 | deleted | t       | 2008-04-24 13:37:19.274039
    295211 | deleted | t       | 2008-04-20 16:14:18.58239
    298798 | deleted | t       | 2008-04-25 17:10:06.157635
    292116 | deleted | t       | 2008-04-15 15:25:03.700086
    300885 | deleted | t       | 2008-04-29 06:04:38.695303
    292165 | deleted | t       | 2008-04-15 16:36:42.08016
    292167 | deleted | t       | 2008-04-15 16:37:07.060649
    292168 | deleted | t       | 2008-04-15 16:37:25.744985
    298990 | deleted | t       | 2008-04-25 22:50:45.040279
    292448 | deleted | t       | 2008-04-16 07:50:28.194757
    292450 | deleted | t       | 2008-04-16 07:51:31.107451
    292451 | deleted | t       | 2008-04-16 07:51:31.191698
    292452 | deleted | t       | 2008-04-16 07:51:50.087107
    292453 | deleted | t       | 2008-04-16 07:51:52.110436
    293106 | deleted | t       | 2008-04-17 10:34:04.491106
    292686 | deleted | t       | 2008-04-16 16:58:37.884782
    300463 | deleted | t       | 2008-04-28 16:57:18.746991
    300579 | deleted | t       | 2008-04-28 19:13:48.642158
    301014 | deleted | t       | 2008-04-29 10:17:09.567855
    302714 | deleted | t       | 2008-05-01 12:31:48.964585
    300651 | deleted | t       | 2008-04-28 21:09:38.542188
    303601 | deleted | t       | 2008-05-03 03:24:35.040218
    305533 | deleted | t       | 2008-05-06 12:16:31.365495
    301920 | deleted | t       | 2008-04-30 10:02:17.254686
    304450 | deleted | t       | 2008-05-05 00:10:31.637089
    305331 | deleted | t       | 2008-05-06 09:56:56.873417
    305719 | deleted | t       | 2008-05-06 13:10:54.938112
    301126 | deleted | t       | 2008-04-29 12:25:44.675963
    301158 | deleted | t       | 2008-04-29 12:51:24.761898
    301659 | deleted | t       | 2008-04-29 23:31:32.568523
    301683 | deleted | t       | 2008-04-30 00:02:44.445567
    302802 | deleted | t       | 2008-05-01 15:43:40.815594
    303512 | deleted | t       | 2008-05-02 22:01:50.234173
    292375 | deleted | t       | 2008-04-16 03:27:58.368315
    299833 | deleted | t       | 2008-04-27 16:14:41.369611
    299838 | deleted | t       | 2008-04-27 16:19:41.054255
    299841 | deleted | t       | 2008-04-27 16:20:46.486939
    303286 | deleted | t       | 2008-05-02 15:24:50.519264
    303328 | deleted | t       | 2008-05-02 16:55:28.126881
    303944 | deleted | t       | 2008-05-03 21:24:40.944596
    304172 | deleted | t       | 2008-05-04 10:31:57.843907
    305538 | deleted | t       | 2008-05-06 12:17:07.315034
    305544 | deleted | t       | 2008-05-06 12:17:40.171033
    305546 | deleted | t       | 2008-05-06 12:17:54.196476
    305559 | deleted | t       | 2008-05-06 12:20:21.98211
    304587 | deleted | t       | 2008-05-05 09:30:50.760561
    304763 | deleted | t       | 2008-05-05 17:23:27.635881
    304957 | deleted | t       | 2008-05-05 22:28:55.423373
    304967 | deleted | t       | 2008-05-05 22:47:50.031475
    307595 | deleted | t       | 2008-05-08 19:15:01.352154
    304745 | deleted | t       | 2008-05-05 15:54:06.512448
    305420 | deleted | t       | 2008-05-06 11:15:43.059
    305593 | deleted | t       | 2008-05-06 12:28:50.797079
    305600 | deleted | t       | 2008-05-06 12:30:03.343431
    305617 | deleted | t       | 2008-05-06 12:34:57.240086
    306562 | deleted | t       | 2008-05-07 14:16:06.101345
    307197 | deleted | t       | 2008-05-08 09:23:42.581075
    307919 | deleted | t       | 2008-05-09 06:33:44.081164
    308293 | deleted | t       | 2008-05-09 13:31:09.350359
    305093 | deleted | t       | 2008-05-06 01:24:24.358452
    305118 | deleted | t       | 2008-05-06 02:04:38.037564
    305933 | deleted | t       | 2008-05-06 16:53:18.895142
    305936 | deleted | t       | 2008-05-06 16:55:54.914904
    305937 | deleted | t       | 2008-05-06 16:56:13.31173
    305938 | deleted | t       | 2008-05-06 16:56:38.10171
    304713 | deleted | t       | 2008-05-05 15:03:57.979261
    310919 | deleted | t       | 2008-05-14 02:58:14.968321
    310469 | deleted | t       | 2008-05-13 12:55:37.439083
    311924 | deleted | t       | 2008-05-15 09:23:12.052365
    305611 | deleted | t       | 2008-05-06 12:33:14.027151
    305627 | deleted | t       | 2008-05-06 12:39:49.938938
    305636 | deleted | t       | 2008-05-06 12:43:26.910501
    305638 | deleted | t       | 2008-05-06 12:43:46.951174
    305641 | deleted | t       | 2008-05-06 12:43:50.679818
    305643 | deleted | t       | 2008-05-06 12:44:12.474045
    305645 | deleted | t       | 2008-05-06 12:44:43.726571
    305648 | deleted | t       | 2008-05-06 12:44:50.705147
    305661 | deleted | t       | 2008-05-06 12:45:33.771304
    305677 | deleted | t       | 2008-05-06 12:48:04.013488
    311361 | deleted | t       | 2008-05-14 16:09:02.852479
    312307 | deleted | t       | 2008-05-15 18:32:57.521233
    312516 | deleted | t       | 2008-05-15 22:32:06.300606
    310563 | deleted | t       | 2008-05-13 14:18:12.800942
    311175 | deleted | t       | 2008-05-14 12:57:41.285238
    311441 | deleted | t       | 2008-05-14 17:50:31.916096
    312325 | deleted | t       | 2008-05-15 18:52:02.868174
    306845 | deleted | t       | 2008-05-07 22:27:18.639655
    313176 | deleted | t       | 2008-05-16 07:00:30.419969
    313178 | deleted | t       | 2008-05-16 07:01:49.667149
    309988 | deleted | t       | 2008-05-12 19:04:21.540407
    313326 | deleted | t       | 2008-05-16 10:35:33.987627
    313869 | deleted | t       | 2008-05-16 21:49:49.307481
    310163 | deleted | t       | 2008-05-13 03:58:40.7438
    310203 | deleted | t       | 2008-05-13 05:57:27.641153
    312950 | deleted | t       | 2008-05-16 06:14:38.858474
    312968 | deleted | t       | 2008-05-16 06:16:27.391022
    312972 | deleted | t       | 2008-05-16 06:16:50.798704
    312988 | deleted | t       | 2008-05-16 06:18:24.447569
    312990 | deleted | t       | 2008-05-16 06:18:32.901663
    312995 | deleted | t       | 2008-05-16 06:19:47.779705
    313001 | deleted | t       | 2008-05-16 06:20:17.056471
    313006 | deleted | t       | 2008-05-16 06:20:32.148157
    313008 | deleted | t       | 2008-05-16 06:21:02.610171
    313025 | deleted | t       | 2008-05-16 06:23:12.609671
    313032 | deleted | t       | 2008-05-16 06:24:24.772291
    313037 | deleted | t       | 2008-05-16 06:24:53.533491
    313038 | deleted | t       | 2008-05-16 06:24:57.091271
    313043 | deleted | t       | 2008-05-16 06:25:41.777045
    313045 | deleted | t       | 2008-05-16 06:25:49.82455
    313048 | deleted | t       | 2008-05-16 06:25:54.005004
    313053 | deleted | t       | 2008-05-16 06:26:36.159722
    313062 | deleted | t       | 2008-05-16 06:27:04.728768
    313063 | deleted | t       | 2008-05-16 06:27:23.776715
    313064 | deleted | t       | 2008-05-16 06:27:24.811551
    313068 | deleted | t       | 2008-05-16 06:27:47.724988
    313073 | deleted | t       | 2008-05-16 06:28:44.56852
    313083 | deleted | t       | 2008-05-16 06:30:16.493743
    313086 | deleted | t       | 2008-05-16 06:30:32.257849
    313092 | deleted | t       | 2008-05-16 06:31:18.833836
    313100 | deleted | t       | 2008-05-16 06:32:01.223524
    313103 | deleted | t       | 2008-05-16 06:33:00.354515
    313104 | deleted | t       | 2008-05-16 06:33:16.231874
    313114 | deleted | t       | 2008-05-16 06:36:59.473362
    313376 | deleted | t       | 2008-05-16 11:42:41.140174
    313482 | deleted | t       | 2008-05-16 13:41:56.373506
    313799 | deleted | t       | 2008-05-16 20:27:14.543176
    313503 | deleted | t       | 2008-05-16 13:57:36.581259
    314922 | deleted | t       | 2008-05-18 12:10:31.919382
    314943 | deleted | t       | 2008-05-18 12:25:41.255816
    314945 | deleted | t       | 2008-05-18 12:27:59.121015
    315713 | deleted | t       | 2008-05-19 05:44:45.81586
    315719 | deleted | t       | 2008-05-19 05:46:34.513102
    315720 | deleted | t       | 2008-05-19 05:46:41.232417
    315810 | deleted | t       | 2008-05-19 07:26:15.809783
    315814 | deleted | t       | 2008-05-19 07:30:03.988539
    315815 | deleted | t       | 2008-05-19 07:31:27.518594
    315825 | deleted | t       | 2008-05-19 07:37:39.221889
    315890 | deleted | t       | 2008-05-19 08:45:50.710972
    315891 | deleted | t       | 2008-05-19 08:46:51.009109
    315892 | deleted | t       | 2008-05-19 08:47:43.378622
    315896 | deleted | t       | 2008-05-19 08:52:35.831505
    315904 | deleted | t       | 2008-05-19 09:00:09.314078
    315905 | deleted | t       | 2008-05-19 09:06:22.52901
    315908 | deleted | t       | 2008-05-19 09:07:37.508435
    315915 | deleted | t       | 2008-05-19 09:14:15.997613
    315972 | deleted | t       | 2008-05-19 09:48:55.282335
    315982 | deleted | t       | 2008-05-19 09:55:52.79203
    316002 | deleted | t       | 2008-05-19 10:07:35.577795
    316008 | deleted | t       | 2008-05-19 10:15:13.044047
    316015 | deleted | t       | 2008-05-19 10:22:53.199765
    316023 | deleted | t       | 2008-05-19 10:26:19.462943
    316060 | deleted | t       | 2008-05-19 10:53:26.300783
    316065 | deleted | t       | 2008-05-19 11:00:07.05559
    316114 | deleted | t       | 2008-05-19 11:37:55.090656
    316128 | deleted | t       | 2008-05-19 11:45:08.031791
    316129 | deleted | t       | 2008-05-19 11:45:43.13547
    316135 | deleted | t       | 2008-05-19 11:52:28.678237
    316138 | deleted | t       | 2008-05-19 11:52:47.199722
    315161 | deleted | t       | 2008-05-18 16:55:36.506658
    316418 | deleted | t       | 2008-05-19 14:45:22.180525
    316460 | deleted | t       | 2008-05-19 15:04:13.21035
    316516 | deleted | t       | 2008-05-19 15:33:08.956619
    316518 | deleted | t       | 2008-05-19 15:33:27.744673
    316539 | deleted | t       | 2008-05-19 15:40:41.268558
    316607 | deleted | t       | 2008-05-19 16:17:36.64668
    316690 | deleted | t       | 2008-05-19 17:25:21.332136
    317547 | deleted | t       | 2008-05-20 06:15:53.847494
    317565 | deleted | t       | 2008-05-20 06:24:23.414196
    317567 | deleted | t       | 2008-05-20 06:26:10.061189
    317568 | deleted | t       | 2008-05-20 06:26:10.207146
    317570 | deleted | t       | 2008-05-20 06:26:14.113082
    317590 | deleted | t       | 2008-05-20 06:31:11.965681
    317718 | deleted | t       | 2008-05-20 06:57:32.722079
    317733 | deleted | t       | 2008-05-20 07:01:18.444693
    322067 | deleted | t       | 2008-05-25 18:44:56.555915
    322441 | deleted | t       | 2008-05-26 12:43:07.107248
    316267 | deleted | t       | 2008-05-19 13:08:36.744228
    316537 | deleted | t       | 2008-05-19 15:40:28.645214
    316723 | deleted | t       | 2008-05-19 17:55:48.929627
    316724 | deleted | t       | 2008-05-19 17:55:56.57029
    316770 | deleted | t       | 2008-05-19 18:28:01.613201
    316775 | deleted | t       | 2008-05-19 18:31:19.939195
    316776 | deleted | t       | 2008-05-19 18:31:49.13226
    316805 | deleted | t       | 2008-05-19 19:02:05.138161
    316834 | deleted | t       | 2008-05-19 19:31:24.817003
    316842 | deleted | t       | 2008-05-19 19:34:21.486182
    316921 | deleted | t       | 2008-05-19 20:46:46.191401
    317109 | deleted | t       | 2008-05-20 00:13:05.946812
    317110 | deleted | t       | 2008-05-20 00:13:12.09543
    317276 | deleted | t       | 2008-05-20 03:29:00.18973
    317604 | deleted | t       | 2008-05-20 06:35:09.589336
    317614 | deleted | t       | 2008-05-20 06:36:46.98524
    317615 | deleted | t       | 2008-05-20 06:36:55.250537
    317619 | deleted | t       | 2008-05-20 06:37:10.501104
    317620 | deleted | t       | 2008-05-20 06:37:14.090264
    317749 | deleted | t       | 2008-05-20 07:06:37.036379
    317824 | deleted | t       | 2008-05-20 07:25:18.66753
    317939 | deleted | t       | 2008-05-20 08:38:23.592638
    316544 | deleted | t       | 2008-05-19 15:44:18.529068
    316546 | deleted | t       | 2008-05-19 15:45:28.73253
    316554 | deleted | t       | 2008-05-19 15:49:07.883515
    316870 | deleted | t       | 2008-05-19 19:51:01.458801
    317637 | deleted | t       | 2008-05-20 06:39:10.459681
    317745 | deleted | t       | 2008-05-20 07:05:09.54824
    320336 | deleted | t       | 2008-05-22 14:09:40.245055
    316707 | deleted | t       | 2008-05-19 17:42:06.447962
    316746 | deleted | t       | 2008-05-19 18:07:22.346005
    316751 | deleted | t       | 2008-05-19 18:12:48.102229
    316873 | deleted | t       | 2008-05-19 19:52:54.230457
    316968 | deleted | t       | 2008-05-19 21:59:51.412499
    316999 | deleted | t       | 2008-05-19 22:37:48.040917
    317001 | deleted | t       | 2008-05-19 22:38:43.715119
    317297 | deleted | t       | 2008-05-20 03:47:43.523767
    317516 | deleted | t       | 2008-05-20 06:08:02.179623
    317609 | deleted | t       | 2008-05-20 06:36:12.881253
    317641 | deleted | t       | 2008-05-20 06:39:36.168194
    317731 | deleted | t       | 2008-05-20 07:00:28.748263
    317879 | deleted | t       | 2008-05-20 08:02:28.508968
    317995 | deleted | t       | 2008-05-20 09:08:17.712694
    318176 | deleted | t       | 2008-05-20 12:11:23.260139
    318182 | deleted | t       | 2008-05-20 12:13:42.357909
    318248 | deleted | t       | 2008-05-20 12:50:44.48805
    317638 | deleted | t       | 2008-05-20 06:39:26.065003
    317640 | deleted | t       | 2008-05-20 06:39:35.189366
    317683 | deleted | t       | 2008-05-20 06:47:58.984068
    317721 | deleted | t       | 2008-05-20 06:57:57.592895
    317758 | deleted | t       | 2008-05-20 07:09:59.538576
    317759 | deleted | t       | 2008-05-20 07:10:04.933097
    317764 | deleted | t       | 2008-05-20 07:13:13.461065
    317773 | deleted | t       | 2008-05-20 07:15:01.861359
    317786 | deleted | t       | 2008-05-20 07:15:09.152284
    317791 | deleted | t       | 2008-05-20 07:15:49.956922
    317804 | deleted | t       | 2008-05-20 07:20:17.237758
    317806 | deleted | t       | 2008-05-20 07:21:10.699897
    317814 | deleted | t       | 2008-05-20 07:22:48.169199
    317818 | deleted | t       | 2008-05-20 07:23:12.454067
    317825 | deleted | t       | 2008-05-20 07:25:26.618032
    317839 | deleted | t       | 2008-05-20 07:30:29.315333
    317876 | deleted | t       | 2008-05-20 08:00:22.976454
    317892 | deleted | t       | 2008-05-20 08:09:20.809774
    318197 | deleted | t       | 2008-05-20 12:17:07.453649
    318229 | deleted | t       | 2008-05-20 12:34:13.670933
    318237 | deleted | t       | 2008-05-20 12:38:36.400311
    319626 | deleted | t       | 2008-05-21 14:53:47.668488
    320867 | deleted | t       | 2008-05-23 04:26:29.93609
    317460 | deleted | t       | 2008-05-20 05:47:50.618912
    317474 | deleted | t       | 2008-05-20 05:56:03.6988
    317480 | deleted | t       | 2008-05-20 05:58:22.591919
    317976 | deleted | t       | 2008-05-20 08:56:23.818214
    317977 | deleted | t       | 2008-05-20 08:56:53.114416
    317979 | deleted | t       | 2008-05-20 08:59:32.315793
    317980 | deleted | t       | 2008-05-20 08:59:44.123168
    318191 | deleted | t       | 2008-05-20 12:15:07.153716
    318202 | deleted | t       | 2008-05-20 12:19:29.465786
    318207 | deleted | t       | 2008-05-20 12:23:01.452924
    319027 | deleted | t       | 2008-05-21 00:28:00.602884
    320729 | deleted | t       | 2008-05-22 22:23:48.179757
    320887 | deleted | t       | 2008-05-23 05:41:08.043582
    321295 | deleted | t       | 2008-05-23 18:58:09.085359
    322110 | deleted | t       | 2008-05-25 20:55:25.137997
    322415 | deleted | t       | 2008-05-26 12:08:50.26202
    322416 | deleted | t       | 2008-05-26 12:08:51.946677
    317509 | deleted | t       | 2008-05-20 06:06:13.392364
    318000 | deleted | t       | 2008-05-20 09:08:43.133182
    317517 | deleted | t       | 2008-05-20 06:08:30.325643
    317518 | deleted | t       | 2008-05-20 06:08:45.073003
    317524 | deleted | t       | 2008-05-20 06:09:50.949033
    317631 | deleted | t       | 2008-05-20 06:37:56.071003
    317646 | deleted | t       | 2008-05-20 06:41:07.396396
    317664 | deleted | t       | 2008-05-20 06:45:23.192786
    317669 | deleted | t       | 2008-05-20 06:46:07.068179
    317684 | deleted | t       | 2008-05-20 06:48:03.063812
    317696 | deleted | t       | 2008-05-20 06:49:55.830802
    318040 | deleted | t       | 2008-05-20 09:31:14.273788
    318119 | deleted | t       | 2008-05-20 11:06:23.846227
    318739 | deleted | t       | 2008-05-20 19:08:56.593814
    318740 | deleted | t       | 2008-05-20 19:09:15.365267
    319086 | deleted | t       | 2008-05-21 02:01:50.853994
    319088 | deleted | t       | 2008-05-21 02:02:12.873889
    320419 | deleted | t       | 2008-05-22 15:21:27.343702
    321319 | deleted | t       | 2008-05-23 19:45:11.231003
    317834 | deleted | t       | 2008-05-20 07:28:49.543152
    317842 | deleted | t       | 2008-05-20 07:34:09.13465
    317843 | deleted | t       | 2008-05-20 07:35:38.296992
    317848 | deleted | t       | 2008-05-20 07:38:14.746949
    318233 | deleted | t       | 2008-05-20 12:37:31.448809
    318339 | deleted | t       | 2008-05-20 13:44:31.026543
    318343 | deleted | t       | 2008-05-20 13:45:07.561745
    318757 | deleted | t       | 2008-05-20 19:22:00.489537
    319134 | deleted | t       | 2008-05-21 03:19:33.640894
    319447 | deleted | t       | 2008-05-21 11:45:42.143498
    319481 | deleted | t       | 2008-05-21 12:29:17.753939
    320507 | deleted | t       | 2008-05-22 17:20:10.575967
    317901 | deleted | t       | 2008-05-20 08:15:35.469511
    317910 | deleted | t       | 2008-05-20 08:23:31.970848
    317916 | deleted | t       | 2008-05-20 08:23:54.286794
    317923 | deleted | t       | 2008-05-20 08:30:27.495116
    317998 | deleted | t       | 2008-05-20 09:08:34.100048
    318901 | deleted | t       | 2008-05-20 21:13:23.438725
    318948 | deleted | t       | 2008-05-20 22:30:17.51601
    321696 | deleted | t       | 2008-05-24 18:08:30.791024
    318003 | deleted | t       | 2008-05-20 09:09:21.293424
    318133 | deleted | t       | 2008-05-20 11:30:28.141644
    318135 | deleted | t       | 2008-05-20 11:30:53.452129
    318136 | deleted | t       | 2008-05-20 11:35:17.822728
    323071 | deleted | t       | 2008-05-27 11:15:26.781599
    323078 | deleted | t       | 2008-05-27 11:25:42.215495
    323416 | deleted | t       | 2008-05-27 16:36:28.462489
    323417 | deleted | t       | 2008-05-27 16:36:28.510727
    324698 | deleted | t       | 2008-05-28 19:11:22.199399
    325304 | deleted | t       | 2008-05-29 10:42:52.19294
    326518 | deleted | t       | 2008-05-30 17:23:34.620487
    322888 | deleted | t       | 2008-05-27 06:59:09.714854
    322430 | deleted | t       | 2008-05-26 12:25:36.950364
    322544 | deleted | t       | 2008-05-26 15:40:49.779841
    325354 | deleted | t       | 2008-05-29 12:23:05.528501
    331053 | deleted | t       | 2008-06-06 13:54:10.103256
    324249 | deleted | t       | 2008-05-28 11:20:27.471734
    324250 | deleted | t       | 2008-05-28 11:21:45.92377
    324251 | deleted | t       | 2008-05-28 11:22:17.117349
    324253 | deleted | t       | 2008-05-28 11:23:10.322614
    324254 | deleted | t       | 2008-05-28 11:23:29.457882
    324256 | deleted | t       | 2008-05-28 11:24:04.079151
    324262 | deleted | t       | 2008-05-28 11:25:58.750703
    324265 | deleted | t       | 2008-05-28 11:30:04.98999
    296267 | deleted | t       | 2008-04-22 08:56:34.810278
    323073 | deleted | t       | 2008-05-27 11:22:17.529831
    323074 | deleted | t       | 2008-05-27 11:22:44.201587
    323081 | deleted | t       | 2008-05-27 11:27:00.98534
    324080 | deleted | t       | 2008-05-28 08:23:25.53927
    326463 | deleted | t       | 2008-05-30 15:45:02.508161
    326947 | deleted | t       | 2008-05-31 04:07:56.860403
    328298 | deleted | t       | 2008-06-03 03:18:49.204881
    323435 | deleted | t       | 2008-05-27 16:44:14.920534
    323436 | deleted | t       | 2008-05-27 16:44:15.014942
    325029 | deleted | t       | 2008-05-29 03:51:39.817639
    325544 | deleted | t       | 2008-05-29 17:05:07.726549
    326203 | deleted | t       | 2008-05-30 11:15:31.833028
    326325 | deleted | t       | 2008-05-30 13:19:26.819805
    327854 | deleted | t       | 2008-06-02 16:48:27.012208
    327612 | deleted | t       | 2008-06-02 13:56:42.419373
    330422 | deleted | t       | 2008-06-05 20:25:52.815022
    324079 | deleted | t       | 2008-05-28 08:23:13.42152
    324096 | deleted | t       | 2008-05-28 08:38:13.874402
    327396 | deleted | t       | 2008-06-01 00:34:19.056008
    329437 | deleted | t       | 2008-06-04 11:19:14.257817
    311549 | deleted | t       | 2008-05-14 20:13:44.515974
    326759 | deleted | t       | 2008-05-30 20:25:38.933925
    328665 | deleted | t       | 2008-06-03 13:29:22.725355
    329083 | deleted | t       | 2008-06-03 23:01:44.621637
    329453 | deleted | t       | 2008-06-04 11:39:12.105644
    329454 | deleted | t       | 2008-06-04 11:39:12.539868
    326390 | deleted | t       | 2008-05-30 14:37:55.767125
    326391 | deleted | t       | 2008-05-30 14:38:14.198238
    330568 | deleted | t       | 2008-06-05 22:32:43.484214
    331752 | deleted | t       | 2008-06-07 23:21:55.269859
    375093 | deleted | t       | 2008-08-04 03:52:01.292881
    375192 | deleted | t       | 2008-08-04 05:58:41.864513
    331007 | deleted | t       | 2008-06-06 12:51:14.879606
    331302 | deleted | t       | 2008-06-06 20:29:49.754159
    331907 | deleted | t       | 2008-06-08 07:53:01.732636
    331926 | deleted | t       | 2008-06-08 08:31:29.200333
    334144 | deleted | t       | 2008-06-11 17:42:37.638696
    333096 | deleted | t       | 2008-06-10 10:34:53.734242
    375800 | deleted | t       | 2008-08-04 16:32:55.220909
    375801 | deleted | t       | 2008-08-04 16:34:19.54179
    375822 | deleted | t       | 2008-08-04 17:02:30.527736
    376019 | deleted | t       | 2008-08-04 19:47:56.735992
    376504 | deleted | t       | 2008-08-05 10:09:23.109232
    376515 | deleted | t       | 2008-08-05 10:17:42.042019
    329888 | deleted | t       | 2008-06-05 02:38:04.609169
    330898 | deleted | t       | 2008-06-06 09:35:13.614265
    331419 | deleted | t       | 2008-06-07 00:32:50.515859
    331420 | deleted | t       | 2008-06-07 00:32:58.223282
    333940 | deleted | t       | 2008-06-11 13:39:47.337667
    373775 | deleted | t       | 2008-08-01 12:59:35.694558
    373779 | deleted | t       | 2008-08-01 13:02:47.281579
    376705 | deleted | t       | 2008-08-05 14:49:10.637093
    376706 | deleted | t       | 2008-08-05 14:49:33.010941
    376839 | deleted | t       | 2008-08-05 18:49:57.671605
    376867 | deleted | t       | 2008-08-05 19:27:13.243701
    377098 | deleted | t       | 2008-08-06 02:50:53.499517
    377474 | deleted | t       | 2008-08-06 10:05:08.863685
    334660 | deleted | t       | 2008-06-12 11:12:12.960993
    358903 | deleted | t       | 2008-07-14 08:33:21.136153
    337063 | deleted | t       | 2008-06-15 07:17:50.477893
    365480 | deleted | t       | 2008-07-22 12:12:35.651701
    377995 | deleted | t       | 2008-08-06 18:25:08.004349
    378118 | deleted | t       | 2008-08-06 21:04:37.769311
    378137 | deleted | t       | 2008-08-06 21:26:28.319326
    378352 | deleted | t       | 2008-08-07 05:42:05.540627
    378364 | deleted | t       | 2008-08-07 06:04:52.517732
    377143 | deleted | t       | 2008-08-06 03:24:12.421744
    337327 | deleted | t       | 2008-06-15 16:17:32.76622
    325022 | deleted | t       | 2008-05-29 03:44:58.004156
    325028 | deleted | t       | 2008-05-29 03:51:39.707908
    374015 | deleted | t       | 2008-08-01 18:01:32.478192
    337377 | deleted | t       | 2008-06-15 17:26:18.444403
    338855 | deleted | t       | 2008-06-17 08:14:51.046962
    339604 | deleted | t       | 2008-06-18 08:51:27.58726
    339760 | deleted | t       | 2008-06-18 11:38:31.735809
    350745 | deleted | t       | 2008-07-02 17:59:59.469729
    339879 | deleted | t       | 2008-06-18 14:41:54.29325
    340248 | deleted | t       | 2008-06-18 22:45:59.213339
    340249 | deleted | t       | 2008-06-18 22:46:20.963178
    339967 | deleted | t       | 2008-06-18 16:13:04.437937
    342158 | deleted | t       | 2008-06-21 03:21:59.045692
    293311 | deleted | t       | 2008-04-17 12:48:19.955429
    293356 | deleted | t       | 2008-04-17 13:33:17.100181
    339302 | deleted | t       | 2008-06-17 19:10:59.786907
    339506 | deleted | t       | 2008-06-18 04:45:05.15633
    342781 | deleted | t       | 2008-06-22 12:41:52.618628
    353806 | deleted | t       | 2008-07-07 09:00:05.424786
    342793 | deleted | t       | 2008-06-22 12:48:42.318464
    338822 | deleted | t       | 2008-06-17 07:23:18.943769
    339576 | deleted | t       | 2008-06-18 08:08:50.147101
    343920 | deleted | t       | 2008-06-24 06:00:05.059259
    373865 | deleted | t       | 2008-08-01 14:35:45.71454
    343926 | deleted | t       | 2008-06-24 06:15:05.413287
    355441 | deleted | t       | 2008-07-09 08:05:13.267606
    339792 | deleted | t       | 2008-06-18 12:17:58.979805
    343909 | deleted | t       | 2008-06-24 05:40:25.629775
    343934 | deleted | t       | 2008-06-24 06:30:09.208485
    343940 | deleted | t       | 2008-06-24 06:41:49.563425
    340113 | deleted | t       | 2008-06-18 19:04:19.600466
    343943 | deleted | t       | 2008-06-24 06:45:05.42952
    343947 | deleted | t       | 2008-06-24 06:52:29.768463
    344040 | deleted | t       | 2008-06-24 09:00:08.533871
    353831 | deleted | t       | 2008-07-07 09:43:23.293111
    343944 | deleted | t       | 2008-06-24 06:51:29.971148
    343969 | deleted | t       | 2008-06-24 07:22:33.788874
    344066 | deleted | t       | 2008-06-24 09:52:34.979386
    344071 | deleted | t       | 2008-06-24 10:00:08.469503
    340404 | deleted | t       | 2008-06-19 05:13:53.29171
    341223 | deleted | t       | 2008-06-19 22:15:35.463181
    344448 | deleted | t       | 2008-06-24 16:46:49.242299
    339898 | deleted | t       | 2008-06-18 15:14:53.537954
    339915 | deleted | t       | 2008-06-18 15:28:28.624415
    341774 | deleted | t       | 2008-06-20 13:16:22.429854
    341779 | deleted | t       | 2008-06-20 13:22:39.063282
    341588 | deleted | t       | 2008-06-20 09:31:41.140282
    340506 | deleted | t       | 2008-06-19 07:47:40.305212
    346529 | deleted | t       | 2008-06-27 00:22:28.103534
    346532 | deleted | t       | 2008-06-27 00:27:07.780674
    347287 | deleted | t       | 2008-06-28 06:31:45.521676
    345592 | deleted | t       | 2008-06-25 22:49:48.598011
    346727 | deleted | t       | 2008-06-27 07:53:03.714237
    346363 | deleted | t       | 2008-06-26 18:06:31.703532
    317368 | deleted | t       | 2008-05-20 04:43:30.948557
    317375 | deleted | t       | 2008-05-20 04:43:36.673352
    317775 | deleted | t       | 2008-05-20 07:15:02.934865
    317784 | deleted | t       | 2008-05-20 07:15:07.721908
    341953 | deleted | t       | 2008-06-20 18:25:51.248815
    344032 | deleted | t       | 2008-06-24 08:48:15.394694
    344075 | deleted | t       | 2008-06-24 10:07:35.383292
    350628 | deleted | t       | 2008-07-02 16:56:36.485215
    351653 | deleted | t       | 2008-07-03 15:57:14.768596
    352489 | deleted | t       | 2008-07-04 16:51:28.697236
    365984 | deleted | t       | 2008-07-22 20:49:49.74789
    371022 | deleted | t       | 2008-07-29 13:11:44.617771
    342921 | deleted | t       | 2008-06-22 18:29:13.531143
    344105 | deleted | t       | 2008-06-24 10:52:39.417833
    344113 | deleted | t       | 2008-06-24 11:00:10.184839
    344118 | deleted | t       | 2008-06-24 11:07:42.400527
    344125 | deleted | t       | 2008-06-24 11:22:41.115636
    344319 | deleted | t       | 2008-06-24 14:45:59.218377
    344609 | deleted | t       | 2008-06-24 20:31:20.611489
    348010 | deleted | t       | 2008-06-29 22:34:00.01933
    343111 | deleted | t       | 2008-06-23 01:50:53.565808
    343232 | deleted | t       | 2008-06-23 05:42:55.859436
    359393 | deleted | t       | 2008-07-14 18:33:43.327909
    343997 | deleted | t       | 2008-06-24 07:55:17.913613
    343998 | deleted | t       | 2008-06-24 07:55:18.032679
    343999 | deleted | t       | 2008-06-24 07:55:44.222561
    344003 | deleted | t       | 2008-06-24 08:00:06.071285
    344007 | deleted | t       | 2008-06-24 08:07:32.672053
    349436 | deleted | t       | 2008-07-01 12:32:22.408964
    360511 | deleted | t       | 2008-07-16 01:44:14.297377
    360515 | deleted | t       | 2008-07-16 01:45:19.690131
    346024 | deleted | t       | 2008-06-26 12:17:22.904171
    351282 | deleted | t       | 2008-07-03 09:50:34.678254
    348447 | deleted | t       | 2008-06-30 14:54:20.684566
    348448 | deleted | t       | 2008-06-30 14:54:22.867098
    348928 | deleted | t       | 2008-06-30 23:30:59.230593
    348930 | deleted | t       | 2008-06-30 23:37:25.049234
    354290 | deleted | t       | 2008-07-07 21:24:44.174767
    305095 | deleted | t       | 2008-05-06 01:24:34.867582
    305096 | deleted | t       | 2008-05-06 01:24:47.953261
    305097 | deleted | t       | 2008-05-06 01:25:07.466932
    305098 | deleted | t       | 2008-05-06 01:25:19.498213
    305099 | deleted | t       | 2008-05-06 01:25:33.834541
    305105 | deleted | t       | 2008-05-06 01:34:28.613057
    305106 | deleted | t       | 2008-05-06 01:44:21.89031
    305107 | deleted | t       | 2008-05-06 01:44:35.17054
    305798 | deleted | t       | 2008-05-06 14:06:25.322996
    353606 | deleted | t       | 2008-07-07 00:10:54.076206
    354327 | deleted | t       | 2008-07-07 22:00:39.524751
    356621 | deleted | t       | 2008-07-10 15:18:06.499018
    356545 | deleted | t       | 2008-07-10 13:51:15.469564
    358706 | deleted | t       | 2008-07-13 22:34:55.443205
    357454 | deleted | t       | 2008-07-11 14:17:22.521622
    357455 | deleted | t       | 2008-07-11 14:17:51.684114
    357456 | deleted | t       | 2008-07-11 14:18:26.274609
    362342 | deleted | t       | 2008-07-18 00:17:19.113442
    359926 | deleted | t       | 2008-07-15 09:50:45.910155
    359940 | deleted | t       | 2008-07-15 10:07:57.240979
    359610 | deleted | t       | 2008-07-15 00:34:14.652647
    361691 | deleted | t       | 2008-07-17 08:26:38.118384
    373252 | deleted | t       | 2008-07-31 20:39:25.853003
    371405 | deleted | t       | 2008-07-29 21:01:43.306489
    364405 | deleted | t       | 2008-07-21 11:17:26.491802
    364703 | deleted | t       | 2008-07-21 16:36:37.191454
    364704 | deleted | t       | 2008-07-21 16:38:52.797013
    362776 | deleted | t       | 2008-07-18 13:35:10.330641
    365361 | deleted | t       | 2008-07-22 09:00:53.474333
    365377 | deleted | t       | 2008-07-22 09:30:06.249555
    365388 | deleted | t       | 2008-07-22 09:45:07.026294
    366364 | deleted | t       | 2008-07-23 10:12:05.092204
    366370 | deleted | t       | 2008-07-23 10:28:54.465065
    370192 | deleted | t       | 2008-07-28 15:55:13.367896
    365391 | deleted | t       | 2008-07-22 09:52:30.152137
    365401 | deleted | t       | 2008-07-22 10:15:07.603214
    365407 | deleted | t       | 2008-07-22 10:22:31.162982
    365411 | deleted | t       | 2008-07-22 10:30:07.196271
    365415 | deleted | t       | 2008-07-22 10:37:31.462595
    365423 | deleted | t       | 2008-07-22 10:52:34.394428
    370739 | deleted | t       | 2008-07-29 07:11:10.150634
    372402 | deleted | t       | 2008-07-31 00:13:05.179289
    366710 | deleted | t       | 2008-07-23 20:54:51.848918
    364225 | deleted | t       | 2008-07-21 07:44:32.820493
    369250 | deleted | t       | 2008-07-27 07:15:26.725104
    364455 | deleted | t       | 2008-07-21 12:23:58.204605
    368480 | deleted | t       | 2008-07-25 19:49:58.690098
    371910 | deleted | t       | 2008-07-30 15:13:36.606954
    373714 | deleted | t       | 2008-08-01 10:40:01.412762
    309849 | deleted | t       | 2008-05-12 15:20:58.622569
    315829 | deleted | t       | 2008-05-19 07:45:05.812854
    308122 | deleted | t       | 2008-05-09 10:14:20.775529
    368901 | deleted | t       | 2008-07-26 16:19:49.945881
    369752 | deleted | t       | 2008-07-28 01:20:01.022903
    371023 | deleted | t       | 2008-07-29 13:12:05.177208
    367636 | deleted | t       | 2008-07-24 22:54:43.88315
    369616 | deleted | t       | 2008-07-27 22:21:43.098016
    369973 | deleted | t       | 2008-07-28 10:29:55.343423
    372056 | deleted | t       | 2008-07-30 17:44:34.782299
    356846 | deleted | t       | 2008-07-10 19:07:38.842657
    369628 | deleted | t       | 2008-07-27 22:33:58.05063
    369662 | deleted | t       | 2008-07-27 22:52:12.841497
    370053 | deleted | t       | 2008-07-28 13:46:48.374422
    370112 | deleted | t       | 2008-07-28 15:12:58.897522
    370135 | deleted | t       | 2008-07-28 15:26:07.412575
    370670 | deleted | t       | 2008-07-29 05:30:04.442427
    370897 | deleted | t       | 2008-07-29 10:19:33.062378
    372069 | deleted | t       | 2008-07-30 18:05:04.986621
    370110 | deleted | t       | 2008-07-28 15:09:39.228886
    370688 | deleted | t       | 2008-07-29 06:11:28.604441
    373447 | deleted | t       | 2008-08-01 05:05:58.357746
    369532 | deleted | t       | 2008-07-27 20:45:31.57147
    369559 | deleted | t       | 2008-07-27 21:39:53.977426
    370594 | deleted | t       | 2008-07-29 04:01:28.234376
    370620 | deleted | t       | 2008-07-29 04:21:46.787888
    372204 | deleted | t       | 2008-07-30 20:44:10.516881
    374976 | deleted | t       | 2008-08-03 22:45:44.947758
    373287 | deleted | t       | 2008-07-31 21:50:42.115705
    373492 | deleted | t       | 2008-08-01 06:37:21.672381
    373493 | deleted | t       | 2008-08-01 06:38:27.594637
    373815 | deleted | t       | 2008-08-01 13:54:09.992037
    373863 | deleted | t       | 2008-08-01 14:35:21.393781
    373871 | deleted | t       | 2008-08-01 14:38:05.320172
    376524 | deleted | t       | 2008-08-05 10:24:24.92825
    378363 | deleted | t       | 2008-08-07 06:04:32.627529
    376368 | deleted | t       | 2008-08-05 08:19:11.021224
    377085 | deleted | t       | 2008-08-06 02:35:36.782908
    375641 | deleted | t       | 2008-08-04 14:43:14.055052
    376519 | deleted | t       | 2008-08-05 10:19:34.739762
    377221 | deleted | t       | 2008-08-06 04:38:47.464903
    356455 | deleted | t       | 2008-07-10 12:53:24.041218
    378403 | deleted | t       | 2008-08-07 07:07:04.372248
    378411 | deleted | t       | 2008-08-07 07:44:45.777425
    342313 | deleted | t       | 2008-06-21 09:56:32.162771
    313147 | deleted | t       | 2008-05-16 06:47:20.744945
    317776 | deleted | t       | 2008-05-20 07:15:03.605953
    350554 | deleted | t       | 2008-07-02 16:21:06.486634
    312771 | deleted | t       | 2008-05-16 05:53:27.120469
    312987 | deleted | t       | 2008-05-16 06:18:22.756342
    317617 | deleted | t       | 2008-05-20 06:37:00.281824
    332505 | deleted | t       | 2008-06-09 11:12:10.363739
    332772 | deleted | t       | 2008-06-09 18:15:29.587576
    333098 | deleted | t       | 2008-06-10 10:35:33.072824
    333099 | deleted | t       | 2008-06-10 10:35:33.946108
    330904 | deleted | t       | 2008-06-06 09:40:25.355471
    333268 | deleted | t       | 2008-06-10 15:43:44.094702
    333398 | deleted | t       | 2008-06-10 20:43:43.645641
    330401 | deleted | t       | 2008-06-05 20:07:46.10471
    333903 | deleted | t       | 2008-06-11 12:55:29.293483
    333915 | deleted | t       | 2008-06-11 13:15:49.281504
    334044 | deleted | t       | 2008-06-11 15:31:51.413246
    334067 | deleted | t       | 2008-06-11 15:50:42.251329
    334078 | deleted | t       | 2008-06-11 16:06:43.123294
    334117 | deleted | t       | 2008-06-11 17:06:55.820955
    334171 | deleted | t       | 2008-06-11 18:31:01.247422
    334679 | deleted | t       | 2008-06-12 11:23:25.7914
    334681 | deleted | t       | 2008-06-12 11:24:38.63916
    334726 | deleted | t       | 2008-06-12 11:46:21.641583
    335048 | deleted | t       | 2008-06-12 19:48:08.064682
    335101 | deleted | t       | 2008-06-12 20:38:06.652956
    335103 | deleted | t       | 2008-06-12 20:38:52.386005
    335108 | deleted | t       | 2008-06-12 20:41:59.0901
    335110 | deleted | t       | 2008-06-12 20:43:40.381731
    335620 | deleted | t       | 2008-06-13 12:09:54.053235
    335931 | deleted | t       | 2008-06-13 15:10:58.389579
    336161 | deleted | t       | 2008-06-13 18:12:12.968391
    336803 | deleted | t       | 2008-06-14 17:51:32.397381
    336882 | deleted | t       | 2008-06-14 21:12:33.815403
    337101 | deleted | t       | 2008-06-15 08:55:32.319181
    337166 | deleted | t       | 2008-06-15 11:14:35.202493
    337181 | deleted | t       | 2008-06-15 11:24:43.359769
    338025 | deleted | t       | 2008-06-16 10:41:37.115152
    338859 | deleted | t       | 2008-06-17 08:15:18.448535
    339243 | deleted | t       | 2008-06-17 17:40:38.784638
    339327 | deleted | t       | 2008-06-17 19:53:34.668785
    339376 | deleted | t       | 2008-06-17 22:20:03.456802
    339474 | deleted | t       | 2008-06-18 03:41:15.486269
    339603 | deleted | t       | 2008-06-18 08:51:27.055016
    339752 | deleted | t       | 2008-06-18 11:30:19.940574
    339745 | deleted | t       | 2008-06-18 11:27:30.870434
    339748 | deleted | t       | 2008-06-18 11:29:38.407524
    339753 | deleted | t       | 2008-06-18 11:31:12.732131
    339754 | deleted | t       | 2008-06-18 11:32:05.764995
    339755 | deleted | t       | 2008-06-18 11:32:10.004596
    339761 | deleted | t       | 2008-06-18 11:39:21.809464
    339926 | deleted | t       | 2008-06-18 15:37:09.957158
    339940 | deleted | t       | 2008-06-18 15:59:19.530729
    340004 | deleted | t       | 2008-06-18 16:59:44.10844
    340251 | deleted | t       | 2008-06-18 22:46:22.865677
    340500 | deleted | t       | 2008-06-19 07:45:36.107802
    340677 | deleted | t       | 2008-06-19 10:18:41.430953
    341600 | deleted | t       | 2008-06-20 09:38:37.087437
    341601 | deleted | t       | 2008-06-20 09:38:55.474799
    341022 | deleted | t       | 2008-06-19 17:30:17.501808
    341140 | deleted | t       | 2008-06-19 20:29:53.964107
    341145 | deleted | t       | 2008-06-19 20:30:17.134096
    341226 | deleted | t       | 2008-06-19 22:18:14.25243
    343061 | deleted | t       | 2008-06-22 23:09:13.635118
    343237 | deleted | t       | 2008-06-23 05:46:06.145046
    343537 | deleted | t       | 2008-06-23 17:34:59.48471
    343833 | deleted | t       | 2008-06-24 02:30:26.445576
    343910 | deleted | t       | 2008-06-24 05:44:00.477274
    343913 | deleted | t       | 2008-06-24 05:45:04.086528
    343916 | deleted | t       | 2008-06-24 05:52:25.57657
    343923 | deleted | t       | 2008-06-24 06:07:31.988991
    343938 | deleted | t       | 2008-06-24 06:37:51.846124
    343952 | deleted | t       | 2008-06-24 07:00:05.056072
    343959 | deleted | t       | 2008-06-24 07:07:30.814815
    343964 | deleted | t       | 2008-06-24 07:15:06.083395
    343970 | deleted | t       | 2008-06-24 07:25:47.52218
    343976 | deleted | t       | 2008-06-24 07:30:05.794702
    343979 | deleted | t       | 2008-06-24 07:37:31.808385
    343980 | deleted | t       | 2008-06-24 07:39:01.484901
    344028 | deleted | t       | 2008-06-24 08:37:37.623331
    344037 | deleted | t       | 2008-06-24 08:53:22.917821
    344044 | deleted | t       | 2008-06-24 09:07:37.820926
    344047 | deleted | t       | 2008-06-24 09:15:06.942873
    344053 | deleted | t       | 2008-06-24 09:22:34.331188
    344057 | deleted | t       | 2008-06-24 09:30:07.839951
    344060 | deleted | t       | 2008-06-24 09:37:36.346033
    344063 | deleted | t       | 2008-06-24 09:45:06.956554
    344082 | deleted | t       | 2008-06-24 10:15:07.284685
    344087 | deleted | t       | 2008-06-24 10:22:35.291202
    344092 | deleted | t       | 2008-06-24 10:30:07.70916
    344098 | deleted | t       | 2008-06-24 10:45:08.958124
    344102 | deleted | t       | 2008-06-24 10:52:08.287164
    344106 | deleted | t       | 2008-06-24 10:52:40.592997
    344109 | deleted | t       | 2008-06-24 10:54:11.425353
    344122 | deleted | t       | 2008-06-24 11:15:11.037208
    344129 | deleted | t       | 2008-06-24 11:30:09.085532
    344132 | deleted | t       | 2008-06-24 11:37:38.073078
    335674 | deleted | t       | 2008-06-13 12:54:31.880276
    340503 | deleted | t       | 2008-06-19 07:46:31.873957
    340504 | deleted | t       | 2008-06-19 07:46:52.965579
    343954 | deleted | t       | 2008-06-24 07:03:41.742574
    344077 | deleted | t       | 2008-06-24 10:09:15.7792
    344436 | deleted | t       | 2008-06-24 16:32:13.588806
    344459 | deleted | t       | 2008-06-24 17:04:42.10099
    344460 | deleted | t       | 2008-06-24 17:05:17.738124
    344465 | deleted | t       | 2008-06-24 17:14:36.977733
    344720 | deleted | t       | 2008-06-24 21:49:19.774761
    344814 | deleted | t       | 2008-06-25 00:08:20.050685
    345805 | deleted | t       | 2008-06-26 06:26:58.051921
    343737 | deleted | t       | 2008-06-23 22:50:28.082048
    345185 | deleted | t       | 2008-06-25 14:19:14.850989
    345610 | deleted | t       | 2008-06-25 23:09:53.138806
    345781 | deleted | t       | 2008-06-26 05:52:12.043875
    345782 | deleted | t       | 2008-06-26 05:52:25.386244
    345783 | deleted | t       | 2008-06-26 05:52:44.262464
    345799 | deleted | t       | 2008-06-26 06:17:15.715865
    345957 | deleted | t       | 2008-06-26 10:48:22.340244
    345358 | deleted | t       | 2008-06-25 18:21:46.5977
    346054 | deleted | t       | 2008-06-26 12:50:24.774456
    346241 | deleted | t       | 2008-06-26 15:37:15.903971
    346302 | deleted | t       | 2008-06-26 16:23:01.14548
    346313 | deleted | t       | 2008-06-26 16:29:48.840221
    346505 | deleted | t       | 2008-06-26 23:21:16.41612
    347070 | deleted | t       | 2008-06-27 20:32:29.059395
    347509 | deleted | t       | 2008-06-28 20:02:42.439875
    347803 | deleted | t       | 2008-06-29 12:15:04.769846
    347836 | deleted | t       | 2008-06-29 13:44:04.14985
    348250 | deleted | t       | 2008-06-30 08:57:00.646986
    348355 | deleted | t       | 2008-06-30 11:58:03.434663
    348517 | deleted | t       | 2008-06-30 16:21:45.75809
    348934 | deleted | t       | 2008-06-30 23:38:32.352186
    349122 | deleted | t       | 2008-07-01 08:03:02.11081
    348834 | deleted | t       | 2008-06-30 21:28:00.979738
    348840 | deleted | t       | 2008-06-30 21:34:01.655533
    348925 | deleted | t       | 2008-06-30 23:30:13.028143
    348929 | deleted | t       | 2008-06-30 23:33:40.866937
    348997 | deleted | t       | 2008-07-01 03:22:03.711176
    349488 | deleted | t       | 2008-07-01 13:58:09.668573
    349621 | deleted | t       | 2008-07-01 17:20:52.231034
    349807 | deleted | t       | 2008-07-01 21:39:19.445488
    350706 | deleted | t       | 2008-07-02 17:43:10.257954
    350739 | deleted | t       | 2008-07-02 17:58:28.869226
    351270 | deleted | t       | 2008-07-03 09:38:39.597488
    351281 | deleted | t       | 2008-07-03 09:48:48.456047
    351394 | deleted | t       | 2008-07-03 12:35:50.766219
    351748 | deleted | t       | 2008-07-03 17:40:30.14106
    351956 | deleted | t       | 2008-07-03 23:44:59.476727
    351995 | deleted | t       | 2008-07-04 01:20:54.734775
    352251 | deleted | t       | 2008-07-04 10:34:41.362999
    352560 | deleted | t       | 2008-07-04 17:37:00.980787
    328600 | deleted | t       | 2008-06-03 11:47:06.648219
    353686 | deleted | t       | 2008-07-07 04:09:55.786816
    353783 | deleted | t       | 2008-07-07 08:36:09.956687
    353830 | deleted | t       | 2008-07-07 09:40:37.686762
    353835 | deleted | t       | 2008-07-07 09:45:56.636289
    353842 | deleted | t       | 2008-07-07 09:47:36.769609
    319429 | deleted | t       | 2008-05-21 11:26:07.791814
    354644 | deleted | t       | 2008-07-08 11:43:08.043384
    354666 | deleted | t       | 2008-07-08 12:13:35.17747
    354691 | deleted | t       | 2008-07-08 12:43:56.214817
    354961 | deleted | t       | 2008-07-08 17:37:52.378768
    354962 | deleted | t       | 2008-07-08 17:38:23.236831
    355156 | deleted | t       | 2008-07-08 20:18:13.546102
    355976 | deleted | t       | 2008-07-09 21:06:04.960907
    355621 | deleted | t       | 2008-07-09 12:17:49.767682
    355726 | deleted | t       | 2008-07-09 14:44:03.72548
    355727 | deleted | t       | 2008-07-09 14:44:56.430606
    355783 | deleted | t       | 2008-07-09 16:21:25.09419
    355849 | deleted | t       | 2008-07-09 18:18:37.884915
    355860 | deleted | t       | 2008-07-09 18:43:00.080445
    355907 | deleted | t       | 2008-07-09 19:43:26.483755
    355961 | deleted | t       | 2008-07-09 20:46:59.395274
    356170 | deleted | t       | 2008-07-10 04:14:34.21796
    356344 | deleted | t       | 2008-07-10 10:13:35.928384
    355932 | deleted | t       | 2008-07-09 20:11:07.347129
    356387 | deleted | t       | 2008-07-10 11:31:49.254144
    356559 | deleted | t       | 2008-07-10 14:25:28.704065
    356598 | deleted | t       | 2008-07-10 14:57:08.936019
    356614 | deleted | t       | 2008-07-10 15:14:49.499798
    356671 | deleted | t       | 2008-07-10 16:00:25.940007
    356697 | deleted | t       | 2008-07-10 16:44:15.761792
    356724 | deleted | t       | 2008-07-10 17:10:32.774072
    356891 | deleted | t       | 2008-07-10 19:32:03.627943
    356923 | deleted | t       | 2008-07-10 20:06:40.606074
    356945 | deleted | t       | 2008-07-10 21:06:07.968697
    356971 | deleted | t       | 2008-07-10 22:04:55.530245
    357148 | deleted | t       | 2008-07-11 05:15:04.911305
    357151 | deleted | t       | 2008-07-11 05:22:26.542929
    357154 | deleted | t       | 2008-07-11 05:30:05.136907
    357487 | deleted | t       | 2008-07-11 15:03:22.450946
    357602 | deleted | t       | 2008-07-11 18:00:11.653408
    357656 | deleted | t       | 2008-07-11 18:44:13.456752
    358558 | deleted | t       | 2008-07-13 15:31:46.509886
    358559 | deleted | t       | 2008-07-13 15:31:55.390729
    358929 | deleted | t       | 2008-07-14 09:27:56.944706
    358942 | deleted | t       | 2008-07-14 09:59:56.812926
    358529 | deleted | t       | 2008-07-13 14:38:42.357233
    359434 | deleted | t       | 2008-07-14 19:01:45.352729
    359490 | deleted | t       | 2008-07-14 20:44:12.394544
    359776 | deleted | t       | 2008-07-15 07:07:34.877029
    359852 | deleted | t       | 2008-07-15 08:22:07.527375
    359925 | deleted | t       | 2008-07-15 09:48:19.375669
    360057 | deleted | t       | 2008-07-15 13:13:42.588587
    360064 | deleted | t       | 2008-07-15 13:23:25.138715
    360283 | deleted | t       | 2008-07-15 19:04:48.355307
    360582 | deleted | t       | 2008-07-16 05:02:55.22933
    344048 | deleted | t       | 2008-06-24 09:20:46.034916
    344049 | deleted | t       | 2008-06-24 09:21:39.043328
    344050 | deleted | t       | 2008-06-24 09:21:54.295314
    347161 | deleted | t       | 2008-06-27 23:10:49.278334
    347162 | deleted | t       | 2008-06-27 23:11:10.655795
    348885 | deleted | t       | 2008-06-30 22:36:54.642455
    350794 | deleted | t       | 2008-07-02 18:15:05.358599
    361217 | deleted | t       | 2008-07-16 19:27:25.330498
    361218 | deleted | t       | 2008-07-16 19:27:32.735446
    361293 | deleted | t       | 2008-07-16 20:55:14.314854
    361295 | deleted | t       | 2008-07-16 20:55:52.575456
    361789 | deleted | t       | 2008-07-17 11:17:02.281842
    361966 | deleted | t       | 2008-07-17 16:37:25.569724
    361988 | deleted | t       | 2008-07-17 17:15:45.894468
    362083 | deleted | t       | 2008-07-17 19:10:42.946469
    362152 | deleted | t       | 2008-07-17 20:56:27.080213
    362155 | deleted | t       | 2008-07-17 20:58:14.842725
    362161 | deleted | t       | 2008-07-17 21:01:50.474129
    362162 | deleted | t       | 2008-07-17 21:02:28.550743
    362271 | deleted | t       | 2008-07-17 23:12:10.950144
    362349 | deleted | t       | 2008-07-18 00:29:32.583521
    362457 | deleted | t       | 2008-07-18 03:05:33.050107
    362834 | deleted | t       | 2008-07-18 15:02:24.070755
    362876 | deleted | t       | 2008-07-18 16:03:24.940299
    363009 | deleted | t       | 2008-07-18 19:33:31.748039
    363023 | deleted | t       | 2008-07-18 19:47:20.644981
    363897 | deleted | t       | 2008-07-20 19:58:31.61996
    363920 | deleted | t       | 2008-07-20 20:31:05.899916
    362888 | deleted | t       | 2008-07-18 16:15:30.026215
    364705 | deleted | t       | 2008-07-21 16:41:24.756821
    364785 | deleted | t       | 2008-07-21 19:16:09.547074
    364786 | deleted | t       | 2008-07-21 19:16:29.885563
    365234 | deleted | t       | 2008-07-22 03:55:39.201793
    365235 | deleted | t       | 2008-07-22 03:56:47.924664
    365254 | deleted | t       | 2008-07-22 04:27:13.069061
    365258 | deleted | t       | 2008-07-22 04:32:49.88445
    365262 | deleted | t       | 2008-07-22 04:45:02.900137
    365365 | deleted | t       | 2008-07-22 09:11:16.063793
    365368 | deleted | t       | 2008-07-22 09:15:06.010684
    365374 | deleted | t       | 2008-07-22 09:22:29.2021
    365382 | deleted | t       | 2008-07-22 09:37:30.180006
    365394 | deleted | t       | 2008-07-22 10:00:06.65686
    365398 | deleted | t       | 2008-07-22 10:07:30.606707
    365418 | deleted | t       | 2008-07-22 10:45:08.295886
    365427 | deleted | t       | 2008-07-22 11:00:13.350611
    365430 | deleted | t       | 2008-07-22 11:07:44.528625
    365433 | deleted | t       | 2008-07-22 11:15:10.613658
    365437 | deleted | t       | 2008-07-22 11:21:25.42159
    365499 | deleted | t       | 2008-07-22 12:44:10.347272
    365539 | deleted | t       | 2008-07-22 13:18:46.95925
    365541 | deleted | t       | 2008-07-22 13:19:38.519973
    365542 | deleted | t       | 2008-07-22 13:21:03.41348
    365572 | deleted | t       | 2008-07-22 13:47:15.481215
    365573 | deleted | t       | 2008-07-22 13:48:29.506535
    365682 | deleted | t       | 2008-07-22 16:08:19.596703
    365683 | deleted | t       | 2008-07-22 16:08:49.534883
    365684 | deleted | t       | 2008-07-22 16:08:49.641002
    365964 | deleted | t       | 2008-07-22 20:32:03.701545
    366122 | deleted | t       | 2008-07-23 01:31:53.124511
    366369 | deleted | t       | 2008-07-23 10:16:52.087862
    367126 | deleted | t       | 2008-07-24 13:32:59.493604
    368166 | deleted | t       | 2008-07-25 15:40:14.031744
    368573 | deleted | t       | 2008-07-25 22:15:59.119754
    315327 | deleted | t       | 2008-05-18 19:45:05.43736
  41312143 | deleted | t       | 2020-05-30 19:38:35.794593
  41312134 | deleted | t       | 2020-05-30 19:37:36.234086
  41312001 | deleted | t       | 2020-05-30 19:24:52.370647
  41311645 | deleted | t       | 2020-05-30 18:33:59.322143
  52682813 | deleted | t       | 2021-03-08 13:48:08.307142
  52682868 | deleted | t       | 2021-03-08 13:48:29.410037
  52682772 | deleted | t       | 2021-03-08 13:47:41.214434
  52680399 | deleted | t       | 2021-03-08 12:31:08.128169
 102782020 | deleted | t       | 2024-02-08 19:08:51.212974
 102782021 | deleted | t       | 2024-02-08 19:08:51.212976
 102782012 | deleted | t       | 2024-02-08 19:08:51.212956
 102782018 | deleted | t       | 2024-02-08 19:08:51.21297
 102782019 | deleted | t       | 2024-02-08 19:08:51.212972
 102782010 | deleted | t       | 2024-02-08 19:08:51.212948
 102782001 | deleted | t       | 2024-02-08 19:08:51.212914
 102782005 | deleted | t       | 2024-02-08 19:08:51.21293
 102782007 | deleted | t       | 2024-02-08 19:08:51.212937
 102782004 | deleted | t       | 2024-02-08 19:08:51.212927
 102782009 | deleted | t       | 2024-02-08 19:08:51.212945
 102782002 | deleted | t       | 2024-02-08 19:08:51.212921
 102782003 | deleted | t       | 2024-02-08 19:08:51.212925
 102782008 | deleted | t       | 2024-02-08 19:08:51.212941
 102782006 | deleted | t       | 2024-02-08 19:08:51.212933
 102782014 | deleted | t       | 2024-02-08 19:08:51.21296
 102782015 | deleted | t       | 2024-02-08 19:08:51.212963
 102782016 | deleted | t       | 2024-02-08 19:08:51.212966
 102782011 | deleted | t       | 2024-02-08 19:08:51.212952
 102781210 | deleted | t       | 2024-02-08 18:54:25.529913
 102781213 | deleted | t       | 2024-02-08 18:54:25.529919
 102781214 | deleted | t       | 2024-02-08 18:54:25.529921
 102781212 | deleted | t       | 2024-02-08 18:54:25.529917
 102781215 | deleted | t       | 2024-02-08 18:54:25.529923
 102781216 | deleted | t       | 2024-02-08 18:54:25.529925
 102781211 | deleted | t       | 2024-02-08 18:54:25.529915
 102782013 | deleted | t       | 2024-02-08 19:08:51.212958
 102782017 | deleted | t       | 2024-02-08 19:08:51.212968

I wonder if the ones from february have been manually set to that state, do you have any recollection of that @natefoo ?

@mvdbeek
Copy link
Member

mvdbeek commented Mar 7, 2024

Fixed this with UPDATE dataset set state = 'discarded' WHERE dataset.state = 'deleted';, I'll check if we're properly sanitizing valid states on history import, but otherwise it all looks like a manual thing.

@mvdbeek mvdbeek closed this as completed Mar 7, 2024
@mvdbeek mvdbeek added area/database Galaxy's database or data access layer and removed area/backend labels Mar 7, 2024
@martenson
Copy link
Member Author

What do you mean by manual thing? Something other than the app modifying the db?

@mvdbeek
Copy link
Member

mvdbeek commented Mar 7, 2024

yes

@jdavcs
Copy link
Member

jdavcs commented Mar 15, 2024

I think we need to have data migrations (or something of that sort), so that other admins can apply such fixes to their instances. It's separate from db schema migrations. Also, that would document all such fixes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/database Galaxy's database or data access layer release-testing-24.0
Projects
None yet
Development

No branches or pull requests

4 participants