UPDATE
it was not running on a slave - I ran it on a master
since last week
I have upgraded mysql 5.1.61 to Percona 5.5.28
Still get the same error
BTW - pt-show-grants works fine
===================================
[root@sjcstgdbm06 6.34]# pt-online-schema-change -P3306 --alter "ADD COLUMN client_create_date DATETIME NULL" --alter-foreign-keys-method=auto -uxxxx -pxxxx h=127.0.0.1,D=ye,t=backup_test_folder_2012 --nocheck-replication-filters --lock-wait-time=360 --execute
Failed to SHOW GRANTS FOR CURRENT_USER(): DBD::mysql::db selectcol_arrayref failed: [34816] syntax error: syntax error near "CURRENT_USER"
LINE: SHOW GRANTS FOR CURRENT_USER() ^ [for Statement "SHOW GRANTS FOR CURRENT_USER()"] at /usr/bin/pt-online-schema-change line 4083.
--------------
mysql Ver 14.14 Distrib 5.5.28, for Linux (x86_64) using readline 5.1
Connection id: 1248017
Current database:
Current user: dbadmin@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.28-rel29.1-log Percona Server with XtraDB (GPL), Release rel29.1, Revision 334
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 2 days 17 hours 13 min 43 sec
UPDATE
it was not running on a slave - I ran it on a master
since last week
I have upgraded mysql 5.1.61 to Percona 5.5.28
Still get the same error
BTW - pt-show-grants works fine
======= ======= ======= ======= =======
[root@sjcstgdbm06 6.34]# pt-online- schema- change -P3306 --alter "ADD COLUMN client_create_date DATETIME NULL" --alter- foreign- keys-method= auto -uxxxx -pxxxx h=127.0. 0.1,D=ye, t=backup_ test_folder_ 2012 --nocheck- replication- filters --lock- wait-time= 360 --execute
^ [for Statement "SHOW GRANTS FOR CURRENT_USER()"] at /usr/bin/ pt-online- schema- change line 4083.
Failed to SHOW GRANTS FOR CURRENT_USER(): DBD::mysql::db selectcol_arrayref failed: [34816] syntax error: syntax error near "CURRENT_USER"
LINE: SHOW GRANTS FOR CURRENT_USER()
[root@sjcstgdbm06 6.34]# pt-online- schema- change --version schema- change 2.1.9
pt-online-
--------------
mysql Ver 14.14 Distrib 5.5.28, for Linux (x86_64) using readline 5.1
Connection id: 1248017
Current database:
Current user: dbadmin@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.28-rel29.1-log Percona Server with XtraDB (GPL), Release rel29.1, Revision 334
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 2 days 17 hours 13 min 43 sec