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

**URL:** <https://forums.percona.com/t/error-in-server-handshake-at-usr-bin-pt-online-schema-change-line-2345/15585>\
**Category:** Percona Toolkit\
**Tags:** mysql, percona\
**Created:** [May 6, 2022, 1:41pm UTC](https://forums.percona.com/t/error-in-server-handshake-at-usr-bin-pt-online-schema-change-line-2345/15585 "2022-05-06T13:41:45Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alex\_B1](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/alex_b1/32/5518_2.png) [@Alex\_B1](https://forums.percona.com/u/Alex_B1)\
**Post date:** [May 6, 2022, 1:41pm UTC](https://forums.percona.com/t/error-in-server-handshake-at-usr-bin-pt-online-schema-change-line-2345/15585/1 "2022-05-06T13:41:45Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [May 6, 2022, 2:36pm UTC](https://forums.percona.com/t/error-in-server-handshake-at-usr-bin-pt-online-schema-change-line-2345/15585/2 "2022-05-06T14:36:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Alex\_B1](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/alex_b1/32/5518_2.png) [@Alex\_B1](https://forums.percona.com/u/Alex_B1)\
**Post date:** [May 6, 2022, 5:55pm UTC](https://forums.percona.com/t/error-in-server-handshake-at-usr-bin-pt-online-schema-change-line-2345/15585/3 "2022-05-06T17:55:16Z")

</div>

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

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

```

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [May 7, 2022, 1:16am UTC](https://forums.percona.com/t/error-in-server-handshake-at-usr-bin-pt-online-schema-change-line-2345/15585/4 "2022-05-07T01:16:36Z")

</div>

What about libmysqlclient?

---

<div class="post-metadata">

**Author:** ![Alex\_B1](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/alex_b1/32/5518_2.png) [@Alex\_B1](https://forums.percona.com/u/Alex_B1)\
**Post date:** [May 7, 2022, 8:28am UTC](https://forums.percona.com/t/error-in-server-handshake-at-usr-bin-pt-online-schema-change-line-2345/15585/5 "2022-05-07T08:28:09Z")

</div>

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`

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [May 11, 2022, 8:40pm UTC](https://forums.percona.com/t/error-in-server-handshake-at-usr-bin-pt-online-schema-change-line-2345/15585/6 "2022-05-11T20:40:29Z")

</div>

You probably need the `-compat` package/library as well
