MySQL Forums
Forum List  »  Replication

Re: MYSQL Replication
Posted by: Sameer Shah
Date: March 14, 2014 09:08AM

To give some more information:
I see the following in the slave error logs:

140314 12:57:35 InnoDB: ERROR: the age of the last checkpoint is 9437860,
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.
140314 12:57:51 InnoDB: ERROR: the age of the last checkpoint is 9433566,
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.
140314 12:58:04 InnoDB: WARNING: over 67 percent of the buffer pool is occupied by
InnoDB: lock heaps or the adaptive hash index! Check that your
InnoDB: transactions do not set too many row locks.
InnoDB: Your buffer pool size is 8 MB. Maybe you should make
InnoDB: the buffer pool bigger?
InnoDB: Starting the InnoDB Monitor to print diagnostics, including
InnoDB: lock heap and hash index sizes.

140314 12:58:43 InnoDB: ERROR: over 95 percent of the buffer pool is occupied by
InnoDB: lock heaps or the adaptive hash index! Check that your
InnoDB: transactions do not set too many row locks.
InnoDB: Your buffer pool size is 8 MB. Maybe you should make
InnoDB: the buffer pool bigger?
InnoDB: We intentionally generate a seg fault to print a stack trace
InnoDB: on Linux!
140314 12:58:43InnoDB: Assertion failure in thread 3037547424 in file buf0lru.c line 372
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: about forcing recovery.
140314 12:58:43 - mysqld got signal 11;

Also there is an update going on for days now on the slave.

Options: ReplyQuote


Subject
Views
Written By
Posted
1748
March 13, 2014 11:35AM
Re: MYSQL Replication
1630
March 14, 2014 09:08AM
1065
March 16, 2014 03:55PM
996
March 18, 2014 09:12AM
991
March 19, 2014 05:29PM
862
March 25, 2014 03:58PM
836
March 26, 2014 06:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.