MySQL Bugs: #36292: Can't create a new thread (errno 12); if you are not out of available memory

Bug #36292	Can't create a new thread (errno 12); if you are not out of available memory
Submitted:	23 Apr 2008 14:16	Modified:	25 Apr 2008 16:37
Reporter:	Waled Eissa	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S1 (Critical)
Version:	5.0.41-community-nt	OS:	Windows (Windows XP SP2)
Assigned to:		CPU Architecture:	Any
Tags:	innodb

Description:
I created an application for testing the performance of the MyISAM engine vs the performance of the InnoDB engine (mainly to decide which to use for my website), so, I created an application that creates 100 threads with each thread inserting 1000 rows in some table in my database. I ran the application with the MyISAM engine with no problems (i.e. created a table with engine=MyISAM in the table definition), now when I ran the same test using an InnoDB table, I got this error message:
Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

I have no problems with the memory, I checked the task manager while the application was running and there seemed to be plenty of available memory so that's not really the problem.

More details:
- I'm using MySQL .NET Connector v5.1.4 in a .NET console application written in C# (.NET Framework 2.0)
- I didn't make any manual changes to the configuration file, my.ini, on my computer, I just used the MySQL Server Instance Config Wizard (and selected all the options that give higher performance, didn't change the default values though)

How to repeat:
Create an application that runs 100 threads that insert rows in an InnoDB table.

Thank you for a problem report. Please, try to repeat with a newer version, 5.0.51a, and inform about the results.

Thanks Valeriy, that solved the problem.

Thank you for the feedback. Closing according your last comment.