datatracker
datatracker copied to clipboard
ietf-tools
Submissions should expire
keyword_sprint type_defect | by [email protected]
There are many Submissions that are pending some form of approval indefinitely. From a recent database snapshot:
In: set(Submission.objects.values_list('state__name',flat=True))
Out:
{u"Awaiting Approval from Previous Version Authors'",
u'Awaiting Initial Version Approval',
u'Awaiting Manual Post',
u'Awaiting Submitter Authentication',
u'Cancelled',
u'Posted',
u'Uploaded'}
In: Submission.objects.filter(state__name__startswith='Awaiting').count()
Out: 1697
In: Submission.objects.filter(state__name='Awaiting Manual Post',submission_date__year=2008).count()
Out: 468
It would be better if Submissions timed out at some point, and be moved to some not-awaiting state (see the use scenario at #987).
I suggest 90 days (grooming this similarly to how we groom expiring drafts) and moving the Submissions either to Cancelled, or a new state of TimedOut.
Issue migrated from trac:1514 at 2022-03-04 03:53:56 +0000
@[email protected] commented
In d1306762b59cd4e43691ddbc579d88eb3e83647b: Counter(Submission.objects.values_list('state__name',flat=True))
Outd1306762b59cd4e43691ddbc579d88eb3e83647b:
Counter({u'Awaiting Approval from Previous Version Authors': 37,
u'Awaiting Initial Version Approval': 75,
u'Awaiting Manual Post': 5,
u'Awaiting Submitter Authentication': 137,
u'Cancelled': 27106,
u'Posted': 67646,
u'Uploaded': 1782})
@[email protected] commented
Still an issue, and further:
In 8dc41f5190d9da361fc659a7a9dc8543d48ecc18: Counter(Submission.objects.filter(state__name__contains='wait').values_l ...: ist('submission_date__year',flat=True)) Out8dc41f5190d9da361fc659a7a9dc8543d48ecc18: Counter({2008: 34, 2009: 35, 2010: 31, 2011: 24, 2012: 30, 2013: 24, 2014: 25, 2015: 7, 2016: 13, 2017: 6, 2020: 6, 2018: 6, 2019: 5, 2021: 4})
There is an expire-submissions command in ietf/bin that is not being used. It needs to be vetted and tested, and if appropriate, plugged into bin/daily.
