pt-online-schema-change 2.1.1 crashes without InnoDB

[Guy Nir]

Hi
We have a MySQL db, without innodb(my.cnf: skip_innodb)
It seems that the pt-online-schema-change cannot handle MyISAM only dbs.

Here is the error:
# pt_online_schema_change:5012 32418 DBI::db=HASH(0x8a710e0) SHOW SESSION VARIABLES LIKE 'innodb_lock_wait_timeout'
# pt_online_schema_change:5014 32418 innodb_lock_wait_timeout on server: undef
Cannot connect to MySQL: Use of uninitialized value in numeric gt (>) at /usr/bin/pt-online-schema-change line 5015.

and of course from the mysql:

root@dc01avlogmdb-01 [(none)]> SHOW SESSION VARIABLES LIKE 'innodb_lock_wait_timeout';
Empty set (0.00 sec)

Regards,
Guy

[Baron Schwartz (baron-xaprb)]

Thank you for the bug report. Indeed, when there is no such variable, the tool probably does not behave well.

[Daniel Nichter (daniel-nichter)]

I've been able to reproduce this on 2.1 (which should also hold true for 2.0):

05-04T09:59:19 Use of uninitialized value $curr_lwt in numeric gt (>) at /Users/daniel/p/fix-ptc-innodb-bug-994010/bin/pt-table-checksum line 6018.

[MihVan (spir-sp)]

I am able to reproduce this with pt-table-checksum. Innodb engine is completely disabled in my.cnf.

$ pt-table-checksum
05-07T18:56:14 Use of uninitialized value $curr_lwt in numeric gt (>) at /usr/bin/pt-table-checksum line 6018.

SHOW SESSION VARIABLES LIKE 'innodb_lock_wait_timeout' query returns nothing in this case.

[Daniel Nichter (daniel-nichter)]

I created bug 996110 for this problem in pt-table-checksum.

[Daniel Nichter (daniel-nichter)]

I mixed up bug: I fixed pt-table-checksum here instead of in bug 996110. I'll switch the linked branches around.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-310