Bug 784407

Summary: MySQL 5.1 thread stack overrun error
Product: OKD Reporter: Nam Duong <nduong>
Component: PodAssignee: Rob Millner <rmillner>
Status: CLOSED CURRENTRELEASE QA Contact: libra bugs <libra-bugs>
Severity: high Docs Contact:
Priority: high    
Version: 2.xCC: jofernan, mfisher, mshao, rmillner
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: rhc-cartridge-mysql-5.1-0.19.3-1+ Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-02-02 23:55:41 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Nam Duong 2012-01-24 19:39:29 UTC 
Description of problem:
Reported by user in forum:

https://www.redhat.com/openshift/community/forums/express/thread-stack-overrun-error-in-mysql

The user is getting this error:
#1436 - Thread stack overrun: 11904 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

My query is: SELECT * FROM (`ext_ppl_view`) WHERE `item_status` NOT IN (0, 1, 3).


Thanks to Ram for debugging.  Turns out our default thread_stack may be too low for 64-bit env.  Should be 256K rather than 128K
Comment 1 Rob Millner 2012-01-30 08:12:09 UTC 
Ram fixed in commit 9d1a6dd5.
Comment 2 Attila Nagy 2012-01-30 09:46:28 UTC 
Verified on ami-b7fe2fde
The bug is fixed
Comment 3 Mrunal Patel 2012-02-02 23:55:41 UTC 
Closing verified bugs.