Bug 524453
| Summary: | option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 | ||
|---|---|---|---|
| Product: | Red Hat Enterprise Linux 5 | Reporter: | Simon Matter <simon.matter> |
| Component: | mysql | Assignee: | Tom Lane <tgl> |
| Status: | CLOSED ERRATA | QA Contact: | qe-baseos-daemons |
| Severity: | low | Docs Contact: | |
| Priority: | medium | ||
| Version: | 5.4 | CC: | byte, hhorak, jwest, redhat-bugzilla, robert.scheck, rpiddapa, spoyarek |
| Target Milestone: | rc | Keywords: | EasyFix, Patch |
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | mysql-5.0.95-1.el5_7.1 | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2012-02-14 17:21:31 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
|
Description
Simon Matter
2009-09-20 11:48:21 UTC
Hm, is there any non-cosmetic effect? OK, you may be right it's only cosmetic. The warning message doesn't show up on x86_64 because the bigger value of 'max_join_size' is allowed there. Looking at the defaults from both 5.0.45.i386 and 5.0.77.i386 show that the effective 'max_join_size' has not changed. So yes, it seems fine despite the warning message. Thanks --- the upstream report seems rather confused about whether there's any real effect beyond the warning message, so I was wondering if you'd seen anything. As things stand, I doubt we'd bother to fix this short of a version update; but if you see any worse effects please note them here. Our production box which is now running 5.0.77 on i386 seems to behave exactly the same way as it did with 5.0.45. The DB size is ~2G at an average rate of ~320 queries per second. I guess if some parameter was really wrong we should have seen it now somehow. This request was evaluated by Red Hat Product Management for inclusion in the current release of Red Hat Enterprise Linux. Because the affected component is not scheduled to be updated in the current release, Red Hat is unfortunately unable to address this request at this time. Red Hat invites you to ask your support representative to propose this request, if appropriate and relevant, in the next release of Red Hat Enterprise Linux. We are seeing the same issue, but it seems only to exist on 32 bit systems. As this issue was introduced with a MySQL update of RHEL around or before 2009-09-20, I've now cross-filed this issue as Service Request 00474460. This request was evaluated by Red Hat Product Management for inclusion in the current release of Red Hat Enterprise Linux. Because the affected component is not scheduled to be updated in the current release, Red Hat is unfortunately unable to address this request at this time. Red Hat invites you to ask your support representative to propose this request, if appropriate and relevant, in the next release of Red Hat Enterprise Linux. Candidate fix from the bz: http://lists.mysql.com/commits/79465 The upstream fix for this should be included in our recent security update: RHSA-2012:0127 https://rhn.redhat.com/errata/RHSA-2012-0127.html although this bug is not listed there since it is not a security issue. |