-
Bug
-
Resolution: Duplicate
-
Normal
-
None
-
None
-
None
Failed query: 'SELECT pg_advisory_xact_lock(?, id) FROM unnest(?::integer[]) AS id' (22 ARRAY(0x561698f86568)) 40P01 DBD::Pg::st execute failed: ERROR: deadlock detected DETAIL: Process 1552 waits for ExclusiveLock on advisory lock [16806,22,44,2]; blocked by process 1416. Process 1416 waits for AccessExclusiveLock on relation 140674910 of database 16806; blocked by process 1552. HINT: See server log for query details. [for Statement "SELECT pg_advisory_xact_lock(?, id) FROM unnest(?::integer[]) AS id" with ParamValues: 1='22', 2='{"40","41","42","43","44","45","46"}'] at lib/Sql.pm line 116. Sql::catch {...} (MusicBrainz::Server::Exceptions::DatabaseError=HASH(0x5616a9d8a7c8)) called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 123 Try::Tiny::try(CODE(0x5616a9e1a428), Try::Tiny::Catch=REF(0x5616a9cb0d70)) called at lib/Sql.pm line 117 Sql::do(Sql=HASH(0x5616aa0542f0), "SELECT pg_advisory_xact_lock(?, id) FROM unnest(?::integer["..., 22, ARRAY(0x561698f86568)) called at lib/MusicBrainz/Server/Data/Role/EntityCache.pm line 152 MusicBrainz::Server::Data::Role::EntityCache::delete_from_cache(MusicBrainz::Server::Data::Recording=HASH(0x5616a3093ab8), 29827190, 29827191, 29827192, 29827193, 29827194, 29827195, 29827196) called at lib/MusicBrainz/Server/Data/Track.pm line 182 MusicBrainz::Server::Data::Track::_insert_hook_after(MusicBrainz::Server::Data::Track=HASH(0x5616a33cae18), ARRAY(0x5616993f53b0), HASH(0x5616aa334778)) called at lib/MusicBrainz/Server/Data/CoreEntity.pm line 102 MusicBrainz::Server::Data::CoreEntity::insert(MusicBrainz::Server::Data::Track=HASH(0x5616a33cae18), HASH(0x5616a47b4bb0), HASH(0x5616aa0c5b38), HASH(0x5616aa090758), HASH(0x5616a9ee7c98), HASH(0x5616a9f16e18), HASH(0x5616a9edbff8), HASH(0x5616a9ee0070)) called at lib/MusicBrainz/Server/Data/Medium.pm line 154 MusicBrainz::Server::Data::Medium::insert(MusicBrainz::Server::Data::Medium=HASH(0x5616a303f2c8), HASH(0x5616a9f0d3a8)) called at lib/MusicBrainz/Server/Edit/Generic/Create.pm line 48 MusicBrainz::Server::Edit::Generic::Create::insert(MusicBrainz::Server::Edit::Medium::Create=HASH(0x5616a9f04e68)) called at lib/MusicBrainz/Server/Data/Edit.pm line 566 MusicBrainz::Server::Data::Edit::create(MusicBrainz::Server::Data::Edit=HASH(0x5616a1f6c270), "tracklist", ARRAY(0x5616a9d753f0), "position", 1, "edit_type", 51, "format_id", ...) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 599 MusicBrainz::Server::Controller::WS::js::Edit::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(0x5616a4ccf1e0), Try::Tiny::Catch=REF(0x5616a9eca518)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 617 MusicBrainz::Server::Controller::WS::js::Edit::create_edits(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x5616a3e77cb0), MusicBrainz::Server=HASH(0x5616aa0607a0), HASH(0x5616a9f2f4d0)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 674 MusicBrainz::Server::Controller::WS::js::Edit::ANON() called at lib/Sql.pm line 322 Sql::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(0x5616a9ec0d28), Try::Tiny::Catch=REF(0x5616a9e77f08)) called at lib/Sql.pm line 335 Sql::_auto_transaction(CODE(0x5616a9f67ef8), Sql=HASH(0x5616aa0542f0)) called at lib/Sql.pm line 340 Sql::_run_in_transaction_one(CODE(0x5616a9f67ef8), Sql=HASH(0x5616aa0542f0)) called at lib/Sql.pm line 355 Sql::run_in_transaction(CODE(0x5616a9f67ef8), Sql=HASH(0x5616aa0542f0)) called at lib/MusicBrainz/Server/Model/MB.pm line 19 MusicBrainz::Server::Model::MB::with_transaction(MusicBrainz::Server::Model::MB=HASH(0x5616a177c5a8), CODE(0x5616a9f67ef8)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 685 MusicBrainz::Server::Controller::WS::js::Edit::submit_edits(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x5616a3e77cb0), MusicBrainz::Server=HASH(0x5616aa0607a0), HASH(0x5616a9f2f4d0)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 649 MusicBrainz::Server::Controller::WS::js::Edit::create(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x5616a3e77cb0), MusicBrainz::Server=HASH(0x5616aa0607a0)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 358 Catalyst::Action::execute(Catalyst::Action=HASH(0x5616a4372d50), MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x5616a3e77cb0), MusicBrainz::Server=HASH(0x5616aa0607a0)) 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(0x5616aa0607a0), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x5616a4372d50)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34 Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x5616aa0607a0), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x5616a4372d50)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 353 Catalyst::Action::dispatch(Catalyst::Action=HASH(0x5616a4372d50), MusicBrainz::Server=HASH(0x5616aa0607a0)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/ActionChain.pm line 46 Catalyst::ActionChain::dispatch(Catalyst::ActionChain=HASH(0x5616a9db3ad0), MusicBrainz::Server=HASH(0x5616aa0607a0)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Controller.pm line 170 Catalyst::Controller::_ACTION(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x5616a3e77cb0), MusicBrainz::Server=HASH(0x5616aa0607a0)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 358 Catalyst::Action::execute(Catalyst::Action=HASH(0x5616a436ebd8), MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x5616a3e77cb0), MusicBrainz::Server=HASH(0x5616aa0607a0)) 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(0x5616aa0607a0), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x5616a436ebd8)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34 Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x5616aa0607a0), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x5616a436ebd8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 353 Catalyst::Action::dispatch(Catalyst::Action=HASH(0x5616a436ebd8), MusicBrainz::Server=HASH(0x5616aa0607a0)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 261 Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x5616974e6b80), "forward", MusicBrainz::Server=HASH(0x5616aa0607a0), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 241 Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x5616974e6b80), MusicBrainz::Server=HASH(0x5616aa0607a0), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 483 Catalyst::forward(MusicBrainz::Server=HASH(0x5616aa0607a0), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Controller.pm line 134 Catalyst::Controller::_DISPATCH(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x5616a3e77cb0), MusicBrainz::Server=HASH(0x5616aa0607a0)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 358 Catalyst::Action::execute(Catalyst::Action=HASH(0x5616a436eaa0), MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x5616a3e77cb0), MusicBrainz::Server=HASH(0x5616aa0607a0)) 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(0x5616aa0607a0), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x5616a436eaa0)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34 Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x5616aa0607a0), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x5616a436eaa0)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 353 Catalyst::Action::dispatch(Catalyst::Action=HASH(0x5616a436eaa0), MusicBrainz::Server=HASH(0x5616aa0607a0)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 261 Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x5616974e6b80), "forward", MusicBrainz::Server=HASH(0x5616aa0607a0), "/ws/js/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 241 Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x5616974e6b80), MusicBrainz::Server=HASH(0x5616aa0607a0), "/ws/js/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 483 Catalyst::forward(MusicBrainz::Server=HASH(0x5616aa0607a0), "/ws/js/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 107 Catalyst::Dispatcher::dispatch(Catalyst::Dispatcher=HASH(0x5616974e6b80), MusicBrainz::Server=HASH(0x5616aa0607a0)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2007 Catalyst::dispatch(MusicBrainz::Server=HASH(0x5616aa0607a0)) called at lib/MusicBrainz/Server.pm line 390 MusicBrainz::Server::ANON() called at lib/MusicBrainz/Server.pm line 357 MusicBrainz::Server::with_translations(MusicBrainz::Server=HASH(0x5616aa0607a0), CODE(0x5616a9eba838)) called at lib/MusicBrainz/Server.pm line 391 Class::MOP::Class:::around(CODE(0x561693319818), MusicBrainz::Server=HASH(0x5616aa0607a0)) 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(0x5616aa0607a0)) called at lib/MusicBrainz/Server.pm line 405 Class::MOP::Class:::around(CODE(0x5616a3ebf100), MusicBrainz::Server=HASH(0x5616aa0607a0)) 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(0x5616aa0607a0)) called at lib/MusicBrainz/Server.pm line 490 Class::MOP::Class:::around(CODE(0x5616a4176230), MusicBrainz::Server=HASH(0x5616aa0607a0)) 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(0x5616aa0607a0)) 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(0x5616aa0607a0)) 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(0x5616aa0607a0)) 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(0x5616a93b28e8), Try::Tiny::Catch=REF(0x5616a54cf668)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2422 Catalyst::handle_request("MusicBrainz::Server", "env", HASH(0x5616a9db3140), "response_cb", CODE(0x5616a54a91f8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Engine.pm line 807 Catalyst::Engine::ANON(CODE(0x5616a54a91f8)) 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(0x5616a562bb40), Try::Tiny::Catch=REF(0x5616aa03b6b8)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Middleware/HTTPExceptions.pm line 41 Plack::Middleware::HTTPExceptions::ANON(CODE(0x5616a5427f50)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339 Plack::Util::ANON(CODE(0x5616a9eacf78)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339 Plack::Util::ANON(CODE(0x5616a9f22998)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339 Plack::Util::ANON_(CODE(0x5616a9d616a8)) called at /home/musicbrainz/carton-local/lib/perl5/Starlet/Server.pm line 377 Starlet::Server::handle_connection(Plack::Handler::Starlet=HASH(0x5616a3de9748), HASH(0x5616a9db3140), IO::Socket::INET=GLOB(0x5616a9f177c0), CODE(0x5616a41be0c8), "", "", "") called at /home/musicbrainz/carton-local/lib/perl5/Starlet/Server.pm line 190 Starlet::Server::accept_loop(Plack::Handler::Starlet=HASH(0x5616a3de9748), CODE(0x5616a41be0c8), 49) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Handler/Starlet.pm line 80 Plack::Handler::Starlet::run(Plack::Handler::Starlet=HASH(0x5616a3de9748), CODE(0x5616a41be0c8)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Loader.pm line 84 Plack::Loader::run(Plack::Loader=HASH(0x561690c120c0), Plack::Handler::Starlet=HASH(0x5616a3de9748)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Runner.pm line 277 Plack::Runner::run(Plack::Runner=HASH(0x561690c11eb0)) called at /home/musicbrainz/carton-local/bin/plackup line 7
- duplicates
-
MBS-11682 Deadlock when entering edits
- Closed