Bug 1678662 - MariaDB TABLE CHECKSUM calculation sometimes ignore columns
Summary: MariaDB TABLE CHECKSUM calculation sometimes ignore columns
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Linux 7
Classification: Red Hat
Component: mariadb
Version: 7.6
Hardware: x86_64
OS: Linux
unspecified
medium
Target Milestone: rc
: ---
Assignee: Michal Schorm
QA Contact: Anna Khaitovich
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2019-02-19 10:47 UTC by sdarade
Modified: 2019-08-06 13:18 UTC (History)
5 users (show)

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.
Clone Of:
Environment:
Last Closed: 2019-08-06 13:18:16 UTC
Target Upstream Version:


Attachments (Terms of Use)


Links
System ID Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2019:2327 None None None 2019-08-06 13:18:44 UTC

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


Note You need to log in before you can comment on or make changes to this bug.