thread_stack setting is too small

[Dave Walker]

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.

[Launchpad Janitor (janitor)]

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