-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
None
The URL here is of the form /collection/ID/edits (the error is from a private collection, so the actual URL isn't very useful).
Presumably related to MBS-8117, but it definitely shouldn't be ISEing.
Fehler:
Caught exception in MusicBrainz::Server::Controller::Collection->edits "57014 DBD::Pg::st execute failed: ERROR: canceling statement due to statement timeout at lib/MusicBrainz/Server/Connector.pm line 45, line 3.
at lib/Sql.pm line 465, line 3.
Sql::_ANON_("57014 DBD::Pg::st execute failed: ERROR: canceling statement"...) called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100
Try::Tiny::try(CODE(0x174d0180), Try::Tiny::Catch=REF(0x175599f8), Try::Tiny::Finally=REF(0x17538098)) called at lib/Sql.pm line 469
Sql::_select_list(Sql=HASH(0x178878e0), "\xUnknown macro: {a}WITH x AS (SELECT edit.id, edit.editor, edit.open_ti"..., ARRAY(0x17d549b0), "hashref") called at lib/Sql.pm line 497
Sql::select_list_of_hashes(Sql=HASH(0x178878e0), "\xWITH x AS (SELECT edit.id, edit.editor, edit.open_ti"..., 34895, 34895, 0) called at lib/MusicBrainz/Server/Data/Utils.pm line 256
MusicBrainz::Server::Data::Utils::query_to_list_limited(Sql=HASH(0x178878e0), 0, 50, CODE(0x177eda48), "SELECT edit.id, edit.editor, edit.open_time, edit.expire_time"..., 34895, 34895, 0) called at lib/MusicBrainz/Server/Data/Edit.pm line 180
MusicBrainz::Server::Data::Edit::find_by_collection(MusicBrainz::Server::Data::Edit=HASH(0xcd35188), 34895, 50, 0, undef) called at lib/MusicBrainz/Server/Controller/Collection.pm line 190
MusicBrainz::Server::Controller::Collection::_ANON_(50, 0) called at lib/MusicBrainz/Server/Controller.pm line 256
MusicBrainz::Server::Controller::_load_paged(MusicBrainz::Server::Controller::Collection=HASH(0xafecd08), MusicBrainz::Server=HASH(0x16da4b50), CODE(0x16d56638)) called at lib/MusicBrainz/Server/Controller/Collection.pm line 191
MusicBrainz::Server::Controller::Collection::_list_edits(MusicBrainz::Server::Controller::Collection=HASH(0xafecd08), MusicBrainz::Server=HASH(0x16da4b50)) called at lib/MusicBrainz/Server/Controller/Collection.pm line 175
MusicBrainz::Server::Controller::Collection::edits(MusicBrainz::Server::Controller::Collection=HASH(0xafecd08), MusicBrainz::Server=HASH(0x16da4b50)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute(Catalyst::Action=HASH(0xe498090), MusicBrainz::Server::Controller::Collection=HASH(0xafecd08), MusicBrainz::Server=HASH(0x16da4b50)) 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(0x16da4b50), "MusicBrainz::Server::Controller::Collection", Catalyst::Action=HASH(0xe498090)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x16da4b50), "MusicBrainz::Server::Controller::Collection", Catalyst::Action=HASH(0xe498090)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch(Catalyst::Action=HASH(0xe498090), MusicBrainz::Server=HASH(0x16da4b50)) called at /home/beta/perl5/lib/perl5/Catalyst/ActionChain.pm line 41
Catalyst::ActionChain::dispatch(Catalyst::ActionChain=HASH(0x17545358), MusicBrainz::Server=HASH(0x16da4b50)) called at /home/beta/perl5/lib/perl5/Catalyst/Controller.pm line 158
Catalyst::Controller::_ACTION(MusicBrainz::Server::Controller::Collection=HASH(0xafecd08), MusicBrainz::Server=HASH(0x16da4b50)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute(Catalyst::Action=HASH(0xe3d5cb8), MusicBrainz::Server::Controller::Collection=HASH(0xafecd08), MusicBrainz::Server=HASH(0x16da4b50)) 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(0x16da4b50), "MusicBrainz::Server::Controller::Collection", Catalyst::Action=HASH(0xe3d5cb8)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x16da4b50), "MusicBrainz::Server::Controller::Collection", Catalyst::Action=HASH(0xe3d5cb8)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch(Catalyst::Action=HASH(0xe3d5cb8), MusicBrainz::Server=HASH(0x16da4b50)) called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x3be3180), "forward", MusicBrainz::Server=HASH(0x16da4b50), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x3be3180), MusicBrainz::Server=HASH(0x16da4b50), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst.pm line 373
Catalyst::forward(MusicBrainz::Server=HASH(0x16da4b50), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst/Controller.pm line 132
Catalyst::Controller::_DISPATCH(MusicBrainz::Server::Controller::Collection=HASH(0xafecd08), MusicBrainz::Server=HASH(0x16da4b50)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute(Catalyst::Action=HASH(0xe3d5838), MusicBrainz::Server::Controller::Collection=HASH(0xafecd08), MusicBrainz::Server=HASH(0x16da4b50)) 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(0x16da4b50), "MusicBrainz::Server::Controller::Collection", Catalyst::Action=HASH(0xe3d5838)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x16da4b50), "MusicBrainz::Server::Controller::Collection", Catalyst::Action=HASH(0xe3d5838)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch(Catalyst::Action=HASH(0xe3d5838), MusicBrainz::Server=HASH(0x16da4b50)) called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x3be3180), "forward", MusicBrainz::Server=HASH(0x16da4b50), "/collection/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x3be3180), MusicBrainz::Server=HASH(0x16da4b50), "/collection/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst.pm line 373
Catalyst::forward(MusicBrainz::Server=HASH(0x16da4b50), "/collection/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 105
Catalyst::Dispatcher::dispatch(Catalyst::Dispatcher=HASH(0x3be3180), MusicBrainz::Server=HASH(0x16da4b50)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1633
Catalyst::dispatch(MusicBrainz::Server=HASH(0x16da4b50)) called at lib/MusicBrainz/Server.pm line 330
MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 304
MusicBrainz::Server::with_translations(MusicBrainz::Server=HASH(0x16da4b50), CODE(0x178a5d00)) called at lib/MusicBrainz/Server.pm line 331
Class::MOP::Class:::around(CODE(0x3025e08), MusicBrainz::Server=HASH(0x16da4b50)) 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(0x16da4b50)) called at lib/MusicBrainz/Server.pm line 345
Class::MOP::Class:::around(CODE(0xe7a5520), MusicBrainz::Server=HASH(0x16da4b50)) 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(0x16da4b50)) called at lib/MusicBrainz/Server.pm line 391
Class::MOP::Class:::around(CODE(0xe7a5b80), MusicBrainz::Server=HASH(0x16da4b50)) 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(0x16da4b50)) 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(0x16da4b50)) 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(0x16da4b50)) 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(0x16bfb988), Try::Tiny::Catch=REF(0x16bfc5d0)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1998
Catalyst::handle_request("MusicBrainz::Server", "env", HASH(0x16bdad40), "response_cb", CODE(0x1695bd90)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
Catalyst::Plugin::AutoRestart::handle_request("MusicBrainz::Server", "env", HASH(0x16bdad40), "response_cb", CODE(0x1695bd90)) called at /home/beta/perl5/lib/perl5/Catalyst/Engine.pm line 697
Catalyst::Engine::_ANON_(CODE(0x1695bd90)) called at /home/beta/perl5/lib/perl5/Plack/Handler/FCGI.pm line 136
Plack::Handler::FCGI::run(Plack::Handler::FCGI=HASH(0x107d8c8), CODE(0xe7cdc98)) called at /home/beta/perl5/lib/perl5/Plack/Loader.pm line 84
Plack::Loader::run(Plack::Loader=HASH(0x1054f10), Plack::Handler::FCGI=HASH(0x107d8c8)) called at /home/beta/perl5/lib/perl5/Plack/Runner.pm line 277
Plack::Runner::run(Plack::Runner=HASH(0xdf4500)) called at /home/beta/perl5/bin/plackup line 10"Stack-Trace:
line 256 MusicBrainz::Server::Data::Utils
line 180 MusicBrainz::Server::Data::Edit
line 190 MusicBrainz::Server::Controller::Collection
line 256 MusicBrainz::Server::Controller
line 191 MusicBrainz::Server::Controller::Collection
line 175 MusicBrainz::Server::Controller::Collection
line 330 MusicBrainz::Server
line 304 MusicBrainz::Server
line 331 MusicBrainz::Server
line 345 MusicBrainz::Server
line 391 MusicBrainz::ServerAnfragedaten:
$VAR1 = {
'query_parameters' => {},
'body_parameters' => {}
};Zeit: 2015-01-16 09:43:20 UTC
Host: pino
- has related issue
-
MBS-8368 Edit queries for large collections time out
- Closed