[MDEV-28020] CHECKSUM TABLE calculates different checksums - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.5.15, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Fix Version/s: 10.7.4, 10.2.44, 10.3.35, 10.4.25, 10.5.16, 10.6.8
Component/s: Replication
Labels:
None
Environment:
linux

I have a master slave setup. And two tables calculate different checksums, while the data seems be in sync.

checksum table A, ASlave extended;

(select * from ASlave ORDER BY ID ) except (select * from A ORDER BY ID);

Empty set (2.461 sec)

(select * from A ORDER BY ID ) except (select * from ASlave ORDER BY ID);

Empty set (2.418 sec)

Any other command to check for differences in tables?

is duplicated by

MDEV-11783 Assertion `checksum_start + checksum_length == f->ptr' failed in mysql_checksum_table

relates to

MDEV-36460 Checksum Table Quick is not updated correctly

MDEV-15519 CHECKSUM TABLE gives different results across MariaDB 10.0 and 10.2

Estimated:

Not Specified

Remaining:

Logged:

1d 1h 40m

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.