Bug #50316 Add Master_info_file to SHOW SLAVE STATUS
Submitted: 13 Jan 2010 20:58 Modified: 4 Aug 2010 10:56
Reporter: Mark Leith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S4 (Feature request)
Version:5.5.0 OS:Any
Assigned to: Andrei Elkin CPU Architecture:Any

[13 Jan 2010 20:58] Mark Leith
Description:
It is impossible to discover where the master.info file is, if somebody uses the --master-info-file variable. 

As this variable points to a file with master credentials within it, it does not appear in the output of SHOW GLOBAL VARIABLES (one assumes), so the request is for this to be shown within SHOW SLAVE STATUS, so only users with the REPLICATION CLIENT privilege can view the value for the variable. 

How to repeat:
Try to ascertain where the master-info-file is, from a running server.

Suggested fix:
Add Master_info_file to SHOW SLAVE STATUS
[24 Mar 2010 8:20] Andrei Elkin
This feature request can be addressed along wl#3656 implementation.
Two options to consider: 
- to add Master_info_file solely into the upcoming I_S.show_slave_status
- to add it to either displays, that is the standard Show Slave Status as well.
[24 Mar 2010 12:19] Mark Leith
Hi Andrei, 

Please add it to both - the MEM agent uses SHOW SLAVE STATUS currently (and will continue to do so for backwards compatibility). 

Cheers,

Mark
[5 May 2010 15:29] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/107551

3140 Andrei Elkin	2010-05-05
      Bug #50316  Add Master_info_file to SHOW SLAVE STATUS
      
      Implemeneted the suggested feature for the SHOW SLAVE STATUS command.
     @ mysql-test/extra/rpl_tests/rpl_extraMaster_Col.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/extra/rpl_tests/rpl_row_tabledefs.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/include/show_slave_status.inc
        shadowing non-deterministic value in show slave status
     @ mysql-test/include/show_slave_status2.inc
        shadowing non-deterministic value in show slave status
     @ mysql-test/include/test_fieldsize.inc
        shadowing non-deterministic value in show slave status
     @ mysql-test/suite/rpl/r/rpl_000015.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_bug33931.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_change_master.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_deadlock_innodb.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_extraColmaster_innodb.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_extraColmaster_myisam.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_flushlog_loop.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_grant.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_heartbeat.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_incident.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_known_bugs_detection.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_loaddata_fatal.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_log_pos.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_rbr_to_sbr.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_replicate_do.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_rotate_logs.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_colSize.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_log.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_log_innodb.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_max_relay_size.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_reset_slave.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_tabledefs_2myisam.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_tabledefs_3innodb.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_until.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_skip_error.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_slave_skip.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_ssl.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_ssl1.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_stm_log.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_stm_max_relay_size.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_stm_reset_slave.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_stm_until.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_temporary_errors.result
        results changed
     @ mysql-test/suite/rpl/t/rpl_bug33931.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_flushlog_loop.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_incident.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_known_bugs_detection.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_rbr_to_sbr.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_replicate_do.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_row_until.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_slave_skip.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_ssl.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_ssl1.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_basic.test
        shadowing possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_idempotent.test
        shadowing possible non-deterministic output due to the new SSS field
     @ sql/rpl_mi.cc
        master info file name the new member of Master_Info initialization is added to replace a local char[] inside init_master_info().
     @ sql/rpl_mi.h
        Adding a new member to Master_Info to keep a path value to the master
        info file.
     @ sql/slave.cc
        Adding a new line to the SSS.
[5 May 2010 15:31] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/107552

3141 Andrei Elkin	2010-05-05
      Bug #50316  Add Master_info_file to SHOW SLAVE STATUS
      
      a test for the bug showing that the server init parameter propagates its
      value into active_mi and that info is displayed is SSS output
[6 May 2010 19:43] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/107689

