Description:
executing SELECT COUNT(DISTINCT CONCAT(productCode,'/',majorCode)) FROM requirement WHERE productCode='M801' seems to consistently crash the MySQL server
(MyISAM tables being used)
any other combination of COUNT, DISTINCT and CONCAT seems to be OK
The server does not seem to crash immediatly, using the MySQL client I was able to run the statement a couple of times before the server crashed
Using the DBVisualiser tool and the MySQL JABC 3.1.6 connector it crashed immediatly (or apparently so)
Using the JDBC and a Java program several subsequent statements were executed before the server crashed
This is the 5.0.3 distribution as downloaded, there have been no changes to the binaries.
It's possible that 5.0.1 had the same issue in that there were occacsional problems there but they were far less frequent.
How to repeat:
This may be specific to my database schema (it's not specific to the contents of the database) I'm happy to provide a copy of the DB and config file if needed.
Just executing
SELECT COUNT(DISTINCT CONCAT(productCode,'/',majorCode)) FROM requirement WHERE productCode='M801'
causes the database to lock up with the following error messages
(note there are over seven hundred pages like this in the log with the sequence apparently repreating)
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\heap\hp_open.c:41'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\uniques.cpp:65'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mf_cache.c:65'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mf_cache.c:66'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mf_iocache.c:216'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:195'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_select.cpp:5731'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\lock.cpp:210'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\array.c:236'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:183'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:184'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mf_iocache.c:1241'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mf_cache.c:118'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mf_cache.c:119'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:291'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\array.c:236'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\heap\hp_close.c:49'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\heap\hp_create.c:268'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\heap\hp_create.c:269'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_select.cpp:8630'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_select.cpp:8635'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:291'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:63'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:291'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:183'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:184'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_db.cpp:1020'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_db.cpp:1084'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:183'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:184'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:63'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:291'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:183'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:184'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:63'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:291'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\lock.cpp:415'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_select.cpp:3059'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:195'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:291'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:195'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mulalloc.c:51'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_select.cpp:8126'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\ha_heap.cpp:467'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\heap\hp_create.c:132'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\heap\hp_create.c:187'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\ha_heap.cpp:558'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\heap\hp_open.c:41'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\uniques.cpp:65'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mf_cache.c:65'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mf_cache.c:66'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mf_iocache.c:216'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:195'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_select.cpp:5731'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\lock.cpp:210'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\array.c:236'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:183'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:184'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mf_iocache.c:1241'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mf_cache.c:118'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\mf_cache.c:119'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:291'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\array.c:236'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\heap\hp_close.c:49'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\heap\hp_create.c:268'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\heap\hp_create.c:269'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_select.cpp:8630'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_select.cpp:8635'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:291'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:63'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:291'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:183'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:184'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_db.cpp:1020'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_db.cpp:1084'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:183'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:184'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:63'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:291'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:183'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_lex.cpp:184'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:63'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:291'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\lock.cpp:415'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\sql\sql_select.cpp:3059'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:195'
Error: Memory allocated at C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:127 was overrun, discovered at 'C:\cygwin\home\mysqldev\build\mysql-5.0.3-beta-build\mysql-5.0.3-beta\mysys\my_alloc.c:291'
Suggested fix:
I admit the code that causes the problem is dumb code (whihc is why this is not severity 1) and I've been able to find a far easier way of working out the answer but it does still crash the server - hence the Severity 2 priority