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

Assertion `share->tmp_table == NO_TMP_TABLE' failed in get_schema_tables_record

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.11, 11.0(EOL), 11.1(EOL)
    • 10.5, 10.6, 10.11
    • Replication
    • None

    Description

      --source include/master-slave.inc
      		 
       
      --connection master
      		 
      CREATE TEMPORARY TABLE t1 (i int);
      		 
      CREATE  TABLE t2 SELECT  * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
      		 
       
      		 
      --sync_slave_with_master
      		 
       
      		 
      --connection master
      		 
      drop table t1,t2;
      		 
       
      		 
      --source include/rpl_end.inc

      10.3 b633b6a9d8278a3e0d9baaf8

      		 
       
      		 
      #3  <signal handler called>
      		 
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      		 
      #5  0x00007f141ebe1535 in __GI_abort () at abort.c:79
      		 
      #6  0x00007f141ebe140f in __assert_fail_base (fmt=0x7f141ed43ee0 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x556b2c1af0d8 "share->tmp_table == NO_TMP_TABLE", file=0x556b2c1ada2d "/10.3/sql/sql_show.cc", line=5422, function=<optimized out>) at assert.c:92
      		 
      #7  0x00007f141ebef102 in __GI___assert_fail (assertion=0x556b2c1af0d8 "share->tmp_table == NO_TMP_TABLE", file=0x556b2c1ada2d "/10.3/sql/sql_show.cc", line=5422, function=0x556b2c1b1c40 <get_schema_tables_record(THD*, TABLE_LIST*, TABLE*, bool, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*)::__PRETTY_FUNCTION__> "int get_schema_tables_record(THD*, TABLE_LIST*, TABLE*, bool, const LEX_CSTRING*, const LEX_CSTRING*)") at assert.c:101
      		 
      #8  0x0000556b2b5aa0bf in get_schema_tables_record (thd=0x7f13b4001910, tables=0x7f13b407dc18, table=0x7f13b402acf8, res=false, db_name=0x7f13b4044ce8, table_name=0x7f13b4044640) at /10.3/sql/sql_show.cc:5422
      		 
      #9  0x0000556b2b5a7909 in fill_schema_table_by_open (thd=0x7f13b4001910, mem_root=0x7f14101f0eb0, is_show_fields_or_keys=false, table=0x7f13b402acf8, schema_table=0x556b2c9d9880 <schema_tables+1984>, orig_db_name=0x7f13b4044ce8, orig_table_name=0x7f13b4044640, open_tables_state_backup=0x7f14101f0f00, can_deadlock=true) at /10.3/sql/sql_show.cc:4657
      		 
      #10 0x0000556b2b5a927c in get_all_tables (thd=0x7f13b4001910, tables=0x7f13b400e3b0, cond=0x7f13b400ebd0) at /10.3/sql/sql_show.cc:5260
      		 
      #11 0x0000556b2b5ba4da in get_schema_tables_result (join=0x7f13b4010ae8, executed_place=PROCESSED_BY_JOIN_EXEC) at /10.3/sql/sql_show.cc:8872
      		 
      #12 0x0000556b2b54f5b3 in JOIN::exec_inner (this=0x7f13b4010ae8) at /10.3/sql/sql_select.cc:4079
      		 
      #13 0x0000556b2b54ebc8 in JOIN::exec (this=0x7f13b4010ae8) at /10.3/sql/sql_select.cc:3910
      		 
      #14 0x0000556b2b54fed5 in mysql_select (thd=0x7f13b4001910, tables=0x7f13b400e3b0, wild_num=1, fields=..., conds=0x7f13b400ebd0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2953054976, result=0x7f13b40109f0, unit=0x7f13b40057d8, select_lex=0x7f13b4005f60) at /10.3/sql/sql_select.cc:4315
      		 
      #15 0x0000556b2b541646 in handle_select (thd=0x7f13b4001910, lex=0x7f13b4005718, result=0x7f13b40109f0, setup_tables_done_option=0) at /10.3/sql/sql_select.cc:370
      		 
      #16 0x0000556b2b5ec7b1 in Sql_cmd_create_table_like::execute (this=0x7f13b400dbc0, thd=0x7f13b4001910) at /10.3/sql/sql_table.cc:11227
      		 
      #17 0x0000556b2b507e7b in mysql_execute_command (thd=0x7f13b4001910) at /10.3/sql/sql_parse.cc:6030
      		 
      #18 0x0000556b2b50d5e6 in mysql_parse (thd=0x7f13b4001910, rawbuf=0x7f13b402aafb "CREATE  TABLE t2 SELECT  * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'", length=81, parser_state=0x7f14101f2430, is_com_multi=false, is_next_command=false) at /10.3/sql/sql_parse.cc:7818
      		 
      #19 0x0000556b2b95a6c2 in Query_log_event::do_apply_event (this=0x7f13b4022cb0, rgi=0x7f13b4000ce0, query_arg=0x7f13b402aafb "CREATE  TABLE t2 SELECT  * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'", q_len_arg=81) at /10.3/sql/log_event.cc:5703
      		 
      #20 0x0000556b2b959577 in Query_log_event::do_apply_event (this=0x7f13b4022cb0, rgi=0x7f13b4000ce0) at /10.3/sql/log_event.cc:5381
      		 
      #21 0x0000556b2b4168ab in Log_event::apply_event (this=0x7f13b4022cb0, rgi=0x7f13b4000ce0) at /10.3/sql/log_event.h:1482
      		 
      #22 0x0000556b2b409a47 in apply_event_and_update_pos_apply (ev=0x7f13b4022cb0, thd=0x7f13b4001910, rgi=0x7f13b4000ce0, reason=0) at /10.3/sql/slave.cc:3914
      		 
      #23 0x0000556b2b40a05c in apply_event_and_update_pos (ev=0x7f13b4022cb0, thd=0x7f13b4001910, rgi=0x7f13b4000ce0) at /10.3/sql/slave.cc:4082
      		 
      #24 0x0000556b2b40a901 in exec_relay_log_event (thd=0x7f13b4001910, rli=0x556b2eea4cc8, serial_rgi=0x7f13b4000ce0) at /10.3/sql/slave.cc:4378
      		 
      #25 0x0000556b2b40e1fa in handle_slave_sql (arg=0x556b2eea3000) at /10.3/sql/slave.cc:5551
      		 
      #26 0x0000556b2c00ad21 in pfs_spawn_thread (arg=0x556b2edef590) at /10.3/storage/perfschema/pfs.cc:1869
      		 
      #27 0x00007f141f334fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486
      		 
      #28 0x00007f141ecb84cf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

      no visible effect on a non-debug build

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33244 Slave: Assertion `marked_for_write_or_computed()' failed in Field_long::store

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            Roel Roel Van de Paar added a comment -

            I also ran into this bug:

            --source include/have_binlog_format_statement.inc
            		 
            --source include/master-slave.inc
            		 
            --source include/have_partition.inc
            		 
            CREATE TEMPORARY TABLE t (a INT,INDEX (a));
            		 
            CREATE TABLE t (c INT,c2 CHAR(5)) PARTITION BY RANGE (c) (PARTITION p0 VALUES LESS THAN (1),PARTITION p1 VALUES LESS THAN (20),PARTITION p2 VALUES LESS THAN (30),PARTITION p3 VALUES LESS THAN MAXVALUE);
            		 
            INSERT INTO t SELECT table_rows FROM information_schema.tables;
            		 
            --source include/rpl_end.inc

            10.6.16 076df87b4c1dc5123d66600b82201050c45aa9d9

            		 
            mariadbd: /test/10.6_dbg/sql/sql_show.cc:5559: int get_schema_tables_record(THD*, TABLE_LIST*, TABLE*, bool, const LEX_CSTRING*, const LEX_CSTRING*): Assertion `share->tmp_table == NO_TMP_TABLE' failed.

            10.6.16 076df87b4c1dc5123d66600b82201050c45aa9d9

            		 
            Core was generated by `/test/MD270923-mariadb-10.6.16-linux-x86_64-dbg/bin/mariadbd --defaults-group-s'.
            		 
            Program terminated with signal SIGABRT, Aborted.
            		 
            #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=23111893988928)
            		 
                at ./nptl/pthread_kill.c:44
            		 
            [Current thread is 1 (Thread 0x1505283b3640 (LWP 1711426))]
            		 
            (gdb) bt
            		 
            #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=23111893988928) at ./nptl/pthread_kill.c:44
            		 
            #1  __pthread_kill_internal (signo=6, threadid=23111893988928) at ./nptl/pthread_kill.c:78
            		 
            #2  __GI___pthread_kill (threadid=23111893988928, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
            		 
            #3  0x000015052ea42476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
            		 
            #4  0x000015052ea287f3 in __GI_abort () at ./stdlib/abort.c:79
            		 
            #5  0x000015052ea2871b in __assert_fail_base (fmt=0x15052ebdd150 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55875b3a2e98 "share->tmp_table == NO_TMP_TABLE", file=0x55875b3a27b0 "/test/10.6_dbg/sql/sql_show.cc", line=5559, function=<optimized out>) at ./assert/assert.c:92
            		 
            #6  0x000015052ea39e96 in __GI___assert_fail (assertion=0x55875b3a2e98 "share->tmp_table == NO_TMP_TABLE", file=0x55875b3a27b0 "/test/10.6_dbg/sql/sql_show.cc", line=5559, function=0x55875b3a2ec0 "int get_schema_tables_record(THD*, TABLE_LIST*, TABLE*, bool, const LEX_CSTRING*, const LEX_CSTRING*)") at ./assert/assert.c:101
            		 
            #7  0x000055875a85964b in get_schema_tables_record (thd=0x1504e4001aa8, tables=0x1504e40712f0, table=0x1504e403ad30, res=false, db_name=<optimized out>, table_name=<optimized out>) at /test/10.6_dbg/sql/sql_show.cc:5559
            		 
            #8  0x000055875a842b42 in fill_schema_table_by_open (thd=thd@entry=0x1504e4001aa8, mem_root=mem_root@entry=0x1505283b01f0, is_show_fields_or_keys=is_show_fields_or_keys@entry=false, table=table@entry=0x1504e403ad30, schema_table=schema_table@entry=0x55875bc1d440 <schema_tables+2176>, orig_db_name=orig_db_name@entry=0x1504e406d8c0, orig_table_name=0x1504e406d908, open_tables_state_backup=0x1505283b0230, can_deadlock=false) at /test/10.6_dbg/sql/sql_show.cc:4712
            		 
            #9  0x000055875a863c8e in get_all_tables (thd=0x1504e4001aa8, tables=0x1504e4010678, cond=<optimized out>) at /test/10.6_dbg/sql/sql_show.cc:5367
            		 
            #10 0x000055875a86519e in get_schema_tables_result (join=join@entry=0x1504e4012250, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /test/10.6_dbg/sql/sql_show.cc:8912
            		 
            #11 0x000055875a83bda9 in JOIN::exec_inner (this=this@entry=0x1504e4012250) at /test/10.6_dbg/sql/sql_select.cc:4791
            		 
            #12 0x000055875a83c8bc in JOIN::exec (this=this@entry=0x1504e4012250) at /test/10.6_dbg/sql/sql_select.cc:4612
            		 
            #13 0x000055875a83a794 in mysql_select (thd=thd@entry=0x1504e4001aa8, tables=0x1504e4010678, fields=@0x1504e40102f0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1504e4010618, last = 0x1504e4010618, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2202816219904, result=0x1504e4012190, unit=0x1504e4005e50, select_lex=0x1504e4010038) at /test/10.6_dbg/sql/sql_select.cc:5091
            		 
            #14 0x000055875a83af8e in handle_select (thd=thd@entry=0x1504e4001aa8, lex=lex@entry=0x1504e4005d88, result=result@entry=0x1504e4012190, setup_tables_done_option=setup_tables_done_option@entry=1073741824) at /test/10.6_dbg/sql/sql_select.cc:559
            		 
            #15 0x000055875a7c1d83 in mysql_execute_command (thd=thd@entry=0x1504e4001aa8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.6_dbg/sql/sql_parse.cc:4731
            		 
            #16 0x000055875a7c7164 in mysql_parse (thd=0x1504e4001aa8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1505283b21c0) at /test/10.6_dbg/sql/sql_parse.cc:8050
            		 
            #17 0x000055875abe29f2 in Query_log_event::do_apply_event (this=0x1504e402d4a8, rgi=0x1504e4000cf0, query_arg=0x1504e403cfa3 "INSERT INTO t SELECT table_rows FROM information_schema.tables", q_len_arg=<optimized out>) at /test/10.6_dbg/sql/sql_class.h:241
            		 
            #18 0x000055875abe3348 in Query_log_event::do_apply_event (this=<optimized out>, rgi=<optimized out>) at /test/10.6_dbg/sql/log_event_server.cc:1605
            		 
            #19 0x000055875a6ea3f4 in Log_event::apply_event (rgi=0x1504e4000cf0, this=0x1504e402d4a8) at /test/10.6_dbg/sql/log_event.h:1499
            		 
            #20 apply_event_and_update_pos_apply (ev=ev@entry=0x1504e402d4a8, thd=thd@entry=0x1504e4001aa8, rgi=rgi@entry=0x1504e4000cf0, reason=reason@entry=0) at /test/10.6_dbg/sql/slave.cc:3894
            		 
            #21 0x000055875a6f4413 in apply_event_and_update_pos (ev=ev@entry=0x1504e402d4a8, thd=thd@entry=0x1504e4001aa8, rgi=rgi@entry=0x1504e4000cf0) at /test/10.6_dbg/sql/slave.cc:4066
            		 
            #22 0x000055875a6f6890 in exec_relay_log_event (serial_rgi=0x1504e4000cf0, rli=0x55875e0edbd0, thd=0x1504e4001aa8) at /test/10.6_dbg/sql/slave.cc:4427
            		 
            #23 handle_slave_sql (arg=arg@entry=0x55875e0ebc70) at /test/10.6_dbg/sql/slave.cc:5630
            		 
            #24 0x000055875ad5608c in pfs_spawn_thread (arg=0x1504ec209a08) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
            		 
            #25 0x000015052ea94b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
            		 
            #26 0x000015052eb26a00 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

            Roel Roel Van de Paar added a comment - I also ran into this bug: --source include/have_binlog_format_statement.inc --source include/master-slave.inc --source include/have_partition.inc CREATE TEMPORARY TABLE t (a INT , INDEX (a)); CREATE TABLE t (c INT ,c2 CHAR (5)) PARTITION BY RANGE (c) (PARTITION p0 VALUES LESS THAN (1),PARTITION p1 VALUES LESS THAN (20),PARTITION p2 VALUES LESS THAN (30),PARTITION p3 VALUES LESS THAN MAXVALUE); INSERT INTO t SELECT table_rows FROM information_schema.tables; --source include/rpl_end.inc 10.6.16 076df87b4c1dc5123d66600b82201050c45aa9d9 mariadbd: /test/10.6_dbg/sql/sql_show.cc:5559: int get_schema_tables_record(THD*, TABLE_LIST*, TABLE*, bool, const LEX_CSTRING*, const LEX_CSTRING*): Assertion `share->tmp_table == NO_TMP_TABLE' failed. 10.6.16 076df87b4c1dc5123d66600b82201050c45aa9d9 Core was generated by `/test/MD270923-mariadb-10.6.16-linux-x86_64-dbg/bin/mariadbd --defaults-group-s'. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=23111893988928) at ./nptl/pthread_kill.c:44 [Current thread is 1 (Thread 0x1505283b3640 (LWP 1711426))] (gdb) bt #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=23111893988928) at ./nptl/pthread_kill.c:44 #1 __pthread_kill_internal (signo=6, threadid=23111893988928) at ./nptl/pthread_kill.c:78 #2 __GI___pthread_kill (threadid=23111893988928, signo=signo@entry=6) at ./nptl/pthread_kill.c:89 #3 0x000015052ea42476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26 #4 0x000015052ea287f3 in __GI_abort () at ./stdlib/abort.c:79 #5 0x000015052ea2871b in __assert_fail_base (fmt=0x15052ebdd150 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55875b3a2e98 "share->tmp_table == NO_TMP_TABLE", file=0x55875b3a27b0 "/test/10.6_dbg/sql/sql_show.cc", line=5559, function=<optimized out>) at ./assert/assert.c:92 #6 0x000015052ea39e96 in __GI___assert_fail (assertion=0x55875b3a2e98 "share->tmp_table == NO_TMP_TABLE", file=0x55875b3a27b0 "/test/10.6_dbg/sql/sql_show.cc", line=5559, function=0x55875b3a2ec0 "int get_schema_tables_record(THD*, TABLE_LIST*, TABLE*, bool, const LEX_CSTRING*, const LEX_CSTRING*)") at ./assert/assert.c:101 #7 0x000055875a85964b in get_schema_tables_record (thd=0x1504e4001aa8, tables=0x1504e40712f0, table=0x1504e403ad30, res=false, db_name=<optimized out>, table_name=<optimized out>) at /test/10.6_dbg/sql/sql_show.cc:5559 #8 0x000055875a842b42 in fill_schema_table_by_open (thd=thd@entry=0x1504e4001aa8, mem_root=mem_root@entry=0x1505283b01f0, is_show_fields_or_keys=is_show_fields_or_keys@entry=false, table=table@entry=0x1504e403ad30, schema_table=schema_table@entry=0x55875bc1d440 <schema_tables+2176>, orig_db_name=orig_db_name@entry=0x1504e406d8c0, orig_table_name=0x1504e406d908, open_tables_state_backup=0x1505283b0230, can_deadlock=false) at /test/10.6_dbg/sql/sql_show.cc:4712 #9 0x000055875a863c8e in get_all_tables (thd=0x1504e4001aa8, tables=0x1504e4010678, cond=<optimized out>) at /test/10.6_dbg/sql/sql_show.cc:5367 #10 0x000055875a86519e in get_schema_tables_result (join=join@entry=0x1504e4012250, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /test/10.6_dbg/sql/sql_show.cc:8912 #11 0x000055875a83bda9 in JOIN::exec_inner (this=this@entry=0x1504e4012250) at /test/10.6_dbg/sql/sql_select.cc:4791 #12 0x000055875a83c8bc in JOIN::exec (this=this@entry=0x1504e4012250) at /test/10.6_dbg/sql/sql_select.cc:4612 #13 0x000055875a83a794 in mysql_select (thd=thd@entry=0x1504e4001aa8, tables=0x1504e4010678, fields=@0x1504e40102f0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1504e4010618, last = 0x1504e4010618, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2202816219904, result=0x1504e4012190, unit=0x1504e4005e50, select_lex=0x1504e4010038) at /test/10.6_dbg/sql/sql_select.cc:5091 #14 0x000055875a83af8e in handle_select (thd=thd@entry=0x1504e4001aa8, lex=lex@entry=0x1504e4005d88, result=result@entry=0x1504e4012190, setup_tables_done_option=setup_tables_done_option@entry=1073741824) at /test/10.6_dbg/sql/sql_select.cc:559 #15 0x000055875a7c1d83 in mysql_execute_command (thd=thd@entry=0x1504e4001aa8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.6_dbg/sql/sql_parse.cc:4731 #16 0x000055875a7c7164 in mysql_parse (thd=0x1504e4001aa8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1505283b21c0) at /test/10.6_dbg/sql/sql_parse.cc:8050 #17 0x000055875abe29f2 in Query_log_event::do_apply_event (this=0x1504e402d4a8, rgi=0x1504e4000cf0, query_arg=0x1504e403cfa3 "INSERT INTO t SELECT table_rows FROM information_schema.tables", q_len_arg=<optimized out>) at /test/10.6_dbg/sql/sql_class.h:241 #18 0x000055875abe3348 in Query_log_event::do_apply_event (this=<optimized out>, rgi=<optimized out>) at /test/10.6_dbg/sql/log_event_server.cc:1605 #19 0x000055875a6ea3f4 in Log_event::apply_event (rgi=0x1504e4000cf0, this=0x1504e402d4a8) at /test/10.6_dbg/sql/log_event.h:1499 #20 apply_event_and_update_pos_apply (ev=ev@entry=0x1504e402d4a8, thd=thd@entry=0x1504e4001aa8, rgi=rgi@entry=0x1504e4000cf0, reason=reason@entry=0) at /test/10.6_dbg/sql/slave.cc:3894 #21 0x000055875a6f4413 in apply_event_and_update_pos (ev=ev@entry=0x1504e402d4a8, thd=thd@entry=0x1504e4001aa8, rgi=rgi@entry=0x1504e4000cf0) at /test/10.6_dbg/sql/slave.cc:4066 #22 0x000055875a6f6890 in exec_relay_log_event (serial_rgi=0x1504e4000cf0, rli=0x55875e0edbd0, thd=0x1504e4001aa8) at /test/10.6_dbg/sql/slave.cc:4427 #23 handle_slave_sql (arg=arg@entry=0x55875e0ebc70) at /test/10.6_dbg/sql/slave.cc:5630 #24 0x000055875ad5608c in pfs_spawn_thread (arg=0x1504ec209a08) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201 #25 0x000015052ea94b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442 #26 0x000015052eb26a00 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
            Roel Roel Van de Paar added a comment -

            This bug is seen from 10.4 (or 10.3) to 11.1, after that we see MDEV-33244 instead.

            Roel Roel Van de Paar added a comment - This bug is seen from 10.4 (or 10.3) to 11.1, after that we see MDEV-33244 instead.
            Roel Roel Van de Paar added a comment - 

            --source include/master-slave.inc
            		 
            CREATE TABLE t (val INT);
            		 
            CREATE TEMPORARY TABLE t (a INT);
            		 
            INSERT INTO t SELECT table_rows FROM information_schema.tables;
            		 
            --sync_slave_with_master
            		 
            --source include/rpl_end.inc

            Roel Roel Van de Paar added a comment - --source include/master-slave.inc CREATE TABLE t (val INT ); CREATE TEMPORARY TABLE t (a INT ); INSERT INTO t SELECT table_rows FROM information_schema.tables; --sync_slave_with_master --source include/rpl_end.inc

            People

              bnestere Brandon Nesterenko
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.