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

Assertion `!table->versioned(VERS_TRX_ID)' failed in Write_rows_log_event::binlog_row_logging_function

Details

    Description

      bb-11.0-oalter f9b33ac570337be320f7

      --source include/have_innodb.inc 
      --source include/have_partition.inc 
       
      		 
      CREATE TABLE t1 (id int, row_start BIGINT UNSIGNED GENERATED ALWAYS AS ROW START, row_end BIGINT UNSIGNED GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME ( row_start, row_end )) ENGINE=InnoDB WITH SYSTEM VERSIONING;
      		 
       
      		 
      create procedure sp() ALTER TABLE t1 PARTITION BY HASH(id) ;
      		 
      --connect (a1,127.0.0.1,root,,test)
      		 
       
      		 
      --connection a1 
      --send 
      call sp();
      		 
       
      		 
      --connection default
      		 
       
      		 
       let $1=100;
      		 
      while ($1)
      		 
      {
      		 
      INSERT INTO t1 (id) VALUES (1);
      		 
       dec $1;
      		 
      }
      		 
      


      Version: '11.0.1-MariaDB-debug-log' 
      mysqld: /11.0/sql/log_event.h:4889: static bool Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, const uchar*, const uchar*): Assertion `!table->versioned(VERS_TRX_ID)' failed.
      		 
      230324 12:40:22 [ERROR] mysqld got signal 6 ;
      		 
       
      		 
       
      		 
      ??:0(gsignal)[0x7fb8054f100b]
      		 
      ??:0(abort)[0x7fb8054d0859]
      		 
      /lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7fb8054d0729]
      		 
      ??:0(__assert_fail)[0x7fb8054e1fd6]
      		 
      sql/log_event.h:4890(Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*))[0x556ef09eee7c]
      		 
      sql/log.cc:2288(binlog_log_row_online_alter(TABLE*, unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x556ef0cf8150]
      		 
      sql/handler.cc:7274(handler::binlog_log_row(unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x556ef09db34a]
      		 
      sql/handler.cc:7822(handler::ha_write_row(unsigned char const*))[0x556ef09e1865]
      		 
      sql/ha_partition.cc:4580(ha_partition::write_row(unsigned char const*))[0x556ef112c66f]
      		 
      sql/handler.cc:7814(handler::ha_write_row(unsigned char const*))[0x556ef09e1711]
      		 
      sql/sql_insert.cc:2203(write_record(THD*, TABLE*, st_copy_info*, select_result*))[0x556eeffd9d73]
      		 
      sql/sql_insert.cc:1153(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x556eeffd0f7d]
      		 
      sql/sql_parse.cc:4569(mysql_execute_command(THD*, bool))[0x556ef009e4b1]
      		 
      sql/sql_parse.cc:8000(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556ef00b69d6]
      		 
      sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556ef008cc2c]
      		 
      sql/sql_parse.cc:1407(do_command(THD*, bool))[0x556ef0089968]
      		 
      sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x556ef0559c39]
      		 
      sql/sql_connect.cc:1320(handle_one_connection)[0x556ef0559596]
      		 
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556ef11776fe]
      		 
      nptl/pthread_create.c:478(start_thread)[0x7fb8059fc609]
      		 
       
      		 
      Query (0x6290001f92a8): INSERT INTO t1 (id) VALUES (1)

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-16329 Engine-independent online ALTER TABLE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            alice Alice Sherepa created issue -
            alice Alice Sherepa made changes -
            Field Original Value New Value
            alice Alice Sherepa made changes -
            Description bb-11.0-oalter
            {noformat}
            mysqld: 10.11/sql/log_event.h:4889: static bool Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, const uchar*, const uchar*): Assertion `!table->versioned(VERS_TRX_ID)' failed.
            230321 10:56:00 [ERROR] mysqld got signal 6 ;


            Server version: 11.0.1-MariaDB-debug-log source revision: f9b33ac570337be320f718d52fd88d301a2bc1e7

            sql/signal_handler.cc:238(handle_fatal_signal)[0x55dd5ce175bc]
            ??:0(__restore_rt)[0x7fbd6a1c8730]
            linux/raise.c:51(__GI_raise)[0x7fbd69d058eb]
            stdlib/abort.c:81(__GI_abort)[0x7fbd69cf0535]
            intl/loadmsgcat.c:1177(_nl_load_domain)[0x7fbd69cf040f]
            ??:0(__assert_fail)[0x7fbd69cfe1a2]
            sql/log_event.h:4890(Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*))[0x55dd5ce67890]
            sql/log.cc:2288(binlog_log_row_online_alter(TABLE*, unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x55dd5d15fe16]
            sql/handler.cc:7274(handler::binlog_log_row(unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x55dd5ce541fc]
            sql/handler.cc:7822(handler::ha_write_row(unsigned char const*))[0x55dd5ce5a5df]
            sql/sql_insert.cc:2203(write_record(THD*, TABLE*, st_copy_info*, select_result*))[0x55dd5c4840d7]
            sql/sql_insert.cc:1153(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x55dd5c47b50a]
            sql/sql_parse.cc:4569(mysql_execute_command(THD*, bool))[0x55dd5c5452f0]
            sql/sql_parse.cc:8000(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55dd5c55d393]
            sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55dd5c533c81]
            sql/sql_parse.cc:1407(do_command(THD*, bool))[0x55dd5c53098a]
            sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55dd5c9e9416]
            sql/sql_connect.cc:1320(handle_one_connection)[0x55dd5c9e8d6c]
            perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55dd5d67ad1f]
            nptl/pthread_create.c:487(start_thread)[0x7fbd6a1bdfa3]
            x86_64/clone.S:97(clone)[0x7fbd69dc706f]


            Query (0x629001e692a8): INSERT IGNORE INTO `t1` ( `col2` ) VALUES ( 'p' )
            {noformat}
            		bb-11.0-oalter f9b33ac570337be320f7
            {noformat}
            query_init_add:
              CREATE TABLE IF NOT EXISTS t1 (id int, row_start BIGINT UNSIGNED GENERATED ALWAYS AS ROW START, row_end BIGINT UNSIGNED GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME ( row_start, row_end )) ENGINE=InnoDB WITH SYSTEM VERSIONING;

            thread1:
              ALTER TABLE t1 PARTITION BY HASH(id) ;#| ALTER TABLE t1 REMOVE PARTITIONING ;
                
            thread2:
              INSERT INTO t1 (id) VALUES (1);
            {noformat}
            {noformat}
            Version: '11.0.1-MariaDB-debug-log'
            mysqld: /11.0/sql/log_event.h:4889: static bool Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, const uchar*, const uchar*): Assertion `!table->versioned(VERS_TRX_ID)' failed.
            230324 12:40:22 [ERROR] mysqld got signal 6 ;


            ??:0(gsignal)[0x7fb8054f100b]
            ??:0(abort)[0x7fb8054d0859]
            /lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7fb8054d0729]
            ??:0(__assert_fail)[0x7fb8054e1fd6]
            sql/log_event.h:4890(Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*))[0x556ef09eee7c]
            sql/log.cc:2288(binlog_log_row_online_alter(TABLE*, unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x556ef0cf8150]
            sql/handler.cc:7274(handler::binlog_log_row(unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x556ef09db34a]
            sql/handler.cc:7822(handler::ha_write_row(unsigned char const*))[0x556ef09e1865]
            sql/ha_partition.cc:4580(ha_partition::write_row(unsigned char const*))[0x556ef112c66f]
            sql/handler.cc:7814(handler::ha_write_row(unsigned char const*))[0x556ef09e1711]
            sql/sql_insert.cc:2203(write_record(THD*, TABLE*, st_copy_info*, select_result*))[0x556eeffd9d73]
            sql/sql_insert.cc:1153(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x556eeffd0f7d]
            sql/sql_parse.cc:4569(mysql_execute_command(THD*, bool))[0x556ef009e4b1]
            sql/sql_parse.cc:8000(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556ef00b69d6]
            sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556ef008cc2c]
            sql/sql_parse.cc:1407(do_command(THD*, bool))[0x556ef0089968]
            sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x556ef0559c39]
            sql/sql_connect.cc:1320(handle_one_connection)[0x556ef0559596]
            perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556ef11776fe]
            nptl/pthread_create.c:478(start_thread)[0x7fb8059fc609]

            Query (0x6290001f92a8): INSERT INTO t1 (id) VALUES (1)
            {noformat}
            alice Alice Sherepa made changes -
            Description bb-11.0-oalter f9b33ac570337be320f7
            {noformat}
            query_init_add:
              CREATE TABLE IF NOT EXISTS t1 (id int, row_start BIGINT UNSIGNED GENERATED ALWAYS AS ROW START, row_end BIGINT UNSIGNED GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME ( row_start, row_end )) ENGINE=InnoDB WITH SYSTEM VERSIONING;

            thread1:
              ALTER TABLE t1 PARTITION BY HASH(id) ;#| ALTER TABLE t1 REMOVE PARTITIONING ;
                
            thread2:
              INSERT INTO t1 (id) VALUES (1);
            {noformat}
            {noformat}
            Version: '11.0.1-MariaDB-debug-log'
            mysqld: /11.0/sql/log_event.h:4889: static bool Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, const uchar*, const uchar*): Assertion `!table->versioned(VERS_TRX_ID)' failed.
            230324 12:40:22 [ERROR] mysqld got signal 6 ;


            ??:0(gsignal)[0x7fb8054f100b]
            ??:0(abort)[0x7fb8054d0859]
            /lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7fb8054d0729]
            ??:0(__assert_fail)[0x7fb8054e1fd6]
            sql/log_event.h:4890(Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*))[0x556ef09eee7c]
            sql/log.cc:2288(binlog_log_row_online_alter(TABLE*, unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x556ef0cf8150]
            sql/handler.cc:7274(handler::binlog_log_row(unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x556ef09db34a]
            sql/handler.cc:7822(handler::ha_write_row(unsigned char const*))[0x556ef09e1865]
            sql/ha_partition.cc:4580(ha_partition::write_row(unsigned char const*))[0x556ef112c66f]
            sql/handler.cc:7814(handler::ha_write_row(unsigned char const*))[0x556ef09e1711]
            sql/sql_insert.cc:2203(write_record(THD*, TABLE*, st_copy_info*, select_result*))[0x556eeffd9d73]
            sql/sql_insert.cc:1153(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x556eeffd0f7d]
            sql/sql_parse.cc:4569(mysql_execute_command(THD*, bool))[0x556ef009e4b1]
            sql/sql_parse.cc:8000(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556ef00b69d6]
            sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556ef008cc2c]
            sql/sql_parse.cc:1407(do_command(THD*, bool))[0x556ef0089968]
            sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x556ef0559c39]
            sql/sql_connect.cc:1320(handle_one_connection)[0x556ef0559596]
            perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556ef11776fe]
            nptl/pthread_create.c:478(start_thread)[0x7fb8059fc609]

            Query (0x6290001f92a8): INSERT INTO t1 (id) VALUES (1)
            {noformat}
            		bb-11.0-oalter f9b33ac570337be320f7
            {code:sql}
            --source include/have_innodb.inc
            --source include/have_partition.inc
            --source include/have_log_bin.inc

            CREATE TABLE t1 (id int, row_start BIGINT UNSIGNED GENERATED ALWAYS AS ROW START, row_end BIGINT UNSIGNED GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME ( row_start, row_end )) ENGINE=InnoDB WITH SYSTEM VERSIONING;

            create procedure sp() ALTER TABLE t1 PARTITION BY HASH(id) ;
            --connect (a1,127.0.0.1,root,,test)

            --connection a1
            --send
            call sp();

            --connection default

             let $1=100;
            while ($1)
            {
            INSERT INTO t1 (id) VALUES (1);
             dec $1;
            }

            {code}
            {noformat}
            Version: '11.0.1-MariaDB-debug-log'
            mysqld: /11.0/sql/log_event.h:4889: static bool Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, const uchar*, const uchar*): Assertion `!table->versioned(VERS_TRX_ID)' failed.
            230324 12:40:22 [ERROR] mysqld got signal 6 ;


            ??:0(gsignal)[0x7fb8054f100b]
            ??:0(abort)[0x7fb8054d0859]
            /lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7fb8054d0729]
            ??:0(__assert_fail)[0x7fb8054e1fd6]
            sql/log_event.h:4890(Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*))[0x556ef09eee7c]
            sql/log.cc:2288(binlog_log_row_online_alter(TABLE*, unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x556ef0cf8150]
            sql/handler.cc:7274(handler::binlog_log_row(unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x556ef09db34a]
            sql/handler.cc:7822(handler::ha_write_row(unsigned char const*))[0x556ef09e1865]
            sql/ha_partition.cc:4580(ha_partition::write_row(unsigned char const*))[0x556ef112c66f]
            sql/handler.cc:7814(handler::ha_write_row(unsigned char const*))[0x556ef09e1711]
            sql/sql_insert.cc:2203(write_record(THD*, TABLE*, st_copy_info*, select_result*))[0x556eeffd9d73]
            sql/sql_insert.cc:1153(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x556eeffd0f7d]
            sql/sql_parse.cc:4569(mysql_execute_command(THD*, bool))[0x556ef009e4b1]
            sql/sql_parse.cc:8000(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556ef00b69d6]
            sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556ef008cc2c]
            sql/sql_parse.cc:1407(do_command(THD*, bool))[0x556ef0089968]
            sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x556ef0559c39]
            sql/sql_connect.cc:1320(handle_one_connection)[0x556ef0559596]
            perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556ef11776fe]
            nptl/pthread_create.c:478(start_thread)[0x7fb8059fc609]

            Query (0x6290001f92a8): INSERT INTO t1 (id) VALUES (1)
            {noformat}
            alice Alice Sherepa made changes -
            Assignee Alice Sherepa [ alice ] Nikita Malyavin [ nikitamalyavin ]
            alice Alice Sherepa made changes -
            Summary [draft] Assertion `!table->versioned(VERS_TRX_ID)' failed in Write_rows_log_event::binlog_row_logging_function  Assertion `!table->versioned(VERS_TRX_ID)' failed in Write_rows_log_event::binlog_row_logging_function
            alice Alice Sherepa made changes -
            Description bb-11.0-oalter f9b33ac570337be320f7
            {code:sql}
            --source include/have_innodb.inc
            --source include/have_partition.inc
            --source include/have_log_bin.inc

            CREATE TABLE t1 (id int, row_start BIGINT UNSIGNED GENERATED ALWAYS AS ROW START, row_end BIGINT UNSIGNED GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME ( row_start, row_end )) ENGINE=InnoDB WITH SYSTEM VERSIONING;

            create procedure sp() ALTER TABLE t1 PARTITION BY HASH(id) ;
            --connect (a1,127.0.0.1,root,,test)

            --connection a1
            --send
            call sp();

            --connection default

             let $1=100;
            while ($1)
            {
            INSERT INTO t1 (id) VALUES (1);
             dec $1;
            }

            {code}
            {noformat}
            Version: '11.0.1-MariaDB-debug-log'
            mysqld: /11.0/sql/log_event.h:4889: static bool Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, const uchar*, const uchar*): Assertion `!table->versioned(VERS_TRX_ID)' failed.
            230324 12:40:22 [ERROR] mysqld got signal 6 ;


            ??:0(gsignal)[0x7fb8054f100b]
            ??:0(abort)[0x7fb8054d0859]
            /lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7fb8054d0729]
            ??:0(__assert_fail)[0x7fb8054e1fd6]
            sql/log_event.h:4890(Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*))[0x556ef09eee7c]
            sql/log.cc:2288(binlog_log_row_online_alter(TABLE*, unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x556ef0cf8150]
            sql/handler.cc:7274(handler::binlog_log_row(unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x556ef09db34a]
            sql/handler.cc:7822(handler::ha_write_row(unsigned char const*))[0x556ef09e1865]
            sql/ha_partition.cc:4580(ha_partition::write_row(unsigned char const*))[0x556ef112c66f]
            sql/handler.cc:7814(handler::ha_write_row(unsigned char const*))[0x556ef09e1711]
            sql/sql_insert.cc:2203(write_record(THD*, TABLE*, st_copy_info*, select_result*))[0x556eeffd9d73]
            sql/sql_insert.cc:1153(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x556eeffd0f7d]
            sql/sql_parse.cc:4569(mysql_execute_command(THD*, bool))[0x556ef009e4b1]
            sql/sql_parse.cc:8000(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556ef00b69d6]
            sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556ef008cc2c]
            sql/sql_parse.cc:1407(do_command(THD*, bool))[0x556ef0089968]
            sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x556ef0559c39]
            sql/sql_connect.cc:1320(handle_one_connection)[0x556ef0559596]
            perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556ef11776fe]
            nptl/pthread_create.c:478(start_thread)[0x7fb8059fc609]

            Query (0x6290001f92a8): INSERT INTO t1 (id) VALUES (1)
            {noformat}
            		bb-11.0-oalter f9b33ac570337be320f7
            {code:sql}
            --source include/have_innodb.inc
            --source include/have_partition.inc

            CREATE TABLE t1 (id int, row_start BIGINT UNSIGNED GENERATED ALWAYS AS ROW START, row_end BIGINT UNSIGNED GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME ( row_start, row_end )) ENGINE=InnoDB WITH SYSTEM VERSIONING;

            create procedure sp() ALTER TABLE t1 PARTITION BY HASH(id) ;
            --connect (a1,127.0.0.1,root,,test)

            --connection a1
            --send
            call sp();

            --connection default

             let $1=100;
            while ($1)
            {
            INSERT INTO t1 (id) VALUES (1);
             dec $1;
            }

            {code}
            {noformat}
            Version: '11.0.1-MariaDB-debug-log'
            mysqld: /11.0/sql/log_event.h:4889: static bool Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, const uchar*, const uchar*): Assertion `!table->versioned(VERS_TRX_ID)' failed.
            230324 12:40:22 [ERROR] mysqld got signal 6 ;


            ??:0(gsignal)[0x7fb8054f100b]
            ??:0(abort)[0x7fb8054d0859]
            /lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7fb8054d0729]
            ??:0(__assert_fail)[0x7fb8054e1fd6]
            sql/log_event.h:4890(Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*))[0x556ef09eee7c]
            sql/log.cc:2288(binlog_log_row_online_alter(TABLE*, unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x556ef0cf8150]
            sql/handler.cc:7274(handler::binlog_log_row(unsigned char const*, unsigned char const*, bool (*)(THD*, TABLE*, Event_log*, binlog_cache_data*, bool, unsigned char const*, unsigned char const*)))[0x556ef09db34a]
            sql/handler.cc:7822(handler::ha_write_row(unsigned char const*))[0x556ef09e1865]
            sql/ha_partition.cc:4580(ha_partition::write_row(unsigned char const*))[0x556ef112c66f]
            sql/handler.cc:7814(handler::ha_write_row(unsigned char const*))[0x556ef09e1711]
            sql/sql_insert.cc:2203(write_record(THD*, TABLE*, st_copy_info*, select_result*))[0x556eeffd9d73]
            sql/sql_insert.cc:1153(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x556eeffd0f7d]
            sql/sql_parse.cc:4569(mysql_execute_command(THD*, bool))[0x556ef009e4b1]
            sql/sql_parse.cc:8000(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556ef00b69d6]
            sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556ef008cc2c]
            sql/sql_parse.cc:1407(do_command(THD*, bool))[0x556ef0089968]
            sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x556ef0559c39]
            sql/sql_connect.cc:1320(handle_one_connection)[0x556ef0559596]
            perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556ef11776fe]
            nptl/pthread_create.c:478(start_thread)[0x7fb8059fc609]

            Query (0x6290001f92a8): INSERT INTO t1 (id) VALUES (1)
            {noformat}
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            elenst Elena Stepanova made changes -
            Component/s Data Definition - Alter Table [ 10114 ]
            Component/s Partitioning [ 10802 ]
            Fix Version/s 11.1 [ 28549 ]
            Affects Version/s N/A [ 14700 ]
            Priority Major [ 3 ] Critical [ 2 ]
            nikitamalyavin Nikita Malyavin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            nikitamalyavin Nikita Malyavin made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Aleksey Midenkov [ midenok ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            midenok Aleksey Midenkov made changes -
            Assignee Aleksey Midenkov [ midenok ] Nikita Malyavin [ nikitamalyavin ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            nikitamalyavin Nikita Malyavin made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.2 [ 28603 ]
            Fix Version/s 11.1 [ 28549 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 11.2.1 [ 29034 ]
            Fix Version/s 11.2 [ 28603 ]
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]

            People

              nikitamalyavin Nikita Malyavin
              alice Alice Sherepa
              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.