Heikki and Monty,
HT> maybe Monty discovered the source of the problem: Innobase indeed
HT> modifies the sigmask of the thread which does the database intialization.
HT> Maybe other threads then inherit the modified sigmask.
HT> I had disabled the use of native Unix aio from Innobase, but forgot
HT> the following segment of code into /innobase/os/os0file.c,
HT> about line 920 in function os_aio_init:
HT> .................................
HT> }
HT> #ifdef POSIX_ASYNC_IO
HT> /* Block aio signals from the current thread and its children:
HT> for this to work, the current thread must be the first created
HT> in the database, so that all its children will inherit its
HT> signal mask */
HT> sigemptyset(&sigset);
HT> sigaddset(&sigset, SIGRTMIN + 1 + 0);
HT> sigaddset(&sigset, SIGRTMIN + 1 + 1);
HT> sigaddset(&sigset, SIGRTMIN + 1 + 2);
HT> sigaddset(&sigset, SIGRTMIN + 1 + 3);
HT> pthread_sigmask(SIG_BLOCK, &sigset, NULL);
HT> #endif
HT> }
HT> .................................
HT> Alex, try commenting out those lines, and check if the signal 14 error
HT> still occurs.
Sorry, I commented out these lines but :
010326 11:30:24 mysqld started
Innobase: The first specified data file /usr/local/mysql/var/innobase_data/ibdata1 did
not exist:
Innobase: a new database to be created!
Innobase: Log file /usr/local/mysql/var/innobase_logs/ib_logfile0 did not exist: new
to be created
Innobase: Log file /usr/local/mysql/var/innobase_logs/ib_logfile1 did not exist: new
to be created
Innobase: Log file /usr/local/mysql/var/innobase_logs/ib_logfile2 did not exist: new
to be created
Innobase: Log file /usr/local/mysql/var/innobase_logs/ib_logfile3 did not exist: new
to be created
Innobase: Log file /usr/local/mysql/var/innobase_logs/ib_logfile4 did not exist: new
to be created
Innobase: Started
Innobase: Setting file /usr/local/mysql/var/innobase_data/ibdata1 size to 524288000
Innobase: Database physically writes the file full: wait...
Innobase: Setting log file /usr/local/mysql/var/innobase_logs/ib_logfile0 size to
31457280
Innobase: Setting log file /usr/local/mysql/var/innobase_logs/ib_logfile1 size to
31457280
Innobase: Setting log file /usr/local/mysql/var/innobase_logs/ib_logfile2 size to
31457280
Innobase: Setting log file /usr/local/mysql/var/innobase_logs/ib_logfile3 size to
31457280
Innobase: Setting log file /usr/local/mysql/var/innobase_logs/ib_logfile4 size to
31457280
/usr/local/mysql/libexec/mysqld: ready for connections
010326 11:32:16 Warning: Got signal 14 from thread 4
010326 11:32:18 Warning: Got signal 14 from thread 4
010326 11:32:24 Warning: Got signal 14 from thread 4
010326 11:32:26 Warning: Got signal 14 from thread 4
010326 11:32:28 Warning: Got signal 14 from thread 4
010326 11:32:30 Warning: Got signal 14 from thread 4
010326 11:32:32 Warning: Got signal 14 from thread 4
010326 11:32:34 Warning: Got signal 14 from thread 4
010326 11:32:36 Warning: Got signal 14 from thread 4
Maybe you found a possible cause of problem, but there seems to be
another.
Regards,
Alex.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
