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

Spider : Crash on mysqldump when changing spider_crd_sync = 0

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.5
    • 10.0.11
    • None
    • MariDB 10.0.4

      Linux version 2.6.32-5-amd64 (Debian 2.6.32-35) (dannf@debian.org) (gcc version 4.3.5 (Debian 4.3.5-4) ) #1 SMP Tue Jun 14 09:42:28 UTC 2011

    Description

      We have been running with default spider parameter for a while without issue

      After changing some spider parameters on all the slaves
      spider_crd_sync = 0
      spider_same_server_link = 1

      Only the slave used for backup was crashed

      Note that the spider partitions is pointing to mixed remote and local innodb tables

      Intresting is that the mysqldump that break is having --no-data 

       -u${user} -p${passwd} -h${host} --database ${_db} \
      		 
              --allow-keywords --comments --add-drop-table=FALSE \
      		 
              --flush-logs ${master_opt} ${tables_opt} --routines --triggers --no-data \
      		 
              > ${working_dir}/${_db}-struct-dump.sql 2>${working_dir}/${_db}-struct-dump-error.log
      		 
       
      		 
      Thread pointer: 0x0x7f2911ed90f8
      		 
      Attempting backtrace. You can use the following information to find out
      		 
      where mysqld died. If you see no messages after this, something went
      		 
      terribly wrong...
      		 
      stack_bottom = 0x7f2d704f0e50 thread_stack 0x40000
      		 
      (my_addr_resolve failure: fork)
      		 
      /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x2e) [0xb8f29e]
      		 
      /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x422) [0x708952]
      		 
      /lib/libpthread.so.0(+0xeff0) [0x7f2e9793bff0]
      		 
      /usr/local/mysql/bin/mysqld() [0x516bb5]
      		 
      /usr/local/mysql/bin/mysqld(my_net_read+0x17b) [0x516e4b]
      		 
      /usr/local/mysql/bin/mysqld(cli_safe_read+0x26) [0x6e05e6]
      		 
      /usr/local/mysql/bin/mysqld() [0x6e23c4]
      		 
      /usr/local/mysql/bin/mysqld(mysql_real_query+0x4a) [0x6de6ba]
      		 
      /usr/local/mysql/lib/plugin/ha_spider.so(spider_mysql_handler::show_index(int, int)+0x7fa) [0x7f292d31d8fa]
      		 
      /usr/local/mysql/lib/plugin/ha_spider.so(spider_get_crd(st_spider_share*, int, long, ha_spider*, TABLE*, double, int, int, int)+0x447) [0x7f292d2dc157]
      		 
      /usr/local/mysql/lib/plugin/ha_spider.so(ha_spider::check_crd()+0x37d) [0x7f292d2fb37d]
      		 
      /usr/local/mysql/lib/plugin/ha_spider.so(ha_spider::info(unsigned int)+0x509) [0x7f292d2fc889]
      		 
      /usr/local/mysql/bin/mysqld(handler::get_dynamic_partition_info(PARTITION_STATS*, unsigned int)+0x1b) [0x708f8b]
      		 
      /usr/local/mysql/bin/mysqld() [0x5f021b]
      		 
      /usr/local/mysql/bin/mysqld() [0x5fc526]
      		 
      /usr/local/mysql/bin/mysqld() [0x5f485c]
      		 
      /usr/local/mysql/bin/mysqld(get_all_tables(THD*, TABLE_LIST*, Item*)+0xa55) [0x5f90a5]
      		 
      /usr/local/mysql/bin/mysqld(get_schema_tables_result(JOIN*, enum_schema_table_state)+0x296) [0x5ef666]
      		 
      /usr/local/mysql/bin/mysqld(JOIN::exec_inner()+0x84e) [0x5ea49e]
      		 
      /usr/local/mysql/bin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x20c) [0x5eccbc]
      		 
      /usr/local/mysql/bin/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x28a) [0x5ed90a]
      		 
      /usr/local/mysql/bin/mysqld() [0x593368]
      		 
      /usr/local/mysql/bin/mysqld(mysql_execute_command(THD*)+0x926) [0x5961b6]
      		 
      /usr/local/mysql/bin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x259) [0x59d189]
      		 
      /usr/local/mysql/bin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x192c) [0x59f0ac]
      		 
      /usr/local/mysql/bin/mysqld(do_command(THD*)+0xed) [0x59f84d]
      		 
      /usr/local/mysql/bin/mysqld(do_handle_one_connection(THD*)+0x164) [0x665494]
      		 
      /usr/local/mysql/bin/mysqld(handle_one_connection+0x42) [0x6655d2]
      		 
      /usr/local/mysql/bin/mysqld() [0xafa9ab]
      		 
      /lib/libpthread.so.0(+0x68ca) [0x7f2e979338ca]
      		 
      /lib/libc.so.6(clone+0x6d) [0x7f2e968c0b6d]

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          stephane@skysql.com VAROQUI Stephane created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Description We have been running with default spider parameter for a while without issue

          After changing some spider parameters on all the slaves
          spider_crd_sync = 0
          spider_same_server_link = 1

          Only the slave used for backup was crashed

          Note that the spider partitions is pointing to mixed remote and local innodb tables

          Intresting is that the mysqldump that break is having --no-data

           -u${user} -p${passwd} -h${host} --database ${_db} \
                  --allow-keywords --comments --add-drop-table=FALSE \
                  --flush-logs ${master_opt} ${tables_opt} --routines --triggers --no-data \
                  > ${working_dir}/${_db}-struct-dump.sql 2>${working_dir}/${_db}-struct-dump-error.log

          Thread pointer: 0x0x7f2911ed90f8
          Attempting backtrace. You can use the following information to find out
          where mysqld died. If you see no messages after this, something went
          terribly wrong...
          stack_bottom = 0x7f2d704f0e50 thread_stack 0x40000
          (my_addr_resolve failure: fork)
          /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x2e) [0xb8f29e]
          /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x422) [0x708952]
          /lib/libpthread.so.0(+0xeff0) [0x7f2e9793bff0]
          /usr/local/mysql/bin/mysqld() [0x516bb5]
          /usr/local/mysql/bin/mysqld(my_net_read+0x17b) [0x516e4b]
          /usr/local/mysql/bin/mysqld(cli_safe_read+0x26) [0x6e05e6]
          /usr/local/mysql/bin/mysqld() [0x6e23c4]
          /usr/local/mysql/bin/mysqld(mysql_real_query+0x4a) [0x6de6ba]
          /usr/local/mysql/lib/plugin/ha_spider.so(spider_mysql_handler::show_index(int, int)+0x7fa) [0x7f292d31d8fa]
          /usr/local/mysql/lib/plugin/ha_spider.so(spider_get_crd(st_spider_share*, int, long, ha_spider*, TABLE*, double, int, int, int)+0x447) [0x7f292d2dc157]
          /usr/local/mysql/lib/plugin/ha_spider.so(ha_spider::check_crd()+0x37d) [0x7f292d2fb37d]
          /usr/local/mysql/lib/plugin/ha_spider.so(ha_spider::info(unsigned int)+0x509) [0x7f292d2fc889]
          /usr/local/mysql/bin/mysqld(handler::get_dynamic_partition_info(PARTITION_STATS*, unsigned int)+0x1b) [0x708f8b]
          /usr/local/mysql/bin/mysqld() [0x5f021b]
          /usr/local/mysql/bin/mysqld() [0x5fc526]
          /usr/local/mysql/bin/mysqld() [0x5f485c]
          /usr/local/mysql/bin/mysqld(get_all_tables(THD*, TABLE_LIST*, Item*)+0xa55) [0x5f90a5]
          /usr/local/mysql/bin/mysqld(get_schema_tables_result(JOIN*, enum_schema_table_state)+0x296) [0x5ef666]
          /usr/local/mysql/bin/mysqld(JOIN::exec_inner()+0x84e) [0x5ea49e]
          /usr/local/mysql/bin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x20c) [0x5eccbc]
          /usr/local/mysql/bin/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x28a) [0x5ed90a]
          /usr/local/mysql/bin/mysqld() [0x593368]
          /usr/local/mysql/bin/mysqld(mysql_execute_command(THD*)+0x926) [0x5961b6]
          /usr/local/mysql/bin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x259) [0x59d189]
          /usr/local/mysql/bin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x192c) [0x59f0ac]
          /usr/local/mysql/bin/mysqld(do_command(THD*)+0xed) [0x59f84d]
          /usr/local/mysql/bin/mysqld(do_handle_one_connection(THD*)+0x164) [0x665494]
          /usr/local/mysql/bin/mysqld(handle_one_connection+0x42) [0x6655d2]
          /usr/local/mysql/bin/mysqld() [0xafa9ab]
          /lib/libpthread.so.0(+0x68ca) [0x7f2e979338ca]
          /lib/libc.so.6(clone+0x6d) [0x7f2e968c0b6d]
          		 We have been running with default spider parameter for a while without issue

          After changing some spider parameters on all the slaves
          spider_crd_sync = 0
          spider_same_server_link = 1

          Only the slave used for backup was crashed

          Note that the spider partitions is pointing to mixed remote and local innodb tables

          Intresting is that the mysqldump that break is having --no-data
          {noformat}
           -u${user} -p${passwd} -h${host} --database ${_db} \
                  --allow-keywords --comments --add-drop-table=FALSE \
                  --flush-logs ${master_opt} ${tables_opt} --routines --triggers --no-data \
                  > ${working_dir}/${_db}-struct-dump.sql 2>${working_dir}/${_db}-struct-dump-error.log

          Thread pointer: 0x0x7f2911ed90f8
          Attempting backtrace. You can use the following information to find out
          where mysqld died. If you see no messages after this, something went
          terribly wrong...
          stack_bottom = 0x7f2d704f0e50 thread_stack 0x40000
          (my_addr_resolve failure: fork)
          /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x2e) [0xb8f29e]
          /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x422) [0x708952]
          /lib/libpthread.so.0(+0xeff0) [0x7f2e9793bff0]
          /usr/local/mysql/bin/mysqld() [0x516bb5]
          /usr/local/mysql/bin/mysqld(my_net_read+0x17b) [0x516e4b]
          /usr/local/mysql/bin/mysqld(cli_safe_read+0x26) [0x6e05e6]
          /usr/local/mysql/bin/mysqld() [0x6e23c4]
          /usr/local/mysql/bin/mysqld(mysql_real_query+0x4a) [0x6de6ba]
          /usr/local/mysql/lib/plugin/ha_spider.so(spider_mysql_handler::show_index(int, int)+0x7fa) [0x7f292d31d8fa]
          /usr/local/mysql/lib/plugin/ha_spider.so(spider_get_crd(st_spider_share*, int, long, ha_spider*, TABLE*, double, int, int, int)+0x447) [0x7f292d2dc157]
          /usr/local/mysql/lib/plugin/ha_spider.so(ha_spider::check_crd()+0x37d) [0x7f292d2fb37d]
          /usr/local/mysql/lib/plugin/ha_spider.so(ha_spider::info(unsigned int)+0x509) [0x7f292d2fc889]
          /usr/local/mysql/bin/mysqld(handler::get_dynamic_partition_info(PARTITION_STATS*, unsigned int)+0x1b) [0x708f8b]
          /usr/local/mysql/bin/mysqld() [0x5f021b]
          /usr/local/mysql/bin/mysqld() [0x5fc526]
          /usr/local/mysql/bin/mysqld() [0x5f485c]
          /usr/local/mysql/bin/mysqld(get_all_tables(THD*, TABLE_LIST*, Item*)+0xa55) [0x5f90a5]
          /usr/local/mysql/bin/mysqld(get_schema_tables_result(JOIN*, enum_schema_table_state)+0x296) [0x5ef666]
          /usr/local/mysql/bin/mysqld(JOIN::exec_inner()+0x84e) [0x5ea49e]
          /usr/local/mysql/bin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x20c) [0x5eccbc]
          /usr/local/mysql/bin/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x28a) [0x5ed90a]
          /usr/local/mysql/bin/mysqld() [0x593368]
          /usr/local/mysql/bin/mysqld(mysql_execute_command(THD*)+0x926) [0x5961b6]
          /usr/local/mysql/bin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x259) [0x59d189]
          /usr/local/mysql/bin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x192c) [0x59f0ac]
          /usr/local/mysql/bin/mysqld(do_command(THD*)+0xed) [0x59f84d]
          /usr/local/mysql/bin/mysqld(do_handle_one_connection(THD*)+0x164) [0x665494]
          /usr/local/mysql/bin/mysqld(handle_one_connection+0x42) [0x6655d2]
          /usr/local/mysql/bin/mysqld() [0xafa9ab]
          /lib/libpthread.so.0(+0x68ca) [0x7f2e979338ca]
          /lib/libc.so.6(clone+0x6d) [0x7f2e968c0b6d]
          {noformat}
          serg Sergei Golubchik made changes -
          Assignee Sergey Vojtovich [ svoj ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.7 [ 14100 ]
          serg Sergei Golubchik made changes -
          Priority Major [ 3 ] Minor [ 4 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.8 [ 14200 ]
          Fix Version/s 10.0.7 [ 14100 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.9 [ 14400 ]
          Fix Version/s 10.0.8 [ 14200 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.10 [ 14500 ]
          Fix Version/s 10.0.9 [ 14400 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.11 [ 15200 ]
          Fix Version/s 10.0.10 [ 14500 ]
          svoj Sergey Vojtovich made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 29728 ] MariaDB v2 [ 43700 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 43700 ] MariaDB v3 [ 62859 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 62859 ] MariaDB v4 [ 147237 ]

          People

            svoj Sergey Vojtovich
            stephane@skysql.com VAROQUI Stephane
            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.