Comments (1)
After checking again on this, it seems that this is just a minor issue. Luckily, there are just 458 tracks which are affected by this problem (as per database snapshot 2023-05-20
). That number was found with the following query:
SELECT track_id, mbid, count(*) FROM track_mbid GROUP BY track_id, mbid HAVING count(*) > 1;
However, for those few tracks which are affected by this, the submission counts (and sometimes also the disabled status) of the linked MusicBrainz recordings are incorrect. This is also true for the main database on acoustid.org itself.
Here is an example of a track with an incorrect disabled status. The 2020-03-04-track_mbid-update.jsonl.gz says that the link from AcoustID track 16460536
to MusicBrainz recording 6f32542e-c6eb-45cc-a317-b4d8399cbbf6
has been disabled on 2020-03-04
:
wget -q -O - https://data.acoustid.org/2020/2020-03/2020-03-04-track_mbid-update.jsonl.gz | gunzip | grep 6f32542e-c6eb-45cc-a317-b4d8399cbbf6
{"id":10901219,"track_id":16460536,"mbid":"6f32542e-c6eb-45cc-a317-b4d8399cbbf6","submission_count":1,"disabled":true,"created":"2014-06-22T22:25:12.650192+00:00","updated":"2020-03-04T23:31:56.633364+00:00"}
However, when looking at https://acoustid.org/track/16460536 we can see that this link is still incorrectly enabled as of right now.
The problem also becomes evident when looking at the output of the following query:
acoustid=# SELECT * FROM track_mbid WHERE track_id = 16460536 AND mbid = '6f32542e-c6eb-45cc-a317-b4d8399cbbf6';
id | track_id | mbid | submission_count | disabled | created | updated
----------+----------+--------------------------------------+------------------+----------+-------------------------------+-------------------------------
8894757 | 16460536 | 6f32542e-c6eb-45cc-a317-b4d8399cbbf6 | 2 | f | 2013-09-07 00:09:01.917261+02 | 2021-07-14 22:30:11.091301+02
10901219 | 16460536 | 6f32542e-c6eb-45cc-a317-b4d8399cbbf6 | 1 | t | 2014-06-23 00:25:12.650192+02 | 2020-03-05 00:31:56.633364+01
(2 rows)
from acoustid-server.
Related Issues (20)
- Unable to submit / receive new AcoustIDs HOT 2
- MBID recording merges are not applied HOT 3
- Lookup returns empty result despite submitted data
- MusicBrainz metadata caching
- Send API tokens in HTTP headers
- Enforce SNI
- Stop supporting fingerprints without metadata HOT 2
- Separate service for fingerprint searches
- Separate service for musicbrainz metadata lookup
- Google OAuth fails with error 401 on acoustid.org HOT 1
- API fingerprint lookup no longer returns MusicBrainz release HOT 1
- Submission stuck in pending state HOT 12
- Specific fingerprint not returning a match when it should HOT 1
- Updates for track_meta link table are missing from https://data.acoustid.org/ HOT 1
- Automatically remove disables acoustid/mbid pairings after certain time HOT 2
- Daily data updates dont seem to inform of the correct mbid-acoustid pairings disabled on the day
- Hide disabled acoustid mbrecording pairings from acoustid webpages
- Not possible to download https://data.acoustid.org/fingerprint.delta.2019-11.csv.gz HOT 1
- Provide anonymised user id for acoustid/mbid pair submissions
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from acoustid-server.