MySQL crashed
… several times since I chnaged some system parameters.
First, immediately during startup (elapsed time half a minute) after first reboot:
071003 22:45:33 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 38153825.
InnoDB: Doing recovery: scanned up to log sequence number 0 38153825
InnoDB: Last MySQL binlog file position 0 4, file name ./diana-bin.000011
071003 22:45:36 InnoDB: Flushing modified pages from the buffer pool...
071003 22:45:37 InnoDB: Started; log sequence number 0 38153825
071003 22:45:37 [ERROR] After InnoDB crash recovery, checking if the binary log
'./diana-bin.000011' contains rolled back transactions which must be removed from it...
/$116$DKA100/000000/WEB/MYSQL/MYSQL/VMS/BIN/mysqld.exe:
File './diana-bin.000011' not found (Errcode: 2)
071003 22:45:37 [ERROR] Could not open the binary log './diana-bin.000011' for truncation.
InnoDB: Error: tried to read 16384 bytes at offset 0 6012928.
InnoDB: Was only able to read -1.
071003 22:45:38 InnoDB: Operating system error number 12 in a file operation.
InnoDB: Error number 12 means 'not enough core'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: File operation call: 'read'.
InnoDB: Cannot continue operation.
After restart it crashed again during startup:
$ Set NoOn
$ VERIFY = F$VERIFY(F$TRNLNM("SYLOGIN_VERIFY"))
071003 23:03:41 InnoDB: Operating system error number 12 in a file operation.
InnoDB: Error number 12 means 'not enough core'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: File name /database/mysql41/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
I restarted it once again, and next, the server ran for almost 4 days and crahed – again:
%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
InnoDB: Thread 117396224 stopped in file MYSQL_ROOT:[innobase.include]sync0sync
%SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=00000000000
%TRACE-F-TRACEBACK, symbolic stack dump follows
image module routine line rel PC abs PC
PTHREAD$RTL 0 000000000004381C FFFFFFFF81E6181C
PTHREAD$RTL 0 000000000006EB58 FFFFFFFF81E8CB58
0 FFFFFFFF8016EFB4 FFFFFFFF8016EFB4
0 FFFFFFFF80376E0C FFFFFFFF80376E0C
DECC$SHR_EV56 0 00000000001D2DC4 FFFFFFFF82066DC4
DECC$SHR_EV56 0 00000000001D2A8C FFFFFFFF82066A8C
0 FFFFFFFF8018776C FFFFFFFF8018776C
0 FFFFFFFF8018776C FFFFFFFF8018776C
—– 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
DECC$SHR_EV56 0 0000000000108364 FFFFFFFF81F9C364
DECC$SHR_EV56 0 0000000000108560 FFFFFFFF81F9C560
DECC$SHR_EV56 0 0000000000142D74 FFFFFFFF81FD6D74
DECC$SHR_EV56 0 0000000000142118 FFFFFFFF81FD6118
DECC$SHR_EV56 0 000000000013BBA4 FFFFFFFF81FCFBA4
InnoDB: Thread 87978752 stopped in file MYSQL_ROOT:[innobase.include]sync0sync.
mysqld MY_PTHREAD sigwait 23808 0000000000000408 00000000003C5108
mysqld OS0FILE os_aio_simulated_handle
36642 0000000000005AB4 00000000002CE344
InnoDB: Thread 87929600 stopped in file MYSQL_ROOT:[innobase.os]os0sync.c;1 lin
mysqld mysqld signal_hand 86616 0000000000002AE8 0000000000232AE8
PTHREAD$RTL 0 000000000005773C FFFFFFFF81E7573C
PTHREAD$RTL 0 0000000000043940 FFFFFFFF81E61940
0 0000000000000000 0000000000000000
PTHREAD$RTL ? ?
0 FFFFFFFF80377CE4 FFFFFFFF80377CE4
%TRACE-I-END, end of TRACE stack dump
mysqld FIL0FIL fil_aio_wait 45034 000000000000E80C 000000000028D12C
mysqld SRV0START io_handler_thread 57590 00000000000009D4 0000000000317984
PTHREAD$RTL 0 000000000005773C FFFFFFFF81E7573C
PTHREAD$RTL 0 0000000000043940 FFFFFFFF81E61940
0 0000000000000000 0000000000000000
PTHREAD$RTL ? ?
0 FFFFFFFF80377CE4 FFFFFFFF80377CE4
%TRACE-I-END, end of TRACE stack dump
%CMA-F-EXIT_THREAD, current thread has been requested to exit
InnoDB: Thread 87929600 stopped in file MYSQL_ROOT:[innobase.os]os0sync.c;1 line 501
InnoDB: Thread 87978752 stopped in file MYSQL_ROOT:[innobase.include]sync0sync.ic;1 line 111
%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 000000000004381C FFFFFFFF81E6181C
PTHREAD$RTL 0 000000000006EB58 FFFFFFFF81E8CB58
0 FFFFFFFF8016EFB4 FFFFFFFF8016EFB4
0 FFFFFFFF80376E0C FFFFFFFF80376E0C
DECC$SHR_EV56 0 00000000001D2DC4 FFFFFFFF82066DC4
DECC$SHR_EV56 0 00000000001D2A8C FFFFFFFF82066A8C
0 FFFFFFFF8018776C FFFFFFFF8018776C
0 FFFFFFFF8018776C FFFFFFFF8018776C
—– above condition handler called with exception 0000000C:
%SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=0000000000000000, PC=000000000028CDE4, PS=0000001B
—– end of exception message
0 FFFFFFFF800A911C FFFFFFFF800A911C
mysqld FIL0FIL fil_io 44926 000000000000E4C4 000000000028CDE4
and the last one happend yesterday:
InnoDB: Thread 87929600 stopped in file MYSQL_ROOT:[innobase.os]os0sync.c;1 lin
InnoDB: Thread 87978752 stopped in file MYSQL_ROOT:[innobase.include]sync0sync.
%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 000000000004381C FFFFFFFF81E6181C
PTHREAD$RTL 0 000000000006EB58 FFFFFFFF81E8CB58
0 FFFFFFFF8016EFB4 FFFFFFFF8016EFB4
0 FFFFFFFF80376E0C FFFFFFFF80376E0C
DECC$SHR_EV56 0 00000000001D2DC4 FFFFFFFF82066DC4
DECC$SHR_EV56 0 00000000001D2A8C FFFFFFFF82066A8C
0 FFFFFFFF8018776C FFFFFFFF8018776C
0 FFFFFFFF8018776C FFFFFFFF8018776C
----- 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
mysqld FIL0FIL fil_io 44926 000000000000E4C4 000000000028CDE4
The first ones may have to do with the IDE server of Distributed Netbeans running: there might indeed have been too little memory, all consumed by that stuff.
The last ones may have been the result of the WEBES issues – again, a set of JAVA programs consuming lots of memory.
Keep the fingers crossed….
PHP problems
It’s not just MySQL. PHP suffers of access problems as well since these changes: complains of files that cannot be opened, and on second invocation, nothing is wrong…
I’ll have to reconsider the cahnges and eventually turn them back – bit on the other hand, I may need at least some of the resources when RdB is installed.