MySQL Forums :: Replication :: slave stuck


Advanced Search

slave stuck
Posted by: Gareth Williams ()
Date: January 27, 2010 11:06PM

Can anyone provide pointers on what the following state means and how to recover from it?

regards,

Gareth

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: db-2.arcs.org.au
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysqld-bin.000282
Read_Master_Log_Pos: 7323135
Relay_Log_File: mysqld_slave-relay-bin.000364
Relay_Log_Pos: 16808192
Relay_Master_Log_File: mysqld-bin.000274
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1114
Last_Error: Error 'The table 'temp_attribute_data_16' is full' on query. Default database: 'arcs_odl'. Query: 'INSERT INTO temp_attribute_data_16 ( `id` , `file_attribute_id`, `dataset_attribute_id`, `file_id`, `dataset_id`, `array_index` , `value_byte`, `value_float32` ,`value_float64`, `value_int16`, `value_int32`, `value_string`, `value_uint16`, `value_uint32`, `value_unknown`, `value_url`) VALUES (0, 20001486,1,540890,16,null,null,null,null,null,null,null,null,null,null,'http://opendap-qcif.arcs.org.au/thredds/fileServer/IMOS/ACORN/radial/LEI/2007/11/11/IMOS_ACORN_RV_20071111T063500Z_LEI_FV00_radial.nc';), (0, 20001487,2,540890,16,null,null,null,null,null,null,null,null,null,null,'http://opendap-qcif.arcs.org.au/thredds/dodsC/IMOS/ACORN/radial/LEI/2007/11/11/IMOS_ACORN_RV_20071111T063500Z_LEI_FV00_radial.nc';), (0, 20001488,3,540890,16,null,null,null,null,null,null,'IMOS_ACORN_RV_20071111T063500Z_LEI_FV00_radial.nc',null,null,null,null), (0, 20001489,4,5408
90,16,null,null,null,null,null,null,'http://opendap-qcif.arcs.
Skip_Counter: 0
Exec_Master_Log_Pos: 40265269
Relay_Log_Space: 2738626820
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
1 row in set (0.00 sec)

Options: ReplyQuote


Subject Views Written By Posted
slave stuck 4088 Gareth Williams 01/27/2010 11:06PM
Re: slave stuck 1597 Rick James 01/29/2010 09:06PM
Re: slave stuck 1404 Gareth Williams 02/01/2010 12:01AM
Re: slave stuck 1321 Rick James 02/01/2010 02:15PM
Re: slave stuck 1367 Gareth Williams 02/01/2010 07:57PM
Re: slave stuck 1349 Gareth Williams 02/01/2010 08:24PM
Re: slave stuck 1342 Rick James 02/01/2010 11:54PM
Re: slave stuck 1404 Gareth Williams 02/03/2010 05:01AM
Re: slave stuck 1318 Rick James 02/03/2010 10:59PM
Re: slave stuck 1319 Gareth Williams 02/04/2010 07:47PM
Re: slave stuck 1591 Gareth Williams 02/21/2010 07:30PM
Re: slave stuck 1352 Gareth Williams 02/22/2010 02:27PM
Re: slave stuck 1181 Gareth Williams 02/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.