LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 09-25-2014, 10:12 AM   #1
depam
Member
 
Registered: Sep 2005
Posts: 861

Rep: Reputation: 30
MySQL Slave failing because of master corruption


Running an old MySQL 4.X and have setup Replication. The problem is that the Slave stops every time with error 1034.

Error

<-- snip
caused different errors on mast er and slave. Error on master: 'Incorrect key file for table: '%-.64s'. Try to r epair it' (1034), Error on slave: 'no error' (0). Default database
-->

This is always happening and I suspect that could be due to the large DB (roughly around 3-6GB) with jobs doing massive deletes everyday.

Each time this happens, I reset master, stop and reset slave and dump the whole DB from master, scp to the slave and import, start slave. This sometimes causes tables to still be not in sync. Can you please advise on what is the best way for the master and slave to be in sync when this issue arises?
 
Old 09-26-2014, 07:34 AM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.2
Posts: 18,329

Rep: Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745
Possibly a 32 bit problem (2^32 = 4G). Is it a 32 bit system and/or a 32 bit install of MySQL4?
 
Old 09-29-2014, 10:34 AM   #3
depam
Member
 
Registered: Sep 2005
Posts: 861

Original Poster
Rep: Reputation: 30
Yes. This is a 32 bit and MySQL4. Did you have the same issue?
 
Old 10-02-2014, 08:20 AM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.2
Posts: 18,329

Rep: Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745Reputation: 2745
Not specifically, but if the DB is "roughly around 3-6GB" and you do some "massive deletes", then its possible the system is at some point trying to create/access beyond 4G ie 2^32.

It's really time you used a current version of OS+MySQL ie MySQL (or MariaDB) 5.x and 64bit, otherwise you're likely to see this often.

Note that this is just a best guess based on the info provided.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] mysql master slave replication error divyashree Linux - Software 2 12-01-2013 10:09 PM
Question about mysql master-slave circus78 Linux - Server 2 01-29-2013 04:39 AM
MySQL Master-Slave Replication - How to make the slave read-only? saagar Linux - Server 1 08-31-2010 09:13 AM
MySQL Master-SLave Replication?? linuxshadow Linux - Server 7 06-13-2008 10:22 AM
Multiple Master to one Slave for MySQL Replication Swakoo Linux - General 0 03-31-2007 05:40 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:33 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration