-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Normal
-
None
-
Affects Version/s: None
-
Component/s: Release editor
-
None
replacing empty mediums with filled ones from same RG results in a failed query error:
Failed query: 'UPDATE medium SET position = (SELECT position FROM (VALUES (?::INTEGER, ?::INTEGER), (?::INTEGER, ?::INTEGER), (?::INTEGER, ?::INTEGER), (?::INTEGER, ?::INTEGER)) AS mpos (medium, position) WHERE mpos.medium = medium.id) WHERE id IN (?,?,?,?)' (5348335 5 5348337 5 5348336 5 5381704 4 5348335 5348337 5348336 5381704) 23505 DBD::Pg::st execute failed: ERROR: duplicate key value violates unique constraint "medium_uniq" DETAIL: Key (release, "position")=(4917682, 5) already exists. [for Statement "UPDATE medium SET position = (SELECT position FROM (VALUES (?::INTEGER, ?::INTEGER), (?::INTEGER, ?::INTEGER), (?::INTEGER, ?::INTEGER), (?::INTEGER, ?::INTEGER)) AS mpos (medium, position) WHERE mpos.medium = medium.id) WHERE id IN (?,?,?,?)" with ParamValues: 1='5348335', 2='5', 3='5348337', 4='5', 5='5348336', 6='5', 7='5381704', 8='4', 9='5348335', 10='5348337', 11='5348336', 12='5381704'] at lib/Sql.pm line 129. Sql::catch {...} (MusicBrainz::Server::Exceptions::DatabaseError=HASH(0x558a6a48d240)) called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 123 Try::Tiny::try(CODE(0x558a6a3c0088), Try::Tiny::Catch=REF(0x558a6a595d68)) called at lib/Sql.pm line 130 Sql::do(Sql=HASH(0x558a6a4ed478), "UPDATE medium SET position =\x{a} (SELECT position"..., 5348335, 5, 5348337, 5, 5348336, 5, ...) called at lib/MusicBrainz/Server/Data/Medium.pm line 294 MusicBrainz::Server::Data::Medium::reorder(MusicBrainz::Server::Data::Medium=HASH(0x558a61ca9730), 5381704, 4, 5348336, 5, 5348337, 5, 5348335, ...) called at lib/MusicBrainz/Server/Edit/Release/ReorderMediums.pm line 139 MusicBrainz::Server::Edit::Release::ReorderMediums::accept(MusicBrainz::Server::Edit::Release::ReorderMediums=HASH(0x558a6a501a58)) called at lib/MusicBrainz/Server/Data/Edit.pm line 813 MusicBrainz::Server::Data::Edit::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(0x558a6a5a8a48), Try::Tiny::Catch=REF(0x558a6a5b5a90)) called at lib/MusicBrainz/Server/Data/Edit.pm line 876 MusicBrainz::Server::Data::Edit::do_accept(MusicBrainz::Server::Data::Edit=HASH(0x558a60db3508), MusicBrainz::Server::Edit::Release::ReorderMediums=HASH(0x558a6a501a58)) called at lib/MusicBrainz/Server/Data/Edit.pm line 915 MusicBrainz::Server::Data::Edit::ANON(MusicBrainz::Server::Edit::Release::ReorderMediums=HASH(0x558a6a501a58)) called at lib/MusicBrainz/Server/Data/Edit.pm line 938 MusicBrainz::Server::Data::Edit::_close(MusicBrainz::Server::Data::Edit=HASH(0x558a60db3508), MusicBrainz::Server::Edit::Release::ReorderMediums=HASH(0x558a6a501a58), CODE(0x558a6a5d8800)) called at lib/MusicBrainz/Server/Data/Edit.pm line 915 MusicBrainz::Server::Data::Edit::accept(MusicBrainz::Server::Data::Edit=HASH(0x558a60db3508), MusicBrainz::Server::Edit::Release::ReorderMediums=HASH(0x558a6a501a58)) called at lib/MusicBrainz/Server/Data/Edit.pm line 652 MusicBrainz::Server::Data::Edit::create(MusicBrainz::Server::Data::Edit=HASH(0x558a60db3508), "edit_type", 313, "medium_positions", ARRAY(0x558a6a2d3e28), "release", MusicBrainz::Server::Entity::Release=HASH(0x558a698a4258), "editor", ...) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 697 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(0x558a66a09d30), Try::Tiny::Catch=REF(0x558a6a66d910)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 715 MusicBrainz::Server::Controller::WS::js::Edit::create_edits(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x558a62e18810), MusicBrainz::Server=HASH(0x558a6a1a1238), HASH(0x558a6a4903a0)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 779 MusicBrainz::Server::Controller::WS::js::Edit::ANON() called at lib/Sql.pm line 352 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(0x558a6a4f4f60), Try::Tiny::Catch=REF(0x558a6a424850)) called at lib/Sql.pm line 364 Sql::_auto_transaction(CODE(0x558a669cdfd0), Sql=HASH(0x558a6a4ed478)) called at lib/Sql.pm line 370 Sql::_run_in_transaction_one(CODE(0x558a669cdfd0), Sql=HASH(0x558a6a4ed478)) called at lib/Sql.pm line 385 Sql::run_in_transaction(CODE(0x558a669cdfd0), Sql=HASH(0x558a6a4ed478)) called at lib/MusicBrainz/Server/Model/MB.pm line 20 MusicBrainz::Server::Model::MB::with_transaction(MusicBrainz::Server::Model::MB=HASH(0x558a60653790), CODE(0x558a669cdfd0)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 790 MusicBrainz::Server::Controller::WS::js::Edit::submit_edits(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x558a62e18810), MusicBrainz::Server=HASH(0x558a6a1a1238), HASH(0x558a6a4903a0)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 750 MusicBrainz::Server::Controller::WS::js::Edit::create(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x558a62e18810), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 374 Catalyst::Action::execute(Catalyst::Action=HASH(0x558a6332c290), MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x558a62e18810), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2067 eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2067 Catalyst::execute(MusicBrainz::Server=HASH(0x558a6a1a1238), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x558a6332c290)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34 Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x558a6a1a1238), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x558a6332c290)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 368 Catalyst::Action::dispatch(Catalyst::Action=HASH(0x558a6332c290), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/ActionChain.pm line 74 Catalyst::ActionChain::_dispatch_chain_actions(Catalyst::ActionChain=HASH(0x558a6a523f50), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/ActionChain.pm line 43 Catalyst::ActionChain::dispatch(Catalyst::ActionChain=HASH(0x558a6a523f50), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Controller.pm line 170 Catalyst::Controller::_ACTION(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x558a62e18810), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 374 Catalyst::Action::execute(Catalyst::Action=HASH(0x558a63326460), MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x558a62e18810), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2067 eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2067 Catalyst::execute(MusicBrainz::Server=HASH(0x558a6a1a1238), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x558a63326460)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34 Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x558a6a1a1238), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x558a63326460)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 368 Catalyst::Action::dispatch(Catalyst::Action=HASH(0x558a63326460), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 261 Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x558a564d3a40), "forward", MusicBrainz::Server=HASH(0x558a6a1a1238), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 241 Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x558a564d3a40), MusicBrainz::Server=HASH(0x558a6a1a1238), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 489 Catalyst::forward(MusicBrainz::Server=HASH(0x558a6a1a1238), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Controller.pm line 134 Catalyst::Controller::_DISPATCH(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x558a62e18810), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 374 Catalyst::Action::execute(Catalyst::Action=HASH(0x558a6331e118), MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x558a62e18810), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2067 eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2067 Catalyst::execute(MusicBrainz::Server=HASH(0x558a6a1a1238), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x558a6331e118)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34 Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x558a6a1a1238), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x558a6331e118)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 368 Catalyst::Action::dispatch(Catalyst::Action=HASH(0x558a6331e118), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 261 Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x558a564d3a40), "forward", MusicBrainz::Server=HASH(0x558a6a1a1238), "/ws/js/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 241 Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x558a564d3a40), MusicBrainz::Server=HASH(0x558a6a1a1238), "/ws/js/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 489 Catalyst::forward(MusicBrainz::Server=HASH(0x558a6a1a1238), "/ws/js/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 107 Catalyst::Dispatcher::dispatch(Catalyst::Dispatcher=HASH(0x558a564d3a40), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2013 Catalyst::dispatch(MusicBrainz::Server=HASH(0x558a6a1a1238)) called at lib/MusicBrainz/Server.pm line 402 MusicBrainz::Server::ANON() called at lib/MusicBrainz/Server.pm line 367 MusicBrainz::Server::with_translations(MusicBrainz::Server=HASH(0x558a6a1a1238), CODE(0x558a669e5868)) called at lib/MusicBrainz/Server.pm line 403 Class::MOP::Class:::around(CODE(0x558a55acde80), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 166 Class::MOP::Method::Wrapped::ANON(MusicBrainz::Server=HASH(0x558a6a1a1238)) called at lib/MusicBrainz/Server.pm line 417 Class::MOP::Class:::around(CODE(0x558a6313d3e0), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 166 Class::MOP::Method::Wrapped::ANON(MusicBrainz::Server=HASH(0x558a6a1a1238)) called at lib/MusicBrainz/Server.pm line 536 Class::MOP::Class:::around(CODE(0x558a6313cfd8), MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 166 Class::MOP::Method::Wrapped::ANON(MusicBrainz::Server=HASH(0x558a6a1a1238)) 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(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 97 MusicBrainz::Server::dispatch(MusicBrainz::Server=HASH(0x558a6a1a1238)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2419 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(0x558a6a507fa0), Try::Tiny::Catch=REF(0x558a66a15bb0)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2428 Catalyst::handle_request("MusicBrainz::Server", "env", HASH(0x558a669d0f88), "response_cb", CODE(0x558a6a37bac8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Engine.pm line 807 Catalyst::Engine::ANON(CODE(0x558a6a37bac8)) 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(0x558a65c3fdb8), Try::Tiny::Catch=REF(0x558a65aa4828)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Middleware/HTTPExceptions.pm line 41 Plack::Middleware::HTTPExceptions::ANON(CODE(0x558a6a2deb48)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339 Plack::Util::ANON(CODE(0x558a6a4488e8)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339 Plack::Util::ANON(CODE(0x558a6a3f8a20)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339 Plack::Util::ANON(CODE(0x558a69b5c660)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339 Plack::Util::ANON(CODE(0x558a6a3e6718)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339 Plack::Util::ANON_(CODE(0x558a6a1e8398)) called at /home/musicbrainz/carton-local/lib/perl5/Starlet/Server.pm line 377 Starlet::Server::handle_connection(Plack::Handler::Starlet=HASH(0x558a606534a8), HASH(0x558a669d0f88), IO::Socket::INET=GLOB(0x558a669eb228), CODE(0x558a633c89f8), "", "", "") called at /home/musicbrainz/carton-local/lib/perl5/Starlet/Server.pm line 190 Starlet::Server::accept_loop(Plack::Handler::Starlet=HASH(0x558a606534a8), CODE(0x558a633c89f8), 81) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Handler/Starlet.pm line 80 Plack::Handler::Starlet::run(Plack::Handler::Starlet=HASH(0x558a606534a8), CODE(0x558a633c89f8)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Loader.pm line 84 Plack::Loader::run(Plack::Loader=HASH(0x558a4f3ce420), Plack::Handler::Starlet=HASH(0x558a606534a8)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Runner.pm line 279 Plack::Runner::run(Plack::Runner=HASH(0x558a4f0c5940)) called at /home/musicbrainz/carton-local/bin/plackup line 7
