[ http://tickets.musicbrainz.org/browse/MBS-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chad Wilson updated MBS-2940:
-----------------------------
Fix Version/s: Schema Change, 2011-07-11
Component/s: Web service
> 500 internal error searching for a discid
> -----------------------------------------
>> Key: MBS-2940
> URL: http://tickets.musicbrainz.org/browse/MBS-2940> Project: MusicBrainz Server
> Issue Type: Bug
> Components: Web service
> Reporter: Andy Hawkins
> Assignee: Oliver Charles
> Fix For: Schema Change, 2011-07-11
>>> 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' => {}
> };
>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tickets.musicbrainz.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira