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

ISE while approving edit

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Edit system
    • Labels:
      None

      Description

      https://chatlogs.metabrainz.org/brainzbot/metabrainz/msg/4592666/

      Caught exception in MusicBrainz::Server::Controller::Edit->approve "Failed query:
      	'SELECT id FROM edit WHERE id = ? FOR UPDATE NOWAIT'
      	(70031043)
      55P03 DBD::Pg::st execute failed: ERROR:  could not obtain lock on row in relation "edit" [for Statement "SELECT id FROM edit WHERE id = ? FOR UPDATE NOWAIT" with ParamValues: 1='70031043']
       at lib/Sql.pm line 389.
      	Sql::catch {...} (MusicBrainz::Server::Exceptions::DatabaseError=HASH(0x1c419b90)) called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 123
      	Try::Tiny::try(CODE(0x1c0f4388), Try::Tiny::Catch=REF(0x1c14a138), Try::Tiny::Finally=REF(0x1c240c20)) called at lib/Sql.pm line 394
      	Sql::_select_single_row(Sql=HASH(0x1c328c58), "SELECT id FROM edit WHERE id = ? FOR UPDATE NOWAIT", ARRAY(0x1c21a638), "hashref") called at lib/Sql.pm line 400
      	Sql::select_single_row_hash(Sql=HASH(0x1c328c58), "SELECT id FROM edit WHERE id = ? FOR UPDATE NOWAIT", 70031043) called at lib/MusicBrainz/Server/Data/Edit.pm line 118
      	MusicBrainz::Server::Data::Edit::get_by_id_and_lock(MusicBrainz::Server::Data::Edit=HASH(0x132931c0), 70031043) called at lib/MusicBrainz/Server/Controller/Edit.pm line 125
      	MusicBrainz::Server::Controller::Edit::__ANON__() called at lib/Sql.pm line 321
      	Sql::try {...} () called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 100
      	eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 93
      	Try::Tiny::try(CODE(0x1c10d998), Try::Tiny::Catch=REF(0x1c2e9d60)) called at lib/Sql.pm line 335
      	Sql::_auto_transaction(CODE(0x1c23c828), Sql=HASH(0x1c328c58)) called at lib/Sql.pm line 340
      	Sql::_run_in_transaction_one(CODE(0x1c23c828), Sql=HASH(0x1c328c58)) called at lib/Sql.pm line 355
      	Sql::run_in_transaction(CODE(0x1c23c828), Sql=HASH(0x1c328c58)) called at lib/MusicBrainz/Server/Model/MB.pm line 19
      	MusicBrainz::Server::Model::MB::with_transaction(MusicBrainz::Server::Model::MB=HASH(0x12a460b0), CODE(0x1c23c828)) called at lib/MusicBrainz/Server/Controller/Edit.pm line 152
      	MusicBrainz::Server::Controller::Edit::approve(MusicBrainz::Server::Controller::Edit=HASH(0x150ac530), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 358
      	Catalyst::Action::execute(Catalyst::Action=HASH(0x152ce3a0), MusicBrainz::Server::Controller::Edit=HASH(0x150ac530), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2061
      	eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2061
      	Catalyst::execute(MusicBrainz::Server=HASH(0x174ab490), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0x152ce3a0)) called at lib/Catalyst/Plugin/Sentry.pm line 23
      	Catalyst::Plugin::Sentry::execute(MusicBrainz::Server=HASH(0x174ab490), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0x152ce3a0)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 353
      	Catalyst::Action::dispatch(Catalyst::Action=HASH(0x152ce3a0), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/ActionChain.pm line 46
      	Catalyst::ActionChain::dispatch(Catalyst::ActionChain=HASH(0x1c240fc8), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Controller.pm line 170
      	Catalyst::Controller::_ACTION(MusicBrainz::Server::Controller::Edit=HASH(0x150ac530), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 358
      	Catalyst::Action::execute(Catalyst::Action=HASH(0x152ca010), MusicBrainz::Server::Controller::Edit=HASH(0x150ac530), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2061
      	eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2061
      	Catalyst::execute(MusicBrainz::Server=HASH(0x174ab490), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0x152ca010)) called at lib/Catalyst/Plugin/Sentry.pm line 23
      	Catalyst::Plugin::Sentry::execute(MusicBrainz::Server=HASH(0x174ab490), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0x152ca010)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 353
      	Catalyst::Action::dispatch(Catalyst::Action=HASH(0x152ca010), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 261
      	Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x8e4dda0), "forward", MusicBrainz::Server=HASH(0x174ab490), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 241
      	Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x8e4dda0), MusicBrainz::Server=HASH(0x174ab490), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 483
      	Catalyst::forward(MusicBrainz::Server=HASH(0x174ab490), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Controller.pm line 134
      	Catalyst::Controller::_DISPATCH(MusicBrainz::Server::Controller::Edit=HASH(0x150ac530), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 358
      	Catalyst::Action::execute(Catalyst::Action=HASH(0x152c9ba8), MusicBrainz::Server::Controller::Edit=HASH(0x150ac530), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2061
      	eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2061
      	Catalyst::execute(MusicBrainz::Server=HASH(0x174ab490), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0x152c9ba8)) called at lib/Catalyst/Plugin/Sentry.pm line 23
      	Catalyst::Plugin::Sentry::execute(MusicBrainz::Server=HASH(0x174ab490), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0x152c9ba8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 353
      	Catalyst::Action::dispatch(Catalyst::Action=HASH(0x152c9ba8), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 261
      	Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x8e4dda0), "forward", MusicBrainz::Server=HASH(0x174ab490), "/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 241
      	Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x8e4dda0), MusicBrainz::Server=HASH(0x174ab490), "/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 483
      	Catalyst::forward(MusicBrainz::Server=HASH(0x174ab490), "/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 107
      	Catalyst::Dispatcher::dispatch(Catalyst::Dispatcher=HASH(0x8e4dda0), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2007
      	Catalyst::dispatch(MusicBrainz::Server=HASH(0x174ab490)) called at lib/MusicBrainz/Server.pm line 324
      	MusicBrainz::Server::__ANON__() called at lib/MusicBrainz/Server.pm line 299
      	MusicBrainz::Server::with_translations(MusicBrainz::Server=HASH(0x174ab490), CODE(0x1748bc28)) called at lib/MusicBrainz/Server.pm line 325
      	Class::MOP::Class:::around(CODE(0x47d4ae8), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 164
      	Class::MOP::Method::Wrapped::__ANON__(MusicBrainz::Server=HASH(0x174ab490)) called at lib/MusicBrainz/Server.pm line 339
      	Class::MOP::Class:::around(CODE(0x151680c8), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 164
      	Class::MOP::Method::Wrapped::__ANON__(MusicBrainz::Server=HASH(0x174ab490)) called at lib/MusicBrainz/Server.pm line 417
      	Class::MOP::Class:::around(CODE(0x151692a8), MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 164
      	Class::MOP::Method::Wrapped::__ANON__(MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 35
      	MusicBrainz::Server::_wrapped_dispatch(MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 95
      	MusicBrainz::Server::dispatch(MusicBrainz::Server=HASH(0x174ab490)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2413
      	Catalyst::try {...} () called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 102
      	eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 93
      	Try::Tiny::try(CODE(0x1c3230f0), Try::Tiny::Catch=REF(0x17aeb678)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2422
      	Catalyst::handle_request("MusicBrainz::Server", "env", HASH(0x1c100d18), "response_cb", CODE(0x17b58a58)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Engine.pm line 807
      	Catalyst::Engine::__ANON__(CODE(0x17b58a58)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Middleware/HTTPExceptions.pm line 32
      	Plack::Middleware::HTTPExceptions::try {...} () called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 102
      	eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 93
      	Try::Tiny::try(CODE(0x1c23e068), Try::Tiny::Catch=REF(0x1704b938)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Middleware/HTTPExceptions.pm line 41
      	Plack::Middleware::HTTPExceptions::__ANON__(CODE(0x1c23fa10)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339
      	Plack::Util::__ANON__(CODE(0x1c23ab50)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339
      	Plack::Util::__ANON__(CODE(0x1c3dcef0)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339
      	Plack::Util::__ANON__(CODE(0x17b58da0)) called at /home/musicbrainz/carton-local/lib/perl5/Starlet/Server.pm line 377
      	Starlet::Server::handle_connection(Plack::Handler::Starlet=HASH(0x1512da88), HASH(0x1c100d18), IO::Socket::INET=GLOB(0x1c330be0), CODE(0x1562b2d8), "", "", "") called at /home/musicbrainz/carton-local/lib/perl5/Starlet/Server.pm line 190
      	Starlet::Server::accept_loop(Plack::Handler::Starlet=HASH(0x1512da88), CODE(0x1562b2d8), 38) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Handler/Starlet.pm line 80
      	Plack::Handler::Starlet::run(Plack::Handler::Starlet=HASH(0x1512da88), CODE(0x1562b2d8)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Loader.pm line 84
      	Plack::Loader::run(Plack::Loader=HASH(0x238f400), Plack::Handler::Starlet=HASH(0x1512da88)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Runner.pm line 277
      	Plack::Runner::run(Plack::Runner=HASH(0x2177ad8)) called at /home/musicbrainz/carton-local/bin/plackup line 7
       at lib/Sql.pm line 335."
      Stack trace:
      line
      line
      line
      Edits loaded for the page:
      
      70031043 (raw edit data)
      Time: 2020-05-24 07:26:02 UTC
      
      Host: d9487c7127e6
      
      Interface language: en
      
      URL: https://musicbrainz.org/edit/70031043/approve?returnto=https%3A%2F%2Fmusicbrainz.org%2Fedit%2F70031043
      
      Request data:
      
      $VAR1 = {
                'body_parameters' => {},
                'query_parameters' => {
                                        'returnto' => 'https://musicbrainz.org/edit/70031043'
                                      }
              };
      
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              chaban chaban
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Packages

                Version Package