Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-8145

Internal server error loading collection edits

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2015-12-14
    • Component/s: Collections
    • Labels:
      None

      Description

      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), "\x

      Unknown 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), "\x

      WITH 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
      eval

      Unknown 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
      eval

      called 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
      eval

      Unknown 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
      eval

      called 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::Server

      Anfragedaten:
      $VAR1 = {
      'query_parameters' => {},
      'body_parameters' => {}
      };

      Zeit: 2015-01-16 09:43:20 UTC

      Host: pino

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                chirlu Ulrich Klauer
                Reporter:
                nikki nikki
              • Votes:
                1 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  2015-12-14