Uploaded image for project: 'FTS'
  1. FTS
  2. FTS-840

Deadlock between updateProtocol and updateFileTransferStatus

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: fts 3.5.7
    • Fix Version/s: fts 3.6.0
    • Component/s: MySQL
    • Security Level: Public Data (This ticket is visible to anyone on the internet and will be indexed by search engines)
    • Labels:
      None

      Description

      LATEST DETECTED DEADLOCK
      ------------------------
      2017-01-06 08:25:05 7f27af970700
      *** (1) TRANSACTION:
      TRANSACTION 13714999196, ACTIVE 0 sec starting index read
      mysql tables in use 1, locked 1
      LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
      MySQL thread id 875905, OS thread handle 0x7f27aeb38700, query id 12381580980 fts119.cern.ch 128.142.132.207 fts3lb updating
      UPDATE t_file set INTERNAL_FILE_PARAMS='nostreams:2,timeout:4000,buffersize:0', FILESIZE=4323974946 where file_id=400652028
      *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
      RECORD LOCKS space id 17 page no 1048042 n bits 80 index `PRIMARY` of table `pilotfts3lb`.`t_file` trx id 13714999196 lock_mode X locks rec but not gap waiting
      Record lock, heap no 12 PHYSICAL RECORD: n_fields 47; compact format; info bits 0
       
      *** (2) TRANSACTION:
      TRANSACTION 13714999197, ACTIVE 0 sec starting index read
      mysql tables in use 1, locked 1
      4 lock struct(s), heap size 1184, 2 row lock(s)
      MySQL thread id 875902, OS thread handle 0x7f27af970700, query id 12381580985 fts119.cern.ch 128.142.132.207 fts3lb updating
      UPDATE t_file SET     file_state = 'ACTIVE', reason = '', START_TIME = '2017-01-06 07:25:04', transferHost = 'fts119.cern.ch'   , pid = 32265, filesize = 0, tx_duration = 0, throughput = 0, current_failures = 0 WHERE file_id = 400652028
      *** (2) HOLDS THE LOCK(S):
      RECORD LOCKS space id 17 page no 1048042 n bits 80 index `PRIMARY` of table `pilotfts3lb`.`t_file` trx id 13714999197 lock mode S locks rec but not gap
      Record lock, heap no 12 PHYSICAL RECORD: n_fields 47; compact format; info bits 0
      *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
      RECORD LOCKS space id 17 page no 1048042 n bits 80 index `PRIMARY` of table `pilotfts3lb`.`t_file` trx id 13714999197 lock_mode X locks rec but not gap waiting
      Record lock, heap no 12 PHYSICAL RECORD: n_fields 47; compact format; info bits 0
       
      *** WE ROLL BACK TRANSACTION (1)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                aalvarez Alejandro Alvarez Ayllon
                Reporter:
                aalvarez Alejandro Alvarez Ayllon
                Component Watchers:
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: