Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

LP #1002512: pt-slave-find does not report with MySQL sandbox

Description

**Reported in Launchpad by Ronald Bradford last update 20-06-2013 18:36:12

Using MySQL Sandbox with a standard replication topology, pt-slave-find states there are 2 slaves connected but does not print any details as expected with tool.

$ pt-slave-find --defaults-file=master/my.sandbox.cnf --host localhost --report-format summary
localhost
Version 5.5.24-log
Server ID 1
Uptime 22:45 (started 2012-05-21T16:33:12)
Replication Is not a slave, has 2 slaves connected,
is not read_only
Filters
Binary logging STATEMENT
Slave status
Slave mode STRICT
Auto-increment increment 1, offset 1
InnoDB version 1.1.8

Full setup instructions

$ wget https://launchpadlibrarian.net/91596901/MySQL-Sandbox-3.0.25.tar.gz
$ tar xvfz MySQL-Sandbox-3.0.25.tar.gz
$ cd MySQL-Sandbox-3.0.25
$ perl Makefile.PL
$ make
$ make test
$ sudo make install
$ make_sandbox --help
$ mkdir -p $HOME/opt/mysql
$ cd $HOME/opt/mysql
$ wget http://mysql.he.net/Downloads/MySQL-5.5/mysql-5.5.24-linux2.6-x86_64.tar.gz
$ tar xvfz mysql-5.5.24-linux2.6-x86_64.tar.gz
$ mv mysql-5.5.24-linux2.6-x86_64 5.5.24
$ make_replication_sandbox 5.5.24
$ cd $HOME/sandbox/rsandbox_5_5_24

Environment

None

Smart Checklist

Activity

lpjirasync January 24, 2018 at 6:39 PM

**Comment from Launchpad by: Brian Fraser on: 16-11-2012 15:09:46

Apparently setting report-host to a fake hostname isn't a normal pattern, so we're just not going to fix that, at least until there's a compelling reason to do so.

If someone is affected by that, feel free to create a new ticket?

lpjirasync January 24, 2018 at 6:39 PM

**Comment from Launchpad by: Brian Fraser on: 07-11-2012 09:08:06

There's two bugs here. First is that even though the server is on a nonstandard port, we incorrectly pick --recursion-method processlist. So until this is fixed, people should be able to work around this by using an explicit --port or dsn on their command lines.
The second bug is that MySQL Sandbox sets report-host to a fake hostname, so even with --recursion-method hosts, it still fails (and hangs!). No clue what to do here.

Details

Assignee

Reporter

Priority

Fix versions

Labels

Smart Checklist

Created January 24, 2018 at 6:39 PM
Updated May 18, 2024 at 12:29 AM

Flag notifications