Database inaccuracies when importing into Postgres

MusicBrainz Development
1

I imported the data dumps into Postgres and have made a specific queries to the database and I get incorrect data.

For example:

SELECT * FROM release where release.name = 'Siamese Dream'

Will return 28 results, but will contain an incorrect artist_credit. One artist_credit is correct, ‘11650’ which represents the band “The Smashing Pumpkins” the other ‘933469’ which represents ''Cypress String Quartet".

I’ve noticed similar issue with other queries.

Has anybody else run into this? Am I importing the data correctly? I should add that I tried two different data dumps and had the same result.

Thanks for the help!

1 Like
2

Artist credit “Smashing Pumpkins” - MusicBrainz says otherwise. I’d be surprised if this isn’t being represented correctly in the data dump.

2 Likes
3

Thanks for your response. You are right see that on the website. Here’s what I see querying the artist table.

Screen Shot 2023-01-28 at 6.18.16 PM
Screen Shot 2023-01-28 at 6.18.16 PM2080×122 54.9 KB

Could this be an issue of how I am importing the data?

4

I think you should be using that ID to query the artist_credit table instead. :slight_smile: See https://musicbrainz.org/artist-credit/933469 vs. https://musicbrainz.org/artist/933469.

3 Likes
5

That was it! Totally missed that table! I was working on this issue for longer than I would like to admit.

Thanks for the help!

2 Likes