3140 Andrei Elkin	2010-05-06
      Bug #50316  Add Master_info_file to SHOW SLAVE STATUS
      
      Implemeneted the suggested feature for the SHOW SLAVE STATUS command.
      Added a test for the bug showing that the server init parameter propagates its
      value into active_mi and that info is displayed is SSS output.
     @ mysql-test/extra/rpl_tests/rpl_extraMaster_Col.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/extra/rpl_tests/rpl_row_tabledefs.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/include/show_slave_status.inc
        shadowing non-deterministic value in show slave status
     @ mysql-test/include/show_slave_status2.inc
        shadowing non-deterministic value in show slave status
     @ mysql-test/include/test_fieldsize.inc
        shadowing non-deterministic value in show slave status
     @ mysql-test/suite/rpl/r/rpl_000015.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_bug33931.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_change_master.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_deadlock_innodb.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_extraColmaster_innodb.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_extraColmaster_myisam.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_flushlog_loop.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_grant.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_heartbeat.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_incident.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_known_bugs_detection.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_loaddata_fatal.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_log_pos.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_rbr_to_sbr.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_replicate_do.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_rotate_logs.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_colSize.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_log.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_log_innodb.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_max_relay_size.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_reset_slave.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_tabledefs_2myisam.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_tabledefs_3innodb.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_row_until.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_skip_error.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_slave_skip.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_ssl.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_ssl1.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_stm_log.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_stm_max_relay_size.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_stm_reset_slave.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_stm_until.result
        results changed
     @ mysql-test/suite/rpl/r/rpl_temporary_errors.result
        results changed
     @ mysql-test/suite/rpl/t/rpl_bug33931.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_flushlog_loop.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_incident.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_known_bugs_detection.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_rbr_to_sbr.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_replicate_do.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_row_until.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_slave_skip.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_ssl.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl/t/rpl_ssl1.test
        #-ing out possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_basic.test
        shadowing possible non-deterministic output due to the new SSS field
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_idempotent.test
        shadowing possible non-deterministic output due to the new SSS field
     @ sql/rpl_mi.cc
        master info file name the new member of Master_Info initialization is added to replace a local char[] inside init_master_info().
     @ sql/rpl_mi.h
        Adding a new member to Master_Info to keep a path value to the master
        info file.
     @ sql/slave.cc
        Adding a new line to the SSS.
[7 May 2010 7:59] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/107710

3141 Andrei Elkin	2010-05-07
      Bug #50316  Add Master_info_file to SHOW SLAVE STATUS
      
      improving the test of the bug
[16 May 2010 18:41] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108410

3045 Andrei Elkin	2010-05-16
      bug#50316  Add Master_info_file to SHOW SLAVE STATUS
      
      pushing to next-mr-bugfixing from working branch
[16 May 2010 20:51] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108414

3179 Andrei Elkin	2010-05-16 [merge]
      merge bug#50316 to next-mr-bugfixing
[18 May 2010 7:14] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108474

3047 Andrei Elkin	2010-05-18 [merge]
      merging bug#50316 fixes
[18 May 2010 7:16] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108475

3181 Andrei Elkin	2010-05-18 [merge]
      merging bug#50316 fixes
[18 May 2010 7:19] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108476

3182 Andrei Elkin	2010-05-18 [merge]
      merging bug#50316 fixes
[18 May 2010 7:20] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108477

3880 Andrei Elkin	2010-05-18 [merge]
      merging bug#50316 fixes
[18 May 2010 8:08] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108478

3048 Andrei Elkin	2010-05-18
      rpl_ndb tests fixing results files due to Master_Info_File of bug#50316
[18 May 2010 8:15] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108479

3183 Andrei Elkin	2010-05-18 [merge]
      merging bug#50316 fixes
[18 May 2010 9:35] Andrei Elkin
Pushed to trunk,next-mr,6.0-codebase - bugfixes trees.
[18 May 2010 15:44] Andrei Elkin
Reverted fixes in mysql-trunk-bugfixing to leave them in the upper trees.
[19 May 2010 5:07] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108565

3186 Andrei Elkin	2010-05-19
      failing parts.rpl_partition for bug#50316
      
      fixed with #-out the new added field value in SSS output
[19 May 2010 5:12] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108567

3885 Andrei Elkin	2010-05-19 [merge]
      merging from next-mr: failing parts.rpl_partition for bug#50316
[20 May 2010 10:04] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100520100225-oe4iuu5kuzsx0knq) (version source revid:alik@sun.com-20100520100057-rmn5y3o3ij726bm7) (merge vers: 6.0.14-alpha) (pib:16)
[20 May 2010 10:05] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100520100041-rf8ujv598zf86wjt) (version source revid:alik@sun.com-20100520100041-rf8ujv598zf86wjt) (merge vers: 5.5.5-m3) (pib:16)
[20 May 2010 10:06] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100520100140-5bzrtadw4w419i3m) (version source revid:alik@sun.com-20100520100049-1njm09rkvnhmysnr) (pib:16)
[3 Jun 2010 16:26] Paul Dubois
Noted in 5.5.5, 6.0.14 changelogs.

The SHOW SLAVE STATUS statement now has a Master_Info_File field
indicating the location of the master.info file.
[3 Jun 2010 17:23] Paul Dubois
Correction: This change is not present in 5.5.5.
[4 Aug 2010 8:10] Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:alik@sun.com-20100520123900-5kadc9fvcxz30s75) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 8:26] Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:alik@sun.com-20100520123900-5kadc9fvcxz30s75) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 10:56] Jon Stephens
Also noted in the 5.6.1 changelog. Closed.
[4 Aug 2010 14:04] Jon Stephens
5.6 version is 5.6.0 not 5.6.1 - fixed changelog entry.