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

Assertion `!return_error || thd->is_error() || thd->killed' failed in mysql_delete

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3, 11.4
    • N/A
    • Sequences
    • None

    Description

      CREATE SEQUENCE s;
      DELETE FROM s WHERE MATCH (cache_size) AGAINST ('a' IN BOOLEAN MODE);
      

       
      mysqld: /10.4/src/sql/sql_delete.cc:988: bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List<st_order>*, ha_rows, ulonglong, select_result*): Assertion `!return_error || thd->is_error() || thd->killed' failed.
      240116 18:19:53 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.4.33-MariaDB-debug-log source revision: 653cb195d30bca678b5b175157f0f34206c3761d
       
      sql/signal_handler.cc:235(handle_fatal_signal)[0x5577a4e8a99d]
      sigaction.c:0(__restore_rt)[0x7f6c795da420]
      /lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f6c790b3fd6]
      sql/sql_delete.cc:989(mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List<st_order>*, unsigned long long, unsigned long long, select_result*))[0x5577a5331030]
      sql/sql_parse.cc:4819(mysql_execute_command(THD*))[0x5577a46cca75]
      sql/sql_parse.cc:8062(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5577a46e2ef3]
      sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5577a46b909f]
      sql/sql_parse.cc:1378(do_command(THD*))[0x5577a46b5bca]
      sql/sql_connect.cc:1419(do_handle_one_connection(CONNECT*))[0x5577a4acac46]
      sql/sql_connect.cc:1324(handle_one_connection)[0x5577a4aca4ea]
      perfschema/pfs.cc:1871(pfs_spawn_thread)[0x5577a576930e]
      nptl/pthread_create.c:478(start_thread)[0x7f6c795ce609]
       
      Query (0x62b0000a1290): DELETE FROM s WHERE MATCH (cache_size) AGAINST ('a' IN BOOLEAN MODE)
      
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.