MySQL Forums
Forum List  »  Replication

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
4230
January 27, 2010 11:06PM
1619
January 29, 2010 09:06PM
1421
February 01, 2010 12:01AM
1338
February 01, 2010 02:15PM
1393
February 01, 2010 07:57PM
1374
February 01, 2010 08:24PM
1361
February 01, 2010 11:54PM
1429
February 03, 2010 05:01AM
1334
February 03, 2010 10:59PM
1338
February 04, 2010 07:47PM
1638
February 21, 2010 07:30PM
1374
February 22, 2010 02:27PM
1208
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.