MySQL Forums
Forum List  »  Replication

Re: slave stuck
Posted by: Rick James
Date: January 29, 2010 09:06PM

In SHOW SLAVE STATUS, look first at these:

Slave_IO_Running: Yes -- Yes is good; No means trouble connecting to Master
Slave_SQL_Running: No -- Yes is good; No: look at Last_Error

Last_Error: Error ... -- If not blank, something is wrong with the statement, at least on the Slave.

Seconds_Behind_Master: NULL -- NULL = trouble (above); 0 or small = good; big number = Slave is having trouble catching up.

Now for the error... "table 'temp_attribute_data_16' is full" -- Sounds like that table hit some limit. Could it be more than 4GB? If so, see MAX_ROWS in ALTER TABLE.
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
SHOW TABLE STATUS LIKE 'temp_attribute_data_16' \G

What to do now? On the Slave...
1. SLAVE STOP;
2. ALTER TABLE ... (assuming it is the 4GB problem)
3. SLAVE START;

Options: ReplyQuote


Subject
Views
Written By
Posted
5431
January 27, 2010 11:06PM
Re: slave stuck
1848
January 29, 2010 09:06PM
1664
February 01, 2010 12:01AM
1573
February 01, 2010 02:15PM
1607
February 01, 2010 07:57PM
1626
February 01, 2010 08:24PM
1690
February 01, 2010 11:54PM
1664
February 03, 2010 05:01AM
1550
February 03, 2010 10:59PM
1609
February 04, 2010 07:47PM
2039
February 21, 2010 07:30PM
1689
February 22, 2010 02:27PM
1508
February 24, 2010 10:16PM


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.