OK so the good news is I have now managed to import the acoustid daily updates required for this report and rebuilt the report, so now the number of potential bad cases has gone up from 78,000 to 117,000.
The bad news is that the daily updates doesn’t seem to be reporting when pairs are disabled properly.
I thought it might just be a very recent issue so I looked at the first Pink Floyd record in the list, and saw you disabled it on 23rd June 2020 - Track "0161da2e-85d6-435a-8978-0c15a8df3df5" | AcoustID
So I downloaded the files for that day and searched for mbid in the file
grep 58ce3b51-da28-4bdd-9279-56eb6c16ac30 2020-06-23-track_mbid-update.jsonl
but no matches
I then looked for any disabled records for that day, and there were some, here are the first two
2020-06-23-track_mbid-update.jsonl:{"id":2263529,"track_id":8895037,"mbid":"a78d43e5-4724-4b57-ac8f-aff521f97d97","submission_count":1,"disabled":true,"created":"2011-08-26T13:46:22.519936+00:00","updated":"2020-06-23T08:57:19.723022+00:00"}
2020-06-23-track_mbid-update.jsonl:{"id":10827664,"track_id":18475023,"mbid":"03e02a24-1d09-45cb-92d4-32a84f36b37d","submission_count":1,"disabled":true,"created":"2014-06-03T11:59:18.380241+00:00","updated":"2020-06-23T13:38:22.6228
So looked up the track to get track gid
jthinksearch=# select * from acoustid_track where id=8895037;
id | created | gid | new_id
---------+-------------------------------+--------------------------------------+--------
8895037 | 2011-08-19 12:45:49.831943+00 | eeb951c4-c47b-4087-a23e-2e9b3ffa19b7 | \N
(1 row)
https://acoustid.org/track/eeb951c4-c47b-4087-a23e-2e9b3ffa19b7
and we can see that although a78d43e5-4724-4b57-ac8f-aff521f97d97 was disabled for this Acoustid it was done on Jan, 09 2015 17:40:54 (by a bot) not 2020-06-23T08:57:19 as the line in the file implies.
So I don’t see how to find out when a pairing has been disabled, is this a bug or misunderstanding on my part, if anyone understands this please let me know.
I also double checked the track I wanted wasn’t mention in the file at all at all, for this I needed to find the internal trackid
jthinksearch=# select * from acoustid_track_mbid where mbid='58ce3b51-da28-4bdd-9279-56eb6c16ac30';
id | track_id | mbid | created | submission_count | disabled
----------+----------+--------------------------------------+-------------------------------+------------------+----------
16459345 | 10158239 | 58ce3b51-da28-4bdd-9279-56eb6c16ac30 | 2018-06-16 15:10:20.894442+00 | 1 | f
1304057 | 10158206 | 58ce3b51-da28-4bdd-9279-56eb6c16ac30 | 2011-08-22 11:24:13.782687+00 | 33 | f
8811442 | 23987646 | 58ce3b51-da28-4bdd-9279-56eb6c16ac30 | 2013-08-20 02:16:34.453068+00 | 1 | f
7700873 | 21655210 | 58ce3b51-da28-4bdd-9279-56eb6c16ac30 | 2012-12-31 15:57:04.133796+00 | 1 | f
(4 rows)
jthinksearch=# select * from acoustid_track where id in (10158239,23987646,21655210);
id | created | gid | new_id
----------+-------------------------------+--------------------------------------+--------
10158239 | 2011-08-22 11:24:13.782687+00 | 0161da2e-85d6-435a-8978-0c15a8df3df5 | \N
21655210 | 2012-12-31 15:57:04.133796+00 | dbbcfc6b-35ee-4cef-90d0-bd587b32a57a | \N
23987646 | 2013-08-20 02:16:34.453068+00 | 102dea03-fe1b-4525-abaa-8f4c5fb44b7c | \N
(3 rows)
grep 10158239 *
returns no results for that day
The only other good news is any links visited for previous report in your browser will still show as visited for this report so you can see what you have already looked at.