Details
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.