sanitized relay log dump for positions seen in error log
```/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#150730 13:30:35 server id 64623 end_log_pos 107 Start: binlog v 4, server v 5.5.20-55-log created 150730 13:30:35
BINLOG '
a4m6VQ9v/AAAZwAAAGsAAAAAAAQANS41LjIwLTU1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==
'/*!*/;
# at 150
#150730 11:30:27 server id 64523 end_log_pos 0 Start: binlog v 4, server v 5.5.20-55-log created 150730 11:30:27
BINLOG '
Q226VQ8L/AAAZwAAAAAAAAAAAAQANS41LjIwLTU1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==
'/*!*/;
# at 87508984
#150730 13:30:41 server id 64523 end_log_pos 87496169 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
SET @@session.pseudo_thread_id=439840/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=2097152/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
BEGIN
/*!*/;
# at 87509055
#150730 13:30:41 server id 64523 end_log_pos 87496169 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
BEGIN
/*!*/;
# at 87509126
#150730 13:30:41 server id 64523 end_log_pos 87496627 Query thread_id=439840 exec_time=0 error_code=0
use zapps23/*!*/;
SET TIMESTAMP=1438288241/*!*/;
<STATEMENT>
/*!*/;
# at 87509584
#150730 13:30:41 server id 64523 end_log_pos 87496627 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
<STATEMENT>
/*!*/;
# at 87510042
#150730 13:30:41 server id 64523 end_log_pos 87496654 Xid = 301895834
COMMIT/*!*/;
# at 87510069
#150730 13:30:41 server id 64523 end_log_pos 87496654 Xid = 301895834
COMMIT/*!*/;
# at 87510096
#150730 13:30:41 server id 64523 end_log_pos 87496725 Query thread_id=439842 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
BEGIN
/*!*/;
# at 87510167
#150730 13:30:41 server id 64523 end_log_pos 87496725 Query thread_id=439842 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
BEGIN
/*!*/;
# at 87510238
#150730 13:30:41 server id 64523 end_log_pos 87499143 Query thread_id=439842 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
<STATEMENT>
/*!*/;
# at 87512656
#150730 13:30:41 server id 64523 end_log_pos 87499143 Query thread_id=439842 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
<STATEMENT>
/*!*/;
# at 87515074
#150730 13:30:41 server id 64523 end_log_pos 87499170 Xid = 301895923
COMMIT/*!*/;
# at 87515101
#150730 13:30:41 server id 64523 end_log_pos 87499170 Xid = 301895923
COMMIT/*!*/;
# at 87515128
#150730 13:30:41 server id 64523 end_log_pos 87499241 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
BEGIN
/*!*/;
# at 87515199
#150730 13:30:41 server id 64523 end_log_pos 87499241 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
BEGIN
/*!*/;
# at 87515270
#150730 13:30:41 server id 64523 end_log_pos 87499678 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
<STATEMENT>
/*!*/;
# at 87515707
#150730 13:30:41 server id 64523 end_log_pos 87499678 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
<STATEMENT>
/*!*/;
# at 87516144
#150730 13:30:41 server id 64523 end_log_pos 87499705 Xid = 301895951
COMMIT/*!*/;
# at 87516171
#150730 13:30:41 server id 64523 end_log_pos 87499705 Xid = 301895951
COMMIT/*!*/;
# at 87516198
#150730 13:30:41 server id 64523 end_log_pos 87499776 Query thread_id=440818 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
BEGIN
/*!*/;
# at 87516269
#150730 13:30:41 server id 64523 end_log_pos 87499776 Query thread_id=440818 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
BEGIN
/*!*/;
# at 87516340
#150730 13:30:41 server id 64523 end_log_pos 87500465 Query thread_id=440818 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
<STATEMENT>
/*!*/;
# at 87517029
#150730 13:30:41 server id 64523 end_log_pos 87500492 Xid = 301896000
COMMIT/*!*/;
# at 87517056
#150730 13:30:41 server id 64523 end_log_pos 87500465 Query thread_id=440818 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;
<STATEMENT>
/*!*/;
# at 87517745
#150730 13:30:41 server id 64523 end_log_pos 87500492 Xid = 301896000
COMMIT/*!*/;
# at 87517772
#150730 13:30:41 server id 64523 end_log_pos 87500563 Query thread_id=441104 exec_time=0 error_code=0
SET TIMESTAMP=1438288241/*!*/;```
sanitized relay log dump for positions seen in error log
```/*!40019 SET @@session. max_insert_ delayed_ threads= 0*/; _TYPE=@ @COMPLETION_ TYPE,COMPLETION _TYPE=0* /; AAAZwAAAGsAAAAA AAQANS41LjIwLTU 1LWxvZwAAAAAAAA AAAAAAAAAAAAAAA AAAAAAA AAAAAAAAAEzgNAA gAEgAEBAQEEgAAV AAEGggAAAAICAgC AA== AAAZwAAAAAAAAAA AAQANS41LjIwLTU 1LWxvZwAAAAAAAA AAAAAAAAAAAAAAA AAAAAAA AAAAAAAAAEzgNAA gAEgAEBAQEEgAAV AAEGggAAAAICAgC AA== 1438288241/ *!*/; pseudo_ thread_ id=439840/ *!*/; foreign_ key_checks= 1, @@session. sql_auto_ is_null= 0, @@session. unique_ checks= 1, @@session. autocommit= 1/*!*/; sql_mode= 2097152/ *!*/; auto_increment_ increment= 1, @@session. auto_increment_ offset= 1/*!*/; character_ set_client= 33,@@session. collation_ connection= 33,@@session. collation_ server= 8/*!*/; lc_time_ names=0/ *!*/; collation_ database= DEFAULT/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/; 1438288241/ *!*/;`` `
/*!50003 SET @OLD_COMPLETION
DELIMITER /*!*/;
# at 4
#150730 13:30:35 server id 64623 end_log_pos 107 Start: binlog v 4, server v 5.5.20-55-log created 150730 13:30:35
BINLOG '
a4m6VQ9v/
AAAAAAAAAAAAAAA
'/*!*/;
# at 150
#150730 11:30:27 server id 64523 end_log_pos 0 Start: binlog v 4, server v 5.5.20-55-log created 150730 11:30:27
BINLOG '
Q226VQ8L/
AAAAAAAAAAAAAAA
'/*!*/;
# at 87508984
#150730 13:30:41 server id 64523 end_log_pos 87496169 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=
SET @@session.
SET @@session.
SET @@session.
SET @@session.
/*!\C utf8 *//*!*/;
SET @@session.
SET @@session.
SET @@session.
BEGIN
/*!*/;
# at 87509055
#150730 13:30:41 server id 64523 end_log_pos 87496169 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=
BEGIN
/*!*/;
# at 87509126
#150730 13:30:41 server id 64523 end_log_pos 87496627 Query thread_id=439840 exec_time=0 error_code=0
use zapps23/*!*/;
SET TIMESTAMP=
<STATEMENT>
/*!*/;
# at 87509584
#150730 13:30:41 server id 64523 end_log_pos 87496627 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=
<STATEMENT>
/*!*/;
# at 87510042
#150730 13:30:41 server id 64523 end_log_pos 87496654 Xid = 301895834
COMMIT/*!*/;
# at 87510069
#150730 13:30:41 server id 64523 end_log_pos 87496654 Xid = 301895834
COMMIT/*!*/;
# at 87510096
#150730 13:30:41 server id 64523 end_log_pos 87496725 Query thread_id=439842 exec_time=0 error_code=0
SET TIMESTAMP=
BEGIN
/*!*/;
# at 87510167
#150730 13:30:41 server id 64523 end_log_pos 87496725 Query thread_id=439842 exec_time=0 error_code=0
SET TIMESTAMP=
BEGIN
/*!*/;
# at 87510238
#150730 13:30:41 server id 64523 end_log_pos 87499143 Query thread_id=439842 exec_time=0 error_code=0
SET TIMESTAMP=
<STATEMENT>
/*!*/;
# at 87512656
#150730 13:30:41 server id 64523 end_log_pos 87499143 Query thread_id=439842 exec_time=0 error_code=0
SET TIMESTAMP=
<STATEMENT>
/*!*/;
# at 87515074
#150730 13:30:41 server id 64523 end_log_pos 87499170 Xid = 301895923
COMMIT/*!*/;
# at 87515101
#150730 13:30:41 server id 64523 end_log_pos 87499170 Xid = 301895923
COMMIT/*!*/;
# at 87515128
#150730 13:30:41 server id 64523 end_log_pos 87499241 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=
BEGIN
/*!*/;
# at 87515199
#150730 13:30:41 server id 64523 end_log_pos 87499241 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=
BEGIN
/*!*/;
# at 87515270
#150730 13:30:41 server id 64523 end_log_pos 87499678 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=
<STATEMENT>
/*!*/;
# at 87515707
#150730 13:30:41 server id 64523 end_log_pos 87499678 Query thread_id=439840 exec_time=0 error_code=0
SET TIMESTAMP=
<STATEMENT>
/*!*/;
# at 87516144
#150730 13:30:41 server id 64523 end_log_pos 87499705 Xid = 301895951
COMMIT/*!*/;
# at 87516171
#150730 13:30:41 server id 64523 end_log_pos 87499705 Xid = 301895951
COMMIT/*!*/;
# at 87516198
#150730 13:30:41 server id 64523 end_log_pos 87499776 Query thread_id=440818 exec_time=0 error_code=0
SET TIMESTAMP=
BEGIN
/*!*/;
# at 87516269
#150730 13:30:41 server id 64523 end_log_pos 87499776 Query thread_id=440818 exec_time=0 error_code=0
SET TIMESTAMP=
BEGIN
/*!*/;
# at 87516340
#150730 13:30:41 server id 64523 end_log_pos 87500465 Query thread_id=440818 exec_time=0 error_code=0
SET TIMESTAMP=
<STATEMENT>
/*!*/;
# at 87517029
#150730 13:30:41 server id 64523 end_log_pos 87500492 Xid = 301896000
COMMIT/*!*/;
# at 87517056
#150730 13:30:41 server id 64523 end_log_pos 87500465 Query thread_id=440818 exec_time=0 error_code=0
SET TIMESTAMP=
<STATEMENT>
/*!*/;
# at 87517745
#150730 13:30:41 server id 64523 end_log_pos 87500492 Xid = 301896000
COMMIT/*!*/;
# at 87517772
#150730 13:30:41 server id 64523 end_log_pos 87500563 Query thread_id=441104 exec_time=0 error_code=0
SET TIMESTAMP=