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

Voting on edits ignores DB_READ_ONLY

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2013-07-22
    • Component/s: None
    • Labels:
      None

      Description

      Voting on edits, either from the edit search or an individual edit page gives:

      Fehler:

      Caught exception in MusicBrainz::Server::Controller::Edit->enter_votes "Failed query:
      'LOCK vote IN SHARE ROW EXCLUSIVE MODE'
      ()
      DBD::Pg::st execute failed: ERROR: cannot execute LOCK TABLE during recovery at lib/Sql.pm line 107, line 3.

      at lib/Sql.pm line 113, line 3.
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: cannot execute LOCK TABLE...') called at admin/../local/lib/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0xdbd3f60)', 'Try::Tiny::Catch=REF(0xdbd3ed0)') called at lib/Sql.pm line 114
      Sql::do('Sql=HASH(0xcec6858)', 'LOCK vote IN SHARE ROW EXCLUSIVE MODE') called at lib/MusicBrainz/Server/Data/Vote.pm line 54
      MusicBrainz::Server::Data::Vote::_ANON_() called at lib/Sql.pm line 281
      Sql::_ANON_() called at admin/../local/lib/perl5/Try/Tiny.pm line 76
      eval

      Unknown macro: {...}

      called at admin/../local/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0xdbcfc28)', 'Try::Tiny::Catch=REF(0xdad6e70)') called at lib/Sql.pm line 294
      Sql::_auto_transaction('CODE(0x50f95c0)', 'Sql=HASH(0xcec6858)') called at lib/Sql.pm line 299
      Sql::_run_in_transaction_one('CODE(0x50f95c0)', 'Sql=HASH(0xcec6858)') called at lib/Sql.pm line 313
      Sql::run_in_transaction('CODE(0x50f95c0)', 'Sql=HASH(0xcec6858)') called at lib/MusicBrainz/Server/Data/Vote.pm line 139
      MusicBrainz::Server::Data::Vote::enter_votes('MusicBrainz::Server::Data::Vote=HASH(0xbd629f8)', 53705, 'HASH(0xdaab570)') called at lib/MusicBrainz/Server/Data/Edit.pm line 666
      MusicBrainz::Server::Data::Edit::_ANON_() called at lib/Sql.pm line 281
      Sql::_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(0xdbcb000)', 'Try::Tiny::Catch=REF(0xdad6ca8)') called at lib/Sql.pm line 294
      Sql::_auto_transaction('CODE(0xcec6c90)', 'Sql=HASH(0xcec6858)') called at lib/Sql.pm line 299
      Sql::_run_in_transaction_one('CODE(0xcec6c90)', 'Sql=HASH(0xcec6858)') called at lib/Sql.pm line 313
      Sql::run_in_transaction('CODE(0xcec6c90)', 'Sql=HASH(0xcec6858)') called at lib/MusicBrainz/Server/Data/Edit.pm line 675
      MusicBrainz::Server::Data::Edit::insert_votes_and_notes('MusicBrainz::Server::Data::Edit=HASH(0xb2bde20)', 53705, 'votes', 'ARRAY(0xcec6630)', 'notes', 'ARRAY(0xd9000a0)') called at lib/MusicBrainz/Server/Controller/Edit.pm line 78
      MusicBrainz::Server::Controller::Edit::enter_votes('MusicBrainz::Server::Controller::Edit=HASH(0xc497588)', 'MusicBrainz::Server=HASH(0xcb76e78)') called at admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xc8188a0)', 'MusicBrainz::Server::Controller::Edit=HASH(0xc497588)', 'MusicBrainz::Server=HASH(0xcb76e78)') 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(0xcb76e78)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc8188a0)') called at admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xcb76e78)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc8188a0)') called at admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc8188a0)', 'MusicBrainz::Server=HASH(0xcb76e78)') called at admin/../local/lib/perl5/Catalyst/Controller.pm line 158
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Edit=HASH(0xc497588)', 'MusicBrainz::Server=HASH(0xcb76e78)') called at admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0x996aec0)', 'MusicBrainz::Server::Controller::Edit=HASH(0xc497588)', 'MusicBrainz::Server=HASH(0xcb76e78)') 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(0xcb76e78)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x996aec0)') called at admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xcb76e78)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0x996aec0)') called at admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0x996aec0)', 'MusicBrainz::Server=HASH(0xcb76e78)') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x4072bc0)', 'forward', 'MusicBrainz::Server=HASH(0xcb76e78)', '_ACTION') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x4072bc0)', 'MusicBrainz::Server=HASH(0xcb76e78)', '_ACTION') called at admin/../local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward('MusicBrainz::Server=HASH(0xcb76e78)', '_ACTION') called at admin/../local/lib/perl5/Catalyst/Controller.pm line 132
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Edit=HASH(0xc497588)', 'MusicBrainz::Server=HASH(0xcb76e78)') called at admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xc80f970)', 'MusicBrainz::Server::Controller::Edit=HASH(0xc497588)', 'MusicBrainz::Server=HASH(0xcb76e78)') 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(0xcb76e78)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc80f970)') called at admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xcb76e78)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc80f970)') called at admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc80f970)', 'MusicBrainz::Server=HASH(0xcb76e78)') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x4072bc0)', 'forward', 'MusicBrainz::Server=HASH(0xcb76e78)', '/edit/_DISPATCH') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x4072bc0)', 'MusicBrainz::Server=HASH(0xcb76e78)', '/edit/_DISPATCH') called at admin/../local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward('MusicBrainz::Server=HASH(0xcb76e78)', '/edit/_DISPATCH') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x4072bc0)', 'MusicBrainz::Server=HASH(0xcb76e78)') called at admin/../local/lib/perl5/Catalyst.pm line 1618
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xcb76e78)') 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(0xcb76e78)', 'CODE(0xcb0dc08)') called at lib/MusicBrainz/Server.pm line 327
      Class::MOP::Class:::around('CODE(0x345c900)', 'MusicBrainz::Server=HASH(0xcb76e78)') 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(0xcb76e78)') called at lib/MusicBrainz/Server.pm line 341
      Class::MOP::Class:::around('CODE(0xca516b0)', 'MusicBrainz::Server=HASH(0xcb76e78)') 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(0xcb76e78)') called at lib/MusicBrainz/Server.pm line 386
      Class::MOP::Class:::around('CODE(0xca63990)', 'MusicBrainz::Server=HASH(0xcb76e78)') 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(0xcb76e78)') 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(0xcb76e78)') 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(0xcb76e78)') 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(0xcaebca8)', 'Try::Tiny::Catch=REF(0xccce538)') called at admin/../local/lib/perl5/Catalyst.pm line 1974
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xcaebc30)', 'response_cb', 'CODE(0xcaeb8b8)') called at admin/../local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xcaebc30)', 'response_cb', 'CODE(0xcaeb8b8)') called at admin/../local/lib/perl5/Catalyst/Engine.pm line 688
      Catalyst::Engine::_ANON_('CODE(0xcaeb8b8)') 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
      at lib/Sql.pm line 294.
      at lib/Sql.pm line 294."

      Stack-Trace:
      line 675 MusicBrainz::Server::Data::Edit
      line 78 MusicBrainz::Server::Controller::Edit
      line 326 MusicBrainz::Server
      line 300 MusicBrainz::Server
      line 327 MusicBrainz::Server
      line 341 MusicBrainz::Server
      line 386 MusicBrainz::Server

      Anfragedaten:
      $VAR1 = {
      'query_parameters' => {},
      'body_parameters' =>

      Unknown macro: { 'enter-vote.vote.0.edit_id' => '22166080', 'url' => 'https}

      };

      Host: pino

        Attachments

          Activity

            People

            • Assignee:
              ianmcorvidae Ian McEwen
              Reporter:
              nikki nikki
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2013-07-22