In 202050101 and 20251201 Dump Import of Master Artist Failing

[ijabz]

Failing with

Importing data from /home/ubuntu/code/discogs-xml2db/csv-dir/master_artist.csv
Traceback (most recent call last):
  File "postgresql/importcsv.py", line 42, in <module>
    load_csv(os.path.abspath(filename), db)
  File "postgresql/importcsv.py", line 33, in load_csv
    cursor.copy_expert(q, fp)
psycopg2.errors.NotNullViolation: null value in column "artist_id" violates not-null constraint
DETAIL:  Failing row contains (38233, 35849, null, Hecate, null, 1, null, null).
CONTEXT:  COPY master_artist, line 38234: "35849,,Hecate,,1,,"

Problem line in master_artist.csv is
35849,,Hecate,,1,,

[ijabz]

and
`
52196,,Rude Poets,,1,,"

[ijabz]

grep -G "^[0-9]*,," master_artist.csv

shows all the problem lines, not clear why we are now getting these.

[ijabz]

Use grep -G "^[0-9]*,," -v master_artist.csv > master_artist.csv2``

to create a version of file with problem lines removed
`