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

Assertion `!mysql_bin_log.is_open() || is_binlog_format_row()' in THD::mark_tmp_table_as_free_for_reuse

    XMLWordPrintable

Details

    Description

      --source include/have_binlog_format_mixed.inc
       
      SET create_tmp_table_binlog_formats = 'MIXED,STATEMENT';
       
      CREATE TEMPORARY TABLE tmp (a INT);
      INSERT INTO tmp SET a = 1;
      UPDATE IGNORE tmp SET a = 2;
      

      bb-main-atomic 82cc6f32b8fbd4a190159d5a7139afc052b52154

      mariadbd: /data/bld/testing/bb-main-atomic-debug/sql/temporary_tables.cc:870: void THD::mark_tmp_table_as_free_for_reuse(TABLE*): Assertion `!mysql_bin_log.is_open() || is_binlog_format_row()' failed.
      260626 23:30:14 [ERROR] /share8t/bld/testing/bb-main-atomic-debug/sql/mariadbd got signal 6 ;
       
      #9  0x00007f76cac53eb2 in __GI___assert_fail (assertion=0x55de02f34438 "!mysql_bin_log.is_open() || is_binlog_format_row()", file=0x55de02f33e90 "/data/bld/testing/bb-main-atomic-debug/sql/temporary_tables.cc", line=870, function=0x55de02f34400 "void THD::mark_tmp_table_as_free_for_reuse(TABLE*)") at ./assert/assert.c:101
      #10 0x000055de02088fda in THD::mark_tmp_table_as_free_for_reuse (this=0x7f76a0000dd0, table=0x7f76a01b85b0) at /data/bld/testing/bb-main-atomic-debug/sql/temporary_tables.cc:870
      #11 0x000055de02088cd4 in THD::mark_tmp_tables_as_free_for_reuse (this=0x7f76a0000dd0) at /data/bld/testing/bb-main-atomic-debug/sql/temporary_tables.cc:821
      #12 0x000055de01bcf9ff in close_thread_tables (thd=0x7f76a0000dd0) at /data/bld/testing/bb-main-atomic-debug/sql/sql_base.cc:941
      #13 0x000055de01bcf50b in close_thread_tables_for_query (thd=0x7f76a0000dd0) at /data/bld/testing/bb-main-atomic-debug/sql/sql_base.cc:814
      #14 0x000055de01cbe191 in mysql_execute_command (thd=0x7f76a0000dd0, is_called_from_prepared_stmt=false) at /data/bld/testing/bb-main-atomic-debug/sql/sql_parse.cc:5997
      #15 0x000055de01cc4027 in mysql_parse (thd=0x7f76a0000dd0, rawbuf=0x7f76a0018910 "UPDATE IGNORE tmp SET a = 2", length=27, parser_state=0x7f76c4446230) at /data/bld/testing/bb-main-atomic-debug/sql/sql_parse.cc:7945
      #16 0x000055de01caff0e in dispatch_command (command=COM_QUERY, thd=0x7f76a0000dd0, packet=0x7f76a000c701 "UPDATE IGNORE tmp SET a = 2", packet_length=27, blocking=true) at /data/bld/testing/bb-main-atomic-debug/sql/sql_parse.cc:1903
      #17 0x000055de01cae852 in do_command (thd=0x7f76a0000dd0, blocking=true) at /data/bld/testing/bb-main-atomic-debug/sql/sql_parse.cc:1437
      #18 0x000055de01ef8d03 in do_handle_one_connection (connect=0x55de08bb36d0, put_in_cache=true) at /data/bld/testing/bb-main-atomic-debug/sql/sql_connect.cc:1503
      #19 0x000055de01ef8a84 in handle_one_connection (arg=0x55de08b953d0) at /data/bld/testing/bb-main-atomic-debug/sql/sql_connect.cc:1415
      #20 0x000055de02550c04 in pfs_spawn_thread (arg=0x55de08ad5a00) at /data/bld/testing/bb-main-atomic-debug/storage/perfschema/pfs.cc:2198
      #21 0x00007f76caca81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #22 0x00007f76cad2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Not reproducible on the baseline.

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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