replication problem

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

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

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.

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.

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.