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

Deadlock when entering edits

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2021-06-14
    • None
    • Edit system
    • None

      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

            bitmap Michael Wiencek
            chaban chaban
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:

                Version Package
                2021-06-14