| Bug #7967 | mysqlhotcopy doesn't parse 'show slave status' correctly | ||
|---|---|---|---|
| Submitted: | 17 Jan 2005 18:36 | Modified: | 23 Jun 2005 3:49 |
| Reporter: | Scott Wilson | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 4.1.8a | OS: | n/a |
| Assigned to: | Elliot Murphy | CPU Architecture: | Any |
[19 Jan 2005 13:20]
Guilhem Bichot
The reason is that in 4.1 we added a column Slave_IO_State at beginning of SHOW SLAVE STATUS. So the person who fixes this bug should make a portable fix: a fix so that mysqlhotcopy will be able to parse the output of SHOW SLAVE STATUS of 4.1 slave AND of 4.0 slave.
[3 May 2005 20:53]
Guilhem Bichot
Will be assigned shortly.
[3 May 2005 20:54]
Guilhem Bichot
Sorry Lachlan :)
[6 Jun 2005 15: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/internals/25645
[7 Jun 2005 2:17]
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/internals/25667
[7 Jun 2005 9:31]
Elliot Murphy
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.
If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
[22 Jun 2005 16:20]
Elliot Murphy
This fix will be in 4.1.13 and 5.0.8
[23 Jun 2005 3:49]
Jon Stephens
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.
If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
Additional info:
Documented bugfux in 4.1.13 and 5.0.8 changelogs; marked bug Closed.
Description: the record_log_pos function in the mysqlhotcopy script no longer parses the output of 'show slave status currectly. How to repeat: Run mysqlhotcopy on a replication slave using the --record_log_pos= option. Suggested fix: *** mysqlhotcopy.dist Mon Jan 17 13:35:59 2005 --- mysqlhotcopy Mon Jan 17 13:35:46 2005 *************** *** 750,754 **** die "master status is undefined" if !defined $file || !defined $position; ! my ($master_host, undef, undef, undef, $log_file, $log_pos ) = get_row( $dbh, "show slave status" ); --- 750,754 ---- die "master status is undefined" if !defined $file || !defined $position; ! my (undef,$master_host, undef, undef, undef, $log_file, $log_pos ) = get_row( $dbh, "show slave status" );