Description:
Can't start mysqld.exe getting signal 11 in .err file. Can't find localhost once this error starts to occur.
How to repeat:
Initial Problem: attempted to start server using mysqld.exe.
Used mysqld --log in dos shell to check out what the problem was and got:
040803 11:54:41 InnoDB: Starting shutdown...
040803 11:54:43 InnoDB: Shutdown completed
040803 11:54:43 mysqld: Shutdown Complete
Warning: Not freed memory segments: 21
Warning: Memory that was not free'ed (45066 bytes):
40 bytes at 0x002568130, allocated at line 410 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\sql\lock.cpp'
968 bytes at 0x0025682f0, allocated at line 160 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\mysys\my_alloc.c'
968 bytes at 0x002567c20, allocated at line 160 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\mysys\my_alloc.c'
3 bytes at 0x002564558, allocated at line 80 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\sql\table.cpp'
968 bytes at 0x002567718, allocated at line 160 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\mysys\my_alloc.c'
840 bytes at 0x002567380, allocated at line 898 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\sql\sql_base.cpp'
5 bytes at 0x002564430, allocated at line 80 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\sql\table.cpp'
968 bytes at 0x002565fc0, allocated at line 160 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\mysys\my_alloc.c'
840 bytes at 0x002565c28, allocated at line 898 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\sql\sql_base.cpp'
968 bytes at 0x0025645e0, allocated at line 160 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\mysys\my_alloc.c'
968 bytes at 0x002563f30, allocated at line 160 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\mysys\my_alloc.c'
5 bytes at 0x002563df8, allocated at line 80 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\sql\table.cpp'
968 bytes at 0x0025639e0, allocated at line 160 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\mysys\my_alloc.c'
840 bytes at 0x002563648, allocated at line 898 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\sql\sql_base.cpp'
6 bytes at 0x0025635f0, allocated at line 159 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\sql\sql_acl.cpp'
32768 bytes at 0x00255ad60, allocated at line 178 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\mysys\mf_iocache.c'
3 bytes at 0x000ceffa0, allocated at line 66 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\mysys\mf_cache.c'
36 bytes at 0x000ceff28, allocated at line 65 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\mysys\mf_cache.c'
128 bytes at 0x000cefe60, allocated at line 140 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\sql\sql_class.cpp'
2136 bytes at 0x00255a4b8, allocated at line 275 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\sql\sql_list.h'
640 bytes at 0x000bc6330, allocated at line 54 in 'C:\cygwin\home\mysqldev\build\build_gpl-20040527\mysql-4.0.20a\sql\sql_base.cpp'
Maximum memory usage: 8519584 bytes (8320k)
040806 9:51:12 InnoDB: Started
040806 9:51:13 mysqld: Got signal 11. Aborting!
Uninstalled Mysql Version 4.0.20a, deleted the c:/mysql folder and reinstalled
same version of Mysql.
Started mysqld in dos shell and worked fine initially.
Started mysql client.
Created a new database and loaded tables into database.
Went to grant select, insert, update and create privileges
to a user and that is when the Mysql server shutdown the second time.
Restarted computer and tried again - no success.
Tried to start mysqld with --log option. Got the following in the log file.
040806 17:33:57 InnoDB: Started
mysqld: ready for connections.
Version: '4.0.20a-debug' socket: '' port: 3306
040806 17:40:25 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
040806 17:40:26 InnoDB: Flushing modified pages from the buffer pool...
040806 17:40:26 InnoDB: Started
040806 17:40:26 mysqld: Got signal 11. Aborting!
040806 17:40:26 Aborting
Did the following and got the following messages:
>mysqladmin -u root processlist
mysqladmin: connect to server at 'localhost' failed
error: can't connect to MySql server on 'localhost'(10061)
>mysql
ERROR 2003:Can't connect to MySQL server on 'localhost'(10061)
