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

ISE when approving "Edit artist" edit

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Error:

      Caught exception in MusicBrainz::Server::Controller::Edit->approve "Failed query:
      'UPDATE artist SET name = ?, sort_name = ? WHERE id = ?'
      (1348349 1348350 947412)
      DBD::Pg::st execute failed: ERROR: duplicate key value violates unique constraint "artist_idx_uniq_name_comment"
      DETAIL: Key (name, comment)=(1348349, ) already exists. at lib/Sql.pm line 107.

      at lib/Sql.pm line 113.
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: duplicate key value viola...') called at local/lib/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0xfa3cf20)', 'Try::Tiny::Catch=REF(0xfa387c0)') called at lib/Sql.pm line 114
      Sql::do('Sql=HASH(0xca92370)', 'UPDATE artist SET name = ?, sort_name = ? WHERE id = ?', 1348349, 1348350, 947412) called at lib/Sql.pm line 171
      Sql::update_row('Sql=HASH(0xca92370)', 'artist', 'HASH(0x49f7428)', 'HASH(0xfa38e80)') called at lib/MusicBrainz/Server/Data/Artist.pm line 225
      MusicBrainz::Server::Data::Artist::update('MusicBrainz::Server::Data::Artist=HASH(0xa0840a0)', 947412, 'HASH(0xfa3c830)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 56
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server::Data::Artist=HASH(0xa0840a0)', 947412, 'HASH(0xfa3c830)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::Data::Artist::update('MusicBrainz::Server::Data::Artist=HASH(0xa0840a0)', 947412, 'HASH(0xfa3c830)') called at lib/MusicBrainz/Server/Edit/Generic/Edit.pm line 69
      MusicBrainz::Server::Edit::Generic::Edit::_ANON_('MusicBrainz::Server::Edit::Artist::Edit=HASH(0xfa384c0)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Moose/Meta/Method/Overridden.pm line 38
      MusicBrainz::Server::Edit::Generic::Edit::accept('MusicBrainz::Server::Edit::Artist::Edit=HASH(0xfa384c0)') called at lib/MusicBrainz/Server/Data/Edit.pm line 519
      MusicBrainz::Server::Data::Edit::_ANON_() called at local/lib/perl5/Try/Tiny.pm line 71
      eval

      Unknown macro: {...}

      called at local/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0xfa38bc8)', 'Try::Tiny::Catch=REF(0xcac4bb8)') called at lib/MusicBrainz/Server/Data/Edit.pm line 545
      MusicBrainz::Server::Data::Edit::_do_accept('MusicBrainz::Server::Data::Edit=HASH(0xa817890)', 'MusicBrainz::Server::Edit::Artist::Edit=HASH(0xfa384c0)') called at lib/MusicBrainz/Server/Data/Edit.pm line 584
      MusicBrainz::Server::Data::Edit::_ANON_('MusicBrainz::Server::Edit::Artist::Edit=HASH(0xfa384c0)') called at lib/MusicBrainz/Server/Data/Edit.pm line 607
      MusicBrainz::Server::Data::Edit::_close('MusicBrainz::Server::Data::Edit=HASH(0xa817890)', 'MusicBrainz::Server::Edit::Artist::Edit=HASH(0xfa384c0)', 'CODE(0xfa303b8)') called at lib/MusicBrainz/Server/Data/Edit.pm line 584
      MusicBrainz::Server::Data::Edit::accept('MusicBrainz::Server::Data::Edit=HASH(0xa817890)', 'MusicBrainz::Server::Edit::Artist::Edit=HASH(0xfa384c0)') called at lib/MusicBrainz/Server/Data/Edit.pm line 510
      MusicBrainz::Server::Data::Edit::_ANON_() called at lib/Sql.pm line 281
      Sql::_ANON_() called at local/lib/perl5/Try/Tiny.pm line 76
      eval

      called at local/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0xcfff120)', 'Try::Tiny::Catch=REF(0xfa30028)') called at lib/Sql.pm line 294
      Sql::_auto_transaction('CODE(0xcfe50e0)', 'Sql=HASH(0xca92370)') called at lib/Sql.pm line 299
      Sql::_run_in_transaction_one('CODE(0xcfe50e0)', 'Sql=HASH(0xca92370)') called at lib/Sql.pm line 313
      Sql::run_in_transaction('CODE(0xcfe50e0)', 'Sql=HASH(0xca92370)') called at lib/MusicBrainz/Server/Data/Edit.pm line 511
      MusicBrainz::Server::Data::Edit::approve('MusicBrainz::Server::Data::Edit=HASH(0xa817890)', 'MusicBrainz::Server::Edit::Artist::Edit=HASH(0xfa2ff08)', 388788) called at lib/MusicBrainz/Server/Controller/Edit.pm line 112
      MusicBrainz::Server::Controller::Edit::approve('MusicBrainz::Server::Controller::Edit=HASH(0xb932fc0)', 'MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xbc99460)', 'MusicBrainz::Server::Controller::Edit=HASH(0xb932fc0)', 'MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/Catalyst.pm line 1672
      eval

      Unknown macro: {...}

      called at local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0xc98aa70)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xbc99460)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc98aa70)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xbc99460)') called at lib/MusicBrainz/Server.pm line 311
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xc98aa70)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xbc99460)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbc99460)', 'MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/Catalyst/ActionChain.pm line 38
      Catalyst::ActionChain::dispatch('Catalyst::ActionChain=HASH(0xcabc050)', 'MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/Catalyst/Controller.pm line 158
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Edit=HASH(0xb932fc0)', 'MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xbc997d8)', 'MusicBrainz::Server::Controller::Edit=HASH(0xb932fc0)', 'MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/Catalyst.pm line 1672
      eval

      called at local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0xc98aa70)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xbc997d8)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc98aa70)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xbc997d8)') called at lib/MusicBrainz/Server.pm line 311
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xc98aa70)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xbc997d8)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbc997d8)', 'MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x37da068)', 'forward', 'MusicBrainz::Server=HASH(0xc98aa70)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x37da068)', 'MusicBrainz::Server=HASH(0xc98aa70)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward('MusicBrainz::Server=HASH(0xc98aa70)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 132
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Edit=HASH(0xb932fc0)', 'MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xbc98ed8)', 'MusicBrainz::Server::Controller::Edit=HASH(0xb932fc0)', 'MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/Catalyst.pm line 1672
      eval

      Unknown macro: {...}

      called at local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0xc98aa70)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xbc98ed8)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc98aa70)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xbc98ed8)') called at lib/MusicBrainz/Server.pm line 311
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xc98aa70)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xbc98ed8)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbc98ed8)', 'MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x37da068)', 'forward', 'MusicBrainz::Server=HASH(0xc98aa70)', '/edit/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x37da068)', 'MusicBrainz::Server=HASH(0xc98aa70)', '/edit/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward('MusicBrainz::Server=HASH(0xc98aa70)', '/edit/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x37da068)', 'MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/Catalyst.pm line 1618
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xc98aa70)') called at lib/MusicBrainz/Server.pm line 270
      MusicBrainz::Server::_ANON_('MusicBrainz::Server=HASH(0xc98aa70)', 'CODE(0x2a44880)') called at lib/MusicBrainz/Server.pm line 366
      MusicBrainz::Server::with_translations('MusicBrainz::Server=HASH(0xc98aa70)', 'CODE(0x3098cb8)', 'CODE(0x2a44880)') called at lib/MusicBrainz/Server.pm line 277
      Class::MOP::Class:::around('CODE(0x2a44880)', 'MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xc98aa70)') called at local/lib/perl5/Catalyst.pm line 1968
      Catalyst::_ANON_() called at local/lib/perl5/Try/Tiny.pm line 76
      eval

      called at local/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0xc966200)', 'Try::Tiny::Catch=REF(0xd003060)') called at local/lib/perl5/Catalyst.pm line 1974
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xca3ed90)', 'response_cb', 'CODE(0xca3ead8)') called at local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xca3ed90)', 'response_cb', 'CODE(0xca3ead8)') called at local/lib/perl5/Catalyst/Engine.pm line 688
      Catalyst::Engine::_ANON_('CODE(0xca3ead8)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 130
      Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0xd7da28)', 'CODE(0xbef1b80)') called at local/lib/perl5/Plack/Loader.pm line 84
      Plack::Loader::run('Plack::Loader=HASH(0xca4de8)', 'Plack::Handler::FCGI=HASH(0xd7da28)') called at local/lib/perl5/Plack/Runner.pm line 267
      Plack::Runner::run('Plack::Runner=HASH(0xb2d850)') called at local/bin/plackup line 10
      at lib/Sql.pm line 294."

      Stack trace:
      line 511 MusicBrainz::Server::Data::Edit
      line 112 MusicBrainz::Server::Controller::Edit
      line 311 MusicBrainz::Server
      line 311 MusicBrainz::Server
      line 311 MusicBrainz::Server
      line 270 MusicBrainz::Server
      line 366 MusicBrainz::Server
      line 277 MusicBrainz::Server

      Request data:
      $VAR1 = {
      'query_parameters' =>

      Unknown macro: { 'url' => 'http}

      ,
      'body_parameters' => {}
      };

      URL: http://musicbrainz.org/edit/19813802/approve?url=http%3A%2F%2Fmusicbrainz.org%2Fedit%2Fsubscribed_editors

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              humhumxx HumHumXX
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package