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

Spider : Crash on mysqldump when changing spider_crd_sync = 0

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.5
    • Fix Version/s: 10.0.11
    • Component/s: None
    • Labels:
    • Environment:
      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]
      

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            svoj Sergey Vojtovich added a comment -

            According to Kentoku it was fixed in Spider 3.2, which is available in MariaDB 10.0.11.

            Show
            svoj Sergey Vojtovich added a comment - According to Kentoku it was fixed in Spider 3.2, which is available in MariaDB 10.0.11.

              People

              • Assignee:
                svoj Sergey Vojtovich
                Reporter:
                stephane@skysql.com VAROQUI Stephane
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: