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

Internal server error when requesting /tracklist/ with an invalid ID

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2013-03-11
    • Component/s: None
    • Labels:
      None

      Description

      https://musicbrainz.org/tracklist/undefined

      Errors:
      Caught exception in MusicBrainz::Server::Controller::Tracklist->tracklist "Failed query: 'SELECT id, track_count FROM tracklist WHERE id IN ' (undefined) DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "undefined" LINE 1: ...ELECT id, track_count FROM tracklist WHERE id IN ('undefined... ^ at lib/Sql.pm line 83. at lib/Sql.pm line 88. Sql::_ANON_('DBD::Pg::st execute failed: ERROR: invalid input syntax for ...') called at local/lib/perl5/Try/Tiny.pm line 100 Try::Tiny::try('CODE(0xc131e38)', 'Try::Tiny::Catch=REF(0xc917d28)') called at lib/Sql.pm line 90 Sql::select('Sql=HASH(0xcf1bf88)', 'SELECT id, track_count FROM tracklist WHERE id IN ', 'undefined') called at lib/MusicBrainz/Server/Data/Entity.pm line 44 MusicBrainz::Server::Data::Entity::_get_by_keys_append_sql('MusicBrainz::Server::Data::Tracklist=HASH(0xb191db8)', 'id', '', 'undefined') called at lib/MusicBrainz/Server/Data/Entity.pm line 31 MusicBrainz::Server::Data::Entity::_get_by_keys('MusicBrainz::Server::Data::Tracklist=HASH(0xb191db8)', 'id', 'undefined') called at lib/MusicBrainz/Server/Data/Entity.pm line 80 MusicBrainz::Server::Data::Entity::get_by_ids('MusicBrainz::Server::Data::Tracklist=HASH(0xb191db8)', 'undefined') called at lib/MusicBrainz/Server/Data/Entity.pm line 58 MusicBrainz::Server::Data::Entity::get_by_id('MusicBrainz::Server::Data::Tracklist=HASH(0xb191db8)', 'undefined') called at lib/MusicBrainz/Server/Controller/Tracklist.pm line 10 MusicBrainz::Server::Controller::Tracklist::tracklist('MusicBrainz::Server::Controller::Tracklist=HASH(0xb956f00)', 'MusicBrainz::Server=HASH(0xcb5e218)', 'undefined') called at local/lib/perl5/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0xbb576a8)', 'MusicBrainz::Server::Controller::Tracklist=HASH(0xb956f00)', 'MusicBrainz::Server=HASH(0xcb5e218)', 'undefined') called at local/lib/perl5/Catalyst.pm line 1672 eval

      Unknown macro: {...}

      called at local/lib/perl5/Catalyst.pm line 1672 Catalyst::execute('MusicBrainz::Server=HASH(0xcb5e218)', 'MusicBrainz::Server::Controller::Tracklist', 'Catalyst::Action=HASH(0xbb576a8)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xcb5e218)', 'MusicBrainz::Server::Controller::Tracklist', 'Catalyst::Action=HASH(0xbb576a8)') called at local/lib/perl5/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbb576a8)', 'MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/Catalyst/ActionChain.pm line 36 Catalyst::ActionChain::dispatch('Catalyst::ActionChain=HASH(0xcb22380)', 'MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/Catalyst/Controller.pm line 158 Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Tracklist=HASH(0xb956f00)', 'MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0xbb57468)', 'MusicBrainz::Server::Controller::Tracklist=HASH(0xb956f00)', 'MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/Catalyst.pm line 1672 eval

      called at local/lib/perl5/Catalyst.pm line 1672 Catalyst::execute('MusicBrainz::Server=HASH(0xcb5e218)', 'MusicBrainz::Server::Controller::Tracklist', 'Catalyst::Action=HASH(0xbb57468)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xcb5e218)', 'MusicBrainz::Server::Controller::Tracklist', 'Catalyst::Action=HASH(0xbb57468)') called at local/lib/perl5/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbb57468)', 'MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257 Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x39b4ea0)', 'forward', 'MusicBrainz::Server=HASH(0xcb5e218)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237 Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x39b4ea0)', 'MusicBrainz::Server=HASH(0xcb5e218)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 362 Catalyst::forward('MusicBrainz::Server=HASH(0xcb5e218)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 132 Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Tracklist=HASH(0xb956f00)', 'MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0xbb57078)', 'MusicBrainz::Server::Controller::Tracklist=HASH(0xb956f00)', 'MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/Catalyst.pm line 1672 eval

      Unknown macro: {...}

      called at local/lib/perl5/Catalyst.pm line 1672 Catalyst::execute('MusicBrainz::Server=HASH(0xcb5e218)', 'MusicBrainz::Server::Controller::Tracklist', 'Catalyst::Action=HASH(0xbb57078)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xcb5e218)', 'MusicBrainz::Server::Controller::Tracklist', 'Catalyst::Action=HASH(0xbb57078)') called at local/lib/perl5/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbb57078)', 'MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257 Catalyst::Dispatcher::do_forward('Catalyst::Dispatcher=HASH(0x39b4ea0)', 'forward', 'MusicBrainz::Server=HASH(0xcb5e218)', '/tracklist/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237 Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x39b4ea0)', 'MusicBrainz::Server=HASH(0xcb5e218)', '/tracklist/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 362 Catalyst::forward('MusicBrainz::Server=HASH(0xcb5e218)', '/tracklist/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105 Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x39b4ea0)', 'MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/Catalyst.pm line 1618 Catalyst::dispatch('MusicBrainz::Server=HASH(0xcb5e218)') called at lib/MusicBrainz/Server.pm line 303 MusicBrainz::Server::ANON() called at lib/MusicBrainz/Server.pm line 295 MusicBrainz::Server::with_translations('MusicBrainz::Server=HASH(0xcb5e218)', 'CODE(0xcb4e3f0)') called at lib/MusicBrainz/Server.pm line 304 Class::MOP::Class:::around('CODE(0x2c191f8)', 'MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162 Class::MOP::Method::Wrapped::ANON('MusicBrainz::Server=HASH(0xcb5e218)') called at lib/MusicBrainz/Server.pm line 317 Class::MOP::Class:::around('CODE(0x4632228)', 'MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162 Class::MOP::Method::Wrapped::ANON('MusicBrainz::Server=HASH(0xcb5e218)') called at lib/MusicBrainz/Server.pm line 362 Class::MOP::Class:::around('CODE(0x9cf0d50)', 'MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162 Class::MOP::Method::Wrapped::ANON('MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 35 Class::MOP::Method::Wrapped::ANON('MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91 MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xcb5e218)') called at local/lib/perl5/Catalyst.pm line 1968 Catalyst::ANON_() called at local/lib/perl5/Try/Tiny.pm line 76 eval

      called at local/lib/perl5/Try/Tiny.pm line 67 Try::Tiny::try('CODE(0xcbc1008)', 'Try::Tiny::Catch=REF(0xcce3b48)') called at local/lib/perl5/Catalyst.pm line 1974 Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xcd3bdf8)', 'response_cb', 'CODE(0xd129f40)') called at local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117 Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xcd3bdf8)', 'response_cb', 'CODE(0xd129f40)') called at local/lib/perl5/Catalyst/Engine.pm line 688 Catalyst::Engine::_ANON_('CODE(0xd129f40)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 130 Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0xf549d0)', 'CODE(0x31b3680)') called at local/lib/perl5/Plack/Loader.pm line 84 Plack::Loader::run('Plack::Loader=HASH(0xe7bc90)', 'Plack::Handler::FCGI=HASH(0xf549d0)') called at local/lib/perl5/Plack/Runner.pm line 267 Plack::Runner::run('Plack::Runner=HASH(0xd04808)') called at local/bin/plackup line 10"
      Caught exception in MusicBrainz::Server::Controller::Tracklist->show "Can't call method "id" on an undefined value at lib/MusicBrainz/Server/Data/Track.pm line 68."

      Stack trace:
      line 68 MusicBrainz::Server::Data::Track
      line 21 MusicBrainz::Server::Controller::Tracklist
      line 303 MusicBrainz::Server
      line 295 MusicBrainz::Server
      line 304 MusicBrainz::Server
      line 317 MusicBrainz::Server
      line 362 MusicBrainz::Server

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

      URL: https://musicbrainz.org/tracklist/undefined

      I would expect a response like the one for https://musicbrainz.org/artist/asdf instead.

        Attachments

          Activity

            People

            • Assignee:
              ianmcorvidae Ian McEwen
              Reporter:
              nikki nikki
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2013-03-11