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

Deadlock when entering edits

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2021-06-14
    • Component/s: Edit system
    • Labels:
      None

      Description

      For some time now I've noticed lots of errors (besides the search being generally flaky)  while making edits through the release editor. Unfortunately I never had the chance to capture them so far until it hit me when attempting to remove multiple releases (6 in total) in short succession:

      DBD::Pg::db commit failed: ERROR:  deadlock detected
      DETAIL:  Process 21174 waits for AccessExclusiveLock on relation 140674910 of database 16806; blocked by process 21874.
      Process 21874 waits for AccessExclusiveLock on relation 140674910 of database 16806; blocked by process 21174.
      HINT:  See server log for query details.
      CONTEXT:  SQL statement "TRUNCATE artist_release_group_pending_update"
      PL/pgSQL function apply_artist_release_group_pending_updates() line 32 at SQL statement at lib/MusicBrainz/Server/Connector.pm line 50
      Sql::run_in_transaction(?, ?) called at lib/MusicBrainz/Server/Model/MB.pm line 19
      MusicBrainz::Server::Model::MB::with_transaction(?, ?) called at lib/MusicBrainz/Server/Controller.pm line 184
      MusicBrainz::Server::Controller::edit_action(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller/Role/Delete.pm line 65
      MusicBrainz::Server::Controller::Role::Delete::__ANON__ at lib/MusicBrainz/Server/ControllerUtils/Delete.pm line 28
      MusicBrainz::Server::ControllerUtils::Delete::cancel_or_action(?, undef, undef, ?) called at lib/MusicBrainz/Server/Controller/Role/Delete.pm line 66
      Catalyst::dispatch(?) called at lib/MusicBrainz/Server.pm line 390
      MusicBrainz::Server::__ANON__ at lib/MusicBrainz/Server.pm line 357
      MusicBrainz::Server::with_translations(?, ?) called at lib/MusicBrainz/Server.pm line 391
      Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 405
      Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 490
      

      Only for one of the releases a removal edit was actually created.

      BTW, it also showed the edit number even when none was inserted:
      MBS-10644

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bitmap Michael Wiencek
              Reporter:
              chaban chaban
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Packages

                  Version Package
                  2021-06-14