Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
3.1.0
-
None
-
None
-
0.1
Description
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`.
Attachments
Issue Links
- mentioned in
-
Page Loading...