# replication problem

**URL:** <https://forums.percona.com/t/replication-problem/436>\
**Category:** Other MySQL® Questions\
**Created:** [September 4, 2007, 9:53pm UTC](https://forums.percona.com/t/replication-problem/436 "2007-09-04T21:53:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nappin](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@nappin](https://forums.percona.com/u/nappin)\
**Post date:** [September 4, 2007, 9:53pm UTC](https://forums.percona.com/t/replication-problem/436/1 "2007-09-04T21:53:45Z")

</div>

I realize this isnt a performance question per say, but I find this is the best place for mysql help 😉

Anyways, I’m trying to do replication but I keep getting this error on my slave db:

070904 19:29:17 [ERROR] Slave: Query caused different errors on master and slave. Error on master: ‘Query execution was interrupted’ (1317), Error on slave: ‘Can’t get stat of ‘/tmp/SQL\_LOAD-2-1-5.data’ (Errcode: 2)’ (13). Default database: ‘xxxxxxxxxx’. Query: ‘LOAD DATA INFILE ‘/tmp/SQL\_LOAD-2-1-5.data’ IGNORE INTO TABLE xxxxxx FIELDS ENCLOSED BY ‘'’ (xxx, xxx, xxx)’, Error\_code: 0  
070904 19:29:17 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with “SLAVE START”. We stopped at log ‘mysql-bin.000016’ position 319355725

Is there anyway to fix this?

From doing some searching on the web, it appears replication does not work if I load the data into the master via LOAD DATA INFILE? If so, that’s really a bummer (

Is the only way to get this to work to load my data without using LOAD DATA INFILE?

Thanks in advance,  
Ray

---

<div class="post-metadata">

**Author:** ![james](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@james](https://forums.percona.com/u/james)\
**Post date:** [September 5, 2007, 7:55am UTC](https://forums.percona.com/t/replication-problem/436/2 "2007-09-05T07:55:12Z")

</div>

Well, since the query replicated properly, perhaps you can copy the SQL\_LOAD-2-1-5.data file to /tmp/ on your slave server and execute START SLAVE. The error looks like it can’t find the file, which makes sense since it’s not on the slave.

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [September 5, 2007, 8:42am UTC](https://forums.percona.com/t/replication-problem/436/3 "2007-09-05T08:42:25Z")

</div>

Why can’t it find a file ?

Do you place /tmp/ on tmpfs by chance and have rebooted the box or may be have file deleted other way ?

I would simply load the data on the slave if this is one time error and then do slave\_skip\_counter=1 to skip the query.

---

<div class="post-metadata">

**Author:** ![nappin](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@nappin](https://forums.percona.com/u/nappin)\
**Post date:** [September 5, 2007, 1:51pm UTC](https://forums.percona.com/t/replication-problem/436/4 "2007-09-05T13:51:54Z")

</div>

As far as I know, nothing special happened when this error occurred…

But I think you were right, it does appear to be a one time error at the moment. Hopefully it stays that way. )  
I wiped out the slave and started over from a snap shot and then started up the slave again, and it appears to be replicating again nicely. I also ran my script which uses that LOAD DATA INFILE command and it also replicated just fine.

Thanks for the help.  
Ray.