-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
None
https://beta.musicbrainz.org/edit/30608051 is deleting a track, but is currently stuck. Trying to approve it gives an ISE:
Caught exception in MusicBrainz::Server::Controller::Edit->approve "DBD::Pg::st execute failed: ERROR: update or delete on table "track" violates foreign key constraint "track_gid_redirect_fk_new_id" on table "track_gid_redirect"
DETAIL: Key (id)=(11272243) is still referenced from table "track_gid_redirect". at lib/Sql.pm line 453, line 3.
at lib/Sql.pm line 466, line 3.
Sql::_ANON_("DBD::Pg::st execute failed: ERROR: update or delete on table"...) called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100
Try::Tiny::try(CODE(0x158985e8), Try::Tiny::Catch=REF(0x156a8bd8), Try::Tiny::Finally=REF(0x10c633b8)) called at lib/Sql.pm line 470
Sql::_select_list(Sql=HASH(0x10b87738), "DELETE FROM track WHERE id IN RETURNING medium", ARRAY(0x158979d0), "arrayref", CODE(0x4925328)) called at lib/Sql.pm line 489
Sql::select_list_of_lists(Sql=HASH(0x10b87738), "DELETE FROM track WHERE id IN RETURNING medium", 11272243) called at lib/Sql.pm line 420
Sql::select_single_column_array(Sql=HASH(0x10b87738), "DELETE FROM track WHERE id IN RETURNING medium", 11272243) called at lib/MusicBrainz/Server/Data/Track.pm line 195
MusicBrainz::Server::Data::Track::delete(MusicBrainz::Server::Data::Track=HASH(0xd670778), 11272243) called at lib/MusicBrainz/Server/Edit/Medium/Edit.pm line 494
MusicBrainz::Server::Edit::Medium::Edit::accept(MusicBrainz::Server::Edit::Medium::Edit=HASH(0x1543ff20)) called at lib/MusicBrainz/Server/Data/Edit.pm line 669
MusicBrainz::Server::Data::Edit::_ANON_() called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 71
evalUnknown macro: {...}called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
Try::Tiny::try(CODE(0x15886358), Try::Tiny::Catch=REF(0x1594c5f8)) called at lib/MusicBrainz/Server/Data/Edit.pm line 704
MusicBrainz::Server::Data::Edit::_do_accept(MusicBrainz::Server::Data::Edit=HASH(0xc973d28), MusicBrainz::Server::Edit::Medium::Edit=HASH(0x1543ff20)) called at lib/MusicBrainz/Server/Data/Edit.pm line 743
MusicBrainz::Server::Data::Edit::_ANON_(MusicBrainz::Server::Edit::Medium::Edit=HASH(0x1543ff20)) called at lib/MusicBrainz/Server/Data/Edit.pm line 766
MusicBrainz::Server::Data::Edit::_close(MusicBrainz::Server::Data::Edit=HASH(0xc973d28), MusicBrainz::Server::Edit::Medium::Edit=HASH(0x1543ff20), CODE(0x15655c40)) called at lib/MusicBrainz/Server/Data/Edit.pm line 743
MusicBrainz::Server::Data::Edit::accept(MusicBrainz::Server::Data::Edit=HASH(0xc973d28), MusicBrainz::Server::Edit::Medium::Edit=HASH(0x1543ff20)) called at lib/MusicBrainz/Server/Data/Edit.pm line 661
MusicBrainz::Server::Data::Edit::approve(MusicBrainz::Server::Data::Edit=HASH(0xc973d28), MusicBrainz::Server::Edit::Medium::Edit=HASH(0x1543ff20), 53705) called at lib/MusicBrainz/Server/Controller/Edit.pm line 129
MusicBrainz::Server::Controller::Edit::_ANON_() called at lib/Sql.pm line 316
Sql::_ANON_() called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 71
evalcalled at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
Try::Tiny::try(CODE(0x1547eff8), Try::Tiny::Catch=REF(0x1543e120)) called at lib/Sql.pm line 330
Sql::_auto_transaction(CODE(0x10bcb670), Sql=HASH(0x10b87738)) called at lib/Sql.pm line 335
Sql::_run_in_transaction_one(CODE(0x10bcb670), Sql=HASH(0x10b87738)) called at lib/Sql.pm line 349
Sql::run_in_transaction(CODE(0x10bcb670), Sql=HASH(0x10b87738)) called at lib/MusicBrainz/Server/Model/MB.pm line 19
MusicBrainz::Server::Model::MB::with_transaction(MusicBrainz::Server::Model::MB=HASH(0xc18bee8), CODE(0x10bcb670)) called at lib/MusicBrainz/Server/Controller/Edit.pm line 133
MusicBrainz::Server::Controller::Edit::approve(MusicBrainz::Server::Controller::Edit=HASH(0xdcff2f0), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute(Catalyst::Action=HASH(0xe0fbb10), MusicBrainz::Server::Controller::Edit=HASH(0xdcff2f0), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
evalUnknown macro: {...}called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
Catalyst::execute(MusicBrainz::Server=HASH(0x15916908), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xe0fbb10)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x15916908), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xe0fbb10)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch(Catalyst::Action=HASH(0xe0fbb10), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/Catalyst/ActionChain.pm line 41
Catalyst::ActionChain::dispatch(Catalyst::ActionChain=HASH(0x15926ee0), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/Catalyst/Controller.pm line 158
Catalyst::Controller::_ACTION(MusicBrainz::Server::Controller::Edit=HASH(0xdcff2f0), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute(Catalyst::Action=HASH(0xe0fb8d0), MusicBrainz::Server::Controller::Edit=HASH(0xdcff2f0), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
evalcalled at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
Catalyst::execute(MusicBrainz::Server=HASH(0x15916908), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xe0fb8d0)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x15916908), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xe0fb8d0)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch(Catalyst::Action=HASH(0xe0fb8d0), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x38d1618), "forward", MusicBrainz::Server=HASH(0x15916908), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x38d1618), MusicBrainz::Server=HASH(0x15916908), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst.pm line 373
Catalyst::forward(MusicBrainz::Server=HASH(0x15916908), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst/Controller.pm line 132
Catalyst::Controller::_DISPATCH(MusicBrainz::Server::Controller::Edit=HASH(0xdcff2f0), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute(Catalyst::Action=HASH(0xe0f21a0), MusicBrainz::Server::Controller::Edit=HASH(0xdcff2f0), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
evalUnknown macro: {...}called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
Catalyst::execute(MusicBrainz::Server=HASH(0x15916908), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xe0f21a0)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x15916908), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xe0f21a0)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch(Catalyst::Action=HASH(0xe0f21a0), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x38d1618), "forward", MusicBrainz::Server=HASH(0x15916908), "/edit/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x38d1618), MusicBrainz::Server=HASH(0x15916908), "/edit/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst.pm line 373
Catalyst::forward(MusicBrainz::Server=HASH(0x15916908), "/edit/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 105
Catalyst::Dispatcher::dispatch(Catalyst::Dispatcher=HASH(0x38d1618), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1633
Catalyst::dispatch(MusicBrainz::Server=HASH(0x15916908)) called at lib/MusicBrainz/Server.pm line 329
MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 303
MusicBrainz::Server::with_translations(MusicBrainz::Server=HASH(0x15916908), CODE(0x10cbcb48)) called at lib/MusicBrainz/Server.pm line 330
Class::MOP::Class:::around(CODE(0x2d14cd8), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0x15916908)) called at lib/MusicBrainz/Server.pm line 344
Class::MOP::Class:::around(CODE(0xe3e5ee0), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0x15916908)) called at lib/MusicBrainz/Server.pm line 389
Class::MOP::Class:::around(CODE(0xe3e6540), MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 35
Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
MusicBrainz::Server::dispatch(MusicBrainz::Server=HASH(0x15916908)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1992
Catalyst::_ANON_() called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 76
evalcalled at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
Try::Tiny::try(CODE(0x15894af0), Try::Tiny::Catch=REF(0x157f8160)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1998
Catalyst::handle_request("MusicBrainz::Server", "env", HASH(0x1528e138), "response_cb", CODE(0x151f01c0)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
Catalyst::Plugin::AutoRestart::handle_request("MusicBrainz::Server", "env", HASH(0x1528e138), "response_cb", CODE(0x151f01c0)) called at /home/beta/perl5/lib/perl5/Catalyst/Engine.pm line 697
Catalyst::Engine::_ANON_(CODE(0x151f01c0)) called at /home/beta/perl5/lib/perl5/Plack/Handler/FCGI.pm line 136
Plack::Handler::FCGI::run(Plack::Handler::FCGI=HASH(0xd6c8c8), CODE(0xe407180)) called at /home/beta/perl5/lib/perl5/Plack/Loader.pm line 84
Plack::Loader::run(Plack::Loader=HASH(0xd43f10), Plack::Handler::FCGI=HASH(0xd6c8c8)) called at /home/beta/perl5/lib/perl5/Plack/Runner.pm line 277
Plack::Runner::run(Plack::Runner=HASH(0xae34e0)) called at /home/beta/perl5/bin/plackup line 10
at lib/Sql.pm line 330."Stack-Trace:
line 19 MusicBrainz::Server::Model::MB
line 133 MusicBrainz::Server::Controller::Edit
line 329 MusicBrainz::Server
line 303 MusicBrainz::Server
line 330 MusicBrainz::Server
line 344 MusicBrainz::Server
line 389 MusicBrainz::ServerAnfragedaten:
$VAR1 = {
'query_parameters' => {},
'body_parameters' => {}
};