Re[32]: Warning: Got signal 14 from thread X

[Michael Widenius]

Hi!

>>>>> "Heikki" == Heikki Tuuri <Heikki.Tuuri@stripped>
> writes:

Heikki> Monty and Alex,
Heikki> maybe Monty discovered the source of the problem: Innobase indeed
Heikki> modifies the sigmask of the thread which does the database intialization.
Heikki> Maybe other threads then inherit the modified sigmask.

Heikki> I had disabled the use of native Unix aio from Innobase, but forgot
Heikki> the following segment of code into /innobase/os/os0file.c,
Heikki> about line 920 in function os_aio_init:
Heikki> .................................
Heikki>         }

Heikki> #ifdef POSIX_ASYNC_IO
Heikki>         /* Block aio signals from the current thread and its children:
Heikki>         for this to work, the current thread must be the first created
Heikki>         in the database, so that all its children will inherit its
Heikki>         signal mask */

Heikki>         sigemptyset(&sigset);
Heikki>         sigaddset(&sigset, SIGRTMIN + 1 + 0);
Heikki>         sigaddset(&sigset, SIGRTMIN + 1 + 1);
Heikki>         sigaddset(&sigset, SIGRTMIN + 1 + 2);
Heikki>         sigaddset(&sigset, SIGRTMIN + 1 + 3);

Heikki>         pthread_sigmask(SIG_BLOCK, &sigset, NULL);
Heikki> #endif
Heikki> }
Heikki> .................................

Heikki> Alex, try commenting out those lines, and check if the signal 14 error
Heikki> still occurs.

I have now removed the above lines for MySQL 3.23.36!

Regards,
Monty