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

Crash in private js webservice

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • NGS - Final
    • None
    • Web service
    • 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

      {a}

      ...') 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

      {...} called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      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

      {...} called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      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"

            warp Kuno Woudt
            rob Robert Kaye
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                NGS - Final