[MDEV-5299] Spider : Crash on mysqldump when changing spider_crd_sync = 0 Created: 2013-11-15  Updated: 2014-04-15  Resolved: 2014-04-15

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.5
Fix Version/s: 10.0.11

Type: Bug Priority: Minor
Reporter: VAROQUI Stephane Assignee: Sergey Vojtovich
Resolution: Fixed Votes: 0
Labels: spider
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]



 Comments   
Comment by Sergey Vojtovich [ 2014-04-15 ]

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

Generated at Thu Feb 08 07:03:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.