Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2486

Avoid replication of native ddl tables internally as part of main DDL statement

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • 8.0.15-experimental
    • 8.0.18-internal
    • None

    Description

      Similar to PXC-451
      GDB info

      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
      #1  0x000000000475bbe7 in my_write_core (sig=6) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/mysys/stacktrace.cc:278
      #2  0x000000000359ac0e in handle_fatal_signal (sig=6) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/signal_handler.cc:264
      #3  <signal handler called>
      #4  0x00007f54da533428 in __GI_raise ([email protected]=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #5  0x00007f54da53502a in __GI_abort () at abort.c:89
      #6  0x00007f54da52bbd7 in __assert_fail_base (fmt=<optimized out>, [email protected]=0x5a044e8 "thd->wsrep_exec_mode == LOCAL_STATE", [email protected]=0x5a03188 "/mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/wsrep_mysqld.cc", [email protected]=2124, [email protected]=0x5a05040 <wsrep_to_isolation_begin(THD*, char const*, char const*, TABLE_LIST const*, Alter_info*)::__PRETTY_FUNCTION__> "int wsrep_to_isolation_begin(THD*, const char*, const char*, const TABLE_LIST*, Alter_info*)") at assert.c:92
      #7  0x00007f54da52bc82 in __GI___assert_fail (assertion=0x5a044e8 "thd->wsrep_exec_mode == LOCAL_STATE", file=0x5a03188 "/mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/wsrep_mysqld.cc", line=2124, function=0x5a05040 <wsrep_to_isolation_begin(THD*, char const*, char const*, TABLE_LIST const*, Alter_info*)::__PRETTY_FUNCTION__> "int wsrep_to_isolation_begin(THD*, const char*, const char*, const TABLE_LIST*, Alter_info*)") at assert.c:101
      #8  0x00000000035c2c7d in wsrep_to_isolation_begin (thd=0x7f5496c58000, db_=0x7f5471e75340 "performance_schema", table_=0x7f5471e75358 "pfs_example_continent", table_list=0x0, alter_info=0x0) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/wsrep_mysqld.cc:2124
      #9  0x0000000003313942 in Sql_cmd_create_table::execute (this=0x7f5471d1a818, thd=0x7f5496c58000) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_cmd_ddl_table.cc:384
      #10 0x00000000033b42e6 in mysql_execute_command (thd=0x7f5496c58000, first_level=false) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:3962
      #11 0x00000000033ffcd4 in Execute_sql_statement::execute_server_code (this=0x7f54bad7a580, thd=0x7f5496c58000) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_prepare.cc:2257
      #12 0x0000000003401dd2 in Prepared_statement::execute_server_runnable (this=0x7f54bad7a240, server_runnable=0x7f54bad7a580) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_prepare.cc:2897
      #13 0x00000000034032a9 in Ed_connection::execute_direct (this=0x7f54bad7a600, server_runnable=0x7f54bad7a580) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_prepare.cc:3382
      #14 0x0000000003403162 in Ed_connection::execute_direct (this=0x7f54bad7a600, sql_text=...) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_prepare.cc:3356
      #15 0x0000000004444f00 in execute_query (thd=0x7f5496c58000, q_buf="CREATE TABLE performance_schema.pfs_example_continent(\nNAME char(20) not null, PRIMARY KEY(NAME))engine = 'performance_schema'") at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/dd/impl/bootstrapper.cc:94
      #16 0x000000000447503a in dd::create_native_table (thd=0x7f5496c58000, pt=0x7f54bad7aee0) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/dd/impl/dictionary_impl.cc:587
      #17 0x00000000031c5c01 in do_create_native_table_for_pfs (thd=0x7f5496c58000, t=0x7f54bad7aee0) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/mysqld.cc:12488
      #18 0x00000000031c5c8b in create_native_table_for_pfs (t=0x7f54bad7aee0) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/mysqld.cc:12502
      #19 0x0000000004888c65 in pfs_add_tables_v1 (st_share_list=0x7f54b5fb6890 <share_list>, share_list_count=2) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/perfschema/pfs_plugin_table.cc:425
      #20 0x00007f54b5db215a in pfs_example_component_population_init () at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/components/pfs_component/pfs_example_component_population.cc:168
      #21 0x000000000518948d in mysql_dynamic_loader_imp::load_do_initialize_components (loaded_components=std::vector of length 1, capacity 1 = {...}) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/components/mysql_server/dynamic_loader.cc:868
      #22 0x0000000005189253 in mysql_dynamic_loader_imp::load_do_resolve_dependencies (loaded_components=std::vector of length 1, capacity 1 = {...}) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/components/mysql_server/dynamic_loader.cc:831
      #23 0x0000000005188f0b in mysql_dynamic_loader_imp::load_do_register_services (loaded_components=std::vector of length 1, capacity 1 = {...}) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/components/mysql_server/dynamic_loader.cc:784
      #24 0x0000000005188c09 in mysql_dynamic_loader_imp::load_do_check_dependencies (loaded_components=std::vector of length 1, capacity 1 = {...}, services_provided=std::set with 0 elements) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/components/mysql_server/dynamic_loader.cc:741
      #25 0x00000000051888dd in mysql_dynamic_loader_imp::load_do_collect_services_provided (loaded_components=std::vector of length 1, capacity 1 = {...}) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/components/mysql_server/dynamic_loader.cc:697
      #26 0x0000000005188529 in mysql_dynamic_loader_imp::load_do_load_component_by_scheme (urns=0x7f5496ce96e0, component_count=1) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/components/mysql_server/dynamic_loader.cc:656
      #27 0x00000000051879bf in mysql_dynamic_loader_imp::load (urns=0x7f5496ce96e0, component_count=1) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/components/mysql_server/dynamic_loader.cc:373
      #28 0x00000000035575f0 in mysql_persistent_dynamic_loader_imp::load (thd_ptr=0x7f5496c58000, urns=0x7f5496ce96e0, component_count=1) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/server_component/persistent_dynamic_loader.cc:417
      #29 0x00000000037ecf54 in Sql_cmd_install_component::execute (this=0x7f547236dc50, thd=0x7f5496c58000) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_component.cc:72
      #30 0x00000000033b94bb in mysql_execute_command (thd=0x7f5496c58000, first_level=true) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:5242
      #31 0x00000000033bc1e1 in mysql_parse (thd=0x7f5496c58000, parser_state=0x7f54bad7ec80, update_userstat=false, force_primary_storage_engine=false) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:6076
      #32 0x00000000033bfc57 in wsrep_mysql_parse (thd=0x7f5496c58000, rawbuf=0x7f547236d028 "INSTALL COMPONENT \"file://component_pfs_example_component_population\"", length=69, parser_state=0x7f54bad7ec80, update_userstat=false, force_primary_storage_engine=false) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:7263
      #33 0x00000000033ae313 in dispatch_command (thd=0x7f5496c58000, com_data=0x7f54bad80c50, command=COM_QUERY) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:2050
      #34 0x00000000033abacf in do_command (thd=0x7f5496c58000) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:1419
      #35 0x00000000035841d9 in handle_connection (arg=0x7f54bc6f5580) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/conn_handler/connection_handler_per_thread.cc:311
      #36 0x000000000485290a in pfs_spawn_thread (arg=0x7f54789bb320) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/perfschema/pfs.cc:2836
      #37 0x00007f54dc2516ba in start_thread (arg=0x7f54bad82700) at pthread_create.c:333
      #38 0x00007f54da60541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      

      Attachments

        Issue Links

          Activity

            People

              krunal.bauskar Krunal Bauskar (Inactive)
              ramesh.sivaraman Ramesh Sivaraman (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 hours, 55 minutes
                  2h 55m

                  Smart Checklist