Emergency

pt-archiver - Character set mismatch

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-archiver - Character set mismatch

    I am using pt-archiver 3.0.8 (3.0.8-1.stretch) on Debian 9 "Stretch" with mariaDB (10.1.26-0+deb9u1). When using this command:

    pt-archiver --source h=dbserver.example.local,D=fabitest,t=test --dest h=dbarchiveserver.example.local,D=fabitestarchive, t=test --where 'headerid IN (SELECT id FROM test WHERE (state="ENDED" OR state="ERROR") AND time< DATE_SUB('"2018-04-16 09:31:06"', INTERVAL '40' DAY))' --user archiver --password superpassword --skip-foreign-key-checks --ignore --no-version-check

    I am running in the following issue:

    Character set mismatch: --source DSN uses utf8mb4, table uses latin1. You can disable this check by specifying --no-check-charset.

    The character set seems the same on source and destination.
    dbserver.example.local
    MariaDB [information_schema]> select * from information_schema.schemata;
    +--------------+--------------------+----------------------------+------------------------+----------+
    | CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH |
    +--------------+--------------------+----------------------------+------------------------+----------+
    | def | fabitest | latin1 | latin1_swedish_ci | NULL |
    | def | information_schema | utf8 | utf8_general_ci | NULL |
    | def | mysql | utf8mb4 | utf8mb4_general_ci | NULL |
    | def | performance_schema | utf8 | utf8_general_ci | NULL |
    +--------------+--------------------+----------------------------+------------------------+----------+


    dbarchiveserver.example.local:
    MariaDB [information_schema]> select * from information_schema.schemata;
    +--------------+--------------------+----------------------------+------------------------+----------+
    | CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH |
    +--------------+--------------------+----------------------------+------------------------+----------+
    | def | fabitestarchive | latin1 | latin1_swedish_ci | NULL |
    | def | information_schema | utf8 | utf8_general_ci | NULL |
    | def | mysql | utf8mb4 | utf8mb4_general_ci | NULL |
    | def | performance_schema | utf8 | utf8_general_ci | NULL |
    +--------------+--------------------+----------------------------+------------------------+----------+


    Can somebody explain how pt-archiver checks the character set?
    I used pt-archiver on Debian 8 but with mysql. After upgrading my script isn't working anymore.

    Thanks
Working...
X