# Pastebin RmwmSLHh Failed query: 'SELECT pg_advisory_xact_lock(?, id) FROM unnest(?::integer[]) AS id' (22 ARRAY(0x96aab70)) 40P01 DBD::Pg::st execute failed: ERROR: deadlock detected DETAIL: Process 29235 waits for ExclusiveLock on advisory lock [16806,22,34,2]; blocked by process 29276. Process 29276 waits for ExclusiveLock on advisory lock [16806,22,0,2]; blocked by process 29235. 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='{"48","49","37","0","1","38","2","3","27","4","5","15","35","16","6","7","8","19","34","9","10","11","12","13","14"}'] at lib/Sql.pm line 116. Sql::catch {...} (MusicBrainz::Server::Exceptions::DatabaseError=HASH(0x1b757980)) called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 123 Try::Tiny::try(CODE(0x1b75ff88), Try::Tiny::Catch=REF(0x1b7970a8)) called at lib/Sql.pm line 117 Sql::do(Sql=HASH(0x1b734098), "SELECT pg_advisory_xact_lock(?, id) FROM unnest(?::integer["..., 22, ARRAY(0x96aab70)) called at lib/MusicBrainz/Server/Data/Role/EntityCache.pm line 152 MusicBrainz::Server::Data::Role::EntityCache::_delete_from_cache(MusicBrainz::Server::Data::Recording=HASH(0x13537ec8), 28789848, 28789849, 28784337, 28789850, 28789851, 28784338, 28789852, 28789853, ...) called at lib/MusicBrainz/Server/Data/Track.pm line 170 MusicBrainz::Server::Data::Track::_insert_hook_after(MusicBrainz::Server::Data::Track=HASH(0x13832250), ARRAY(0x9b97e58), HASH(0x1b754d90)) called at lib/MusicBrainz/Server/Data/CoreEntity.pm line 102 MusicBrainz::Server::Data::CoreEntity::insert(MusicBrainz::Server::Data::Track=HASH(0x13832250), HASH(0x1abb3d90), HASH(0x1b7721b8), HASH(0x1b79dc40), HASH(0x1b779750), HASH(0x1b746ac0), HASH(0x1b74bbc8), HASH(0x1b7972b8), HASH(0x1b73edc0), ...) called at lib/MusicBrainz/Server/Data/Medium.pm line 127 MusicBrainz::Server::Data::Medium::insert(MusicBrainz::Server::Data::Medium=HASH(0x13457620), HASH(0x1b790b40)) called at lib/MusicBrainz/Server/Edit/Generic/Create.pm line 48 MusicBrainz::Server::Edit::Generic::Create::insert(MusicBrainz::Server::Edit::Medium::Create=HASH(0x1b775dc0)) called at lib/MusicBrainz/Server/Data/Edit.pm line 551 MusicBrainz::Server::Data::Edit::create(MusicBrainz::Server::Data::Edit=HASH(0x12428180), "tracklist", ARRAY(0x1b726720), "release", MusicBrainz::Server::Entity::Release=HASH(0x1b195f98), "position", 1, "format_id", 12, ...) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 568 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(0x1b768be8), Try::Tiny::Catch=REF(0x1aadac70)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 586 MusicBrainz::Server::Controller::WS::js::Edit::create_edits(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x142c9e18), MusicBrainz::Server=HASH(0x1b6dc918), HASH(0x1b78b390)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 643 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(0x1b7ace78), Try::Tiny::Catch=REF(0x1b2fbfd8)) called at lib/Sql.pm line 335 Sql::_auto_transaction(CODE(0x1b192e38), Sql=HASH(0x1b734098)) called at lib/Sql.pm line 340 Sql::_run_in_transaction_one(CODE(0x1b192e38), Sql=HASH(0x1b734098)) called at lib/Sql.pm line 355 Sql::run_in_transaction(CODE(0x1b192e38), Sql=HASH(0x1b734098)) called at lib/MusicBrainz/Server/Model/MB.pm line 19 MusicBrainz::Server::Model::MB::with_transaction(MusicBrainz::Server::Model::MB=HASH(0x11c4c058), CODE(0x1b192e38)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 654 MusicBrainz::Server::Controller::WS::js::Edit::submit_edits(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x142c9e18), MusicBrainz::Server=HASH(0x1b6dc918), HASH(0x1b78b390)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 618 MusicBrainz::Server::Controller::WS::js::Edit::create(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x142c9e18), MusicBrainz::Server=HASH(0x1b6dc918)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 358 Catalyst::Action::execute(Catalyst::Action=HASH(0x1478b928), MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x142c9e18), MusicBrainz::Server=HASH(0x1b6dc918)) 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(0x1b6dc918), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x1478b928)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34 Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x1b6dc918), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x1478b928)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 353 Catalyst::Action::dispatch(Catalyst::Action=HASH(0x1478b928), MusicBrainz::Server=HASH(0x1b6dc918)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/ActionChain.pm line 46 Catalyst::ActionChain::dispatch(Catalyst::ActionChain=HASH(0x1b31ad18), MusicBrainz::Server=HASH(0x1b6dc918)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Controller.pm line 170 Catalyst::Controller::_ACTION(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x142c9e18), MusicBrainz::Server=HASH(0x1b6dc918)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 358 Catalyst::Action::execute(Catalyst::Action=HASH(0x1478b220), MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x142c9e18), MusicBrainz::Server=HASH(0x1b6dc918)) 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(0x1b6dc918), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x1478b220)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34 Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x1b6dc918), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x1478b220)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 353 Catalyst::Action::dispatch(Catalyst::Action=HASH(0x1478b220), MusicBrainz::Server=HASH(0x1b6dc918)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 261 Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x7ab2fc8), "forward", MusicBrainz::Server=HASH(0x1b6dc918), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 241 Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x7ab2fc8), MusicBrainz::Server=HASH(0x1b6dc918), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 483 Catalyst::forward(MusicBrainz::Server=HASH(0x1b6dc918), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Controller.pm line 134 Catalyst::Controller::_DISPATCH(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x142c9e18), MusicBrainz::Server=HASH(0x1b6dc918)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 358 Catalyst::Action::execute(Catalyst::Action=HASH(0x14786d58), MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x142c9e18), MusicBrainz::Server=HASH(0x1b6dc918)) 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(0x1b6dc918), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x14786d58)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34 Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x1b6dc918), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x14786d58)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 353 Catalyst::Action::dispatch(Catalyst::Action=HASH(0x14786d58), MusicBrainz::Server=HASH(0x1b6dc918)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 261 Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x7ab2fc8), "forward", MusicBrainz::Server=HASH(0x1b6dc918), "/ws/js/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 241 Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x7ab2fc8), MusicBrainz::Server=HASH(0x1b6dc918), "/ws/js/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 483 Catalyst::forward(MusicBrainz::Server=HASH(0x1b6dc918), "/ws/js/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 107 Catalyst::Dispatcher::dispatch(Catalyst::Dispatcher=HASH(0x7ab2fc8), MusicBrainz::Server=HASH(0x1b6dc918)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2007 Catalyst::dispatch(MusicBrainz::Server=HASH(0x1b6dc918)) called at lib/MusicBrainz/Server.pm line 385 MusicBrainz::Server::__ANON__() called at lib/MusicBrainz/Server.pm line 352 MusicBrainz::Server::with_translations(MusicBrainz::Server=HASH(0x1b6dc918), CODE(0x1b195ae8)) called at lib/MusicBrainz/Server.pm line 386 Class::MOP::Class:::around(CODE(0x37f1a50), MusicBrainz::Server=HASH(0x1b6dc918)) 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(0x1b6dc918)) called at lib/MusicBrainz/Server.pm line 400 Class::MOP::Class:::around(CODE(0x1432f1e0), MusicBrainz::Server=HASH(0x1b6dc918)) 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(0x1b6dc918)) called at lib/MusicBrainz/Server.pm line 478 Class::MOP::Class:::around(CODE(0x1433e1c8), MusicBrainz::Server=HASH(0x1b6dc918)) 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(0x1b6dc918)) 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(0x1b6dc918)) 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(0x1b6dc918)) 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(0x1b13e278), Try::Tiny::Catch=REF(0x1b4e60a8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2422 Catalyst::handle_request("MusicBrainz::Server", "env", HASH(0x1b4fca70), "response_cb", CODE(0x1b16f840)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Engine.pm line 807 Catalyst::Engine::__ANON__(CODE(0x1b16f840)) 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(0x1b6c18f0), Try::Tiny::Catch=REF(0x1b6cbc68)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Middleware/HTTPExceptions.pm line 41 Plack::Middleware::HTTPExceptions::__ANON__(CODE(0x1b6bb200)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339 Plack::Util::__ANON__(CODE(0x1b6f97f0)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339 Plack::Util::__ANON__(CODE(0x1b793da8)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339 Plack::Util::__ANON__(CODE(0x1aae0918)) called at /home/musicbrainz/carton-local/lib/perl5/Starlet/Server.pm line 377 Starlet::Server::handle_connection(Plack::Handler::Starlet=HASH(0x1434b6d0), HASH(0x1b4fca70), IO::Socket::INET=GLOB(0x1b6ce338), CODE(0x1480e1d0), "", "", "") called at /home/musicbrainz/carton-local/lib/perl5/Starlet/Server.pm line 190 Starlet::Server::accept_loop(Plack::Handler::Starlet=HASH(0x1434b6d0), CODE(0x1480e1d0), 81) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Handler/Starlet.pm line 80 Plack::Handler::Starlet::run(Plack::Handler::Starlet=HASH(0x1434b6d0), CODE(0x1480e1d0)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Loader.pm line 84 Plack::Loader::run(Plack::Loader=HASH(0x11a62d0), Plack::Handler::Starlet=HASH(0x1434b6d0)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Runner.pm line 277 Plack::Runner::run(Plack::Runner=HASH(0x1197ae8)) called at /home/musicbrainz/carton-local/bin/plackup line 7