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: in rails and mysql environment in linux

[sathish kumar]

Hi All,

Yesterday I was facing the problem with Mysql, It throws an error in every rails request, 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.

Environment: Linux, Mysql and Ruby On Rails.

And I looked at mysql error log file also, it logged following errors: (it has lot of entries with different bytes specified)

090925 20:50:53 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 1048583 bytes)
090925 22:09:52 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 132176 bytes)

After restarting the Mysql:

090926 9:00:06 InnoDB: Started; log sequence number 0 510555941
090926 9:00:06 [Warning] 'user' entry '[e-mail]' ignored in --skip-name-resolve mode.
Also it thrown some error for memory allocation for innodb
Version: '5.0.67-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
090925 20:56:08 [ERROR] /usr/sbin/mysqld: Table './openx/ox_data_bkt_r' is marked as crashed and should be repaired
090925 20:56:08 [Warning] Checking table: './openx/ox_data_bkt_r'
090925 20:56:09 [ERROR] /usr/sbin/mysqld: Table './openx/ox_data_bkt_m' is marked as crashed and should be repaired
090925 20:56:09 [Warning] Checking table: './openx/ox_data_bkt_m'
090925 20:59:28 InnoDB: Error: cannot allocate 278528 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 17863656 bytes. Operating system errno: 12
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...

for the time being, I have reduced my connect_timeout, wait_timeout and interactive_timeout as 10,30 and 120 respectively.

When the connection thread count grows more than 90. it starts throws an error, also when the thread count decreases, no error.

awaiting for suggestions,

Thanks in Advance,



Edited 1 time(s). Last edit at 09/28/2009 01:14AM by sathish kumar.