| Bug #25332 | "out of memory" errors | ||
|---|---|---|---|
| Submitted: | 29 Dec 2006 16:22 | Modified: | 20 Mar 2007 15:49 |
| Reporter: | Jeff C | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | mysql-5.0.32-nightly-20061215 | OS: | Linux (RHEL) |
| Assigned to: | CPU Architecture: | Any | |
[30 Dec 2006 15:08]
MySQL Verification Team
Jeff, Valeriy, I tried to reproduce the problem using attached script, but couldn't. Any pointers on what to change?
Attachment: bug25332.txt (text/plain), 839 bytes.
[30 Dec 2006 15:16]
Valeriy Kravchuk
Jeff, Please, check Shane's test case uploaded as a file to this report. Do you see any difference with your case?
[31 Jan 2007 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[21 Mar 2007 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: I think I've found the root cause of "Out of memory; check if mysqld or some other process uses all available memory;". For me, a table with enum's with triggers and a status warning printed out "column has been truncated" generated these errors repeatedly. Fix: remove enum's and no more out of memory errors. Even with triggers+warnings printing that the column has been truncated. For the record... I'm not out of memory at all. :) No test case... How to repeat: create a table with enum's and triggers updating another table. Inside the trigger I do: insert ... othertable ... on duplicate keys update othertable.whatever = values(enumcol), othertable.another = values(anothercol)... No specific test case, so not much to go on but it definitely is giving me "out of memory" errors and it does not sig11.