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

Internal server error when webservice offset parameter is too large

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Normal Normal
    • None
    • None
    • Web service
    • None

      http://musicbrainz.org/ws/2/release-group/?artist=8208d8f9-61b6-47f2-90c0-2680dadd56a8&limit=30&offset=9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999&type=album

      Ohje! Da ist wohl etwas schief gegangen.

      Fehler:

      Caught exception in MusicBrainz::Server::Controller::WS::2::ReleaseGroup->release_group_browse "DBD::Pg::st execute failed: ERROR: value "9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999" is out of range for type bigint
      ZEILE 34: OFFSET '99999999999999999999999999999999999...
      ^ at lib/Sql.pm line 443.
      at lib/Sql.pm line 456.
      Sql::_ANON_("DBD::Pg::st execute failed: ERROR: value \"999999999999999999"...) called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100
      Try::Tiny::try(CODE(0x1443c9c8), Try::Tiny::Catch=REF(0x14366d48), Try::Tiny::Finally=REF(0x1433d1c0)) called at lib/Sql.pm line 460
      Sql::_select_list(Sql=HASH(0x151a2d50), "\x

      Unknown macro: {a}

      WITH x AS (SELECT DISTINCT rg.id, rg.gid, rg.type AS"..., ARRAY(0x143df0d0), "hashref") called at lib/Sql.pm line 488
      Sql::select_list_of_hashes(Sql=HASH(0x151a2d50), "\x

      WITH x AS (SELECT DISTINCT rg.id, rg.gid, rg.type AS"..., ARRAY(0x152f01e8), 785841, 9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999) called at lib/MusicBrainz/Server/Data/Utils.pm line 263
      MusicBrainz::Server::Data::Utils::query_to_list_limited(Sql=HASH(0x151a2d50), 9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999, 30, CODE(0x14f272e0), "SELECT DISTINCT rg.id, rg.gid, rg.type AS primary_type_id, rg"..., ARRAY(0x152f01e8), 785841, 9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999) called at lib/MusicBrainz/Server/Data/ReleaseGroup.pm line 190
      MusicBrainz::Server::Data::ReleaseGroup::find_by_artist(MusicBrainz::Server::Data::ReleaseGroup=HASH(0xc64ec40), 785841, 1, 30, 9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999, "filter", HASH(0x14451b00)) called at lib/MusicBrainz/Server/Controller/WS/2/ReleaseGroup.pm line 114
      MusicBrainz::Server::Controller::WS::2::ReleaseGroup::release_group_browse(MusicBrainz::Server::Controller::WS::2::ReleaseGroup=HASH(0xcef6f68), MusicBrainz::Server=HASH(0x14535c48)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(Catalyst::Action=HASH(0xd3d07f0), MusicBrainz::Server::Controller::WS::2::ReleaseGroup=HASH(0xcef6f68), MusicBrainz::Server=HASH(0x14535c48)) 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(0x14535c48), "MusicBrainz::Server::Controller::WS::2::ReleaseGroup", Catalyst::Action=HASH(0xd3d07f0)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
      Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x14535c48), "MusicBrainz::Server::Controller::WS::2::ReleaseGroup", Catalyst::Action=HASH(0xd3d07f0)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0xd3d07f0), MusicBrainz::Server=HASH(0x14535c48)) called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x3f47aa0), "detach", MusicBrainz::Server=HASH(0x14535c48), "release_group_browse") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 270
      Catalyst::Dispatcher::detach(Catalyst::Dispatcher=HASH(0x3f47aa0), MusicBrainz::Server=HASH(0x14535c48), "release_group_browse") called at /home/beta/perl5/lib/perl5/Catalyst.pm line 388
      Catalyst::detach(MusicBrainz::Server=HASH(0x14535c48), "release_group_browse") called at lib/MusicBrainz/Server/Controller/WS/2/ReleaseGroup.pm line 142
      MusicBrainz::Server::Controller::WS::2::ReleaseGroup::release_group_search(MusicBrainz::Server::Controller::WS::2::ReleaseGroup=HASH(0xcef6f68), MusicBrainz::Server=HASH(0x14535c48)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(Catalyst::Action=HASH(0xd3d12a8), MusicBrainz::Server::Controller::WS::2::ReleaseGroup=HASH(0xcef6f68), MusicBrainz::Server=HASH(0x14535c48)) 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(0x14535c48), "MusicBrainz::Server::Controller::WS::2::ReleaseGroup", Catalyst::Action=HASH(0xd3d12a8)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
      Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x14535c48), "MusicBrainz::Server::Controller::WS::2::ReleaseGroup", Catalyst::Action=HASH(0xd3d12a8)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0xd3d12a8), MusicBrainz::Server=HASH(0x14535c48)) called at /home/beta/perl5/lib/perl5/Catalyst/ActionChain.pm line 41
      Catalyst::ActionChain::dispatch(Catalyst::ActionChain=HASH(0x150a6608), MusicBrainz::Server=HASH(0x14535c48)) called at /home/beta/perl5/lib/perl5/Catalyst/Controller.pm line 158
      Catalyst::Controller::_ACTION(MusicBrainz::Server::Controller::WS::2::ReleaseGroup=HASH(0xcef6f68), MusicBrainz::Server=HASH(0x14535c48)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(Catalyst::Action=HASH(0xd3c9170), MusicBrainz::Server::Controller::WS::2::ReleaseGroup=HASH(0xcef6f68), MusicBrainz::Server=HASH(0x14535c48)) 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(0x14535c48), "MusicBrainz::Server::Controller::WS::2::ReleaseGroup", Catalyst::Action=HASH(0xd3c9170)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
      Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x14535c48), "MusicBrainz::Server::Controller::WS::2::ReleaseGroup", Catalyst::Action=HASH(0xd3c9170)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0xd3c9170), MusicBrainz::Server=HASH(0x14535c48)) called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x3f47aa0), "forward", MusicBrainz::Server=HASH(0x14535c48), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x3f47aa0), MusicBrainz::Server=HASH(0x14535c48), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst.pm line 373
      Catalyst::forward(MusicBrainz::Server=HASH(0x14535c48), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst/Controller.pm line 132
      Catalyst::Controller::_DISPATCH(MusicBrainz::Server::Controller::WS::2::ReleaseGroup=HASH(0xcef6f68), MusicBrainz::Server=HASH(0x14535c48)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(Catalyst::Action=HASH(0xd3c8c78), MusicBrainz::Server::Controller::WS::2::ReleaseGroup=HASH(0xcef6f68), MusicBrainz::Server=HASH(0x14535c48)) 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(0x14535c48), "MusicBrainz::Server::Controller::WS::2::ReleaseGroup", Catalyst::Action=HASH(0xd3c8c78)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
      Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x14535c48), "MusicBrainz::Server::Controller::WS::2::ReleaseGroup", Catalyst::Action=HASH(0xd3c8c78)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0xd3c8c78), MusicBrainz::Server=HASH(0x14535c48)) called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x3f47aa0), "forward", MusicBrainz::Server=HASH(0x14535c48), "/ws/2/releasegroup/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x3f47aa0), MusicBrainz::Server=HASH(0x14535c48), "/ws/2/releasegroup/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst.pm line 373
      Catalyst::forward(MusicBrainz::Server=HASH(0x14535c48), "/ws/2/releasegroup/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch(Catalyst::Dispatcher=HASH(0x3f47aa0), MusicBrainz::Server=HASH(0x14535c48)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1633
      Catalyst::dispatch(MusicBrainz::Server=HASH(0x14535c48)) called at lib/MusicBrainz/Server.pm line 335
      MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 309
      MusicBrainz::Server::with_translations(MusicBrainz::Server=HASH(0x14535c48), CODE(0x15639138)) called at lib/MusicBrainz/Server.pm line 336
      Class::MOP::Class:::around(CODE(0x33eb938), MusicBrainz::Server=HASH(0x14535c48)) 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(0x14535c48)) called at lib/MusicBrainz/Server.pm line 350
      Class::MOP::Class:::around(CODE(0xd3d1548), MusicBrainz::Server=HASH(0x14535c48)) 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(0x14535c48)) called at lib/MusicBrainz/Server.pm line 395
      Class::MOP::Class:::around(CODE(0xd3d1ba8), MusicBrainz::Server=HASH(0x14535c48)) 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(0x14535c48)) 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(0x14535c48)) 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(0x14535c48)) 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

      Unknown macro: {...}

      called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
      Try::Tiny::try(CODE(0x15159690), Try::Tiny::Catch=REF(0x143811d8)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1998
      Catalyst::handle_request("MusicBrainz::Server", "env", HASH(0x145199a8), "response_cb", CODE(0x143a8b58)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request("MusicBrainz::Server", "env", HASH(0x145199a8), "response_cb", CODE(0x143a8b58)) called at /home/beta/perl5/lib/perl5/Catalyst/Engine.pm line 697
      Catalyst::Engine::_ANON_(CODE(0x143a8b58)) called at /home/beta/perl5/lib/perl5/Plack/Handler/FCGI.pm line 136
      Plack::Handler::FCGI::run(Plack::Handler::FCGI=HASH(0x12e3ab8), CODE(0xd3fb048)) called at /home/beta/perl5/lib/perl5/Plack/Loader.pm line 84
      Plack::Loader::run(Plack::Loader=HASH(0x12baeb0), Plack::Handler::FCGI=HASH(0x12e3ab8)) called at /home/beta/perl5/lib/perl5/Plack/Runner.pm line 277
      Plack::Runner::run(Plack::Runner=HASH(0x1058600)) called at /home/beta/perl5/bin/plackup line 10"

      Stack-Trace:
      line 335 MusicBrainz::Server
      line 309 MusicBrainz::Server
      line 336 MusicBrainz::Server
      line 350 MusicBrainz::Server
      line 395 MusicBrainz::Server

      Anfragedaten:
      $VAR1 = {
      'query_parameters' =>

      Unknown macro: { 'artist' => '8208d8f9-61b6-47f2-90c0-2680dadd56a8', 'type' => 'album', 'limit' => '30', 'offset' => '9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999' }

      ,
      'body_parameters' => {}
      };

      Zeit: 2014-05-14 08:30:24 UTC

      Host: pino

      Oberflächensprache: de

      URL: https://beta.musicbrainz.org/ws/2/release-group/?artist=8208d8f9-61b6-47f2-90c0-2680dadd56a8&limit=30&offset=9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999&type=album

            Unassigned Unassigned
            nikki nikki
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:

                Version Package