Bug #9715 SP crashes MySQL server if query cache is enabled
| Submitted: | 7 Apr 2005 12:58 | Modified: | 17 Jun 2005 13:19 |
|---|---|---|---|
| Reporter: | Victoria Reznichenko | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.0 | OS: | Any (any) |
| Assigned to: | Oleksandr Byelkin | CPU Architecture: | Any |
[7 Apr 2005 13:01]
MySQL Verification Team
Database dump was uploaded to FTP server: bug9715.zip
[13 May 2005 6:05]
Oleksandr Byelkin
Thank you for bugreport. But this bug have the same nature as Bug #5963, Yoiu can yse following URL to track down progress in bugfixing: http://bugs.mysql.com/bug.php?id=5963
[14 Jun 2005 17:41]
Oleksandr Byelkin
minimal test suite: set GLOBAL query_cache_size=1355776; create table t1 (a int); insert into t1 values (1),(2); delimiter //; CREATE PROCEDURE `p1`() begin Declare var1 int; Declare c1 cursor for select a from t1; open c1; select * from t1; end// call p1()//
[14 Jun 2005 18:30]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/25992
[14 Jun 2005 19:45]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/25997
[16 Jun 2005 9:49]
Stas Nichiporovich
Befor patching server crashed every time such procedure was called. And after pacthing it almost does not crash, but sometimes it do :(
[17 Jun 2005 13:19]
Paul DuBois
Noted in 5.0.8 changelog.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.044 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: SP crashes MySQL server if query cache is enabled. mysql> call `dbpos`.`upiaddruntimekeypositions`(); ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> Number of processes running now: 0 050407 16:56:12 mysqld restarted If I disable query cache SP runs like charm. Back trace: (gdb) bt #0 0xb7ceda21 in kill () from /lib/libc.so.6 #1 0xb7e48051 in pthread_kill () from /lib/libpthread.so.0 #2 0xb7e4842b in raise () from /lib/libpthread.so.0 #3 0xb7ced7b4 in raise () from /lib/libc.so.6 #4 0xb7ceec7d in abort () from /lib/libc.so.6 #5 0xb7ce6def in __assert_fail () from /lib/libc.so.6 #6 0x082c4d0a in Query_cache::send_result_to_client (this=0x8852260, thd=0x8eb51e8, sql=0x8f1fd40 "select ifnull(max(slsruntimemap.`lindexid`)+1,1)\n \t\t\tinto p_lindexid\n \t\t\tfrom slsruntimemap\n \t\t\twhere slsruntimemap.`lmapid`=p_lmapid", query_length=133) at sql_cache.cc:930 #7 0x082faad8 in sp_instr_stmt::execute (this=0x8eeef98, thd=0x8eb51e8, nextp=0xbe3ff16c) at sp_head.cc:1356 #8 0x082f88b9 in sp_head::execute (this=0x8eedbb8, thd=0x8eb51e8) at sp_head.cc:558 #9 0x082f927f in sp_head::execute_procedure (this=0x8eedbb8, thd=0x8eb51e8, args=0x8eb567c) at sp_head.cc:778 #10 0x081c4162 in mysql_execute_command (thd=0x8eb51e8) at sql_parse.cc:4090 #11 0x081c6d55 in mysql_parse (thd=0x8eb51e8, inBuf=0x8ebb248 "call `dbpos`.`upiaddruntimekeypositions`()", length=42) at sql_parse.cc:5149 #12 0x081bd46e in dispatch_command (command=COM_QUERY, thd=0x8eb51e8, packet=0x8edc661 "call `dbpos`.`upiaddruntimekeypositions`()", packet_length=43) at sql_parse.cc:1647 #13 0x081bcd1d in do_command (thd=0x8eb51e8) at sql_parse.cc:1453 #14 0x081bbea8 in handle_one_connection (arg=0x8eb51e8) at sql_parse.cc:1110 #15 0xb7e4514b in pthread_start_thread () from /lib/libpthread.so.0 #16 0xb7e451df in pthread_start_thread_event () from /lib/libpthread.so.0 #17 0xb7d7850a in clone () from /lib/libc.so.6 How to repeat: 1. Start MySQL server with enabled query cache. 2. Restore database from dump 3. Create stored procedure from sp.sql 4. Run: call `dbpos`.`upiaddruntimekeypositions`();