LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-05-2010, 02:09 AM   #1
ajayan
Member
 
Registered: Dec 2007
Posts: 89

Rep: Reputation: 16
Mysql Replication error "InnoDB: which exceeds the log group capacity 9433498."


Hi Friends,
I had configured Mysql replication.After i had loaded data in to Master server,replication is not working on the slave.The slave is just got stuck at particular point Showing "Waiting for master to send event".At the time of loading data,the slave server was down.Error logs from slave showing that
"101005 1:52:50 InnoDB: ERROR: the age of the last checkpoint is 10096168,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.".

I guess its a problem with "innodb_log_file size".Currently i hadn't configured no value for "innodb_log_file size".How can i solve the Issue with out loosing data..

Thanks,
Ajayan
 
Old 10-05-2010, 02:17 AM   #2
prayag_pjs
Senior Member
 
Registered: Feb 2008
Location: Pune - India
Distribution: Fedora,RedHat,CentOS,Gentoo
Posts: 1,138
Blog Entries: 4

Rep: Reputation: 147Reputation: 147
Try increasing the size

innodb_log_file_size =

make sure you move existing log files before you start mysql again.
 
  


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
Volume Group "VolGroup00" not found error wisdomvk Linux - Laptop and Netbook 1 10-20-2009 03:05 AM
yum install php-mysql fails with mysql 5.1 - "Error: mysql conflicts with MySQL" rebelde Linux - Software 2 03-13-2009 11:32 AM
Kickstart install error "Unable to read group information from repositories" GGGav Fedora 1 02-07-2008 02:40 PM
usb-hdd: "p1 exceeds device capacity"-> not mountable oskar Linux - Hardware 5 07-27-2007 09:41 PM
New SQUID user: How to clear the "access.log" and "store.log" automatically? yuzuohong Linux - Networking 2 12-02-2006 06:37 AM


All times are GMT -5. The time now is 04:59 PM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration