Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-2023

pt-upgrade Error: Wide character in print

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • None
    • 3.4.0
    • pt-upgrade
    • 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)

       

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            arunjith.aravindan Arunjith Aravindan
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist