Slave_IO_State field is too short

Bug #260651 reported by Giuseppe Maxia
2
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
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event

select Slave_IO_State from INFORMATION_SCHEMA.SLAVE_STATUS\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for ma

select * from columns where table_schema='information_schema' and table_name='slave_status' and column_name='Slave_IO_State'\G
*************************** 1. row ***************************
           TABLE_CATALOG: NULL
            TABLE_SCHEMA: information_schema
              TABLE_NAME: slave_status
             COLUMN_NAME: Slave_IO_State
        ORDINAL_POSITION: 1
          COLUMN_DEFAULT:
             IS_NULLABLE: NO
               DATA_TYPE: varchar
CHARACTER_MAXIMUM_LENGTH: 14
  CHARACTER_OCTET_LENGTH: 42
       NUMERIC_PRECISION: NULL
           NUMERIC_SCALE: NULL
      CHARACTER_SET_NAME: utf8
          COLLATION_NAME: utf8_general_ci
             COLUMN_TYPE: varchar(14)
              COLUMN_KEY:
                   EXTRA:
              PRIVILEGES: select
          COLUMN_COMMENT:

Revision history for this message
Giuseppe Maxia (giuseppe-maxia) wrote :

The patch below solves the problem

=== modified file 'is-replication-status.xml'
--- is-replication-status.xml 2008-08-23 12:30:48 +0000
+++ is-replication-status.xml 2008-08-23 13:50:59 +0000
@@ -54,7 +54,7 @@
   <infoschema name="SLAVE_STATUS">
    <summary>I_S replacement for SHOW SLAVE STATUS, see also WL #3656</summary>

- <field name="Slave_IO_State" type="STRING" length="14"/>
+ <field name="Slave_IO_State" type="STRING"/>
    <field name="Master_Host" type="STRING"/>
    <field name="Master_User" type="STRING"/>
    <field name="Master_Port" type="LONG"/>

=== modified file 'is_replication_status.cpp'
--- is_replication_status.cpp 2008-08-23 12:30:48 +0000
+++ is_replication_status.cpp 2008-08-23 13:51:20 +0000
@@ -73,7 +73,7 @@

 ST_FIELD_INFO SLAVE_STATUS_field_info[] =
 {
- {"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_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, NULL},

Changed in is-replication-status:
assignee: nobody → hartmut-php
status: New → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.