← Back to team overview

maria-discuss team mailing list archive

Re: can not kill process


Am 13.03.23 um 07:50 schrieb Marko Mäkelä:

On Sun, Mar 12, 2023 at 12:45 PM Radisson <Radisson97@xxxxxx> wrote:
Am 11.03.23 um 10:53 schrieb Radisson97@xxxxxx:
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 :)


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.


Follow ups