-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
None
2011-05-17 06:36:42.844935500 [error] Caught exception in MusicBrainz::Server::Controller::WS::js->recording "Failed query:
2011-05-17 06:36:42.844938500 'SELECT DISTINCT ON (recording.id, name.name, type)
2011-05-17 06:36:42.844939500 rg.id, rg.gid, type AS type_id, name.name,
2011-05-17 06:36:42.844940500 rg.artist_credit AS artist_credit_id, recording.id AS recording
2011-05-17 06:36:42.844941500 FROM release_group rg
2011-05-17 06:36:42.844942500 JOIN release_name name ON rg.name=name.id
2011-05-17 06:36:42.844964500 JOIN release ON release.release_group = rg.id
2011-05-17 06:36:42.844965500 JOIN medium ON release.id = medium.release
2011-05-17 06:36:42.844966500 JOIN track ON track.tracklist = medium.tracklist
2011-05-17 06:36:42.844967500 JOIN recording ON recording.id = track.recording
2011-05-17 06:36:42.844969500 WHERE recording.id IN ()'
2011-05-17 06:36:42.844970500 ()
2011-05-17 06:36:42.844970500 DBD::Pg::st execute failed: ERROR: syntax error at or near ")"
2011-05-17 06:36:42.844976500 LINE 10: WHERE recording.id IN ()
2011-05-17 06:36:42.844977500 ^ at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 79.
2011-05-17 06:36:42.844979500
2011-05-17 06:36:42.844980500 at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 84
2011-05-17 06:36:42.844981500 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
2011-05-17 06:36:42.844991500 Try::Tiny::try('CODE(0xeca1f70)', 'Try::Tiny::Catch=REF(0xecc6520)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 86
2011-05-17 06:36:42.844994500 Sql::select('Sql=HASH(0x9fb8718)', 'SELECT DISTINCT ON (recording.id, name.name, type)\x
...') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Recording.pm line 266
2011-05-17 06:36:42.845001500 MusicBrainz::Server::Data::Recording::appears_on('MusicBrainz::Server::Data::Recording=HASH(0x935e760)', 'ARRAY(0x7199280)', 3) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/WS/js.pm line 363
2011-05-17 06:36:42.845005500 MusicBrainz::Server::Controller::WS::js::_recording_indexed('MusicBrainz::Server::Controller::WS::js=HASH(0x9ad7ca8)', 'MusicBrainz::Server=HASH(0xebeac78)', 'Athma', 'Encephalopaticys', 1, 10) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/WS/js.pm line 289
2011-05-17 06:36:42.845037500 MusicBrainz::Server::Controller::WS::js::recording('MusicBrainz::Server::Controller::WS::js=HASH(0x9ad7ca8)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
2011-05-17 06:36:42.845048500 Catalyst::Action::execute('Catalyst::Action=HASH(0x9c586c8)', 'MusicBrainz::Server::Controller::WS::js=HASH(0x9ad7ca8)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
2011-05-17 06:36:42.845050500 eval
2011-05-17 06:36:42.845057500 Catalyst::execute('MusicBrainz::Server=HASH(0xebeac78)', 'MusicBrainz::Server::Controller::WS::js', 'Catalyst::Action=HASH(0x9c586c8)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 22
2011-05-17 06:36:42.845059500 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xebeac78)', 'MusicBrainz::Server::Controller::WS::js', 'Catalyst::Action=HASH(0x9c586c8)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
2011-05-17 06:36:42.845067500 Catalyst::Action::dispatch('Catalyst::Action=HASH(0x9c586c8)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst/ActionChain.pm line 39
2011-05-17 06:36:42.845077500 Catalyst::ActionChain::dispatch('Catalyst::ActionChain=HASH(0xecbc678)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 110
2011-05-17 06:36:42.845079500 Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::WS::js=HASH(0x9ad7ca8)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
2011-05-17 06:36:42.845086500 Catalyst::Action::execute('Catalyst::Action=HASH(0x9c5ea98)', 'MusicBrainz::Server::Controller::WS::js=HASH(0x9ad7ca8)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
2011-05-17 06:36:42.845089500 eval {...}
called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
2011-05-17 06:36:42.845094500 Catalyst::execute('MusicBrainz::Server=HASH(0xebeac78)', 'MusicBrainz::Server::Controller::WS::js', 'Catalyst::Action=HASH(0x9c5ea98)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 22
2011-05-17 06:36:42.845097500 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xebeac78)', 'MusicBrainz::Server::Controller::WS::js', 'Catalyst::Action=HASH(0x9c5ea98)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
2011-05-17 06:36:42.845107500 Catalyst::Action::dispatch('Catalyst::Action=HASH(0x9c5ea98)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
2011-05-17 06:36:42.845109500 Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x3687e28)', 'forward', 'MusicBrainz::Server=HASH(0xebeac78)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
2011-05-17 06:36:42.845117500 Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x3687e28)', 'MusicBrainz::Server=HASH(0xebeac78)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
2011-05-17 06:36:42.845119500 Catalyst::forward('MusicBrainz::Server=HASH(0xebeac78)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 84
2011-05-17 06:36:42.845125500 Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::WS::js=HASH(0x9ad7ca8)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
2011-05-17 06:36:42.845128500 Catalyst::Action::execute('Catalyst::Action=HASH(0x9c531e8)', 'MusicBrainz::Server::Controller::WS::js=HASH(0x9ad7ca8)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
2011-05-17 06:36:42.845148500 eval
2011-05-17 06:36:42.845150500 Catalyst::execute('MusicBrainz::Server=HASH(0xebeac78)', 'MusicBrainz::Server::Controller::WS::js', 'Catalyst::Action=HASH(0x9c531e8)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 22
2011-05-17 06:36:42.845158500 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xebeac78)', 'MusicBrainz::Server::Controller::WS::js', 'Catalyst::Action=HASH(0x9c531e8)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
2011-05-17 06:36:42.845161500 Catalyst::Action::dispatch('Catalyst::Action=HASH(0x9c531e8)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
2011-05-17 06:36:42.845168500 Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x3687e28)', 'forward', 'MusicBrainz::Server=HASH(0xebeac78)', '/ws/js/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
2011-05-17 06:36:42.845177500 Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x3687e28)', 'MusicBrainz::Server=HASH(0xebeac78)', '/ws/js/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
2011-05-17 06:36:42.845180500 Catalyst::forward('MusicBrainz::Server=HASH(0xebeac78)', '/ws/js/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 105
2011-05-17 06:36:42.845187500 Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x3687e28)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1611
2011-05-17 06:36:42.845189500 Catalyst::dispatch('MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/Static/Simple.pm line 76
2011-05-17 06:36:42.845195500 Class::MOP::Class:::around('CODE(0x2e8d7c0)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
2011-05-17 06:36:42.845197500 Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xebeac78)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 238
2011-05-17 06:36:42.845208500 Class::MOP::Class:::around('CODE(0x9f546f8)', 'MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
2011-05-17 06:36:42.845210500 Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 89
2011-05-17 06:36:42.845217500 MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xebeac78)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1952
2011-05-17 06:36:42.845219500 eval {...}
called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1943
2011-05-17 06:36:42.845220500 Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0x3acb6f8)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/AutoRestart.pm line 114
2011-05-17 06:36:42.845227500 Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0x3acb6f8)') called at /usr/local/share/perl/5.10.1/Catalyst/Engine/FastCGI.pm line 149
2011-05-17 06:36:42.845229500 Catalyst::Engine::FastCGI::run('Catalyst::Engine::FastCGI=HASH(0x3a98678)', 'MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x1720d48)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 2396
2011-05-17 06:36:42.845240500 Catalyst::run('MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x1720d48)') called at ./script/musicbrainz_fastcgi.pl line 28"