Am 13.03.23 um 07:50 schrieb Marko Mäkelä:
Hi,
On Sun, Mar 12, 2023 at 12:45 PM Radisson <Radisson97@gmx.de> wrote:
Am 11.03.23 um 10:53 schrieb Radisson97@gmx.de:
hi i have a strange effect a simple insert got stuck (why ?)
I am afraid that the question could only be answered if you had attached a debugger to the mariadbd process and produced a stack trace of all threads. In https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ you can read how this is done. Installing the -debuginfo or -dbgsym package for the server makes the stack traces much more useful.
thx for the info, if it happens again and if possible i will try gdb to see where its stuck. Its a production machine, so do not hold your breath :) CU
any ideas what may the problem ?
We have observed the InnoDB hang https://jira.mariadb.org/browse/MDEV-29835 on MariaDB 10.6 and later versions in our internal testing. I believe that this type of a hang is possible starting with MariaDB 10.2 and MySQL 5.7.
Furthermore, I suspect that the InnoDB "os_event" that was removed in MariaDB Server 10.6 could occasionally lose signals. We occasionally observe test failures on our CI systems due to that.
It is hard to tell which type of hang would be more likely, and your hang could also have occurred due to something completely different.
Marko