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

Assertion `!is_set() || (m_status == DA_EOF_BULK && is_bulk_op())' failed from mysql_admin_table on CHECK TABLE

    XMLWordPrintable

Details

    Description

      INSTALL PLUGIN Spider SONAME 'ha_spider.so';
      SET spider_internal_sql_log_off=0;
      CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock', DATABASE 'test', USER 'Spider', PASSWORD '');
      CREATE TABLE t1 (c INT) ENGINE=InnoDB;
      CREATE TABLE t2 (c INT) ENGINE=Spider COMMENT='WRAPPER "mysql", SRV "srv", TABLE "t1"' PARTITION BY HASH (c) PARTITIONS 2;
      CHECK TABLE t2;
      

      Leads to:

      11.2.5 a21e49cbcc5f4adb1a1b4970ceead6a85e968063 (Debug)

      mariadbd: /test/11.2_dbg/sql/sql_error.cc:375: void Diagnostics_area::set_eof_status(THD*): Assertion `!is_set() || (m_status == DA_EOF_BULK && is_bulk_op())' failed.
      

      11.2.5 a21e49cbcc5f4adb1a1b4970ceead6a85e968063 (Debug)

      Core was generated by `/test/MD190624-mariadb-11.2.5-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.
      [Current thread is 1 (LWP 2037238)]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
      #3  0x0000151852a42866 in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x0000151852a268b7 in __GI_abort () at ./stdlib/abort.c:79
      #5  0x0000151852a267db in __assert_fail_base (fmt=0x151852bc5168 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x562141314560 "!is_set() || (m_status == DA_EOF_BULK && is_bulk_op())", file=file@entry=0x5621413143c0 "/test/11.2_dbg/sql/sql_error.cc", line=line@entry=375, function=function@entry=0x562141314598 "void Diagnostics_area::set_eof_status(THD*)") at ./assert/assert.c:92
      #6  0x0000151852a39186 in __assert_fail (assertion=0x562141314560 "!is_set() || (m_status == DA_EOF_BULK && is_bulk_op())", file=0x5621413143c0 "/test/11.2_dbg/sql/sql_error.cc", line=375, function=0x562141314598 "void Diagnostics_area::set_eof_status(THD*)")at ./assert/assert.c:101
      #7  0x00005621405a819d in Diagnostics_area::set_eof_status (this=0x151810006f40, thd=thd@entry=0x151810000d58)at /test/11.2_dbg/sql/sql_error.cc:375
      #8  0x000056214077a93f in my_eof (thd=0x151810000d58)at /test/11.2_dbg/sql/sql_class.h:4535
      #9  mysql_admin_table (thd=thd@entry=0x151810000d58, tables=tables@entry=0x1518100136e8, check_opt=check_opt@entry=0x1518100065c8, operator_name=operator_name@entry=0x562141b8dfe0 <msg_check>, lock_type=lock_type@entry=TL_READ_NO_INSERT, org_open_for_modify=org_open_for_modify@entry=false, repair_table_use_frm=<optimized out>, extra_open_options=<optimized out>, prepare_func=<optimized out>, operator_func=<optimized out>, view_operator_func=<optimized out>, is_cmd_replicated=<optimized out>)at /test/11.2_dbg/sql/sql_admin.cc:1455
      #10 0x000056214077b08e in Sql_cmd_check_table::execute (this=<optimized out>, thd=0x151810000d58) at /test/11.2_dbg/sql/sql_admin.cc:1588
      #11 0x00005621405f9670 in mysql_execute_command (thd=thd@entry=0x151810000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false)at /test/11.2_dbg/sql/sql_parse.cc:5876
      #12 0x00005621405fb010 in mysql_parse (thd=thd@entry=0x151810000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x15183c1af2e0)at /test/11.2_dbg/sql/sql_parse.cc:7920
      #13 0x00005621405fd3d3 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x151810000d58, packet=packet@entry=0x15181000b2f9 "", packet_length=packet_length@entry=14, blocking=blocking@entry=true)at /test/11.2_dbg/sql/sql_class.h:247
      #14 0x00005621405ff76c in do_command (thd=0x151810000d58, blocking=blocking@entry=true) at /test/11.2_dbg/sql/sql_parse.cc:1407
      #15 0x0000562140766c49 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x562144cfb518, put_in_cache=put_in_cache@entry=true)at /test/11.2_dbg/sql/sql_connect.cc:1439
      #16 0x0000562140766f3e in handle_one_connection (arg=arg@entry=0x562144cfb518)at /test/11.2_dbg/sql/sql_connect.cc:1341
      #17 0x0000562140bb952c in pfs_spawn_thread (arg=0x562144c8f488)at /test/11.2_dbg/storage/perfschema/pfs.cc:2201
      #18 0x0000151852a97ada in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:444
      #19 0x0000151852b2847c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Somewhat concerning, on optimized builds we see (also see MDEV-33196):

      10.5.26 6cab2f75fe25df4673cab5ac6ff2c114fb976ed8 (Optimized)

      10.5.26-opt>CHECK TABLE t2;
      ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation
      

      Bug confirmed present in 10.5+.

      Attachments

        Issue Links

          Activity

            People

              ycp Yuchen Pei
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.