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

/ws/2/discid/ ignores DB_READ_ONLY

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2013-09-16
    • None
    • None
    • None

      Loading https://beta.musicbrainz.org/ws/2/discid/3WmP1JgQ8eB.z1bSdGAjR.mcOQ4-?inc=artists+recordings&limit=1 while DB_READ_ONLY is set gives

      https://beta.musicbrainz.org/ws/2/discid/3WmP1JgQ8eB.z1bSdGAjR.mcOQ4-?inc=artists+recordings&limit=1

      Caught exception in MusicBrainz::Server::Controller::WS::2::DiscID->discid "Failed query:
      'UPDATE release_raw SET lookup_count = lookup_count + 1 WHERE id = ?'
      (4688)
      DBD::Pg::st execute failed: ERROR: cannot execute UPDATE in a read-only transaction at lib/Sql.pm line 107, line 1.

      at lib/Sql.pm line 113, line 1.
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: cannot execute UPDATE in ...') called at admin/../local/lib/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0xd478868)', 'Try::Tiny::Catch=REF(0xd67c158)') called at lib/Sql.pm line 114
      Sql::do('Sql=HASH(0xce9cca0)', 'UPDATE release_raw SET lookup_count = lookup_count + 1 WHERE ...', 4688) called at lib/MusicBrainz/Server/Data/CDStub.pm line 77
      MusicBrainz::Server::Data::CDStub::increment_lookup_count('MusicBrainz::Server::Data::CDStub=HASH(0xae3ad30)', 4688) called at lib/MusicBrainz/Server/Controller/WS/2/DiscID.pm line 75
      MusicBrainz::Server::Controller::WS::2::DiscID::discid('MusicBrainz::Server::Controller::WS::2::DiscID=HASH(0xc4fb8e8)', 'MusicBrainz::Server=HASH(0xccba350)', '3WmP1JgQ8eB.z1bSdGAjR.mcOQ4-') called at admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xc9affe0)', 'MusicBrainz::Server::Controller::WS::2::DiscID=HASH(0xc4fb8e8)', 'MusicBrainz::Server=HASH(0xccba350)', '3WmP1JgQ8eB.z1bSdGAjR.mcOQ4-') called at admin/../local/lib/perl5/Catalyst.pm line 1672
      eval

      Unknown macro: {...}

      called at admin/../local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0xccba350)', 'MusicBrainz::Server::Controller::WS::2::DiscID', 'Catalyst::Action=HASH(0xc9affe0)') called at admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xccba350)', 'MusicBrainz::Server::Controller::WS::2::DiscID', 'Catalyst::Action=HASH(0xc9affe0)') called at admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc9affe0)', 'MusicBrainz::Server=HASH(0xccba350)') called at admin/../local/lib/perl5/Catalyst/ActionChain.pm line 38
      Catalyst::ActionChain::dispatch('Catalyst::ActionChain=HASH(0xd18b7e0)', 'MusicBrainz::Server=HASH(0xccba350)') called at admin/../local/lib/perl5/Catalyst/Controller.pm line 158
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::WS::2::DiscID=HASH(0xc4fb8e8)', 'MusicBrainz::Server=HASH(0xccba350)', '3WmP1JgQ8eB.z1bSdGAjR.mcOQ4-') called at admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xc9af560)', 'MusicBrainz::Server::Controller::WS::2::DiscID=HASH(0xc4fb8e8)', 'MusicBrainz::Server=HASH(0xccba350)', '3WmP1JgQ8eB.z1bSdGAjR.mcOQ4-') called at admin/../local/lib/perl5/Catalyst.pm line 1672
      eval

      called at admin/../local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0xccba350)', 'MusicBrainz::Server::Controller::WS::2::DiscID', 'Catalyst::Action=HASH(0xc9af560)') called at admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xccba350)', 'MusicBrainz::Server::Controller::WS::2::DiscID', 'Catalyst::Action=HASH(0xc9af560)') called at admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc9af560)', 'MusicBrainz::Server=HASH(0xccba350)') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x4072bc0)', 'forward', 'MusicBrainz::Server=HASH(0xccba350)', '_ACTION') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x4072bc0)', 'MusicBrainz::Server=HASH(0xccba350)', '_ACTION') called at admin/../local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward('MusicBrainz::Server=HASH(0xccba350)', '_ACTION') called at admin/../local/lib/perl5/Catalyst/Controller.pm line 132
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::WS::2::DiscID=HASH(0xc4fb8e8)', 'MusicBrainz::Server=HASH(0xccba350)', '3WmP1JgQ8eB.z1bSdGAjR.mcOQ4-') called at admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xc9a7740)', 'MusicBrainz::Server::Controller::WS::2::DiscID=HASH(0xc4fb8e8)', 'MusicBrainz::Server=HASH(0xccba350)', '3WmP1JgQ8eB.z1bSdGAjR.mcOQ4-') called at admin/../local/lib/perl5/Catalyst.pm line 1672
      eval

      Unknown macro: {...}

      called at admin/../local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0xccba350)', 'MusicBrainz::Server::Controller::WS::2::DiscID', 'Catalyst::Action=HASH(0xc9a7740)') called at admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xccba350)', 'MusicBrainz::Server::Controller::WS::2::DiscID', 'Catalyst::Action=HASH(0xc9a7740)') called at admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc9a7740)', 'MusicBrainz::Server=HASH(0xccba350)') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x4072bc0)', 'forward', 'MusicBrainz::Server=HASH(0xccba350)', '/ws/2/discid/_DISPATCH') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x4072bc0)', 'MusicBrainz::Server=HASH(0xccba350)', '/ws/2/discid/_DISPATCH') called at admin/../local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward('MusicBrainz::Server=HASH(0xccba350)', '/ws/2/discid/_DISPATCH') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x4072bc0)', 'MusicBrainz::Server=HASH(0xccba350)') called at admin/../local/lib/perl5/Catalyst.pm line 1618
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xccba350)') called at lib/MusicBrainz/Server.pm line 326
      MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 300
      MusicBrainz::Server::with_translations('MusicBrainz::Server=HASH(0xccba350)', 'CODE(0xd53f368)') called at lib/MusicBrainz/Server.pm line 327
      Class::MOP::Class:::around('CODE(0x345c900)', 'MusicBrainz::Server=HASH(0xccba350)') called at 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(0xccba350)') called at lib/MusicBrainz/Server.pm line 341
      Class::MOP::Class:::around('CODE(0xca516b0)', 'MusicBrainz::Server=HASH(0xccba350)') called at 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(0xccba350)') called at lib/MusicBrainz/Server.pm line 386
      Class::MOP::Class:::around('CODE(0xca63990)', 'MusicBrainz::Server=HASH(0xccba350)') called at 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(0xccba350)') called at admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 35
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xccba350)') called at admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xccba350)') called at admin/../local/lib/perl5/Catalyst.pm line 1968
      Catalyst::_ANON_() called at admin/../local/lib/perl5/Try/Tiny.pm line 76
      eval

      called at admin/../local/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0xd53df28)', 'Try::Tiny::Catch=REF(0xd18ad30)') called at admin/../local/lib/perl5/Catalyst.pm line 1974
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xd6f1de8)', 'response_cb', 'CODE(0xcaeb6f8)') called at admin/../local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xd6f1de8)', 'response_cb', 'CODE(0xcaeb6f8)') called at admin/../local/lib/perl5/Catalyst/Engine.pm line 688
      Catalyst::Engine::_ANON_('CODE(0xcaeb6f8)') called at admin/../local/lib/perl5/Plack/Handler/FCGI.pm line 130
      Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x135b688)', 'CODE(0xca738e8)') called at admin/../local/lib/perl5/Plack/Loader.pm line 84
      Plack::Loader::run('Plack::Loader=HASH(0x1283250)', 'Plack::Handler::FCGI=HASH(0x135b688)') called at admin/../local/lib/perl5/Plack/Runner.pm line 267
      Plack::Runner::run('Plack::Runner=HASH(0x1108660)') called at ./admin/../local/bin/plackup line 10"

      Stack-Trace:
      line 77 MusicBrainz::Server::Data::CDStub
      line 75 MusicBrainz::Server::Controller::WS::2::DiscID
      line 326 MusicBrainz::Server
      line 300 MusicBrainz::Server
      line 327 MusicBrainz::Server
      line 341 MusicBrainz::Server
      line 386 MusicBrainz::Server

      Anfragedaten:
      $VAR1 = {
      'query_parameters' =>

      Unknown macro: { 'inc' => 'artists recordings', 'limit' => '1' }

      ,
      'body_parameters' => {}
      };

      Host: pino

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

              Created:
              Updated:
              Resolved:

                Version Package
                2013-09-16