Bug #13718 | server crash | ||
---|---|---|---|
Submitted: | 3 Oct 2005 15:26 | Modified: | 3 Oct 2005 22:51 |
Reporter: | Vladimir Kolesnikov | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Stored Routines | Severity: | S2 (Serious) |
Version: | 5.0.13 rc/5.0 BK source | OS: | Windows (win xp sp 2/Linux) |
Assigned to: | CPU Architecture: | Any |
[3 Oct 2005 15:26]
Vladimir Kolesnikov
[3 Oct 2005 15:35]
MySQL Verification Team
It is the 5.0.13 an upgrade install over an older one? If yes then it is bug already reported. Thanks in adavnce.
[3 Oct 2005 15:48]
Vladimir Kolesnikov
I just uninstalled the server, then installed it again to a new dir (with a new datadir). After all it still crashes.
[3 Oct 2005 16:31]
MySQL Verification Team
Thank you for the bug report. 051003 13:04:42 [Note] /home/miguel/dbs/5.0/libexec/mysqld: ready for connections. Version: '5.0.15-rc-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution <cut> Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 1132456880 (LWP 7115)] 0x0859e3cc in my_strcasecmp_utf8 (cs=0x878e0e0, s=0x8639dd3 "information_schema", t=0x0) at ctype-utf8.c:2347 2347 while (s[0] && t[0]) Current language: auto; currently c (gdb) bt full #0 0x0859e3cc in my_strcasecmp_utf8 (cs=0x878e0e0, s=0x8639dd3 "information_schema", t=0x0) at ctype-utf8.c:2347 uni_plane = (MY_UNICASE_INFO **) 0x878cf00 #1 0x081f32d0 in mysql_execute_command (thd=0x8e38290) at sql_parse.cc:4049 namelen = 149532008 name = 0x0 db = 0x8e63960 '\217' <repeats 200 times>... result = 1132453808 res = false result = 0 lex = (LEX *) 0x8e382d0 select_lex = (SELECT_LEX *) 0x8e384f4 slave_fake_lock = false fake_prev_lock = (MYSQL_LOCK *) 0x0 first_table = (TABLE_LIST *) 0x0 all_tables = (TABLE_LIST *) 0x0 unit = (SELECT_LEX_UNIT *) 0x8e382e0 _db_func_ = 0x437fdfc8 "" _db_file_ = 0x8e63820 "" _db_level_ = 149127856 _db_framep_ = (char **) 0x437fdfac #2 0x081f6c91 in mysql_parse (thd=0x8e38290, inBuf=0x8e63830 "CREATE PROCEDURE `p1`()\r\nBEGIN\r\n select 2;\r\nEND", length=48) at sql_parse.cc:5507 lex = (LEX *) 0x8e382d0 _db_func_ = 0x87b65c0 "h\207b\b" _db_file_ = 0x81ed44d "\203Ä \203=Ôk|\b" _db_level_ = 1132453908 _db_framep_ = (char **) 0x0 Below the MySQL Administrator sequence commands: 051003 13:22:02 2 Query show databases 051003 13:22:04 4 Connect miguel@192.168.0.33 on 4 Query SET SESSION interactive_timeout=1000000 4 Query SELECT @@sql_mode 4 Query SET SESSION sql_mode='' 4 Query SET NAMES utf8 4 Init DB test 4 Query SHOW TABLE STATUS 4 Quit 5 Connect miguel@192.168.0.33 on 5 Query SET SESSION interactive_timeout=1000000 5 Query SELECT @@sql_mode 5 Query SET SESSION sql_mode='' 5 Query SET NAMES utf8 5 Init DB test 5 Query SHOW TABLE STATUS 5 Quit 6 Connect miguel@192.168.0.33 on 6 Query SET SESSION interactive_timeout=1000000 6 Query SELECT @@sql_mode 6 Query SET SESSION sql_mode='' 6 Query SET NAMES utf8 6 Init DB test 6 Query SHOW PROCEDURE STATUS 6 Query SHOW FUNCTION STATUS 6 Quit 051003 13:22:06 3 Quit 051003 13:22:17 2 Query CREATE PROCEDURE `test`.`sp1` () BEGIN select 1; END 7 Connect miguel@192.168.0.33 on 7 Query SET SESSION interactive_timeout=1000000 7 Query SELECT @@sql_mode 7 Query SET SESSION sql_mode='' 7 Query SET NAMES utf8 7 Init DB test 7 Query SHOW TABLE STATUS 7 Quit 8 Connect miguel@192.168.0.33 on 8 Query SET SESSION interactive_timeout=1000000 8 Query SELECT @@sql_mode 8 Query SET SESSION sql_mode='' 8 Query SET NAMES utf8 8 Init DB test 8 Query SHOW TABLE STATUS 8 Quit 9 Connect miguel@192.168.0.33 on 9 Query SET SESSION interactive_timeout=1000000 9 Query SELECT @@sql_mode 9 Query SET SESSION sql_mode='' 9 Query SET NAMES utf8 9 Init DB test 9 Query SHOW PROCEDURE STATUS 9 Query SHOW CREATE PROCEDURE `test`.`sp1` 9 Query SHOW FUNCTION STATUS 9 Quit 051003 13:22:19 10 Connect miguel@192.168.0.33 on 10 Query SET SESSION interactive_timeout=1000000 10 Query SELECT @@sql_mode 10 Query SET SESSION sql_mode='' 10 Query SET NAMES utf8 10 Query SHOW CREATE PROCEDURE `test`.`sp1` 10 Quit 051003 13:22:24 2 Query DROP PROCEDURE IF EXISTS test.sp1 2 Query CREATE PROCEDURE `sp1`() BEGIN select 2; END
[3 Oct 2005 21:52]
Konstantin Osipov
To be able to proceed with this bug report I need a test case that is reproducible outside of MySQL Administrator. Your collaboration with submitting an easy to repeat test case is highly apreicated.
[3 Oct 2005 22:54]
MySQL Verification Team
This is duplicate of bug: http://bugs.mysql.com/bug.php?id=13514 because MA tries to create the SP without to select a database: 051003 13:22:19 10 Connect miguel@192.168.0.33 on 10 Query SET SESSION interactive_timeout=1000000 10 Query SELECT @@sql_mode 10 Query SET SESSION sql_mode='' 10 Query SET NAMES utf8 10 Query SHOW CREATE PROCEDURE `test`.`sp1` 10 Quit 051003 13:22:24 2 Query DROP PROCEDURE IF EXISTS test.sp1 2 Query CREATE PROCEDURE `sp1`() BEGIN select 2; END See: CREATE PROCEDURE `sp1`() instead of CREATE PROCEDURE `test`.`sp1` () and the back trace shows the same source as the bug above mentioned.