MySQL Bugs: #28362: Bug 26881 regarding error using large MERGE tables still present in 5.0.41

Bug #28362	Bug 26881 regarding error using large MERGE tables still present in 5.0.41
Submitted:	10 May 2007 18:22	Modified:	15 May 2007 8:09
Reporter:	Brett Richardson	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Merge storage engine	Severity:	S2 (Serious)
Version:	5.0.41	OS:	Linux (SUSE SLES 9)
Assigned to:	Sveta Smirnova	CPU Architecture:	Any

Description:
This bug simply still exists in the newest release of MySQL Community Edition.  We have some large MERGE tables that receive the error stated in the prev bug report whenever they are read or written to.  We have rebuilt the MERGE tables many times with the same results.  The error occurs when running mysql_upgrade also.  Had to revert to 5.0.27 again.

How to repeat:
See bug id 26881

Suggested fix:
see bug id 26881

Thank you for the report.

I can not repeat with generic Linux binaries. Please indicate which package you use.

I believe your asking for this:

mysql-5.0.41-linux-s390x.tar.gz

downloaded from section Linux (Non-RPM packages) downloads, listed as:

Linux (S/390X).

Thank you for the feedback.

I can not repeat bug with indicated binaries and test case from bug #26881. Please confirm or reject you use same test case. If you use different sequesnce of actions, please, provide it.

I am very sorry.  This error is general to many different MERGE problems and I was led to believe it may still be the previous bug referred to.  The issue was caused by several tables included in the large merge table mentioned having indexes out-of-order from the other tables. I did not think this was an issue as it did not cause any errors in 5.0.26.  I have remedied the indexes in the tables and the MERGE tables work great in 5.0.41 now.  I have no issues to report, this bug report may be deleted.

Thank you for the feedback.

According to your last sentence, I'll close the report as "Can't repeat"