Comment 5 for bug 1136834

Revision history for this message
yvonne (mysql-girl) wrote :

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.

[root@sjcstgdbm06 6.34]# pt-online-schema-change --version
pt-online-schema-change 2.1.9

--------------
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