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

Internal Server Error adding additional cover art

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: Cover Art Archive
    • Fix Version/s: Cover Art Archive
    • Component/s: None
    • Labels:
      None

      Description

      I was attempting to upload additional covert art to a release, and got this:

      Caught exception in MusicBrainz::Server::Controller::Release->add_cover_art "The edit could not be created.
      POST: $VAR1 =

      { 'add-cover-art.id' => '500439929', 'add-cover-art.type_id' => '1', 'add-cover-art.position' => '1', 'add-cover-art.comment' => '', 'add-cover-art.edit_note' => '' }

      ;

      Exception:$VAR1 = 'Failed query:
      \'INSERT INTO cover_art_archive.cover_art (release, edit, ordering, id, comment)
      VALUES (?, ?, ?, ?, ?)\'
      (1104997 16086426 1 500439929 )
      DBD::Pg::st execute failed: ERROR: insert or update on table "cover_art" violates foreign key constraint "cover_art_edit_fkey"
      DETAIL: Key (edit)=(16086426) is not present in table "edit". at lib/Sql.pm line 103.

      at lib/Sql.pm line 109
      Sql::_ANON_(\'DBD::Pg::st execute failed: ERROR: insert or update on table...\') called at /home/musicbrainz/perl5/lib/perl5/Try/Tiny.pm line 100
      Try::Tiny::try(\'CODE(0x10bbfdc0)\', \'Try::Tiny::Catch=REF(0x10c32ba8)\') called at lib/Sql.pm line 110
      Sql::do(\'Sql=HASH(0xc6e9878)\', \'INSERT INTO cover_art_archive.cover_art (release, edit, order...\', 1104997, 16086426, 1, 500439929, \'\') called at lib/MusicBrainz/Server/Data/CoverArtArchive.pm line 125
      MusicBrainz::Server::Data::CoverArtArchive::insert_cover_art(\'MusicBrainz::Server::Data::CoverArtArchive=HASH(0xa4c2738)\', 1104997, 16086426, 500439929, 1, \'ARRAY(0xde0fa18)\', \'\') called at lib/MusicBrainz/Server/Edit/Release/AddCoverArt.pm line 75
      MusicBrainz::Server::Edit::Release::AddCoverArt::insert(\'MusicBrainz::Server::Edit::Release::AddCoverArt=HASH(0x10c5b148)\') called at lib/MusicBrainz/Server/Data/Edit.pm line 395
      MusicBrainz::Server::Data::Edit::_ANON_() called at lib/Sql.pm line 264
      Sql::_ANON_() called at /home/musicbrainz/perl5/lib/perl5/Try/Tiny.pm line 76
      eval

      {...} called at /home/musicbrainz/perl5/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0x10c32db8)\', \'Try::Tiny::Catch=REF(0x10b70320)\') called at lib/Sql.pm line 277
      Sql::_auto_transaction(\'CODE(0x10c5b160)\', \'Sql=HASH(0xc6e9878)\') called at lib/Sql.pm line 282
      Sql::_run_in_transaction_one(\'CODE(0x10c5b160)\', \'Sql=HASH(0xc6e9878)\') called at lib/Sql.pm line 296
      Sql::run_in_transaction(\'CODE(0x10c5b160)\', \'Sql=HASH(0xc6e9878)\') called at lib/MusicBrainz/Server/Data/Edit.pm line 431
      MusicBrainz::Server::Data::Edit::create(\'MusicBrainz::Server::Data::Edit=HASH(0xa75ac48)\', \'editor_id\', 360197, \'privileges\', 0, \'cover_art_types\', \'ARRAY(0xde0fa18)\', \'cover_art_id\', 500439929, ...) called at lib/MusicBrainz/Server/Controller.pm line 85
      MusicBrainz::Server::Controller::_ANON_() called at /home/musicbrainz/perl5/lib/perl5/Try/Tiny.pm line 76
      eval {...}

      called at /home/musicbrainz/perl5/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0x10c515a0)\', \'Try::Tiny::Catch=REF(0x10bae180)\') called at lib/MusicBrainz/Server/Controller.pm line 101
      MusicBrainz::Server::Controller::_insert_edit(\'MusicBrainz::Server::Controller::Release=HASH(0xbcbc7c8)\', \'MusicBrainz::Server=HASH(0xe1236e0)\', \'MusicBrainz::Server::Form::Release::AddCoverArt=HASH(0xe949390)\', \'edit_type\', 314, \'release\', \'MusicBrainz::Server::Entity::Release=HASH(0xe8fce58)\', \'cover_art_types\', \'ARRAY(0xde0fa18)\', ...) called at lib/MusicBrainz/Server/Controller/Release.pm line 443
      MusicBrainz::Server::Controller::Release::add_cover_art(\'MusicBrainz::Server::Controller::Release=HASH(0xbcbc7c8)\', \'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xc0622d8)\', \'MusicBrainz::Server::Controller::Release=HASH(0xbcbc7c8)\', \'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst.pm line 1667
      eval

      {...} called at /home/musicbrainz/perl5/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xe1236e0)\', \'MusicBrainz::Server::Controller::Release\', \'Catalyst::Action=HASH(0xc0622d8)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xe1236e0)\', \'MusicBrainz::Server::Controller::Release\', \'Catalyst::Action=HASH(0xc0622d8)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xc0622d8)\', \'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/ActionChain.pm line 38
      Catalyst::ActionChain::dispatch(\'Catalyst::ActionChain=HASH(0xddf6948)\', \'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Controller.pm line 125
      Catalyst::Controller::_ACTION(\'MusicBrainz::Server::Controller::Release=HASH(0xbcbc7c8)\', \'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xc05e4d0)\', \'MusicBrainz::Server::Controller::Release=HASH(0xbcbc7c8)\', \'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst.pm line 1667
      eval {...}

      called at /home/musicbrainz/perl5/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xe1236e0)\', \'MusicBrainz::Server::Controller::Release\', \'Catalyst::Action=HASH(0xc05e4d0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xe1236e0)\', \'MusicBrainz::Server::Controller::Release\', \'Catalyst::Action=HASH(0xc05e4d0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xc05e4d0)\', \'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(\'Catalyst::Dispatcher=HASH(0x3d5e3c0)\', \'forward\', \'MusicBrainz::Server=HASH(0xe1236e0)\', \'_ACTION\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(\'Catalyst::Dispatcher=HASH(0x3d5e3c0)\', \'MusicBrainz::Server=HASH(0xe1236e0)\', \'_ACTION\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst.pm line 342
      Catalyst::forward(\'MusicBrainz::Server=HASH(0xe1236e0)\', \'_ACTION\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Controller.pm line 99
      Catalyst::Controller::_DISPATCH(\'MusicBrainz::Server::Controller::Release=HASH(0xbcbc7c8)\', \'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xc05ddf8)\', \'MusicBrainz::Server::Controller::Release=HASH(0xbcbc7c8)\', \'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst.pm line 1667
      eval

      {...} called at /home/musicbrainz/perl5/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xe1236e0)\', \'MusicBrainz::Server::Controller::Release\', \'Catalyst::Action=HASH(0xc05ddf8)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xe1236e0)\', \'MusicBrainz::Server::Controller::Release\', \'Catalyst::Action=HASH(0xc05ddf8)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xc05ddf8)\', \'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(\'Catalyst::Dispatcher=HASH(0x3d5e3c0)\', \'forward\', \'MusicBrainz::Server=HASH(0xe1236e0)\', \'/release/_DISPATCH\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(\'Catalyst::Dispatcher=HASH(0x3d5e3c0)\', \'MusicBrainz::Server=HASH(0xe1236e0)\', \'/release/_DISPATCH\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst.pm line 342
      Catalyst::forward(\'MusicBrainz::Server=HASH(0xe1236e0)\', \'/release/_DISPATCH\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch(\'Catalyst::Dispatcher=HASH(0x3d5e3c0)\', \'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst.pm line 1613
      Catalyst::dispatch(\'MusicBrainz::Server=HASH(0xe1236e0)\') called at lib/MusicBrainz/Server.pm line 264
      Class::MOP::Class:::around(\'CODE(0x39320c8)\', \'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch(\'MusicBrainz::Server=HASH(0xe1236e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst.pm line 1963
      Catalyst::_ANON_() called at /home/musicbrainz/perl5/lib/perl5/Try/Tiny.pm line 76
      eval {...}

      called at /home/musicbrainz/perl5/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0xdc51d68)\', \'Try::Tiny::Catch=REF(0xe93feb8)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst.pm line 1969
      Catalyst::handle_request(\'MusicBrainz::Server\', \'env\', \'HASH(0xdd868e0)\') called at /home/musicbrainz/perl5/lib/perl5/Catalyst/Engine.pm line 856
      Catalyst::Engine::_ANON_(\'CODE(0xc281330)\') called at /home/musicbrainz/perl5/lib/perl5/Plack/Handler/FCGI.pm line 134
      Plack::Handler::FCGI::run(\'Plack::Handler::FCGI=HASH(0x1d89928)\', \'CODE(0xc211468)\') called at /home/musicbrainz/perl5/lib/perl5/Plack/Loader.pm line 88
      Plack::Loader::run(\'Plack::Loader=HASH(0x1d5ee28)\', \'Plack::Handler::FCGI=HASH(0x1d89928)\') called at /home/musicbrainz/perl5/lib/perl5/Plack/Runner.pm line 263
      Plack::Runner::run(\'Plack::Runner=HASH(0x1b54a78)\') called at /home/musicbrainz/perl5/bin/plackup line 10
      at lib/Sql.pm line 277
      ';
      at lib/MusicBrainz/Server/Controller.pm line 101"

      Stack trace:

      line 97 MusicBrainz::Server::Controller
      line 101 MusicBrainz::Server::Controller
      line 443 MusicBrainz::Server::Controller::Release
      line 264 MusicBrainz::Server

      Request data:

      $VAR1 = {
      'query_parameters' => {},
      'body_parameters' =>

      { 'add-cover-art.id' => '500439929', 'add-cover-art.type_id' => '1', 'add-cover-art.edit_note' => '', 'add-cover-art.comment' => '', 'add-cover-art.position' => '1' }

      };

      URL: http://test.musicbrainz.org/release/e0b1477d-e5fd-4cb2-a830-ddb3b0365f20/add-cover-art

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              acid2 Oliver Charles
              Reporter:
              monxton monxton
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package
                  Cover Art Archive