Percona Server moved to https://jira.percona.com/projects/PS

  1. Bug #1182572
  2. Comment #4

Comment 4 for bug 1182572

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote : Re: Update of federated table crashes PS 5.1.x

Test case from upstream http://bugs.mysql.com/bug.php?id=68354 crashed PS 5.5.30-30.2 also:

stack_bottom = 7fd02c065da8 thread_stack 0x40000
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(my_print_stacktrace+0x35)[0x7b1b75]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(handle_fatal_signal+0x4b4)[0x68d494]
/lib64/libpthread.so.0[0x3ffac0eeb0]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(_ZN12ha_federated7rnd_posEPhS0_+0x35)[0x8fdb65]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(_ZN12multi_update10do_updatesEv+0x3ea)[0x5fd7fa]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(_ZN12multi_update8send_eofEv+0x2a8)[0x5fdcd8]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld[0x5b45de]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(_ZN4JOIN4execEv+0xca0)[0x5c98c0]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x12c)[0x5cb0cc]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(_Z18mysql_multi_updateP3THDP10TABLE_LISTP4ListI4ItemES6_PS4_y15enum_duplicatesbP18st_select_lex_unitP13st_select_lexPP12multi_update+0x124)[0x5fc6e4]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(_Z21mysql_execute_commandP3THD+0x317a)[0x58e5ba]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x33b)[0x59019b]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x15cd)[0x59180d]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x13f)[0x62c33f]
/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/bin/mysqld(handle_one_connection+0x51)[0x62c421]
/lib64/libpthread.so.0[0x3ffac06ccb]
/lib64/libc.so.6(clone+0x6d)[0x3ffa8e0c2d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fd014004ba0): UPDATE t1 JOIN t1fed ON t1.id = t1fed.id SET t1fed.message = t1.message