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

Deadlocks while adding works

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

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

      { 'edit-work.name' => 'Recuerdos de viaje, Op. 71: IV. En la Alhambra', 'edit-work.type_id' => '', 'edit-work.iswc' => '', 'edit-work.as_auto_editor' => '1', 'gc-mode' => 'English', 'edit-work.comment' => '', 'edit-work.edit_note' => '' }

      ;

      Exception:$VAR1 = 'Failed query:
      \'UPDATE editor SET auto_edits_accepted = auto_edits_accepted + 1 WHERE id = ?\'
      (326637)
      DBD::Pg::st execute failed: ERROR: deadlock detected
      DETAIL: Process 27822 waits for ExclusiveLock on tuple (2269,29) of relation 1514451 of database 1416385; blocked by process 25745.
      Process 25745 waits for ShareLock on transaction 157450811; blocked by process 27822.
      HINT: See server log for query details. at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 103.

      at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 109
      Sql::_ANON_(\'DBD::Pg::st execute failed: ERROR: deadlock detected
      x

      {a}

      DETAIL:...\') called at /usr/local/share/perl-astro/perl/5.10.1//Try/Tiny.pm line 100
      Try::Tiny::try(\'CODE(0xcb44310)\', \'Try::Tiny::Catch=REF(0xcb723e0)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 110
      Sql::do(\'Sql=HASH(0xacb0c60)\', \'UPDATE editor SET auto_edits_accepted = auto_edits_accepted +...\', 326637) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Editor.pm line 380
      MusicBrainz::Server::Data::Editor::credit(\'MusicBrainz::Server::Data::Editor=HASH(0x53d9278)\', 326637, 2, \'auto_edit\', 1) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 604
      MusicBrainz::Server::Data::Edit::_close(\'MusicBrainz::Server::Data::Edit=HASH(0x908c048)\', \'MusicBrainz::Server::Edit::Work::Create=HASH(0xcb69558)\', \'CODE(0xca5c1a8)\', \'auto_edit\', 1) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 572
      MusicBrainz::Server::Data::Edit::accept(\'MusicBrainz::Server::Data::Edit=HASH(0x908c048)\', \'MusicBrainz::Server::Edit::Work::Create=HASH(0xcb69558)\', \'auto_edit\', 1) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 421
      MusicBrainz::Server::Data::Edit::_ANON_() called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 264
      Sql::_ANON_() called at /usr/local/share/perl-astro/perl/5.10.1//Try/Tiny.pm line 76
      eval

      {...} called at /usr/local/share/perl-astro/perl/5.10.1//Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0xcb58aa8)\', \'Try::Tiny::Catch=REF(0xcb185b8)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 277
      Sql::_auto_transaction(\'CODE(0xcb2bb58)\', \'Sql=HASH(0xacb0c60)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 282
      Sql::_run_in_transaction_one(\'CODE(0xcb2bb58)\', \'Sql=HASH(0xacb0c60)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 296
      Sql::run_in_transaction(\'CODE(0xcb2bb58)\', \'Sql=HASH(0xacb0c60)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 426
      MusicBrainz::Server::Data::Edit::create(\'MusicBrainz::Server::Data::Edit=HASH(0x908c048)\', \'editor_id\', 326637, \'privileges\', 49, \'iswc\', undef, \'comment\', undef, ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller.pm line 83
      MusicBrainz::Server::Controller::_ANON_() called at /usr/local/share/perl-astro/perl/5.10.1//Try/Tiny.pm line 76
      eval {...}

      called at /usr/local/share/perl-astro/perl/5.10.1//Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0x7fdc884a0de0)\', \'Try::Tiny::Catch=REF(0x7fdc884939b8)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller.pm line 99
      MusicBrainz::Server::Controller::_insert_edit(\'MusicBrainz::Server::Controller::Work=HASH(0xa3ee4d8)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\', \'MusicBrainz::Server::Form::Work=HASH(0xb1b7eb8)\', \'edit_type\', 41, \'type_id\', undef, \'name\', \'Recuerdos de viaje, Op. 71: IV. En la Alhambra\', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller.pm line 132
      MusicBrainz::Server::Controller::edit_action(\'MusicBrainz::Server::Controller::Work=HASH(0xa3ee4d8)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\', \'form\', \'Work\', \'type\', 41, \'on_creation\', \'CODE(0xaf59d30)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/Role/Create.pm line 56
      Moose::Meta::Role::_ANON_::SERIAL::7::create(\'MusicBrainz::Server::Controller::Work=HASH(0xa3ee4d8)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xa795d08)\', \'MusicBrainz::Server::Controller::Work=HASH(0xa3ee4d8)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1665
      eval

      {...} called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1665
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xaf5bec8)\', \'MusicBrainz::Server::Controller::Work\', \'Catalyst::Action=HASH(0xa795d08)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xaf5bec8)\', \'MusicBrainz::Server::Controller::Work\', \'Catalyst::Action=HASH(0xa795d08)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xa795d08)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Controller.pm line 110
      Catalyst::Controller::_ACTION(\'MusicBrainz::Server::Controller::Work=HASH(0xa3ee4d8)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xa744290)\', \'MusicBrainz::Server::Controller::Work=HASH(0xa3ee4d8)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1665
      eval {...}

      called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1665
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xaf5bec8)\', \'MusicBrainz::Server::Controller::Work\', \'Catalyst::Action=HASH(0xa744290)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xaf5bec8)\', \'MusicBrainz::Server::Controller::Work\', \'Catalyst::Action=HASH(0xa744290)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xa744290)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(\'Catalyst::Dispatcher=HASH(0x2e04958)\', \'forward\', \'MusicBrainz::Server=HASH(0xaf5bec8)\', \'_ACTION\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(\'Catalyst::Dispatcher=HASH(0x2e04958)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\', \'_ACTION\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 377
      Catalyst::forward(\'MusicBrainz::Server=HASH(0xaf5bec8)\', \'_ACTION\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Controller.pm line 84
      Catalyst::Controller::_DISPATCH(\'MusicBrainz::Server::Controller::Work=HASH(0xa3ee4d8)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xa787fe8)\', \'MusicBrainz::Server::Controller::Work=HASH(0xa3ee4d8)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1665
      eval

      {...} called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1665
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xaf5bec8)\', \'MusicBrainz::Server::Controller::Work\', \'Catalyst::Action=HASH(0xa787fe8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xaf5bec8)\', \'MusicBrainz::Server::Controller::Work\', \'Catalyst::Action=HASH(0xa787fe8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xa787fe8)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(\'Catalyst::Dispatcher=HASH(0x2e04958)\', \'forward\', \'MusicBrainz::Server=HASH(0xaf5bec8)\', \'/work/_DISPATCH\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(\'Catalyst::Dispatcher=HASH(0x2e04958)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\', \'/work/_DISPATCH\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 377
      Catalyst::forward(\'MusicBrainz::Server=HASH(0xaf5bec8)\', \'/work/_DISPATCH\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch(\'Catalyst::Dispatcher=HASH(0x2e04958)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1611
      Catalyst::dispatch(\'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Plugin/Static/Simple.pm line 76
      Class::MOP::Class:::around(\'CODE(0x3467a80)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/lib/perl-astro/perl/5.10.1//Class/MOP/Method/Wrapped.pm line 159
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 274
      Class::MOP::Class:::around(\'CODE(0xa982e18)\', \'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/lib/perl-astro/perl/5.10.1//Class/MOP/Method/Wrapped.pm line 159
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/lib/perl-astro/perl/5.10.1//Class/MOP/Method/Wrapped.pm line 89
      MusicBrainz::Server::dispatch(\'MusicBrainz::Server=HASH(0xaf5bec8)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1952
      eval {...}

      called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 1943
      Catalyst::handle_request(\'MusicBrainz::Server\', \'env\', \'HASH(0x41e5918)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Plugin/AutoRestart.pm line 114
      Catalyst::Plugin::AutoRestart::handle_request(\'MusicBrainz::Server\', \'env\', \'HASH(0x41e5918)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst/Engine/FastCGI.pm line 149
      Catalyst::Engine::FastCGI::run(\'Catalyst::Engine::FastCGI=HASH(0x41b2768)\', \'MusicBrainz::Server\', \'127.0.0.1:55901\', \'HASH(0x1cdbd48)\') called at /usr/local/share/perl-astro/perl/5.10.1//Catalyst.pm line 2396
      Catalyst::run(\'MusicBrainz::Server\', \'127.0.0.1:55901\', \'HASH(0x1cdbd48)\') called at ./script/musicbrainz_fastcgi.pl line 28
      at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 277
      ';
      at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller.pm line 99"
      Stack trace:
      line 95 MusicBrainz::Server::Controller
      line 99 MusicBrainz::Server::Controller
      line 132 MusicBrainz::Server::Controller
      line 56 MusicBrainz::Server::Controller::Role::Create
      line 274 MusicBrainz::Server
      Request data:

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

      { 'edit-work.name' => 'Recuerdos de viaje, Op. 71: IV. En la Alhambra', 'edit-work.type_id' => '', 'edit-work.iswc' => '', 'gc-mode' => 'English', 'edit-work.as_auto_editor' => '1', 'edit-work.edit_note' => '', 'edit-work.comment' => '' }

      };

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              reosarevok Nicolás Tamargo
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package