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

Internal server error loading a report when reports have never been generated

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2012-09-17
    • Component/s: None
    • Labels:
      None

      Description

      Error:

      Caught exception in MusicBrainz::Server::Controller::Report->show "DBD::Pg::st execute failed: ERROR: relation "report.index" does not exist
      LINE 1: SELECT generated_at FROM report.index WHERE report_name = 's...
      ^ at lib/Sql.pm line 414.
      at lib/Sql.pm line 429
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: relation "report.index" d...') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0x11294898)', 'Try::Tiny::Catch=REF(0x10ee3318)') called at lib/Sql.pm line 430
      Sql::_select_list('Sql=HASH(0x10c15cf8)', 'SELECT generated_at FROM report.index WHERE report_name = ?', 'ARRAY(0x110a8ca0)', 'arrayref', 'CODE(0x4a0e618)') called at lib/Sql.pm line 449
      Sql::select_list_of_lists('Sql=HASH(0x10c15cf8)', 'SELECT generated_at FROM report.index WHERE report_name = ?', 'set_in_different_rg') called at lib/Sql.pm line 382
      Sql::select_single_column_array('Sql=HASH(0x10c15cf8)', 'SELECT generated_at FROM report.index WHERE report_name = ?', 'set_in_different_rg') called at lib/Sql.pm line 397
      Sql::select_single_value('Sql=HASH(0x10c15cf8)', 'SELECT generated_at FROM report.index WHERE report_name = ?', 'set_in_different_rg') called at lib/MusicBrainz/Server/Report.pm line 65
      MusicBrainz::Server::Report::generated_at('MusicBrainz::Server::Report::SetInDifferentRG=HASH(0x113a1850)') called at lib/MusicBrainz/Server/Controller/Report.pm line 45
      MusicBrainz::Server::Controller::Report::show('MusicBrainz::Server::Controller::Report=HASH(0xb7b1de8)', 'MusicBrainz::Server=HASH(0x10c459c8)', 'SetInDifferentRG') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xbc528b8)', 'MusicBrainz::Server::Controller::Report=HASH(0xb7b1de8)', 'MusicBrainz::Server=HASH(0x10c459c8)', 'SetInDifferentRG') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1667
      eval

      Unknown macro: {...}

      called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0x10c459c8)', 'MusicBrainz::Server::Controller::Report', 'Catalyst::Action=HASH(0xbc528b8)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0x10c459c8)', 'MusicBrainz::Server::Controller::Report', 'Catalyst::Action=HASH(0xbc528b8)') called at lib/MusicBrainz/Server.pm line 322
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0x10c459c8)', 'MusicBrainz::Server::Controller::Report', 'Catalyst::Action=HASH(0xbc528b8)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbc528b8)', 'MusicBrainz::Server=HASH(0x10c459c8)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Controller.pm line 125
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Report=HASH(0xb7b1de8)', 'MusicBrainz::Server=HASH(0x10c459c8)', 'SetInDifferentRG') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xbc524c8)', 'MusicBrainz::Server::Controller::Report=HASH(0xb7b1de8)', 'MusicBrainz::Server=HASH(0x10c459c8)', 'SetInDifferentRG') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1667
      eval

      called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0x10c459c8)', 'MusicBrainz::Server::Controller::Report', 'Catalyst::Action=HASH(0xbc524c8)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0x10c459c8)', 'MusicBrainz::Server::Controller::Report', 'Catalyst::Action=HASH(0xbc524c8)') called at lib/MusicBrainz/Server.pm line 322
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0x10c459c8)', 'MusicBrainz::Server::Controller::Report', 'Catalyst::Action=HASH(0xbc524c8)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbc524c8)', 'MusicBrainz::Server=HASH(0x10c459c8)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x30a9af0)', 'forward', 'MusicBrainz::Server=HASH(0x10c459c8)', '_ACTION') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x30a9af0)', 'MusicBrainz::Server=HASH(0x10c459c8)', '_ACTION') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 342
      Catalyst::forward('MusicBrainz::Server=HASH(0x10c459c8)', '_ACTION') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Controller.pm line 99
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Report=HASH(0xb7b1de8)', 'MusicBrainz::Server=HASH(0x10c459c8)', 'SetInDifferentRG') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xbc4d378)', 'MusicBrainz::Server::Controller::Report=HASH(0xb7b1de8)', 'MusicBrainz::Server=HASH(0x10c459c8)', 'SetInDifferentRG') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1667
      eval

      Unknown macro: {...}

      called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0x10c459c8)', 'MusicBrainz::Server::Controller::Report', 'Catalyst::Action=HASH(0xbc4d378)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0x10c459c8)', 'MusicBrainz::Server::Controller::Report', 'Catalyst::Action=HASH(0xbc4d378)') called at lib/MusicBrainz/Server.pm line 322
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0x10c459c8)', 'MusicBrainz::Server::Controller::Report', 'Catalyst::Action=HASH(0xbc4d378)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbc4d378)', 'MusicBrainz::Server=HASH(0x10c459c8)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x30a9af0)', 'forward', 'MusicBrainz::Server=HASH(0x10c459c8)', '/report/_DISPATCH') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x30a9af0)', 'MusicBrainz::Server=HASH(0x10c459c8)', '/report/_DISPATCH') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 342
      Catalyst::forward('MusicBrainz::Server=HASH(0x10c459c8)', '/report/_DISPATCH') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x30a9af0)', 'MusicBrainz::Server=HASH(0x10c459c8)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1613
      Catalyst::dispatch('MusicBrainz::Server=HASH(0x10c459c8)') called at lib/MusicBrainz/Server.pm line 291
      Class::MOP::Class:::around('CODE(0x2987230)', 'MusicBrainz::Server=HASH(0x10c459c8)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0x10c459c8)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0x10c459c8)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1963
      Catalyst::_ANON_() called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 76
      eval

      called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0x10a0c130)', 'Try::Tiny::Catch=REF(0x110adef0)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1969
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xbda8330)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Engine.pm line 856
      Catalyst::Engine::_ANON_('CODE(0x100efa58)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Plack/Handler/FCGI.pm line 134
      Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0xd3ed90)', 'CODE(0xbd25838)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Plack/Loader.pm line 88
      Plack::Loader::run('Plack::Loader=HASH(0xd079d0)', 'Plack::Handler::FCGI=HASH(0xd3ed90)') called at /home/musicbrainz/musicbrainz-server/admin/../local/lib/perl5/Plack/Runner.pm line 263
      Plack::Runner::run('Plack::Runner=HASH(0xb03000)') called at /home/musicbrainz/musicbrainz-server/admin/../local/bin/plackup line 10"

      Stack trace:
      line 65 MusicBrainz::Server::Report
      line 45 MusicBrainz::Server::Controller::Report
      line 322 MusicBrainz::Server
      line 322 MusicBrainz::Server
      line 322 MusicBrainz::Server
      line 291 MusicBrainz::Server

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

      URL: http://test.musicbrainz.org/report/SetInDifferentRG

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2012-09-17