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

Internal server error applying problematic add ISRC edits

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2015-01-12
    • Component/s: Edit system
    • Labels:
      None

      Description

      https://beta.musicbrainz.org/edit/30069175 is a duplicate of https://beta.musicbrainz.org/edit/30069145 and ModBot is unable to apply the latter because it's a duplicate ISRC.
      The edit should either be slightly accepted and ignored, since the ISRC has been added, even if it's not by this edit, or it should fail for being a duplicate.

      Trying to approve the edit gives:

      Fehler:

      Caught exception in MusicBrainz::Server::Controller::Edit->approve "Failed query:
      'INSERT INTO isrc (recording, isrc, source) VALUES (?, ?, ?)'
      (17057617 USHM91418108 )
      DBD::Pg::st execute failed: ERROR: duplicate key value violates unique constraint "isrc_idx_isrc_recording"
      DETAIL: Key (isrc, recording)=(USHM91418108, 17057617) already exists. at lib/Sql.pm line 107, line 3.

      at lib/Sql.pm line 113, line 3.
      Sql::_ANON_("DBD::Pg::st execute failed: ERROR: duplicate key value viola"...) called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100
      Try::Tiny::try(CODE(0x148ba590), Try::Tiny::Catch=REF(0x14884750)) called at lib/Sql.pm line 114
      Sql::do(Sql=HASH(0x102f6988), "INSERT INTO isrc (recording, isrc, source) VALUES (?, ?, ?)", 17057617, "USHM91418108", undef) called at lib/MusicBrainz/Server/Data/ISRC.pm line 131
      MusicBrainz::Server::Data::ISRC::insert(MusicBrainz::Server::Data::ISRC=HASH(0xce846b0), HASH(0x1487cc50)) called at lib/MusicBrainz/Server/Edit/Recording/AddISRCs.pm line 100
      MusicBrainz::Server::Edit::Recording::AddISRCs::accept(MusicBrainz::Server::Edit::Recording::AddISRCs=HASH(0xe900818)) called at lib/MusicBrainz/Server/Data/Edit.pm line 669
      MusicBrainz::Server::Data::Edit::_ANON_() called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 71
      eval

      Unknown macro: {...}

      called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
      Try::Tiny::try(CODE(0xed158b8), Try::Tiny::Catch=REF(0x148b7430)) called at lib/MusicBrainz/Server/Data/Edit.pm line 704
      MusicBrainz::Server::Data::Edit::_do_accept(MusicBrainz::Server::Data::Edit=HASH(0xc560c08), MusicBrainz::Server::Edit::Recording::AddISRCs=HASH(0xe900818)) called at lib/MusicBrainz/Server/Data/Edit.pm line 743
      MusicBrainz::Server::Data::Edit::_ANON_(MusicBrainz::Server::Edit::Recording::AddISRCs=HASH(0xe900818)) called at lib/MusicBrainz/Server/Data/Edit.pm line 766
      MusicBrainz::Server::Data::Edit::_close(MusicBrainz::Server::Data::Edit=HASH(0xc560c08), MusicBrainz::Server::Edit::Recording::AddISRCs=HASH(0xe900818), CODE(0x14d8cd00)) called at lib/MusicBrainz/Server/Data/Edit.pm line 743
      MusicBrainz::Server::Data::Edit::accept(MusicBrainz::Server::Data::Edit=HASH(0xc560c08), MusicBrainz::Server::Edit::Recording::AddISRCs=HASH(0xe900818)) called at lib/MusicBrainz/Server/Data/Edit.pm line 661
      MusicBrainz::Server::Data::Edit::approve(MusicBrainz::Server::Data::Edit=HASH(0xc560c08), MusicBrainz::Server::Edit::Recording::AddISRCs=HASH(0xe900818), 53705) called at lib/MusicBrainz/Server/Controller/Edit.pm line 129
      MusicBrainz::Server::Controller::Edit::_ANON_() called at lib/Sql.pm line 316
      Sql::_ANON_() called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 71
      eval

      called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
      Try::Tiny::try(CODE(0x1487dc18), Try::Tiny::Catch=REF(0x148a9180)) called at lib/Sql.pm line 330
      Sql::_auto_transaction(CODE(0xf2ac150), Sql=HASH(0x102f6988)) called at lib/Sql.pm line 335
      Sql::_run_in_transaction_one(CODE(0xf2ac150), Sql=HASH(0x102f6988)) called at lib/Sql.pm line 349
      Sql::run_in_transaction(CODE(0xf2ac150), Sql=HASH(0x102f6988)) called at lib/MusicBrainz/Server/Model/MB.pm line 19
      MusicBrainz::Server::Model::MB::with_transaction(MusicBrainz::Server::Model::MB=HASH(0xbd79570), CODE(0xf2ac150)) called at lib/MusicBrainz/Server/Controller/Edit.pm line 133
      MusicBrainz::Server::Controller::Edit::approve(MusicBrainz::Server::Controller::Edit=HASH(0xbdadc80), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(Catalyst::Action=HASH(0xdcc50d8), MusicBrainz::Server::Controller::Edit=HASH(0xbdadc80), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
      eval

      Unknown macro: {...}

      called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
      Catalyst::execute(MusicBrainz::Server=HASH(0xe3dcc58), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xdcc50d8)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
      Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0xe3dcc58), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xdcc50d8)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0xdcc50d8), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/Catalyst/ActionChain.pm line 41
      Catalyst::ActionChain::dispatch(Catalyst::ActionChain=HASH(0xe3e3350), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/Catalyst/Controller.pm line 158
      Catalyst::Controller::_ACTION(MusicBrainz::Server::Controller::Edit=HASH(0xbdadc80), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(Catalyst::Action=HASH(0xaee4318), MusicBrainz::Server::Controller::Edit=HASH(0xbdadc80), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
      eval

      called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
      Catalyst::execute(MusicBrainz::Server=HASH(0xe3dcc58), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xaee4318)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
      Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0xe3dcc58), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xaee4318)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0xaee4318), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x34f8558), "forward", MusicBrainz::Server=HASH(0xe3dcc58), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x34f8558), MusicBrainz::Server=HASH(0xe3dcc58), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst.pm line 373
      Catalyst::forward(MusicBrainz::Server=HASH(0xe3dcc58), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst/Controller.pm line 132
      Catalyst::Controller::_DISPATCH(MusicBrainz::Server::Controller::Edit=HASH(0xbdadc80), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(Catalyst::Action=HASH(0xdcbd918), MusicBrainz::Server::Controller::Edit=HASH(0xbdadc80), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
      eval

      Unknown macro: {...}

      called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
      Catalyst::execute(MusicBrainz::Server=HASH(0xe3dcc58), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xdcbd918)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
      Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0xe3dcc58), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xdcbd918)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0xdcbd918), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x34f8558), "forward", MusicBrainz::Server=HASH(0xe3dcc58), "/edit/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x34f8558), MusicBrainz::Server=HASH(0xe3dcc58), "/edit/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst.pm line 373
      Catalyst::forward(MusicBrainz::Server=HASH(0xe3dcc58), "/edit/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch(Catalyst::Dispatcher=HASH(0x34f8558), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1633
      Catalyst::dispatch(MusicBrainz::Server=HASH(0xe3dcc58)) called at lib/MusicBrainz/Server.pm line 329
      MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 303
      MusicBrainz::Server::with_translations(MusicBrainz::Server=HASH(0xe3dcc58), CODE(0xf271c98)) called at lib/MusicBrainz/Server.pm line 330
      Class::MOP::Class:::around(CODE(0x293c4a8), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0xe3dcc58)) called at lib/MusicBrainz/Server.pm line 344
      Class::MOP::Class:::around(CODE(0xdfae858), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0xe3dcc58)) called at lib/MusicBrainz/Server.pm line 389
      Class::MOP::Class:::around(CODE(0xbc415e0), MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 35
      Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch(MusicBrainz::Server=HASH(0xe3dcc58)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1992
      Catalyst::_ANON_() called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 76
      eval

      called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
      Try::Tiny::try(CODE(0xe0648f8), Try::Tiny::Catch=REF(0xee1def8)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1998
      Catalyst::handle_request("MusicBrainz::Server", "env", HASH(0xf1fb940), "response_cb", CODE(0xf31aa48)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request("MusicBrainz::Server", "env", HASH(0xf1fb940), "response_cb", CODE(0xf31aa48)) called at /home/beta/perl5/lib/perl5/Catalyst/Engine.pm line 697
      Catalyst::Engine::_ANON_(CODE(0xf31aa48)) called at /home/beta/perl5/lib/perl5/Plack/Handler/FCGI.pm line 136
      Plack::Handler::FCGI::run(Plack::Handler::FCGI=HASH(0x991ab8), CODE(0xdfd3eb8)) called at /home/beta/perl5/lib/perl5/Plack/Loader.pm line 84
      Plack::Loader::run(Plack::Loader=HASH(0x968eb0), Plack::Handler::FCGI=HASH(0x991ab8)) called at /home/beta/perl5/lib/perl5/Plack/Runner.pm line 277
      Plack::Runner::run(Plack::Runner=HASH(0x706600)) called at /home/beta/perl5/bin/plackup line 10
      at lib/Sql.pm line 330."

      Stack-Trace:
      line 19 MusicBrainz::Server::Model::MB
      line 133 MusicBrainz::Server::Controller::Edit
      line 329 MusicBrainz::Server
      line 303 MusicBrainz::Server
      line 330 MusicBrainz::Server
      line 344 MusicBrainz::Server
      line 389 MusicBrainz::Server

      Anfragedaten:
      $VAR1 = {
      'query_parameters' => {},
      'body_parameters' => {}
      };

      Bearbeitungen geladen für die Seite:
      30069175 (rohe Bearbeitungsdaten)

      Zeit: 2014-11-21 17:20:48 UTC

      Host: pino

      Oberflächensprache: de

        Attachments

          Activity

            People

            • Assignee:
              ianmcorvidae Ian McEwen
              Reporter:
              nikki nikki
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2015-01-12