Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29700

Insert statements creating lock, semaphore timeout and database crash

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • None
    • N/A
    • None
    • production

    Description

      Hello,

      We have the following error on mariadb logs

      {{---TRANSACTION 36378384337, ACTIVE 14 sec inserting

      mysql tables in use 1, locked 1

      1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1

      MySQL thread id 75420, OS thread handle 139610418177792, query id 1658346 172.16.0.215 mastermaestro Update

      INSERT INTO `actions` SET `actor` ='6399000', `target` ='6399000', `descr` ='test@icloud.com set bos_mobile_search_filter_selection to {\"start_format\":\"all\",\"category\":\"freeroll\",\"status\":\"all\",\"str_search\":\"\"}', `tag` ='bos_mobile_search_filter_selection', `actor_username` ='test@icloud.com'

      }}

      and error logs are filled with below errors before crashing:

      2022-10-04 13:48:08 0 [Note] InnoDB: A semaphore wait:
      --Thread 139665300420352 has waited at row0ins.cc line 2628 for 255.00 seconds the semaphore:
      SX-lock on RW-latch at 0x7f0648066f78 created in file buf0buf.cc line 1221
      a writer (thread id 139610400573184) has reserved it in mode SX
      number of readers 0, waiters flag 1, lock_word: 10000000
      Last time write locked in file mtr0mtr.ic line 112
      2022-10-04 13:48:08 0 [Note] InnoDB: A semaphore wait:
      --Thread 139665296123648 has waited at row0ins.cc line 2628 for 253.00 seconds the semaphore:
      SX-lock on RW-latch at 0x7f0648066f78 created in file buf0buf.cc line 1221
      a writer (thread id 139610400573184) has reserved it in mode SX
      number of readers 0, waiters flag 1, lock_word: 10000000
      Last time write locked in file mtr0mtr.ic line 112

      Anyone can guide me where to troubleshoot? I've seen some forums re: indexing but we did some changes and still having the same issue.

      Attachments

        Activity

          People

            Unassigned Unassigned
            jusc27 JC
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.