Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-8126

Import scripts fail with newest DBD::Pg

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2015-02-09
    • None
    • Database setup
    • None

      InitDb.pl produces the an error on Ubuntu Server 14.04 (but also Amazon Linux AMI 2014.09.1).

      The following error is produced after executing the "./admin/InitDb.pl --createdb --import /tmp/dumps/mbdump*.tar.bz2 --echo" command:

      ...
      Wed Jan 7 16:32:30 2015 : load series
      series 0 0% 0Error loading /tmp/MBImport-CIzOVRow/mbdump/series: DBD::Pg::db pg_putcopydata failed: no COPY in progress at /home/ubuntu/musicbrainz-server/admin/MBImport.pl line 289, <LOAD> line 1.
      Wed Jan 7 16:32:30 2015 : load series_alias
      series_alias 0 0% 0Error loading /tmp/MBImport-CIzOVRow/mbdump/series_alias: DBD::Pg::db pg_putcopydata failed: no COPY in progress at /home/ubuntu/musicbrainz-server/admin/MBImport.pl line 289, <LOAD> line 2.
      Wed Jan 7 16:32:30 2015 : load series_alias_type
      series_alias_type 0 0% 0Error loading /tmp/MBImport-CIzOVRow/mbdump/series_alias_type: DBD::Pg::db pg_putcopydata failed: no COPY in progress at /home/ubuntu/musicbrainz-server/admin/MBImport.pl line 289, <LOAD> line 3.
      ...
      Wed Jan 7 16:32:30 2015 : import finished
      Loaded 0 tables (0 rows) in 0 seconds

      Failed to import dataset.
      Wed Jan 7 16:32:30 2015 : InitDb.pl failed

      The log file of postgres shows the following error:

      2015-01-07 16:32:30 UTC ERROR: COPY from stdin failed: COPY terminated by new PQexec
      2015-01-07 16:32:30 UTC CONTEXT: COPY work_type, line 1
      2015-01-07 16:32:30 UTC STATEMENT: COPY work_type FROM stdin

      All steps from the install manual (https://github.com/metabrainz/musicbrainz-server/blob/master/INSTALL.md) have been executed successfully.

      The exact same output is generated on the AWS Linux distro.

            chirlu Ulrich Klauer
            zantvoort Leon van Zantvoort
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                2015-02-09