MySQL Bugs: #42565: ndb_cache_trans failure since SERVER_STATUS_IN

Bug #42565	ndb_cache_trans failure since SERVER_STATUS_IN_TRANS added to hash key
Submitted:	3 Feb 2009 11:40	Modified:	29 Apr 2021 15:51
Reporter:	Magnus Blåudd	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	autocommit, disabled, ndb, query cache

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When merging down MySQL Server 5.1.32 the ndb_cache_trans.test shows that queries being part of a transaction is not always retrieved from the cache like they previously was.

This is caused by BUG#36326 that adds two additional bits in the hash key, containing the servers status bits SERVER_STATUS_IN_TRANS and SERVER_STATUS_AUTOCOMMIT. This makes it only possible to retrieve a query that was cached with exactly the same bits set.

How to repeat:
ndb_cache_trans in 6.2-merge

See also bug#42197

Closing since query cache was removed in 8.0