thread_stack setting is too small

Bug #426919 reported by Dave Walker on 2009-09-09
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
MythExport
High
Unassigned
mysql-dfsg-5.1 (Ubuntu)
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://bazaar.launchpad.net/~mythbuntu/mythexport/trunk/annotate/head%3A/usr/share/mythtv/mythexport.sql

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.

Mathias Gug (mathiaz) on 2009-09-09
Changed in mysql-dfsg-5.1 (Ubuntu):
importance: Undecided → Medium
status: New → Confirmed
rhpot1991 (rhpot1991) on 2009-10-07
Changed in mythexport:
status: New → Confirmed
importance: Undecided → High
Launchpad Janitor (janitor) wrote :

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:
    - 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://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html
      for more details.
      (LP: #426919)

 -- Mario Limonciello <email address hidden> Wed, 07 Oct 2009 09:11:48 -0500

Changed in mysql-dfsg-5.1 (Ubuntu):
status: Confirmed → Fix Released
Changed in mythexport:
status: Confirmed → Invalid
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers