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

deadlock while adding standalone recording plus relationships

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Normal Normal
    • None
    • None
    • Edit system
    • None

      Error:
      
      The edit could not be created. Exception (MusicBrainz::Server::Exceptions::DatabaseError): 40P01 DBD::Pg::st execute failed: ERROR:  deadlock detected
      LINE 1: INSERT INTO l_artist_recording (link_order,entity0_credit,en...
                          ^
      DETAIL:  Process 192097 waits for RowExclusiveLock on relation 438240 of database 16806; blocked by process 192513.
      Process 192513 waits for ShareRowExclusiveLock on relation 438973 of database 16806; blocked by process 192097.
      HINT:  See server log for query details. [for Statement "INSERT INTO l_artist_recording (link_order,entity0_credit,entity0,link,entity1_credit,entity1) VALUES (?,?,?,?,?,?) RETURNING id" with ParamValues: 1='0', 2='', 3='2515262', 4='12755', 5='', 6='34713831'] at lib/MusicBrainz/Server/Controller.pm line 82.
      
       at lib/Sql.pm line 347. at lib/MusicBrainz/Server/Model/MB.pm line 19
      MusicBrainz::Server::Model::MB::with_transaction(?, ?) called at lib/MusicBrainz/Server/Controller.pm line 191
      MusicBrainz::Server::Controller::edit_action(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, undef, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller/Role/EditRelationships.pm line 377
      MusicBrainz::Server::Controller::Recording::edit_action(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, undef, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller/Role/Create.pm line 94
      Catalyst::dispatch(?) called at lib/MusicBrainz/Server.pm line 390
      MusicBrainz::Server::__ANON__ at lib/MusicBrainz/Server.pm line 355
      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 493
      Time: 2023-04-11T19:01:20.008Z
      
      Host: 8d906478b2a6
      
      Interface language: en
      
      URL: https://musicbrainz.org/recording/create?edit-recording.name=Raiden+Shogun+%5BMugen+Houyou%5D+%7C+RUS+cover+%7C+SilenTium&edit-recording.video=1&edit-recording.length=166000&edit-recording.edit_note=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DVNIKb4iSDmc&edit-recording.artist_credit.names.0.name=Silentium&edit-recording.url.0.link_type_id=268&edit-recording.url.0.text=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DVNIKb4iSDmc
      
      Request data:
      
      {
        "body_parameters": {
          "edit-recording.artist_credit.names.0.artist.id": "2515262",
          "edit-recording.rel.1.period.begin_date.year": "",
          "edit-recording.artist_credit.names.0.join_phrase": "",
          "edit-recording.rel.0.target": "8b94b32e-6b88-45ce-ba80-c88e1fe93fc4",
          "edit-recording.rel.1.period.begin_date.day": "",
          "edit-recording.rel.1.period.end_date.month": "",
          "edit-recording.rel.1.link_order": "0",
          "edit-recording.rel.1.entity0_credit": "",
          "edit-recording.rel.0.entity1_credit": "",
          "edit-recording.rel.0.period.begin_date.month": "",
          "edit-recording.rel.0.period.end_date.day": "",
          "edit-recording.rel.0.period.ended": "0",
          "edit-recording.artist_credit.names.0.name": "Silentium",
          "edit-recording.url.0.attributes.0.type.gid": "112054d5-e706-4dd8-99ea-09aabee36cd6",
          "edit-recording.url.0.period.ended": "0",
          "edit-recording.rel.0.period.begin_date.year": "",
          "edit-recording.url.0.period.end_date.month": "",
          "edit-recording.rel.0.entity0_credit": "",
          "edit-recording.rel.0.period.end_date.year": "",
          "edit-recording.rel.1.period.end_date.day": "",
          "edit-recording.rel.0.link_type_id": "149",
          "edit-recording.isrcs.0": "",
          "edit-recording.url.0.period.end_date.year": "",
          "edit-recording.edit_note": "https://www.youtube.com/watch?v=VNIKb4iSDmc",
          "edit-recording.rel.1.period.begin_date.month": "",
          "edit-recording.name": "Mugen Houyou",
          "edit-recording.artist_credit.names.0.artist.name": "Silentium",
          "edit-recording.rel.1.period.end_date.year": "",
          "edit-recording.url.0.period.end_date.day": "",
          "edit-recording.rel.1.backward": "0",
          "edit-recording.url.0.link_type_id": "268",
          "edit-recording.url.0.text": "https://www.youtube.com/watch?v=VNIKb4iSDmc",
          "edit-recording.url.0.period.begin_date.day": "",
          "edit-recording.length": "2:46",
          "edit-recording.rel.1.period.ended": "0",
          "edit-recording.rel.0.backward": "1",
          "edit-recording.rel.1.target": "c644f209-620a-4a79-8106-30b49046cd35",
          "edit-recording.rel.0.period.end_date.month": "",
          "edit-recording.rel.0.period.begin_date.day": "",
          "edit-recording.url.0.period.begin_date.year": "",
          "edit-recording.comment": "",
          "edit-recording.video": "1",
          "edit-recording.url.0.period.begin_date.month": "",
          "edit-recording.rel.1.entity1_credit": "",
          "edit-recording.rel.1.link_type_id": "278"
        },
        "query_parameters": {
          "edit-recording.url.0.text": "https://www.youtube.com/watch?v=VNIKb4iSDmc",
          "edit-recording.artist_credit.names.0.name": "Silentium",
          "edit-recording.edit_note": "https://www.youtube.com/watch?v=VNIKb4iSDmc",
          "edit-recording.video": "1",
          "edit-recording.name": "Raiden Shogun [Mugen Houyou] | RUS cover | SilenTium",
          "edit-recording.length": "166000",
          "edit-recording.url.0.link_type_id": "268"
        }
      }
      
      

            Unassigned Unassigned
            chaban chaban
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Version Package