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

pt-osc + PTDEBUG=1 fails with Use of uninitialized value in concatenation (.) or string at /usr/bin/pt-online-schema-change line 4270.


    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 3.1.0
    • 3.5.0
    • None
    • None
    • 0.1


      Execute pt-online-schema-change on a master-slave environment with --slave-user --slave-password options will fail with the error:

      Use of uninitialized value in concatenation (.) or string at /usr/bin/pt-online-schema-change line 4270.


      See attachments for samples runs.

      Without slave user/password in pt-osc will work:

      PTDEBUG=1 pt-online-schema-change --user=master_checksum --password=master_checksum --alter "FORCE" D=test,t=sbtest1 --recursion-method=processlist --no-check-replication-filters --no-check-alter --no-check-plan --chunk-index=PRIMARY --no-version-check --execute > pt-osc_noslaveuser.txt 2>&1


      With slave user/password in pt-osc will not work:

      PTDEBUG=1 pt-online-schema-change --user=master_checksum --password=master_checksum --alter "FORCE" --slave-user=slave_checksum --slave-password=slave_checksum D=test,t=sbtest1 --recursion-method=processlist --no-check-replication-filters --no-check-alter --no-check-plan --chunk-index=PRIMARY --no-version-check --execute > pt-osc_withslaveuser.txt 2>&1


      With --slave-user and --slave-password but without PTDEBUG=1

      pt-online-schema-change --user=master_checksum --password=master_checksum --alter "FORCE" --slave-user=slave_checksum --slave-password=slave_checksum D=test,t=sbtest1 --recursion-method=processlist --no-check-replication-filters --no-check-alter --no-check-plan --chunk-index=PRIMARY --no-version-check --execute
      Found 1 slaves:
      oath2 -> oath2.lxd:socket
      Will check slave lag on:
      oath2 -> oath2.lxd:socket
      Operation, tries, wait:
       analyze_table, 10, 1
       copy_rows, 10, 0.25
       create_triggers, 10, 1
       drop_triggers, 10, 1
       swap_tables, 10, 1
       update_foreign_keys, 10, 1
      Altering `test`.`sbtest1`...
      Creating new table...
      Created new table test._sbtest1_new OK.
      Altering new table...
      Altered `test`.`_sbtest1_new` OK.
      2020-01-25T02:09:21 Creating triggers...
      2020-01-25T02:09:21 Created triggers OK.
      2020-01-25T02:09:21 Copying approximately 961055 rows...
      Copying `test`.`sbtest1`: 78% 00:08 remain
      2020-01-25T02:10:01 Copied rows OK.
      2020-01-25T02:10:01 Analyzing new table...
      2020-01-25T02:10:01 Swapping tables...
      2020-01-25T02:10:02 Swapped original and new tables OK.
      2020-01-25T02:10:02 Dropping old table...
      2020-01-25T02:10:02 Dropped old table `test`.`_sbtest1_old` OK.
      2020-01-25T02:10:02 Dropping triggers...
      2020-01-25T02:10:02 Dropped triggers OK.
      Successfully altered `test`.`sbtest1`.


        Issue Links



              sveta.smirnova Sveta Smirnova
              jericho.rivera Jericho Rivera (Inactive)
              1 Vote for this issue
              3 Start watching this issue



                Smart Checklist