Skip to content

In 20250101 and 20241201 Dump release company has companies with null id causing import to fail #153

Open
@ijabz

Description

@ijabz

e.g

`release_company, line 13552: "3759,,Infinite Jazz Recordings,14,Copyright (c),"

causes



`Importing data from /home/ubuntu/code/discogs-xml2db/csv-dir/release_company.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 "company_id" violates not-null constraint
DETAIL:  Failing row contains (13551, 3759, null, Infinite Jazz Recordings, 14, Copyright (c), null).
CONTEXT:  COPY release_company, line 13552: "3759,,Infinite Jazz Recordings,14,Copyright (c),"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions