thread_stack setting is too small
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MythExport |
Invalid
|
High
|
Unassigned | ||
mysql-dfsg-5.1 (Ubuntu) |
Fix Released
|
Medium
|
Unassigned |
Bug Description
It would seem that some internal changes on mysql from 5.0 to 5.1 would require a higher thread_stack size. The issues was noticed when trying to import a reasonably trivial sql script:
http://
Trying to import with the default setting yields:
ERROR 1436 (HY000) at line 20: Thread stack overrun: 4996 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.
This error did not happen with the same my.cnf settings in 5.0.
When the setting is set from mysql upstream default of 192K on 5.1, the error is not reproducible. Therefore, I would consider this a regression.
Changed in mysql-dfsg-5.1 (Ubuntu): | |
importance: | Undecided → Medium |
status: | New → Confirmed |
Changed in mythexport: | |
status: | New → Confirmed |
importance: | Undecided → High |
Changed in mythexport: | |
status: | Confirmed → Invalid |
This bug was fixed in the package mysql-dfsg-5.1 - 5.1.37-1ubuntu5
---------------
mysql-dfsg-5.1 (5.1.37-1ubuntu5) karmic; urgency=low
* additions/my.cnf: dev.mysql. com/doc/ refman/ 5.1/en/ server- system- variables. html
- Set thread_stack size to 192K rather than 128K. 128K is only useful on
systems with < 64M RAM and causes stack overrides with some SQL commands
See http://
for more details.
(LP: #426919)
-- Mario Limonciello <email address hidden> Wed, 07 Oct 2009 09:11:48 -0500