Another crash of MySQL
This morning, in trying to access the blog to enter something (editing the previous post)., MySQL broke – again:
InnoDB: Thread 82752192 stopped in file MYSQL_ROOT:[innobase.include]sync0sync.
mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.
key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=5
max_connections=100
threads_connected=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 72191
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
InnoDB: Thread 72282816 stopped in file MYSQL_ROOT:[innobase.include]sync0sync.
InnoDB: Thread 72233664 stopped in file MYSQL_ROOT:[innobase.os]os0sync.c;1 lin
%CMA-F-EXIT_THREAD, current thread has been requested to exit
%TRACE-F-TRACEBACK, symbolic stack dump follows
image module routine line rel PC abs PC
PTHREAD$RTL 0 000000000004367C FFFFFFFF8126367C
PTHREAD$RTL 0 000000000006E9E8 FFFFFFFF8128E9E8
0 FFFFFFFF8016F094 FFFFFFFF8016F094
0 FFFFFFFF80376E0C FFFFFFFF80376E0C
DECC$SHR_EV56 0 00000000001D2DC4 FFFFFFFF8146ADC4
DECC$SHR_EV56 0 00000000001D2A8C FFFFFFFF8146AA8C
0 FFFFFFFF8018780C FFFFFFFF8018780C
0 FFFFFFFF8018780C FFFFFFFF8018780C
----- above condition handler called with exception 0000000C:
%SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=00000000000
----- end of exception message
0 FFFFFFFF800A911C FFFFFFFF800A911C
and more stack data
Virtual addres 0 – and therefore ACCVIO.
I Think I found something: the MYSQL database itself seems to be MYISAM. I had installed it requesting INNODB, if I recall correctly! This is something to look into.
Anyway, in 10 minutes the watcher started it agaan to I couild do my editing about 10 minutes later.
On the web front: The program is progessing slowly. The IO routines on RMS files have been coded, except for one or two more routines. Ready to test them – after writing a driver for it.