[MDEV-10503] TokuDB logical row counts could get totally out of sync Created: 2016-08-05  Updated: 2016-11-24  Resolved: 2016-11-24

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - TokuDB
Affects Version/s: 10.1.16, 10.0
Fix Version/s: 10.1.18, 10.0.28

Type: Bug Priority: Critical
Reporter: jocelyn fournier Assignee: Unassigned
Resolution: Fixed Votes: 1
Labels: upstream


 Description   

Hi,

FYI, the latest TokuDB version included in MariaDB 10.1.16 contains a nasty bug which could lead to cardinality wrongly set to 0 for all the keys (with the impact on the execution plan you can imagine).
Detail of the bug (now fixed) upstream is here :

https://tokutek.atlassian.net/browse/DB-1006

Since it could lead to really bad issues, I wonder if you want to cherry pick the bugfix to include it in MariaDB, or just wait for the next TokuDB engine 5.6.32-77.1 release.

Thanks,
Jocelyn

 Comments   
Comment by Phil Sweeney [ 2016-08-14 ]

serg FYI (I ran into this bug with 10.1.16 as well). I see you've just done the TokuDB merge but this fix isn't yet released by Percona so hasn't made it in.

Comment by Reinis Rozitis [ 2016-08-17 ]

This seems to be fixed in the upstream now.
Would be very nice to be included asap as the result of such behaviour in some cases brings down the DB in no-time.

Comment by jocelyn fournier [ 2016-08-25 ]

Too bad MariaDB 10.0.27 has just been release with TokuDB 5.6.31-77.0 instead of 5.6.32-78.0 which contain the fix for this bug.
Do you plan to include 5.6.32-78.0 for the next MariaDB 10.1 release ?

Comment by Sergei Golubchik [ 2016-08-26 ]

Not for 10.1.17, but probably yes for 10.1.18

Comment by jocelyn fournier [ 2016-08-26 ]

Then I will have to manually compile it to avoid having this issue for another month, it sucks
Hopefully 10.1.18 will be shipped with MDEV-7258 fix at the same time...

Comment by jocelyn fournier [ 2016-11-24 ]

This one seems to be fixed now

Comment by Elena Stepanova [ 2016-11-24 ]

joce,

Thanks for update.
Closing as fixed in 10.0.28 and 10.1.18, because these are the last versions when TokuDB merge happened (5.6.33-79.0 and 5.6.32-78.1).

Generated at Thu Feb 08 07:42:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.