Devin <[EMAIL PROTECTED]> wrote: > > I noticed that my MySQL 4.0.13 Slave Replication server is having > a wierd problem. If you look at the master.info file on the slave > it keeps updating like it is really updating the slave but in > the mysql.err log it shows: > > 030609 16:12:08 Slave I/O thread: connected to master > '[EMAIL PROTECTED]:3306', replication started in log 'io-bin.1964' at > position 1930590 > ERROR: 1016 Can't open file: 'named.MYI'. (errno: 145) > 030609 18:34:13 Slave: error 'Can't open file: 'named.MYI'. (errno: 145)' > on query 'update named set registrar='NETWORK SOLUTIONS, INC.', > regexpires='2012-06-09', regcreated='', regupdated='2003-02-11', > whois='\nWhois Server Version 1.3\n\nDomain names in the .com and .net > domains can now be registered\nwith many different competing registrars. > Go to http://www.internic.net\nfor detailed information.\n\n Domain > Name: HEARTNOTES.COM\n Registrar: NETWORK SOLUTIONS, INC.\n Whois > Server: whois.networksolutions.com\n Referral URL: > http://www.networksolutions.com\n Name Server: NS1.AROS.NET\nFound name > server NS1.AROS.NET\n Name Server: NS2.AROS.NET\nFound name server > NS2.AROS.NET\n Status: ACTIVE\n Updated Date: 11-feb-2003\n > *** Converted 11-feb-2003 into 2003-02-11.\n Creation Date: > 10-jun-1998\n Expiration Date: 09-jun-2012\n *** Converted > 09-jun-2012 into 2012-06-09.\n\n\n>>> Last update of whois database: Thu, > 29 May 2003 17:56:56 EDT <<<\n\nNOTICE: The expiration date displayed in > this record is the date th', error_code=1016 > 030609 18:34:13 Error running query, slave SQL thread aborted. Fix the > problem, and restart the slave SQL thread with "SLAVE START". We stopped > at log 'io-bin.1896' position 7345847 > > It complains that it has stopped at position io-bin.1896, position 7345847 > but I can't find how to make it just skip to the next record, any help > would be appreciated?
$ perror 145 Error code 145: Unknown error 145 145 = Table was marked as crashed and should be repaired Your table 'named' is crashed. You need to repair table and then start slave again. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
