Slave_IO_State field is too short
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Replication Status Plugin |
Fix Committed
|
Undecided
|
Hartmut Holzgraefe |
Bug Description
The column Slave_IO_State is too short to receive all the messages related to the slave IO state.
show slave status\G
*******
select Slave_IO_State from INFORMATION_
*******
Slave_IO_State: Waiting for ma
select * from columns where table_schema=
*******
CHARACTER_
CHARACTER_
CHARACTER
Changed in is-replication-status: | |
assignee: | nobody → hartmut-php |
status: | New → Fix Committed |
The patch below solves the problem
=== modified file 'is-replication -status. xml' status. xml 2008-08-23 12:30:48 +0000 status. xml 2008-08-23 13:50:59 +0000 STATUS" >
--- is-replication-
+++ is-replication-
@@ -54,7 +54,7 @@
<infoschema name="SLAVE_
<summary>I_S replacement for SHOW SLAVE STATUS, see also WL #3656</summary>
- <field name="Slave_ IO_State" type="STRING" length="14"/> IO_State" type="STRING"/>
+ <field name="Slave_
<field name="Master_Host" type="STRING"/>
<field name="Master_User" type="STRING"/>
<field name="Master_Port" type="LONG"/>
=== modified file 'is_replication _status. cpp' status. cpp 2008-08-23 12:30:48 +0000 status. cpp 2008-08-23 13:51:20 +0000
--- is_replication_
+++ is_replication_
@@ -73,7 +73,7 @@
ST_FIELD_INFO SLAVE_STATUS_ field_info[ ] = NUM_DECIMAL_ DIGITS, MYSQL_TYPE_LONG, 0, 0, NULL},
{
- {"Slave_IO_State", 14, MYSQL_TYPE_STRING, 0, 0, NULL},
+ {"Slave_IO_State", 255, MYSQL_TYPE_STRING, 0, 0, NULL},
{"Master_Host", NAME_CHAR_LEN, MYSQL_TYPE_STRING, 0, 0, NULL},
{"Master_User", NAME_CHAR_LEN, MYSQL_TYPE_STRING, 0, 0, NULL},
{"Master_Port", MY_INT64_