maria-discuss team mailing list archive

[Radisson <Radisson97@xxxxxx>]

Am 13.03.23 um 07:50 schrieb Marko Mäkelä:
> Hi,
>
> 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 :)

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