Bug 784407 - MySQL 5.1 thread stack overrun error
Summary: MySQL 5.1 thread stack overrun error
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: OKD
Classification: Red Hat
Component: Pod
Version: 2.x
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: Rob Millner
QA Contact: libra bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-01-24 19:39 UTC by Nam Duong
Modified: 2015-05-15 01:45 UTC (History)
4 users (show)

Fixed In Version: rhc-cartridge-mysql-5.1-0.19.3-1+
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-02-02 23:55:41 UTC
Target Upstream Version:

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

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.
Note You need to log in before you can comment on or make changes to this bug.