Error in server handshake at /usr/bin/pt-online-schema-change line 2345

Polyglot Projects Percona Toolkit
,
1

Hello! We upgraded percona-xtradb-cluster-server from 5.7 to 8 version and after upgrade pt-online-schema-change started returning “Error in server handshake at /usr/bin/pt-online-schema-change line 2345” error.
The run command looks like this:
/usr/bin/pt-online-schema-change --alter "MODIFY reason ENUM (one, two, three, four, five, six, seven, eight, nine ) NULL DEFAULT NULL, ADD INDEX reason (reason)" - u root --alter-foreign-keys-method=drop_swap --no-check-unique-key-change --critical-load Threads_running=600 --recursion-method=none D="mydb",t="mytable" --dry-run
Please help fix this problem.

1 Like
2

Please ensure that you have also upgraded your Perl libraries and have upgraded all associated Perl/MySQL libraries. 5.7 uses older libraries while 8.0 uses newer ones. 5.7 cannot communicate with 8.0

1 Like
3

Thanks for your reply, but all packages are the latest available versions for debian stretch.
Here are the dependency versions:

perl 5.24.1-3+deb9u7
libdbi-perl 1.636-1+deb9u1
libdbd-mysql-perl 4.041-2
libterm-readkey-perl 2.37-1
libio-socket-ssl-perl 2.044-1
1 Like
4

What about libmysqlclient?

1 Like
5

It was not installed, but installing libperconaserverclient21-dev did not affect the situation in any way.
now installed:
libperconaserverclient21:amd64 1:8.0.22-13-1.stretch

1 Like
6

You probably need the -compat package/library as well

1 Like