Comment 4 for bug 932614

Revision history for this message
Daniel Nichter (daniel-nichter) wrote : Re: pt-slave-restart slightly confusing error if slave crashed

I think this bug is due to placeholders not working for statements like CHANGE MASTER. For example, our MasterSlave module notes this:

      # Just like with CHANGE MASTER TO, you can't quote the position.
      my $sql = "START SLAVE UNTIL MASTER_LOG_FILE='$pos->{file}', "
              . "MASTER_LOG_POS=$pos->{position}";

So pt-slave-restart shouldn't be using placeholders. Thus the status of this bug is "confirmed" but we have no ETA for its fix because we're the in the middle of many other tasks at the moment. We will fix it, but in the meantime, someone else could fix it by simply using quoted SQL statements like the above rather than a statement handle with ? placeholders.