Bug #37101 | Can't create a new thread (errno 12) | ||
---|---|---|---|
Submitted: | 30 May 2008 13:08 | Modified: | 19 Jul 2008 14:42 |
Reporter: | onur ozturk | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Errors | Severity: | S2 (Serious) |
Version: | 5.0.51b | OS: | Windows (server 2003 standart X64) |
Assigned to: | CPU Architecture: | Any | |
Tags: | .trg file not found, Can't create a new thread (errno 12) |
[30 May 2008 13:08]
onur ozturk
[30 May 2008 13:18]
MySQL Verification Team
Thank you for the bug report. Please try reducing to the minimum possible the table_cache=256 i.e: table_cache=32 and test again.
[30 May 2008 13:35]
onur ozturk
but i have two ini file and i dont know which one i need to configure first one or second one and what value i need to get like; table_cache=256 to table_cache=128 for first ini and table_cache=32 to table_cache=16 for secont ini can u explane more pls
[30 May 2008 13:38]
MySQL Verification Team
Change the my.ini which the server uses.
[30 May 2008 14:09]
onur ozturk
i change my.ini like below table_cache=32 #it was 256 wait_timeout=460 # there was no wait_timeout descriptin before now it seems working good and total ram usage go down from 2.2 GB to 1.8 GB and cpu usage is go a little up from %15 to %25 i ll wait and report what will happen
[30 May 2008 16:59]
onur ozturk
it solve the problem of the man error below Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MySQL][ODBC 3.51 Driver]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 but when i look at error log files and filemon i see two errors still i see in mydatabase.err ; 080530 15:44:24 [ERROR] C:\Program Files (x86)\SWsoft\Plesk\Databases\MySQL\bin\mysqld-nt.exe: Deadlock found when trying to get lock; try restarting transaction 080530 15:44:24 [ERROR] C:\Program Files (x86)\SWsoft\Plesk\Databases\MySQL\bin\mysqld-nt.exe: Sort aborted ------------------------------- i see one error in windos filemon; Request : query information path : C:\Program Files (x86)\SWsoft\Plesk\Databases\MySQL\Data\mydatabasename\mytablename.TRG Result: Not Found what that two errors mean thanks
[19 Jul 2008 14:42]
Valeriy Kravchuk
The first error message means you had a deadlock in InnoDB. They are always possible and your application should just expect them and try to repeat same actions later. The second one means some trigger on your mydatabasename.mytablename table exists but corresponding .TRG file was deleted somehow.