From: Note
Date: March 2 2000 4:41pm
Subject: Re: MySQL crashing on signal 11 many times...
List-Archive: http://lists.mysql.com/mysql/29830
Message-Id: <38BE99AF.E785BC20@teglet.co.jp>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>
      > > > >Description:
      > > >     Maybe it's HW problem, maybe OS, but maybe MySQL... I
don't know why
      > but
      > > > MySQL crashin on signal 11 about 2 times a day. the last
core-dump is
      > here:
      > > > free.xprojekt.cz/mysql/mysql.core. thank you for help.
      > > >
      > > > >How-To-Repeat:
      > > >     Sometimes, about two times per day.
      > > > >Fix:
      > > >     You should know it :-)
      > >
      > > Can you re-compile mysql --with-debug and then backtrace the
core dump.
      > Also
      > > enable logging and try to catch the query that causes the core
dump. Try
      > to
      > > create a fully-functional .sql file so that mysql test <
file.sql would
      > always
      > > cause a core dump if possible.
      > Loging is enable. It crashes on any query, and if i try the same
query
      > again, it works. It's not on query :-(
      > But if i recompile mysql with-debug, compilation crash :-( But
these
      > problems i have from 3.23 versions. Never before...
      >
      > BTW: i tried: 3.23.1, 3.23.3, 3.23.4, 3.23.5, 3.23.8, 3.23.10,
3.23.11...
      > the same :-( downgrade to 3.22 is hard, because i'm using new
function and
      > MyISAM...

Hi Martin,

Did you try "--low-priority-updates" option? In my case, the option
solved the problem.
Shutdown MySQL, run myisamchk -r, and run MySQL with
low-priority-updates. myisamchk 3.23.11 has a bug, so use 3.23.10.

Good luck!
Masayuki
http://www.teglet.co.jp