[MDEV-25137] InnoDB: A long semaphore wait Created: 2021-03-15  Updated: 2021-06-19  Resolved: 2021-06-19

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2.36
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Cristiano Niguerola Assignee: Marko Mäkelä
Resolution: Incomplete Votes: 0
Labels: crash, need_feedback
Environment:

Red Hat Enterprise Linux Server release 6.10 (Santiago)
Dual Intel(R) Xeon(R) CPU E5-2660 v3 @ 2.60GHz, 256GB RAM, SSD storage

Attachments: File crash.7z    
Issue Links:
Relates
relates to MDEV-24378 Crashes on Semaphore wait > 600 seconds Closed

 Description   

Since few weeks we observe constant DB crashes every night around 1AM. We tried to check everything but we cannot pinpoint the root cause of the crashes. Can you please point us in the right direction? I'm attaching the crash log, unfortunately I don't have root access to server so I cannot collect crash dumps, but if those will be needed I will try to chase administrator of that server for help.

 Comments   
Comment by Alice Sherepa [ 2021-03-15 ]

it looks related to MDEV-24378, so maybe upgrade to 10.2.37 will help

Comment by Cristiano Niguerola [ 2021-03-15 ]

I was afraid of this answer. Unfortunately due to old RedHat we cannot upgrade to anything newer at the moment

Comment by Elena Stepanova [ 2021-04-18 ]

Why does old RedHat prevent you from upgrading 10.2.36 to 10.2.37? If you are using MariaDB repository, 10.2 is still provided for RHEL 6, so 10.2.37 should be available.
Or are you using MariaDB packages from the RedHat-owned repo, and they don't update it anymore?
Technically you can still switch to MariaDB repo, but you would have to uninstall the old one first and then install the new one, direct upgrade won't work. I imagine you don't want to do it without a good reason in production, but maybe you could try it in staging to see if it helps to get rid of the problem.

Comment by Cristiano Niguerola [ 2021-04-19 ]

There are no mariadb 10.2.37 under this link:
https://downloads.mariadb.com/MariaDB/mariadb-10.2.37/yum/rhel6-amd64/rpms/
Are you suggesting us to use those:
https://downloads.mariadb.com/MariaDB/mariadb-10.2.37/bintar-linux-systemd-x86_64/
Are they compatible with RHEL6?

Comment by Elena Stepanova [ 2021-05-17 ]

I'm not sure why they are not available there. You can find the packages at mariadb.org:
http://yum.mariadb.org/10.2.37/rhel6-amd64/

Generated at Thu Feb 08 09:35:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.