Invalid Channel_Name in SHOW SLAVE STATUS for second channel

[OrNix]

Server version: 5.7.11-4 Percona Server (GPL), Release 4, Revision 5c940e1
Centos 6.7 x64.

CHANGE MASTER TO
MASTER_LOG_FILE='binlog.023161',
MASTER_LOG_POS=259419561,
MASTER_HOST='10.1.0.40',
MASTER_PORT=3306,
MASTER_USER='repl',
MASTER_PASSWORD='XXXXXX'
FOR CHANNEL 'wm2';

CHANGE MASTER TO
MASTER_LOG_FILE='bin.000012',
MASTER_LOG_POS=210950653,
MASTER_HOST='10.1.0.37',
MASTER_PORT=3306,
MASTER_USER='repl',
MASTER_PASSWORD='XXXXXX'
FOR CHANNEL 'yml';

In SHOW SLAVE STATUS both channels have Channel_Name: wm2. All the rest rows like Master_Host, positions are valid and different for both channels.

[OrNix (ornixx)]

MySQL loses one channel after restart.

[OrNix (ornixx)]

There is only 1 row in select * from slave_master_info\G, for the last started channel.

[Taras (taras-onishchuk)]

In addition to that it looks like the channel name is written to the wrong column (Tls_info) in slave_master_info:

mysql> select * from mysql.slave_master_info \G
*************************** 1. row ***************************
       Number_of_lines: 25
       Master_log_name: mysql-bin.000005
        Master_log_pos: 1418
                  Host: XX.XX.XX.XX
             User_name: replicator
         User_password: XXXXX
                  Port: 3306
         Connect_retry: 60
           Enabled_ssl: 0
                Ssl_ca:
            Ssl_capath:
              Ssl_cert:
            Ssl_cipher:
               Ssl_key:
Ssl_verify_server_cert: 0
             Heartbeat: 30
                  Bind:
    Ignored_server_ids: 0
                  Uuid: 28c8f1db-1e74-11e6-9971-0a34dcde338d
           Retry_count: 86400
               Ssl_crl:
           Ssl_crlpath:
 Enabled_auto_position: 0
           Tls_version: master1
          Channel_name:
1 row in set (0.00 sec)

[Laurynas Biveinis (laurynas-biveinis)]

Set to New so that our Support processes this bug

[Taras (taras-onishchuk)]

Reproduced on Ubuntu 14.04.4 LTS as well.

[Renan Benedicto Pereira (renanbenedicto)]

I got the same on the CentOS Linux release 7.2.1511 and Percona Server 5.7.12-5-log.

All the channels appears with the 1st's channel_name when use "show slave status", but it works normally for all commands with "FOR CHANNEL".

But you always have to remember the channel_name setted by command "CHANGE MASTER TO".

[Taras (taras-onishchuk)]

Any updates/estimates when this is going to be fixed?

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3404