: Assertion `! is_set()' failed when preparing a HANDLER statement
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Medium
|
Michael Widenius |
Bug Description
Preparing a HANDLER statement fails with the following assertion:
mysqld: sql_class.cc:563: void Diagnostics_
backtrace:
# 2011-01-05T13:30:54 #8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
# 2011-01-05T13:30:54 #9 0x0826db43 in Diagnostics_
# 2011-01-05T13:30:54 message_
# 2011-01-05T13:30:54 #10 0x081b1b01 in my_ok (thd=0xa72dc70, affected_rows=0, id=0, message=0x88df29b "Statement prepared") at sql_class.h:2601
# 2011-01-05T13:30:54 #11 0x0834efcd in mysql_sql_
# 2011-01-05T13:30:54 #12 0x0829ad71 in mysql_execute_
# 2011-01-05T13:30:54 #13 0x082a68da in mysql_parse (thd=0xa72dc70,
# 2011-01-05T13:30:54 rawbuf=0xa7422d8 "PREPARE h_r FROM ' HANDLER `table100_
# 2011-01-05T13:30:54 found_semicolon
# 2011-01-05T13:30:54 #14 0x08298840 in dispatch_command (command=COM_QUERY, thd=0xa72dc70,
# 2011-01-05T13:30:54 packet=0xa734459 " PREPARE h_r FROM ' HANDLER `table100_
# 2011-01-05T13:30:54 packet_length=117) at sql_parse.cc:1211
# 2011-01-05T13:30:54 #15 0x08297caa in do_command (thd=0xa72dc70) at sql_parse.cc:904
# 2011-01-05T13:30:54 #16 0x08294d86 in handle_
# 2011-01-05T13:30:54 #17 0x00821919 in start_thread () from /lib/libpthread
# 2011-01-05T13:30:54 #18 0x0076acce in clone () from /lib/libc.so.6
# 2011-01-05T13:30:54 #5 0x004d5424 in __kernel_vsyscall ()
test case (this query is the entire test case):
PREPARE h_r FROM ' HANDLER t1 READ `PRIMARY` LAST ';
Note that historically there have been numerous bugs around the Diagnostics_area assertions, many of them fixed in mysql
Related branches
Changed in maria: | |
milestone: | none → 5.3 |
assignee: | nobody → Michael Widenius (monty) |
Changed in maria: | |
status: | New → In Progress |
Changed in maria: | |
importance: | Undecided → Medium |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |