mysql thread_stack parameter too low, causing usage problems.

Check that your MySQL is up to date then try to reinstall. This looks very much like a MySQL issue I saw pre 10.04 release.

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1799
Server version: 5.1.41-3ubuntu12.6 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Opening a task against mysql, as the thread_stack param was originally set to 128K and was raised to 192K which seemed to resolve the issue. However, it seems from the bug report that this is not the case. I feel it should be raised to 256K, but would like to gauge some thoughts before uploading this to maverick.

What's the default thread_stack option in the upstream code?

Seems kind of odd that its been this long since release and only one user has hit this, so our original solution of bumping from 128k to 192k as recommended by upstream seems to have worked for most users.

Moved value from 196 to 256 restarted mysql did not restart mythtv backend and still did not install.

installArchives() failed: Preconfiguring packages ...

Preconfiguring packages ...

Selecting previously deselected package mythexport.

(Reading database ...
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 150421 files and directories currently installed.)

Unpacking mythexport (from .../mythexport_2.1.5-0ubuntu1_i386.deb) ...

Processing triggers for man-db ...

Processing triggers for ureadahead ...

Setting up mythexport (2.1.5-0ubuntu1) ...

ERROR 1436 (HY000) at line 19: Thread stack overrun: 5012 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

dpkg: error processing mythexport (--configure):

 subprocess installed post-installation script returned error exit status 1

Errors were encountered while processing:

 mythexport

Setting up mythexport (2.1.5-0ubuntu1) ...

ERROR 1436 (HY000) at line 19: Thread stack overrun: 5012 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

dpkg: error processing mythexport (--configure):

 subprocess installed post-installation script returned error exit status 1

Is this still an issue?

Hey kate,
I haven't had a chance to try it again... I will be able to test on
Sunday...
Thanks

Sent from my Droid....
On Oct 21, 2010 12:46 PM, "Kate Stewart" <email address hidden> wrote:
> Is this still an issue?
>
> ** Also affects: mysql-dfsg-5.1 (Ubuntu Natty)
> Importance: Low
> Assignee: Dave Walker (davewalker)
> Status: Incomplete
>
> ** Also affects: mythexport (Ubuntu Natty)
> Importance: Undecided
> Status: Incomplete
>
> ** Changed in: mysql-dfsg-5.1 (Ubuntu Natty)
> Milestone: ubuntu-10.10 => None
>
> ** Changed in: mysql-dfsg-5.1 (Ubuntu Natty)
> Status: Incomplete => Opinion
>
> --
> mysql thread_stack parameter too low, causing usage problems.
> https://bugs.launchpad.net/bugs/633725
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.1” package in Ubuntu: Opinion
> Status in “mythexport” package in Ubuntu: Incomplete
> Status in “mysql-dfsg-5.1” source package in Natty: Opinion
> Status in “mythexport” source package in Natty: Incomplete
>
> Bug description:
> Binary package hint: mythexport
>
> I had selected the mythexport from the control centre for mythbuntu, it
got about 98% complete then crashed. Any other details that you need?
>
> thanks
> Rob Larson
>
> ProblemType: Package
> DistroRelease: Ubuntu 10.04
> Package: mythexport 2.1.5-0ubuntu1
> ProcVersionSignature: Ubuntu 2.6.32-24.41-generic 2.6.32.15+drm33.5
> Uname: Linux 2.6.32-24-generic i686
> Architecture: i386
> Date: Wed Sep 8 22:05:49 2010
> ErrorMessage: subprocess installed post-installation script returned error
exit status 1
> InstallationMedia: Mythbuntu 9.10 "Karmic Koala" - Release i386
(20091028.4)
> SourcePackage: mythexport
> Title: package mythexport 2.1.5-0ubuntu1 failed to install/upgrade:
subprocess installed post-installation script returned error exit status 1
>
> To unsubscribe from this bug, go to:
>
https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/633725/+subscribe

On 10/21/2010 12:39 PM, Kate Stewart wrote:
> Is this still an issue?
>
> ** Also affects: mysql-dfsg-5.1 (Ubuntu Natty)
> Importance: Low
> Assignee: Dave Walker (davewalker)
> Status: Incomplete
>
> ** Also affects: mythexport (Ubuntu Natty)
> Importance: Undecided
> Status: Incomplete
>
> ** Changed in: mysql-dfsg-5.1 (Ubuntu Natty)
> Milestone: ubuntu-10.10 => None
>
> ** Changed in: mysql-dfsg-5.1 (Ubuntu Natty)
> Status: Incomplete => Opinion
>
>
Yes, I just tried again and it crashed again.

