maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

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