Pt-table-checksum causing error 4164

Polyglot Projects Percona Toolkit
1

Hi all,

I’m running into some sort of strange issue when running pt-table-checksum. For all checksum queries it is spitting out an error as below…

03-21T14:08:48 Error checksumming table InstantService.High: Error executing checksum query: Checksum query for table InstantService.High caused MySQL error 4164:
    Level: Warning
     Code: 4164
  Message: Immediately starting the version comment after the version number is deprecated and may change behavior in a future release. Please insert a white-space character after the version number.
    Query: REPLACE INTO `percona`.`checksums` (db, tbl, chunk, chunk_index, lower_boundary, upper_boundary, this_cnt, this_crc) SELECT /*!99997*/ ?, ?, ?, ?, ?, ?, COUNT(*) AS cnt, COALESCE(LOWER(CONV(BIT_XOR(CAST(CRC32(CONCAT_WS('#', CRC32(`engineconfig_id`), convert(`prize` using utf8mb4))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `InstantService`.`High` /*checksum table*/

Toolkit version is percona-toolkit-3.5.7-1.el8.x86_64
Server version is percona-xtradb-cluster-8.0.35-27.1.el8.x86_64

It is saying it is a Warning level, but I am not sure if the checksum actually still being done?

Many thanks
Jason

2

Hello Jason_Stratford,
As per MySQL documentation, this kind of change implemented after 8.0.34

https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html
Error number: 4164; Symbol: ER_WARN_NO_SPACE_VERSION_COMMENT; SQLSTATE: HY000

Message: Immediately starting the version comment after the version number is deprecated and may change behavior in a future release. Please insert a white-space character after the version number.

ER_WARN_NO_SPACE_VERSION_COMMENT was added in 8.0.34.

For example, if your SQL statement includes a version comment like this:

/*!50505 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;

You should modify it to include a white-space character after the version number, like this:

/*! 50505 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;

Warning messages should not cause issues with pt-table-checksum execution, so I expect that your pt-table-checksum is completed well.

Regards,
Denis Subbota.
Managed Services, Percona.