We've been using row replication, but can't really use statement because of
our routines/triggers.

On Thu, Oct 16, 2014 at 10:32 AM, Oscar Elfving <email address hidden> wrote:

> In my case, we were running mixed mode replication, when I switched back
> to statement based replication, the segfaulting stopped.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1380010
>
> Title:
>   Replication segfaults slave server
>
> Status in Percona Server with XtraDB:
>   New
>
> Bug description:
>   After a while when replication ahs been running, the slave server
>   segfaults and restarts, here's the full stacktrace:
>
>   #0  0x000000000086eb32 in unpack_row (rli=<optimized out>,
> table=0x7ffb6d9e6400, colcnt=<optimized out>, row_data=0x7ffb6d9a5e90 "",
> cols=0x7ffb6d9b7a98, current_row_end=0x7ffb6d9b7bb0,
> master_reclength=0x7ffb6d9b7b58, row_end=0x7ffb6d9a69d0 "\360\037")
>       at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/sql/rpl_record.cc:265
>           conv_field = <optimized out>
>           f = <optimized out>
>           master_null_byte_count = <optimized out>
>           pack_ptr = 0x7ffb6d9a5e92 "\t00209-85A\200"
>           tabledef = <optimized out>
>           conv_table = <optimized out>
>           end_ptr = <optimized out>
>           null_mask = <optimized out>
>           null_bits = <optimized out>
>           null_ptr = <optimized out>
>           begin_ptr = 0x7ffb6d9e7a50
>           field_ptr = 0x7ffb6d9e7a50
>           i = <optimized out>
>           max_cols = <optimized out>
>   #1  0x0000000000853324 in unpack_current_row (cols=0x7ffb6d9b7a98,
> rli=0x1c724d60, this=0x7ffb6d9b7940) at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/sql/log_event.h:4301
>   No locals.
>   #2  Write_rows_log_event::write_row (this=this@entry=0x7ffb6d9b7940,
> rli=0x1c724d60, overwrite=false) at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/sql/log_event.cc:12752
>           table = 0x7ffb6d9e6400
>           error = <optimized out>
>           keynum = 0
>           key = {m_ptr = 0x0}
>   #3  0x00000000008536b2 in Write_rows_log_event::do_exec_row
> (this=0x7ffb6d9b7940, rli=<optimized out>) at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/sql/log_event.cc:12970
>           error = <optimized out>
>   #4  0x00000000008431ef in Rows_log_event::do_apply_row (this=this@entry=0x7ffb6d9b7940,
> rli=rli@entry=0x1c724d60) at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/sql/log_event.cc:10309
>           error = 0
>           old_thd = 0x1c755980
>   #5  0x000000000085188f in Rows_log_event::do_apply_event
> (this=0x7ffb6d9b7940, rli=0x1c724d60) at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/sql/log_event.cc:11422
>           after_image = <optimized out>
>           saved_sql_mode = 1073741824
>           saved_m_curr_row = 0x7ffb6d9a49f0 ""
>           do_apply_row_ptr = (int (Rows_log_event::*)(Rows_log_event *
> const, const Relay_log_info *)) 0x8431c0
> <Rows_log_event::do_apply_row(Relay_log_info const*)>
>           error = 0
>           table = 0x7ffb6d9e6400
>   #6  0x000000000084abf7 in Log_event::apply_event (this=0x7ffb6d9b7940,
> rli=0x1c724d60) at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/sql/log_event.cc:3030
>           skip = false
>           parallel = <optimized out>
>           actual_exec_mode = <optimized out>
>           thd = 0x1c755980
>   #7  0x000000000087dc53 in apply_event_and_update_pos (ptr_ev=ptr_ev@entry=0x7ffb831299c0,
> thd=thd@entry=0x1c755980, rli=rli@entry=0x1c724d60)
>       at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/sql/rpl_slave.cc:3549
>           exec_res = 0
>           skip_event = false
>           ev = 0x7ffb6d9b7940
>           reason = <optimized out>
>   #8  0x0000000000880330 in exec_relay_log_event (rli=0x1c724d60,
> thd=0x1c755980) at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/sql/rpl_slave.cc:4045
>           exec_res = <optimized out>
>           ev = 0x7ffb6d9b7940
>           ptr_ev = 0x7ffb831299c0
>   #9  handle_slave_sql (arg=arg@entry=0x1c6e2f20) at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/sql/rpl_slave.cc:5894
>           thd_added = true
>           llbuff1 = "59365801", '\000' <repeats 13 times>
>           saved_master_log_name =
> "/tmp/\000\000\000\300#7\001\000\000\000\000\001\000\000\000\000\000\000\000\360_7\001\000\000\000\000\260\235\022\203\373\177\000\000`\240/\001\000\000\000\000\060\235\022\203\373\177\000\000\342Z\261\000\000\000\000\000\300#7\001",
> '\000' <repeats 20 times>, "\001\000\001\000\000\000\000\000\002", '\000'
> <repeats 11 times>,
> "%\000\000\000\001\000\001\000\000\000\000\000\n\000\000\000\000\000\000\000\360_7\001\000\000\000\000pp0\001\000\000\000\000P\324\061\001\000\000\000\000mC\261\000\000\000\000\000\000\000\006\000\000\000\000\000\300#7\001",
> '\000' <repeats 20 times>"\260, \235\022\203\373\177\000\000@=\325\341\377\177\000\000`\236\022\203\373\177\000\000\367\217\254",
> '\000' <repeats 25 times>,
> "\004\000\000\000\001\000\000\000\000\000\000\000\037\024\352\245\345\317o\000\220B\325\341\377\177\000\000\\B\325"...
>           saved_log_pos = 0
>           saved_master_log_pos = 0
>           rli = 0x1c724d60
>           errmsg = 0x0
>           llbuff = "59365638", '\000' <repeats 13 times>
>           saved_log_name =
> "\003\000\000\000\016\000\000\000\000\060\215\344\377\177\000\000\260\004v\034\000\000\000\000\200[3\001\000\000\000\000@=\325\341\377\177\000\000\000\000\000\000\000\000\000\000\323i\v\217\321{%\000p[\261",
> '\000' <repeats 381 times>"\331,
> w\261\000\000\000\000\000\340\234\022\203\373\177\000\000\300#7\001\000\000\000\000\001\200\000\200\000\000\000\000\000C\035\001\000\000\000\000\220\234\022\203\373\177\000\000$Q\261\000\000\000\000\000\002\000\000\000\000\000\000\000\260\235\022\203\373\177\000"
>           saved_skip = 0
>           mts_inited = false
>           __FUNCTION__ = "handle_slave_sql"
>           thd = 0x1c755980
>   #10 0x0000000000af3e00 in pfs_spawn_thread (arg=0x1c71c1d0) at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/storage/perfschema/pfs.cc:1860
>           typed_arg = 0x1c71c1d0
>           user_arg = 0x1c6e2f20
>           pfs = <optimized out>
>           user_start_routine = 0x87fa50 <handle_slave_sql(void*)>
>           reason = <optimized out>
>   #8  0x0000000000880330 in exec_relay_log_event (rli=0x1c724d60,
> thd=0x1c755980) at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/sql/rpl_slave.cc:4045
>           exec_res = <optimized out>
>           ev = 0x7ffb6d9b7940
>           ptr_ev = 0x7ffb831299c0
>   #9  handle_slave_sql (arg=arg@entry=0x1c6e2f20) at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/sql/rpl_slave.cc:5894
>           thd_added = true
>           llbuff1 = "59365801", '\000' <repeats 13 times>
>           saved_master_log_name =
> "/tmp/\000\000\000\300#7\001\000\000\000\000\001\000\000\000\000\000\000\000\360_7\001\000\000\000\000\260\235\022\203\373\177\000\000`\240/\001\000\000\000\000\060\235\022\203\373\177\000\000\342Z\261\000\000\000\000\000\300#7\001",
> '\000' <repeats 20 times>, "\001\000\001\000\000\000\000\000\002", '\000'
> <repeats 11 times>,
> "%\000\000\000\001\000\001\000\000\000\000\000\n\000\000\000\000\000\000\000\360_7\001\000\000\000\000pp0\001\000\000\000\000P\324\061\001\000\000\000\000mC\261\000\000\000\000\000\000\000\006\000\000\000\000\000\300#7\001",
> '\000' <repeats 20 times>"\260, \235\022\203\373\177\000\000@=\325\341\377\177\000\000`\236\022\203\373\177\000\000\367\217\254",
> '\000' <repeats 25 times>,
> "\004\000\000\000\001\000\000\000\000\000\000\000\037\024\352\245\345\317o\000\220B\325\341\377\177\000\000\\B\325"...
>           saved_log_pos = 0
>           saved_master_log_pos = 0
>           rli = 0x1c724d60
>           errmsg = 0x0
>           llbuff = "59365638", '\000' <repeats 13 times>
>           saved_log_name =
> "\003\000\000\000\016\000\000\000\000\060\215\344\377\177\000\000\260\004v\034\000\000\000\000\200[3\001\000\000\000\000@=\325\341\377\177\000\000\000\000\000\000\000\000\000\000\323i\v\217\321{%\000p[\261",
> '\000' <repeats 381 times>"\331,
> w\261\000\000\000\000\000\340\234\022\203\373\177\000\000\300#7\001\000\000\000\000\001\200\000\200\000\000\000\000\000C\035\001\000\000\000\000\220\234\022\203\373\177\000\000$Q\261\000\000\000\000\000\002\000\000\000\000\000\000\000\260\235\022\203\373\177\000"
>           saved_skip = 0
>           mts_inited = false
>           __FUNCTION__ = "handle_slave_sql"
>           thd = 0x1c755980
>   #10 0x0000000000af3e00 in pfs_spawn_thread (arg=0x1c71c1d0) at
> /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-wheezy-x64/percona-server-5.6-5.6.21-69.0/storage/perfschema/pfs.cc:1860
>           typed_arg = 0x1c71c1d0
>           user_arg = 0x1c6e2f20
>           pfs = <optimized out>
>           user_start_routine = 0x87fa50 <handle_slave_sql(void*)>
>           klass = <optimized out>
>   #11 0x00007ffff7bc7b50 in start_thread () from
> /lib/x86_64-linux-gnu/libpthread.so.0
>   No symbol table info available.
>   #12 0x00007ffff5eb3e6d in clone () from /lib/x86_64-linux-gnu/libc.so.6
>   No symbol table info available.
>   #13 0x0000000000000000 in ?? ()
>   No symbol table info available.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-server/+bug/1380010/+subscriptions
>