Details
-
Bug
-
Status: Done
-
High
-
Resolution: Fixed
-
None
-
None
-
Yes
-
No
-
Yes
-
2
Description
pt-upgrade fails with the below error when testing the upgrade between 5.7.33-0ubuntu0.16.04.1-log and 8.0.15.
Error reporting query class E8EBF188B9D272C8: Wide character in print at /usr/bin/pt-upgrade line 6217, <> line 1.
I have attached the below for reproducing the same.
table_dump.sql [Table dump with test data]
testquery_mytest [Query to test]
testquery_mytest.err C[Error details]
Command used:
pt-upgrade h=<IP mysql57>,u=percona,p=*** h=<IP mysql8>,u=percona,p=**** --max-examples=1 testquery_mytest 1> testquery_mytest.out 2> testquery_mytest.err
Mysql Versions:
mysql> select version(); +-----------------------------+ | version() | +-----------------------------+ | 5.7.33-0ubuntu0.16.04.1-log | +-----------------------------+ 1 row in set (0.00 sec) mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.15 | +-----------+ 1 row in set (0.00 sec)
MySQL 57:
mysql> select * from mytest;
+-----+----------------------------------------------------------+------+------+---------------------+------+------+
| id | pos | col1 | col2 | col3 | col4 | col5 |
+-----+----------------------------------------------------------+------+------+---------------------+------+------+
| 234 | Mytestdata Adafdsfdsftor – Ikkjss Emuuyy & Rlkkj Diuh. | 0 | 0 | 0000-00-00 00:00:00 | A | O |
+-----+----------------------------------------------------------+------+------+---------------------+------+------+
1 row in set (0.00 sec)
mysql> pager md5sum
PAGER set to 'md5sum'
mysql> select * from mytest;
c6f78a42ff1e24c9c1db71bf26926c16 -
1 row in set (0.00 sec)
MySQL8:
mysql> select * from mytest; +-----+----------------------------------------------------------+------+------+---------------------+------+------+ | id | pos | col1 | col2 | col3 | col4 | col5 | +-----+----------------------------------------------------------+------+------+---------------------+------+------+ | 234 | Mytestdata Adafdsfdsftor – Ikkjss Emuuyy & Rlkkj Diuh. | 0 | 0 | 0000-00-00 00:00:00 | A | O | +-----+----------------------------------------------------------+------+------+---------------------+------+------+ 1 row in set (0.00 sec) mysql> select * from mytest; c6f78a42ff1e24c9c1db71bf26926c16 - 1 row in set (0.00 sec)