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

Uploading cover art 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

      Trying to upload cover art while DB_READ_ONLY is set results in:

      Fehler:

      Caught exception in MusicBrainz::Server::Controller::Release->add_cover_art "The edit could not be created.
      POST: $VAR1 =

      Unknown macro: { 'add-cover-art.id' => '4109752358', 'add-cover-art.type_id' => '1', 'add-cover-art.position' => '1', 'add-cover-art.comment' => '', 'add-cover-art.edit_note' => '', 'add-cover-art.as_auto_editor' => '1' }

      ;

      Exception:$VAR1 = 'Failed query:
      \'SELECT 1 FROM editor WHERE id = ? FOR UPDATE\'
      (53705)
      DBD::Pg::st execute failed: ERROR: cannot execute SELECT FOR UPDATE in a read-only transaction 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 SELECT FOR...\') called at admin/../local/lib/perl5/Try/Tiny.pm line 100
      Try::Tiny::try(\'CODE(0x114ef640)\', \'Try::Tiny::Catch=REF(0x114ee2f0)\') called at lib/Sql.pm line 114
      Sql::do(\'Sql=HASH(0xe1809f8)\', \'SELECT 1 FROM editor WHERE id = ? FOR UPDATE\', 53705) called at lib/MusicBrainz/Server/Data/Editor.pm line 394
      MusicBrainz::Server::Data::Editor::lock_row(\'MusicBrainz::Server::Data::Editor=HASH(0xb2f8948)\', 53705) called at lib/MusicBrainz/Server/Data/Edit.pm line 431
      MusicBrainz::Server::Data::Edit::create(\'MusicBrainz::Server::Data::Edit=HASH(0xb2bde20)\', \'editor_id\', 53705, \'privileges\', 185, \'cover_art_types\', \'ARRAY(0x114ed870)\', \'cover_art_id\', 4109752358, ...) called at lib/MusicBrainz/Server/Controller.pm line 85
      MusicBrainz::Server::Controller::_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(0x114edb10)\', \'Try::Tiny::Catch=REF(0x114ed768)\') called at lib/MusicBrainz/Server/Controller.pm line 101
      MusicBrainz::Server::Controller::_insert_edit(\'MusicBrainz::Server::Controller::Release=HASH(0xc4c3e70)\', \'MusicBrainz::Server=HASH(0x10a6c260)\', \'MusicBrainz::Server::Form::Release::AddCoverArt=HASH(0x10a5da98)\', \'edit_type\', 314, \'release\', \'MusicBrainz::Server::Entity::Release=HASH(0x109eb9a0)\', \'cover_art_types\', \'ARRAY(0x114ed870)\', ...) called at lib/MusicBrainz/Server/Controller/Release.pm line 445
      MusicBrainz::Server::Controller::Release::_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(0x114ed528)\', \'Try::Tiny::Catch=REF(0x113b9f08)\') called at lib/Sql.pm line 294
      Sql::_auto_transaction(\'CODE(0x114ed330)\', \'Sql=HASH(0xe1809f8)\') called at lib/Sql.pm line 299
      Sql::_run_in_transaction_one(\'CODE(0x114ed330)\', \'Sql=HASH(0xe1809f8)\') called at lib/Sql.pm line 313
      Sql::run_in_transaction(\'CODE(0x114ed330)\', \'Sql=HASH(0xe1809f8)\') called at lib/MusicBrainz/Server/Model/MB.pm line 19
      MusicBrainz::Server::Model::MB::with_transaction(\'MusicBrainz::Server::Model::MB=HASH(0xabec760)\', \'CODE(0x114ed330)\') called at lib/MusicBrainz/Server/Controller/Release.pm line 451
      MusicBrainz::Server::Controller::Release::add_cover_art(\'MusicBrainz::Server::Controller::Release=HASH(0xc4c3e70)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') called at admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 56
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server::Controller::Release=HASH(0xc4c3e70)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') called at admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::Controller::Release::add_cover_art(\'MusicBrainz::Server::Controller::Release=HASH(0xc4c3e70)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') called at admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xc8afea8)\', \'MusicBrainz::Server::Controller::Release=HASH(0xc4c3e70)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') 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(0x10a6c260)\', \'MusicBrainz::Server::Controller::Release\', \'Catalyst::Action=HASH(0xc8afea8)\') called at admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0x10a6c260)\', \'MusicBrainz::Server::Controller::Release\', \'Catalyst::Action=HASH(0xc8afea8)\') called at admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xc8afea8)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') called at admin/../local/lib/perl5/Catalyst/ActionChain.pm line 38
      Catalyst::ActionChain::dispatch(\'Catalyst::ActionChain=HASH(0x109fc080)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') called at admin/../local/lib/perl5/Catalyst/Controller.pm line 158
      Catalyst::Controller::_ACTION(\'MusicBrainz::Server::Controller::Release=HASH(0xc4c3e70)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') called at admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xc8ab6e8)\', \'MusicBrainz::Server::Controller::Release=HASH(0xc4c3e70)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') 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(0x10a6c260)\', \'MusicBrainz::Server::Controller::Release\', \'Catalyst::Action=HASH(0xc8ab6e8)\') called at admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0x10a6c260)\', \'MusicBrainz::Server::Controller::Release\', \'Catalyst::Action=HASH(0xc8ab6e8)\') called at admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xc8ab6e8)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(\'Catalyst::Dispatcher=HASH(0x4072bc0)\', \'forward\', \'MusicBrainz::Server=HASH(0x10a6c260)\', \'_ACTION\') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(\'Catalyst::Dispatcher=HASH(0x4072bc0)\', \'MusicBrainz::Server=HASH(0x10a6c260)\', \'_ACTION\') called at admin/../local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward(\'MusicBrainz::Server=HASH(0x10a6c260)\', \'_ACTION\') called at admin/../local/lib/perl5/Catalyst/Controller.pm line 132
      Catalyst::Controller::_DISPATCH(\'MusicBrainz::Server::Controller::Release=HASH(0xc4c3e70)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') called at admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xc4deb30)\', \'MusicBrainz::Server::Controller::Release=HASH(0xc4c3e70)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') 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(0x10a6c260)\', \'MusicBrainz::Server::Controller::Release\', \'Catalyst::Action=HASH(0xc4deb30)\') called at admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0x10a6c260)\', \'MusicBrainz::Server::Controller::Release\', \'Catalyst::Action=HASH(0xc4deb30)\') called at admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xc4deb30)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(\'Catalyst::Dispatcher=HASH(0x4072bc0)\', \'forward\', \'MusicBrainz::Server=HASH(0x10a6c260)\', \'/release/_DISPATCH\') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(\'Catalyst::Dispatcher=HASH(0x4072bc0)\', \'MusicBrainz::Server=HASH(0x10a6c260)\', \'/release/_DISPATCH\') called at admin/../local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward(\'MusicBrainz::Server=HASH(0x10a6c260)\', \'/release/_DISPATCH\') called at admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch(\'Catalyst::Dispatcher=HASH(0x4072bc0)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') called at admin/../local/lib/perl5/Catalyst.pm line 1618
      Catalyst::dispatch(\'MusicBrainz::Server=HASH(0x10a6c260)\') 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(0x10a6c260)\', \'CODE(0x1095fe80)\') called at lib/MusicBrainz/Server.pm line 327
      Class::MOP::Class:::around(\'CODE(0x345c900)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') 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(0x10a6c260)\') called at lib/MusicBrainz/Server.pm line 341
      Class::MOP::Class:::around(\'CODE(0xca516b0)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') 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(0x10a6c260)\') called at lib/MusicBrainz/Server.pm line 386
      Class::MOP::Class:::around(\'CODE(0xca63990)\', \'MusicBrainz::Server=HASH(0x10a6c260)\') 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(0x10a6c260)\') 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(0x10a6c260)\') 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(0x10a6c260)\') 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(0x1092d2d8)\', \'Try::Tiny::Catch=REF(0xe2c0cf8)\') called at admin/../local/lib/perl5/Catalyst.pm line 1974
      Catalyst::handle_request(\'MusicBrainz::Server\', \'env\', \'HASH(0x10967630)\', \'response_cb\', \'CODE(0xe146b40)\') called at admin/../local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request(\'MusicBrainz::Server\', \'env\', \'HASH(0x10967630)\', \'response_cb\', \'CODE(0xe146b40)\') called at admin/../local/lib/perl5/Catalyst/Engine.pm line 688
      Catalyst::Engine::_ANON_(\'CODE(0xe146b40)\') 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/MusicBrainz/Server/Controller.pm line 101.
      at lib/Sql.pm line 294."

      Stack-Trace:
      line 19 MusicBrainz::Server::Model::MB
      line 451 MusicBrainz::Server::Controller::Release
      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: { 'add-cover-art.id' => '4109752358', 'add-cover-art.type_id' => '1', 'add-cover-art.edit_note' => '', 'add-cover-art.comment' => '', 'add-cover-art.position' => '1', 'add-cover-art.as_auto_editor' => '1' }

      };

      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