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

Assertion `!mysql_bin_log.is_open()' failed in THD::mark_tmp_table_as_free_for_reuse upon REPAIR

    XMLWordPrintable

Details

    Description

      Does not look related to MDEV-16539. Present only in preview-12.0-preview.

      --source include/have_binlog_format_statement.inc
      CREATE TEMPORARY TABLE t (c INT);
      REPAIR TABLE t;
      

      Leads to:

      preview-12.0-preview CS 12.0.0 61c96785d1910976fd740aa0724105b16952786d (Debug) Build 29/03/2025

      mariadbd: /test/preview-12.0-preview_dbg/sql/temporary_tables.cc:833: void THD::mark_tmp_table_as_free_for_reuse(TABLE *): Assertion `!mysql_bin_log.is_open()' failed.
      

      preview-12.0-preview CS 12.0.0 61c96785d1910976fd740aa0724105b16952786d (Debug) Build 29/03/2025

      Core was generated by `/test/P12_MD290325-mariadb-12.0.0-linux-x86_64-dbg/bin/mariadbd --defaults-grou'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 391420)]
      (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  0x00007d182ec4526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007d182ec288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007d182ec2881b in __assert_fail_base (fmt=0x7d182edd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x618839317619 "!mysql_bin_log.is_open()", file=file@entry=0x61883931731b "/test/preview-12.0-preview_dbg/sql/temporary_tables.cc", line=line@entry=833, function=function@entry=0x6188393175e5 "void THD::mark_tmp_table_as_free_for_reuse(TABLE *)") at ./assert/assert.c:94
      #6  0x00007d182ec3b507 in __assert_fail (assertion=0x618839317619 "!mysql_bin_log.is_open()", file=0x61883931731b "/test/preview-12.0-preview_dbg/sql/temporary_tables.cc", line=833, function=0x6188393175e5 "void THD::mark_tmp_table_as_free_for_reuse(TABLE *)") at ./assert/assert.c:103
      #7  0x00006188385ae734 in THD::mark_tmp_table_as_free_for_reuse (this=0x7d17ec000d58, table=0x7d17ec093468)at /test/preview-12.0-preview_dbg/sql/temporary_tables.cc:833
      #8  0x00006188385ae502 in THD::mark_tmp_tables_as_free_for_reuse (this=0x7d17ec000d58)at /test/preview-12.0-preview_dbg/sql/temporary_tables.cc:787
      #9  0x00006188381ae15b in close_thread_tables (thd=0x7d17ec000d58)at /test/preview-12.0-preview_dbg/sql/sql_base.cc:942
      #10 0x000061883847ec3d in mysql_admin_table (thd=0x7d17ec000d58, tables=0x7d17ec016d98, check_opt=0x7d17ec0064c8, operator_name=0x618839ac5b98 <msg_repair>, lock_type=TL_WRITE, org_open_for_modify=true, no_errors_from_open=false, extra_open_options=32, prepare_func=0x61883847f9f0 <prepare_for_repair(THD*, TABLE_LIST*, st_ha_check_opt*)>, operator_func=(int (handler::*)(class handler * const, class THD *, HA_CHECK_OPT *)) 0x6188386b65e0 <handler::ha_repair(THD*, st_ha_check_opt*)>, view_operator_func=0x6188383f87a0 <view_repair(THD*, TABLE_LIST*, st_ha_check_opt*)>, is_cmd_replicated=true)at /test/preview-12.0-preview_dbg/sql/sql_admin.cc:1471
      #11 0x000061883847f9ab in Sql_cmd_repair_table::execute (this=0x7d17ec0174d0, thd=0x7d17ec000d58) at /test/preview-12.0-preview_dbg/sql/sql_admin.cc:1715
      #12 0x00006188382887f2 in mysql_execute_command (thd=0x7d17ec000d58, is_called_from_prepared_stmt=false)at /test/preview-12.0-preview_dbg/sql/sql_parse.cc:5859
      #13 0x0000618838277b54 in mysql_parse (thd=0x7d17ec000d58, rawbuf=0x7d17ec016ce0 "REPAIR TABLE t", length=14, parser_state=0x7d1828a17a10)at /test/preview-12.0-preview_dbg/sql/sql_parse.cc:7889
      #14 0x0000618838274f28 in dispatch_command (command=COM_QUERY, thd=0x7d17ec000d58, packet=0x7d17ec1c87a9 "", packet_length=14, blocking=true) at /test/preview-12.0-preview_dbg/sql/sql_parse.cc:1875
      #15 0x0000618838278703 in do_command (thd=0x7d17ec000d58, blocking=true)at /test/preview-12.0-preview_dbg/sql/sql_parse.cc:1416
      #16 0x00006188384657e9 in do_handle_one_connection (connect=0x61883c4bd258, put_in_cache=true)at /test/preview-12.0-preview_dbg/sql/sql_connect.cc:1415
      #17 0x000061883846558e in handle_one_connection (arg=0x61883c4b9178)at /test/preview-12.0-preview_dbg/sql/sql_connect.cc:1327
      #18 0x00007d182ec9ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #19 0x00007d182ed29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              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.