Installing new version of config file /etc/cron.daily/mythexport ...
ERROR 1436 (HY000) at line 21: Thread stack overrun: 5012 bytes used of
a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O
thread_stack=#' to specify a bigger stack.
dpkg: error processing mythexport (--configure):
 subprocess installed post-installation script returned error exit status 1
E: Sub-process /usr/bin/dpkg returned an error code (1)
rob@dell:~$

Anything else that I should add to this? Do we need any logs,etc?

Setting up mythexport (2.2.3-0ubuntu1~ppa2) ...
ERROR 1436 (HY000) at line 21: Thread stack overrun: 5012 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.
dpkg: error processing mythexport (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 mythexport
E: Sub-process /usr/bin/dpkg returned an error code (1)
rob@dell:~$

Just wondering what else I should do. This is still occurring.

any update on this?

Hmm,

I have blown this system away.

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Rob Larson
Sent: Saturday, February 12, 2011 8:44 PM
To: <email address hidden>
Subject: [Bug 633725] Re: mysql thread_stack parameter too low, causing usage problems.

any update on this?

--
You received this bug notification because you are a direct subscriber
of a duplicate bug (713248).
https://bugs.launchpad.net/bugs/633725

Title:
  mysql thread_stack parameter too low, causing usage problems.

Status in “mysql-dfsg-5.1” package in Ubuntu:
  Opinion
Status in “mythexport” package in Ubuntu:
  Incomplete
Status in “mysql-dfsg-5.1” source package in Natty:
  Opinion
Status in “mythexport” source package in Natty:
  Incomplete

Bug description:
  Binary package hint: mythexport

  I had selected the mythexport from the control centre for mythbuntu,
  it got about 98% complete then crashed. Any other details that you
  need?

  thanks
  Rob Larson

  ProblemType: Package
  DistroRelease: Ubuntu 10.04
  Package: mythexport 2.1.5-0ubuntu1
  ProcVersionSignature: Ubuntu 2.6.32-24.41-generic 2.6.32.15+drm33.5
  Uname: Linux 2.6.32-24-generic i686
  Architecture: i386
  Date: Wed Sep 8 22:05:49 2010
  ErrorMessage: subprocess installed post-installation script returned error exit status 1
  InstallationMedia: Mythbuntu 9.10 "Karmic Koala" - Release i386 (20091028.4)
  SourcePackage: mythexport
  Title: package mythexport 2.1.5-0ubuntu1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

To unsubscribe from this bug, go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/633725/+subscribe

? You have blown this system away? Are you implying that I should redo the install?

You can close this. I have given up on this bug.

I pretty much gave up on this bug. You can close it. I am now running 11.10

On Mon, Feb 27, 2012 at 2:20 PM, rhpot1991 <email address hidden> wrote:
> ** Changed in: mythexport (Ubuntu)
>       Status: Incomplete => Opinion
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/633725
>
> Title:
>  mysql thread_stack parameter too low, causing usage problems.
>
> Status in “mysql-dfsg-5.1” package in Ubuntu:
>  Opinion
> Status in “mythexport” package in Ubuntu:
>  Opinion
> Status in “mysql-dfsg-5.1” source package in Natty:
>  Opinion
> Status in “mythexport” source package in Natty:
>  Incomplete
>
> Bug description:
>  Binary package hint: mythexport
>
>  I had selected the mythexport from the control centre for mythbuntu,
>  it got about 98% complete then crashed. Any other details that you
>  need?
>
>  thanks
>  Rob Larson
>
>  ProblemType: Package
>  DistroRelease: Ubuntu 10.04
>  Package: mythexport 2.1.5-0ubuntu1
>  ProcVersionSignature: Ubuntu 2.6.32-24.41-generic 2.6.32.15+drm33.5
>  Uname: Linux 2.6.32-24-generic i686
>  Architecture: i386
>  Date: Wed Sep  8 22:05:49 2010
>  ErrorMessage: subprocess installed post-installation script returned error exit status 1
>  InstallationMedia: Mythbuntu 9.10 "Karmic Koala" - Release i386 (20091028.4)
>  SourcePackage: mythexport
>  Title: package mythexport 2.1.5-0ubuntu1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/633725/+subscriptions

--
insert witty comment here

Did the issue go away when you upgraded to 11.10?

natty has seen the end of its life and is no longer receiving any updates. Marking the natty task for this ticket as "Won't Fix".