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

Import scripts fail with newest DBD::Pg

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2015-02-09
    • Component/s: Database setup
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

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

              Dates

              • Due:
                Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2015-02-09