Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1101

LP #1172492: pt-osc : can not connect to slaves why ?

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by yvonne last update 03-05-2013 03:33:50

      Cannot connect to D=USER,P=3306,h=sjcprd3,p=...,u=root

      why do I get this message seen above ?
      I have 3 slaves connected to the master
      the tool still continue to work
      but I have a feeling it does not throttling or care about the max-lag=60 parameter since it says it can not connect
      but one time one of the salves was going down for cold backup while pt-osc was running and it aborted pt-osc so somehow it was aware of the salve status ...
      Mysql v5.1.64
      hmmmm

      1. pt-online-schema-change h=127.0.0.1,D=USER,t=file_download_history -P3306 -uroot -pxxxxxxxx --alter "CHANGE COLUMN download_id download_id bigint(11) unsigned NOT NULL AUTO_INCREMENT" --progress time,300 --chunk-size 50000 --lock-wait-time=360 --max-lag=5000 --no-drop-old-table --max-load=Threads_running:25 --recursion-method=processlist --max-lag=60 --critical-load=Threads_running:2500 --execute
        Cannot connect to D=USER,P=3306,h=sjcprd1,p=...,u=root
        Cannot connect to D=USER,P=3306,h=sjcprd2,p=...,u=root
        Cannot connect to D=USER,P=3306,h=sjcprd3,p=...,u=root
        Altering `USER`.`file_download_history`...
        Creating new table...
        Created new table USER._file_download_history_new OK.
        Altering new table...
        Altered `USER`.`_file_download_history_new` OK.
        Creating triggers...
        Created triggers OK.
        Copying approximately 394093669 rows...
        Copying `USER`.`file_download_history`: 1% 04:06:00 remain
        Copying `USER`.`file_download_history`: 4% 03:57:28 remain

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist