# a replication error in 5.5.25a-log percona version

**URL:** <https://forums.percona.com/t/a-replication-error-in-5-5-25a-log-percona-version/1914>\
**Category:** Other MySQL® Questions\
**Created:** [October 10, 2012, 4:41am UTC](https://forums.percona.com/t/a-replication-error-in-5-5-25a-log-percona-version/1914 "2012-10-10T04:41:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ayalastrike](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@ayalastrike](https://forums.percona.com/u/ayalastrike)\
**Post date:** [October 10, 2012, 4:41am UTC](https://forums.percona.com/t/a-replication-error-in-5-5-25a-log-percona-version/1914/1 "2012-10-10T04:41:05Z")

</div>

here i have 1 master 2 slave, they use the same mysql version(5.5.25a-log percona version).

Then slave 2 break down, i used the bak files from slave 1 (using mysqldump), and then imported to slave 2  
when imported complete, then set slave 2 to catch up master, but replication error happened.

mysql\> show slave status\G  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
Slave\_IO\_State: Waiting for master to send event  
Master\_Host: 192.168.56.119  
Master\_User: repl  
Master\_Port: 3306  
Connect\_Retry: 60  
Master\_Log\_File: mysql-bin.000090  
Read\_Master\_Log\_Pos: 246003112  
Relay\_Log\_File: relay-bin.000002  
Relay\_Log\_Pos: 267860420  
Relay\_Master\_Log\_File: mysql-bin.000087  
Slave\_IO\_Running: Yes  
Slave\_SQL\_Running: No  
Replicate\_Do\_DB:  
Replicate\_Ignore\_DB:  
Replicate\_Do\_Table:  
Replicate\_Ignore\_Table:  
Replicate\_Wild\_Do\_Table:  
Replicate\_Wild\_Ignore\_Table:  
Last\_Errno: 1032  
Last\_Error: Could not execute Update\_rows event on table kx\_info.s\_user\_logo\_7; Can’t find record in ‘s\_user\_logo\_7’, Error\_code: 1032; handler error HA\_ERR\_END\_OF\_FILE; the event’s master log mysql-bin.000087, end\_log\_pos 747388250  
Skip\_Counter: 0  
Exec\_Master\_Log\_Pos: 747387897  
Relay\_Log\_Space: 2987705016  
Until\_Condition: None  
Until\_Log\_File:  
Until\_Log\_Pos: 0  
Master\_SSL\_Allowed: No  
Master\_SSL\_CA\_File:  
Master\_SSL\_CA\_Path:  
Master\_SSL\_Cert:  
Master\_SSL\_Cipher:  
Master\_SSL\_Key:  
Seconds\_Behind\_Master: NULL  
Master\_SSL\_Verify\_Server\_Cert: No  
Last\_IO\_Errno: 0  
Last\_IO\_Error:  
Last\_SQL\_Errno: 1032  
Last\_SQL\_Error: Could not execute Update\_rows event on table kx\_info.s\_user\_logo\_7; Can’t find record in ‘s\_user\_logo\_7’, Error\_code: 1032; handler error HA\_ERR\_END\_OF\_FILE; the event’s master log mysql-bin.000087, end\_log\_pos 747388250  
Replicate\_Ignore\_Server\_Ids:  
Master\_Server\_Id: 561193306

Then i used mysqlbinlog to check in master machine  
/usr/local/mysql/bin/mysqlbinlog mysql-bin.000087 -vv --start-position=747387897 | less

# at 747387968

# at 747388042

#121009 6:45:57 server id 561193306 end\_log\_pos 747388042 Table\_map: `kx_info`.`s_user_logo_7` mapped to number 253  
#121009 6:45:57 server id 561193306 end\_log\_pos 747388250 Update\_rows: table id 253 flags: STMT\_END\_F

BINLOG ’  
pVdzUBNaIXMhSgAAAIo8jCwAAP0AAAAAAAEAB2t4X2luZm8ADXNfdXNlcl9s b2dvXzcADgMDAwMD  
AwQDDwMHBwMPBQQKACAAAAA=  
pVdzUBhaIXMh0AAAAFo9jCwAAP0AAAAAAAEADv////8AwIeRFQNgUH01yQAA AC8AAAAAAAAAtAAA  
AGZauT5RAQAABGpwZWdYAgAAHANzUBwDc1AAAAAAIDFjMWZhNTdiYWQ4ZjJm ZDJlYjUyOWZlNWU0  
YWE5ZjM1AMCHkRUDYFB9NckAAAAvAAAAAAAAALQAAABmWrk+UQEAAARqcGVn WAIAABwDc1ClV3NQ  
AQAAACAxYzFmYTU3YmFkOGYyZmQyZWI1MjlmZTVlNGFhOWYzNQ==  
'/_!_/;

### UPDATE kx\_info.s\_user\_logo\_7

### WHERE

### @1=51745159 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @2=897405024 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @3=201 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @4=47 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @5=0 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @6=180 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @7=0.362018 /\* FLOAT meta=4 nullable=0 is\_null=0 \*/

### @8=337 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @9=‘jpeg’ /\* VARSTRING(10) meta=10 nullable=0 is\_null=0 \*/

### @10=600 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @11=1349714716 /\* TIMESTAMP meta=0 nullable=0 is\_null=0 \*/

### @12=1349714716 /\* TIMESTAMP meta=0 nullable=0 is\_null=0 \*/

### @13=0 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @14=‘1c1fa57bad8f2fd2eb529fe5e4aa9f35’ /\* VARSTRING(32) meta=32 nullable=0 is\_null=0 \*/

### SET

### @1=51745159 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @2=897405024 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @3=201 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @4=47 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @5=0 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @6=180 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @7=0.362018 /\* FLOAT meta=4 nullable=0 is\_null=0 \*/

### @8=337 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @9=‘jpeg’ /\* VARSTRING(10) meta=10 nullable=0 is\_null=0 \*/

### @10=600 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @11=1349714716 /\* TIMESTAMP meta=0 nullable=0 is\_null=0 \*/

### @12=1349736357 /\* TIMESTAMP meta=0 nullable=0 is\_null=0 \*/

### @13=1 /\* INT meta=0 nullable=0 is\_null=0 \*/

### @14=‘1c1fa57bad8f2fd2eb529fe5e4aa9f35’ /\* VARSTRING(32) meta=32 nullable=0 is\_null=0 \*/

# at 747388250

at the sametime, the data in master/slave1/slave2

mysql\> select \* from s\_user\_logo\_7 where uid=51745159 and pid=897405024;  
±-----±---------±----------±-----±----±------±-----± ---------±------±-------±-------±--------------------±- -------------------±-----------±-------------------------- -------+  
|HOST | uid | pid | logo | top | lleft | size | zoom | width | format | height | ctime | mtime | commentnum | md5 |  
±-----±---------±----------±-----±----±------±-----± ---------±------±-------±-------±--------------------±- -------------------±-----------±-------------------------- -------+  
|MASTER| 51745159 | 897405024 | 201 | 47 | 0 | 180 | 0.362018 | 337 | jpeg | 600 | 2012-10-09 00:45:16 | 2012-10-09 06:45:57 | 1 | 1c1fa57bad8f2fd2eb529fe5e4aa9f35 |  
±-----±---------±----------±-----±----±------±-----± ---------±------±-------±-------±--------------------±- -------------------±-----------±-------------------------- -------+  
|SLAVE1| 51745159 | 897405024 | 201 | 47 | 0 | 180 | 0.362018 | 337 | jpeg | 600 | 2012-10-09 00:45:16 | 2012-10-09 06:45:57 | 1 | 1c1fa57bad8f2fd2eb529fe5e4aa9f35 |  
±-----±---------±----------±-----±----±------±-----± ---------±------±-------±-------±--------------------±- -------------------±-----------±-------------------------- -------+  
|SLAVE2| 51745159 | 897405024 | 201 | 47 | 0 | 180 | 0.362018 | 337 | jpeg | 600 | 2012-10-09 00:45:16 | 2012-10-09 00:45:16 | 0 | 1c1fa57bad8f2fd2eb529fe5e4aa9f35 |  
±-----±---------±----------±-----±----±------±-----± ---------±------±-------±-------±--------------------±- -------------------±-----------±-------------------------- -------+

i don’t know why the error happened.  
When i skip this record, the same error will occur again, and only happened in s\_user\_logo table.

Reference,

binlog\_format=mixed  
isolation\_level=read\_committed

Table: s\_user\_logo\_7  
Create Table: CREATE TABLE `s_user_logo_7` (  
`uid` int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘SPLIT\_KEY’,  
`pid` int(11) NOT NULL DEFAULT ‘0’,  
`logo` int(11) NOT NULL DEFAULT ‘0’,  
`top` int(11) NOT NULL DEFAULT ‘0’,  
`lleft` int(11) NOT NULL DEFAULT ‘0’,  
`size` int(11) NOT NULL DEFAULT ‘0’,  
`zoom` float NOT NULL DEFAULT ‘0’,  
`width` int(11) NOT NULL DEFAULT ‘0’,  
`format` varchar(10) NOT NULL DEFAULT ‘’,  
`height` int(11) NOT NULL DEFAULT ‘0’,  
`ctime` timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’,  
`mtime` timestamp NOT NULL DEFAULT CURRENT\_TIMESTAMP ON UPDATE CURRENT\_TIMESTAMP,  
`commentnum` int(11) NOT NULL DEFAULT ‘0’,  
`md5` varchar(32) NOT NULL DEFAULT ‘’,  
KEY `uid` (`uid`,`ctime`),  
KEY `pid` (`pid`),  
KEY `md5` (`md5`)  
) ENGINE=InnoDB DEFAULT CHARSET=latin1

---

<div class="post-metadata">

**Author:** ![ayalastrike](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@ayalastrike](https://forums.percona.com/u/ayalastrike)\
**Post date:** [October 10, 2012, 8:54pm UTC](https://forums.percona.com/t/a-replication-error-in-5-5-25a-log-percona-version/1914/2 "2012-10-10T20:54:42Z")

</div>

i used the old mysqldump(5.0.56 v10.11) to generate bak files from slave 1.  
is it the root cause?  
should use the mysqldump (5.5.25a v10.13)?