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: | |
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
[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.