MySQL Performance: MySQL => replication problem

Members

Help

Home

Home » Performance » MySQL » replication problem

Show: Today's Messages :: Show Polls :: Message Navigator

replication problem [message #1739]

Tue, 04 September 2007 23:23

nappin
Messages: 8
Registered: November 2006

Junior Member

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 Sad

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

Thanks in advance,
Ray

Report message to a moderator

Re: replication problem [message #1744 is a reply to message #1739 ]

Wed, 05 September 2007 09:25

james
Messages: 17
Registered: September 2007
Location: Arlington, TX

Junior Member

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.

Report message to a moderator

Re: replication problem [message #1748 is a reply to message #1739 ]

Wed, 05 September 2007 10:12

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

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.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: replication problem [message #1757 is a reply to message #1739 ]

Wed, 05 September 2007 15:21

nappin
Messages: 8
Registered: November 2006

Junior Member

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. Smile

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.

Report message to a moderator

Previous Topic:	Another InnoDB performance question :)
Next Topic:	increase int column via UPDATE, without SELECT

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 8 20:48:34 EST 2009

Total time taken to generate the page: 0.00648 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.