Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-2848

LP:697622 - : Assertion `! is_set()' failed when preparing a HANDLER statement

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      Preparing a HANDLER statement fails with the following assertion:

      mysqld: sql_class.cc:563: void Diagnostics_area::set_ok_status(THD*, ha_rows, ulonglong, const char*): Assertion `! is_set()' failed.

      backtrace:

      1. 2011-01-05T13:30:54 #8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
      2. 2011-01-05T13:30:54 #9 0x0826db43 in Diagnostics_area::set_ok_status (this=0xa72eea8, thd=0xa72dc70, affected_rows_arg=0, last_insert_id_arg=0,
      3. 2011-01-05T13:30:54 message_arg=0x88df29b "Statement prepared") at sql_class.cc:563
      4. 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
      5. 2011-01-05T13:30:54 #11 0x0834efcd in mysql_sql_stmt_prepare (thd=0xa72dc70) at sql_prepare.cc:2381
      6. 2011-01-05T13:30:54 #12 0x0829ad71 in mysql_execute_command (thd=0xa72dc70) at sql_parse.cc:2239
      7. 2011-01-05T13:30:54 #13 0x082a68da in mysql_parse (thd=0xa72dc70,
      8. 2011-01-05T13:30:54 rawbuf=0xa7422d8 "PREPARE h_r FROM ' HANDLER `table100_myisam_int_autoinc` READ `PRIMARY` LAST WHERE `col_int_not_null_key` >= 239 '", length=115,
      9. 2011-01-05T13:30:54 found_semicolon=0x91598228) at sql_parse.cc:6078
      10. 2011-01-05T13:30:54 #14 0x08298840 in dispatch_command (command=COM_QUERY, thd=0xa72dc70,
      11. 2011-01-05T13:30:54 packet=0xa734459 " PREPARE h_r FROM ' HANDLER `table100_myisam_int_autoinc` READ `PRIMARY` LAST WHERE `col_int_not_null_key` >= 239 ' ",
      12. 2011-01-05T13:30:54 packet_length=117) at sql_parse.cc:1211
      13. 2011-01-05T13:30:54 #15 0x08297caa in do_command (thd=0xa72dc70) at sql_parse.cc:904
      14. 2011-01-05T13:30:54 #16 0x08294d86 in handle_one_connection (arg=0xa72dc70) at sql_connect.cc:1154
      15. 2011-01-05T13:30:54 #17 0x00821919 in start_thread () from /lib/libpthread.so.0
      16. 2011-01-05T13:30:54 #18 0x0076acce in clone () from /lib/libc.so.6
      17. 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

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 697622

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 697622

              People

              • Assignee:
                monty Michael Widenius
                Reporter:
                philipstoev Philip Stoev
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: