Bug #59647 rpl.rpl_semi_sync[_event] crashes debug server when using release plugins
Submitted: 21 Jan 2011 7:51 Modified: 17 Oct 2011 12:05
Reporter: Anitha Gopi Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:mysql-trunk, 5.6 OS:Any
Assigned to: Zhenxing He CPU Architecture:Any
Tags: pb2
Triage: Triaged: D1 (Critical)

[21 Jan 2011 7:51] Anitha Gopi
Description:
http://pb2.norway.sun.com/?action=archive_download&archive_id=2860626&pretty=please

CURRENT_TEST: rpl.rpl_semi_sync_event
mysqltest: At line 53: query 'INSERT INTO t1 (f) VALUES ('a'),('a'),('a'),('a'),('a')' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
include/master-slave.inc
[connection master]
include/stop_slave.inc
include/start_slave.inc
SET GLOBAL event_scheduler = ON;
CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, f varchar(8)) ENGINE=ENGINE_TYPE;

Thread pointer: 0x8894178
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...
/export/home/pb2/test/sb_0-2860414-1295482870.05/mysql-5.6.2-m5-solaris10-x86_64/bin/mysqld:my_print_stacktrace+0x34
/export/home/pb2/test/sb_0-2860414-1295482870.05/mysql-5.6.2-m5-solaris10-x86_64/bin/mysqld:handle_segfault+0x3e8
/lib/amd64/libc.so.1:0xd00b6
/lib/amd64/libc.so.1:0xc53a2
/export/home/pb2/test/sb_0-2860414-1295482870.05/mysql-5.6.2-m5-solaris10-x86_64/lib/plugin/semisync_master.so:repl_semi_after_send_event+0x54 [ Signal 11 (SEGV)]
/export/home/pb2/test/sb_0-2860414-1295482870.05/mysql-5.6.2-m5-solaris10-x86_64/bin/mysqld:__1cYBinlog_transmit_delegateQafter_send_event6MpnDTHD_HpnGString__i_+0x3a4
/export/home/pb2/test/sb_0-2860414-1295482870.05/mysql-5.6.2-m5-solaris10-x86_64/bin/mysqld:__1cRmysql_binlog_send6FpnDTHD_pcXH_v_+0x1a5c
/export/home/pb2/test/sb_0-2860414-1295482870.05/mysql-5.6.2-m5-solaris10-x86_64/bin/mysqld:__1cQdispatch_command6FnTenum_server_command_pnDTHD_pcI_b_+0x27a0
/export/home/pb2/test/sb_0-2860414-1295482870.05/mysql-5.6.2-m5-solaris10-x86_64/bin/mysqld:__1cKdo_command6FpnDTHD__b_+0x3b0
/export/home/pb2/test/sb_0-2860414-1295482870.05/mysql-5.6.2-m5-solaris10-x86_64/bin/mysqld:__1cYdo_handle_one_connection6FpnDTHD__v_+0x7bd
/export/home/pb2/test/sb_0-2860414-1295482870.05/mysql-5.6.2-m5-solaris10-x86_64/bin/mysqld:handle_one_connection+0xba
/export/home/pb2/test/sb_0-2860414-1295482870.05/mysql-5.6.2-m5-solaris10-x86_64/bin/mysqld:pfs_spawn_thread+0x1b9
/lib/amd64/libc.so.1:0xcfd7b
/lib/amd64/libc.so.1:0xcffb0
Please read http://dev.mysql.com/doc/refman/5.1/en/resolve-stack-dump.html
and follow instructions on how to resolve the stack trace.
Resolved stack trace is much more helpful in diagnosing the
problem, so please do resolve it

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): is an invalid pointer
Connection ID (thread ID): 8
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file
----------SERVER LOG END-------------

 - saving '/tmp/mtr-17322/var-rpl_binlog_checksum/1/log/rpl.rpl_semi_sync_event-row/' to '/tmp/mtr-17322/var-rpl_binlog_checksum/log/rpl.rpl_semi_sync_event-row/'
 - found 'core' (1/5)

Trying 'dbx' to get a backtrace
Core generated by '/export/home/pb2/test/sb_0-2860414-1295482870.05/mysql-5.6.2-m5-solaris10-x86_64/bin/mysqld'
Output from dbx follows. Stack trace is printed for all threads in order,
above this you should see info about which thread was the failing one.
----------------------------
For information about new features see `help changes'
To remove this message, put `dbxenv suppress_startup_message 7.6' in your .dbxrc
Reading mysqld
core file header read successfully
Reading ld.so.1
Reading libmtmalloc.so.1
Reading libthread.so.1
Reading libnsl.so.1
Reading libm.so.2
Reading librt.so.1
Reading libsocket.so.1
Reading libCstd.so.1
Reading libCrun.so.1
Reading libc.so.1
Reading libaio.so.1
Reading libmd.so.1
Reading semisync_master.so
t@22 (l@22) terminated by signal SEGV (Segmentation Fault)
0xfffffd7fff17318a: __lwp_kill+0x000a:	jae      __lwp_kill+0x18	[ 0xfffffd7fff173198, .+0xe ]
Current function is my_write_core
dbx: warning: can't find file "/export/home2/pb2/build/sb_0-2860038-1295478588.05/mysql-5.6.2-m5/mysys/stacktrace.c"
dbx: warning: see `help finding-files'
current thread: t@22

How to repeat:
http://pb2.norway.sun.com/?template=mysql_show_test_failure&search=yes&push_id=1942754&tes...
[24 Jan 2011 4:46] Anitha Gopi
On windows the following tests also lead to crash
rpl.rpl_get_master_version_and_clock
rpl.rpl_checksum_cache
rpl.rpl_change_master_crash_safe
rpl.rpl_checksum_cache

Not sure if this is the same problem or not. Adding here for now. Please open a new bug if this is a different problem
http://pb2.norway.sun.com/?action=archive_download&archive_id=2871726&pretty=please
[24 Jan 2011 8:22] Luis Soares
Stack trace on windows:

Thread pointer: 0x50d6210
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...
000007FEF50D3F0D    semisync_master.dll!repl_semi_after_send_event()[semisync_master_plugin.cc:138]
000000013FD84D52    mysqld.exe!Binlog_transmit_delegate::after_send_event()[rpl_handler.cc:413]
00000001400BABE5    mysqld.exe!mysql_binlog_send()[rpl_master.cc:996]
000000013FE66280    mysqld.exe!dispatch_command()[sql_parse.cc:1256]
000000013FE64F3F    mysqld.exe!do_command()[sql_parse.cc:815]
000000013FD37F0E    mysqld.exe!do_handle_one_connection()[sql_connect.cc:748]
000000013FD37967    mysqld.exe!handle_one_connection()[sql_connect.cc:685]
00000001403B31DE    mysqld.exe!pfs_spawn_thread()[pfs.cc:1361]
00000001400E153B    mysqld.exe!pthread_start()[my_winthread.c:62]
000000014049DDE5    mysqld.exe!_callthreadstartex()[threadex.c:348]
000000014049DDB8    mysqld.exe!_threadstartex()[threadex.c:331]
000000007751BE3D    kernel32.dll!BaseThreadInitThunk()
0000000077656A51    ntdll.dll!RtlUserThreadStart()

From:

http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_failure_id=3479240