← Back to team overview

maria-discuss team mailing list archive

Re: Problem with InnoDB: Semaphore wait after upgrading to 10.3.27

 



Am 16.03.21 um 14:58 schrieb Conor Murphy:
Hi,

We have a handful of servers running MariaDB 10.3. We noticed issues on two of them where we were getting issues like "InnoDB: A long semaphore wait:--Thread 140602802394880 has waited at dict0stats.cc line 1969 for 241.00 seconds the semaphore:" and crashes like "ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.210215  7:14:24 [ERROR] mysqld got signal 6 ;"

Turned out that these two servers were running 10.3.27 whereas the others were running 10.3.17. After downgrading the two problem servers to 10.3.17, all the issues with InnoDB semaphores stopped.

Any ideas on how to track down what change between 10.3.17 to 10.3.27 might be causing this problem?

any ideas why you jump from 10.3.17 to 10.3.27 at that point in time?

[root@srv-rhsoft:~]$ rpm -q --changelog mariadb | head
* Mo Feb 22 2021 Reindl Harald <h.reindl@xxxxxxxxxxxxx>
- update to 10.3.28


References