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

500 internal error searching for a discid

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Bug fixes, 2011-07-25
    • Component/s: Web service
    • Labels:
      None

      Description

      When searching for the following discid:

      .m7fRJJlbilsCTh2jBsCd6GqTgk-

      with the following query:

      http://musicbrainz.org/ws/2/discid/.m7fRJJlbilsCTh2jBsCd6GqTgk-

      I get the following:

      Internal Server Error
      Oops, something went wrong!

      Error:

      Caught exception in MusicBrainz::Server::Controller::WS::2::DiscID->discid "Failed query: 'SELECT release.id, release.gid, name.name, release.artist_credit AS artist_credit_id, release_group, release.status, release.packaging, date_year, date_month, date_day, release.country, release.comment, release.edits_pending, release.barcode, release.script, release.language, release.quality, release.last_updated FROM release JOIN release_name name ON release.name=name.id WHERE release.id IN ( SELECT release FROM medium WHERE medium.id IN () ) OFFSET ?' (0) DBD::Pg::st execute failed: ERROR: syntax error at or near ")" LINE 6: WHERE medium.id IN () ^ at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 79. at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 84 Sql::_ANON_('DBD::Pg::st execute failed: ERROR: syntax error at or near "...') called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100 Try::Tiny::try('CODE(0xad88dd0)', 'Try::Tiny::Catch=REF(0xada01e0)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 86 Sql::select('Sql=HASH(0x96a9378)', 'SELECT release.id, release.gid, name.name, release.artist_cre...', 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Utils.pm line 217 MusicBrainz::Server::Data::Utils::query_to_list('Sql=HASH(0x96a9378)', 'CODE(0xada71e0)', 'SELECT release.id, release.gid, name.name, release.artist_cre...', 0) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Release.pm line 431 MusicBrainz::Server::Data::Release::find_by_medium('MusicBrainz::Server::Data::Release=HASH(0x85f86d0)', 'ARRAY(0xad85f88)', undef, undef) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/WS/2/DiscID.pm line 42 MusicBrainz::Server::Controller::WS::2::DiscID::discid('MusicBrainz::Server::Controller::WS::2::DiscID=HASH(0x8dc4c98)', 'MusicBrainz::Server=HASH(0xad8c9b0)', '.m7fRJJlbilsCTh2jBsCd6GqTgk-') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0x91c6498)', 'MusicBrainz::Server::Controller::WS::2::DiscID=HASH(0x8dc4c98)', 'MusicBrainz::Server=HASH(0xad8c9b0)', '.m7fRJJlbilsCTh2jBsCd6GqTgk-') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665 eval

      {...} called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665 Catalyst::execute('MusicBrainz::Server=HASH(0xad8c9b0)', 'MusicBrainz::Server::Controller::WS::2::DiscID', 'Catalyst::Action=HASH(0x91c6498)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xad8c9b0)', 'MusicBrainz::Server::Controller::WS::2::DiscID', 'Catalyst::Action=HASH(0x91c6498)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0x91c6498)', 'MusicBrainz::Server=HASH(0xad8c9b0)') called at /usr/local/share/perl/5.10.1/Catalyst/ActionChain.pm line 39 Catalyst::ActionChain::dispatch('Catalyst::ActionChain=HASH(0xad91a00)', 'MusicBrainz::Server=HASH(0xad8c9b0)') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 110 Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::WS::2::DiscID=HASH(0x8dc4c98)', 'MusicBrainz::Server=HASH(0xad8c9b0)', '.m7fRJJlbilsCTh2jBsCd6GqTgk-') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0x91c4280)', 'MusicBrainz::Server::Controller::WS::2::DiscID=HASH(0x8dc4c98)', 'MusicBrainz::Server=HASH(0xad8c9b0)', '.m7fRJJlbilsCTh2jBsCd6GqTgk-') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665 eval {...}

      called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665 Catalyst::execute('MusicBrainz::Server=HASH(0xad8c9b0)', 'MusicBrainz::Server::Controller::WS::2::DiscID', 'Catalyst::Action=HASH(0x91c4280)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xad8c9b0)', 'MusicBrainz::Server::Controller::WS::2::DiscID', 'Catalyst::Action=HASH(0x91c4280)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0x91c4280)', 'MusicBrainz::Server=HASH(0xad8c9b0)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257 Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x1720698)', 'forward', 'MusicBrainz::Server=HASH(0xad8c9b0)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237 Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x1720698)', 'MusicBrainz::Server=HASH(0xad8c9b0)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377 Catalyst::forward('MusicBrainz::Server=HASH(0xad8c9b0)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 84 Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::WS::2::DiscID=HASH(0x8dc4c98)', 'MusicBrainz::Server=HASH(0xad8c9b0)', '.m7fRJJlbilsCTh2jBsCd6GqTgk-') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0x91c3668)', 'MusicBrainz::Server::Controller::WS::2::DiscID=HASH(0x8dc4c98)', 'MusicBrainz::Server=HASH(0xad8c9b0)', '.m7fRJJlbilsCTh2jBsCd6GqTgk-') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665 eval

      {...} called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665 Catalyst::execute('MusicBrainz::Server=HASH(0xad8c9b0)', 'MusicBrainz::Server::Controller::WS::2::DiscID', 'Catalyst::Action=HASH(0x91c3668)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xad8c9b0)', 'MusicBrainz::Server::Controller::WS::2::DiscID', 'Catalyst::Action=HASH(0x91c3668)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0x91c3668)', 'MusicBrainz::Server=HASH(0xad8c9b0)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257 Catalyst::Dispatcher::do_forward('Catalyst::Dispatcher=HASH(0x1720698)', 'forward', 'MusicBrainz::Server=HASH(0xad8c9b0)', '/ws/2/discid/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237 Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x1720698)', 'MusicBrainz::Server=HASH(0xad8c9b0)', '/ws/2/discid/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377 Catalyst::forward('MusicBrainz::Server=HASH(0xad8c9b0)', '/ws/2/discid/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 105 Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x1720698)', 'MusicBrainz::Server=HASH(0xad8c9b0)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1611 Catalyst::dispatch('MusicBrainz::Server=HASH(0xad8c9b0)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/Static/Simple.pm line 76 Class::MOP::Class:::around('CODE(0x1d80440)', 'MusicBrainz::Server=HASH(0xad8c9b0)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159 Class::MOP::Method::Wrapped::ANON('MusicBrainz::Server=HASH(0xad8c9b0)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 258 Class::MOP::Class:::around('CODE(0x92ed528)', 'MusicBrainz::Server=HASH(0xad8c9b0)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159 Class::MOP::Method::Wrapped::ANON_('MusicBrainz::Server=HASH(0xad8c9b0)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 89 MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xad8c9b0)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1952 eval {...}

      called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1943 Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0x2ad8210)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/AutoRestart.pm line 114 Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0x2ad8210)') called at /usr/local/share/perl/5.10.1/Catalyst/Engine/FastCGI.pm line 149 Catalyst::Engine::FastCGI::run('Catalyst::Engine::FastCGI=HASH(0x2aa3d70)', 'MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x60dd48)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 2396 Catalyst::run('MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x60dd48)') called at ./script/musicbrainz_fastcgi.pl line 28"

      Stack trace:
      line 217 MusicBrainz::Server::Data::Utils
      line 431 MusicBrainz::Server::Data::Release
      line 42 MusicBrainz::Server::Controller::WS::2::DiscID
      line 258 MusicBrainz::Server
      Request data:

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

        Attachments

          Activity

            People

            • Assignee:
              acid2 Oliver Charles
              Reporter:
              adhawkins Andy Hawkins
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                Bug fixes, 2011-07-25