Bug 1678662

Summary: MariaDB TABLE CHECKSUM calculation sometimes ignore columns
Product: Red Hat Enterprise Linux 7 Reporter: sdarade <sdarade>
Component: mariadbAssignee: Michal Schorm <mschorm>
Status: CLOSED ERRATA QA Contact: Anna Khaitovich <akhaitov>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 7.6CC: akhaitov, databases-maint, hhorak, lennart.schedin, mmuzila
Target Milestone: rc   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Cause: The problem in calculating of the mask to clear unused null bits in case of using full byte. Consequence: TABLE CHECKSUM calculation sometimes ignore columns Fix: Fix calculating of the mask. Result: TABLE CHECKSUM calculation does not ignore columns any more.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2019-08-06 13:18:16 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description sdarade 2019-02-19 10:47:44 UTC 
Description of problem:

MariaDB TABLE CHECKSUM calculation sometimes ignore columns

The fix was implemented for MariaDB 5.5 in commit https://github.com/MariaDB/server/commit/1ecccb509c9dfa57976a2e2c3af07753a5356188. It was released in MariaDB 5.5.63 release.

Would it be possible to include this fix in RHEL 7.6?

Version-Release number of selected component (if applicable):

mariadb-5.5.60-1.el7_5.x86_64.rpm 

How reproducible:

I have expanded the src.rpm package "mariadb-5.5.60-1.el7_5.src.rpm"

1) download mariadb-5.5.60-1.el7_5.src.rpm
2) install it with yum install mariadb-5.5.60-1.el7_5.src.rpm
3) cd ~/rpmbuild/SPECS
4) run rpmbuild -bp --nodeps mariadb.spec
5) go to ../BUILD
6) find the file "sql_table.cc" under the directory.
7) check if the patch of https://github.com/MariaDB/server/commit/1ecccb509c9dfa57976a2e2c3af07753a5356188 is applied into the function "mysql_checksum_table".

I have checked the line "uchar null_mask=256 -  (1 << t->s->last_null_bit_pos);" exists in the file "sql_table.cc", so it's not applied.

so, filing a Bugzilla to request the backport.


Steps to Reproduce:
1.
2.
3.

Actual results:

MariaDB TABLE CHECKSUM calculation sometimes ignore columns.


Expected results:

Filing a Bugzilla to request the backport.


Additional info:

The ticket https://jira.mariadb.org/browse/MDEV-17085 and https://jira.mariadb.org/browse/MDEV-17372 deal with a problem that the TABLE CHECKSUM command in MariaDB (server) sometimes ignores/skips columns. Thus the checksum calculation sometimes is wrong.
Comment 8 errata-xmlrpc 2019-08-06 13:18:16 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2019:2327