Re: Error: Can't create a new thread (errno 12)
You should decrease your max_connections value On Sat, Mar 29, 2008 at 11:15 AM, jfuentes [EMAIL PROTECTED] wrote: Hi Last days frequently I see an 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. mysql is 5.0.41 server RAm: 2Gb and 100 Gb free spaces hard disk users around 64 Into my.ini the max_connection parameter is 2048. what could be happened? and what to solve this ? Jaime Fuentes R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Error: Can't create a new thread (errno 12)
Hi Last days frequently I see an 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. mysql is 5.0.41 server RAm: 2Gb and 100 Gb free spaces hard disk users around 64 Into my.ini the max_connection parameter is 2048. what could be happened? and what to solve this ? Jaime Fuentes R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error: 'Can't create a new thread (errno 12).
Hello. [EMAIL PROTECTED] gleb]$ perror 12 OS error code 12: Cannot allocate memory Very often it is ulimits problem. Check if your server has enough memory as well. The cause of problem sometime might be unofficial binaries. If nothing helps, switch to binaries from MySQL AB. [EMAIL PROTECTED] wrote: Hello everyone, I have seen this message crop up recently when connections are denied: mysqladmin: connect to server at 'localhost' failed error: 'Can't create a new thread (errno 12). If you are not out of available me mory, you can consult the manual for a possible OS-dependent bug' Unfortuantely, I haven't been able to find anything in the manual relating to this or an OS bug. The server is running Debian 3.1, mysql 4.0.23, with kernel 2.6.7. I have the results of status and extended-status around the time of the outages: /var/log/apache# mysqladmin status Uptime: 63863 Threads: 14 Questions: 14224034 Slow queries: 8 Opens: 675 Fl ush tables: 1 Open tables: 64 Queries per second avg: 222.727 /var/log/apache# mysqladmin status mysqladmin: connect to server at 'localhost' failed error: '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' /var/log/apache# mysqladmin status Uptime: 64007 Threads: 10 Questions: 14261583 Slow queries: 8 Opens: 675 Flush tables: 1 Open tables: 64 Queries per second avg: 222.813 /var/log/apache# mysqladmin extended-status +--++ | Variable_name| Value | +--++ | Aborted_clients | 23226 | | Aborted_connects | 28087 | | Bytes_received | 1193761149 | | Bytes_sent | 3902943211 | | Com_admin_commands | 2 | | Com_alter_table | 1 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin| 0 | | Com_change_db| 484513 | | Com_change_master| 0 | | Com_check| 73 | | Com_commit | 0 | | Com_create_db| 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 1 | | Com_delete | 826135 | | Com_delete_multi | 0 | | Com_drop_db | 0 | | Com_drop_function| 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_flush| 0 | | Com_grant| 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_insert | 60970 | | Com_insert_select| 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table| 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_purge| 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 21 | | Com_replace_select | 0 | | Com_reset| 0 | | Com_restore_table| 0 | | Com_revoke | 0 | | Com_rollback | 0 | | Com_savepoint| 0 | | Com_select | 5946078| | Com_set_option | 4 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_create | 0 | | Com_show_databases | 2 | | Com_show_fields | 4 | | Com_show_grants | 0 | | Com_show_keys| 27 | | Com_show_logs| 0 | | Com_show_master_status | 0 | | Com_show_new_master | 0 | | Com_show_open_tables | 0 | | Com_show_processlist | 203| | Com_show_slave_hosts | 0 | | Com_show_slave_status| 0 | | Com_show_status | 11 | | Com_show_innodb_status | 0 | | Com_show_tables | 14 | | Com_show_variables | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables| 0 | | Com_update | 275842 | | Connections | 687129 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 0 | | Created_tmp_files| 0
Re: error: 'Can't create a new thread (errno 12).
On Mon, Jul 18, 2005 at 10:33:49AM +0300, Gleb Paharenko wrote: [EMAIL PROTECTED] gleb]$ perror 12 OS error code 12: Cannot allocate memory Very often it is ulimits problem. Check if your server has enough memory as well. The cause of problem sometime might be unofficial binaries. If nothing helps, switch to binaries from MySQL AB. Yea, at first I thought it was an out-of-memory condition, and so I did typical things like lower maximum connections. This helped, but the machine is no longer running out of memory. Or if it is, it's running out of memory without displaying any symptoms of it (nothing is OOM killed by the kernel, other processes don't fail, free reports allocatable memory, etc). I just wanted to see what the OS-dependent bug thing is about - it sounds like it is referring to a particular bug that is described in the manual. I haven't tried MySQL AB binaries - I am using the stock Debian builds. Since it refers to general errors, I may persue it with them as well. Thanks! -- Ross Vandegrift [EMAIL PROTECTED] The good Christian should beware of mathematicians, and all those who make empty prophecies. The danger already exists that the mathematicians have made a covenant with the devil to darken the spirit and to confine man in the bonds of Hell. --St. Augustine, De Genesi ad Litteram, Book II, xviii, 37 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error: 'Can't create a new thread (errno 12).
Hello everyone, I have seen this message crop up recently when connections are denied: mysqladmin: connect to server at 'localhost' failed error: 'Can't create a new thread (errno 12). If you are not out of available me mory, you can consult the manual for a possible OS-dependent bug' Unfortuantely, I haven't been able to find anything in the manual relating to this or an OS bug. The server is running Debian 3.1, mysql 4.0.23, with kernel 2.6.7. I have the results of status and extended-status around the time of the outages: /var/log/apache# mysqladmin status Uptime: 63863 Threads: 14 Questions: 14224034 Slow queries: 8 Opens: 675 Fl ush tables: 1 Open tables: 64 Queries per second avg: 222.727 /var/log/apache# mysqladmin status mysqladmin: connect to server at 'localhost' failed error: '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' /var/log/apache# mysqladmin status Uptime: 64007 Threads: 10 Questions: 14261583 Slow queries: 8 Opens: 675 Flush tables: 1 Open tables: 64 Queries per second avg: 222.813 /var/log/apache# mysqladmin extended-status +--++ | Variable_name| Value | +--++ | Aborted_clients | 23226 | | Aborted_connects | 28087 | | Bytes_received | 1193761149 | | Bytes_sent | 3902943211 | | Com_admin_commands | 2 | | Com_alter_table | 1 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin| 0 | | Com_change_db| 484513 | | Com_change_master| 0 | | Com_check| 73 | | Com_commit | 0 | | Com_create_db| 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 1 | | Com_delete | 826135 | | Com_delete_multi | 0 | | Com_drop_db | 0 | | Com_drop_function| 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_flush| 0 | | Com_grant| 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_insert | 60970 | | Com_insert_select| 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table| 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_purge| 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 21 | | Com_replace_select | 0 | | Com_reset| 0 | | Com_restore_table| 0 | | Com_revoke | 0 | | Com_rollback | 0 | | Com_savepoint| 0 | | Com_select | 5946078| | Com_set_option | 4 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_create | 0 | | Com_show_databases | 2 | | Com_show_fields | 4 | | Com_show_grants | 0 | | Com_show_keys| 27 | | Com_show_logs| 0 | | Com_show_master_status | 0 | | Com_show_new_master | 0 | | Com_show_open_tables | 0 | | Com_show_processlist | 203| | Com_show_slave_hosts | 0 | | Com_show_slave_status| 0 | | Com_show_status | 11 | | Com_show_innodb_status | 0 | | Com_show_tables | 14 | | Com_show_variables | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables| 0 | | Com_update | 275842 | | Connections | 687129 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 0 | | Created_tmp_files| 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_commit | 0 | | Handler_delete | 4455 | | Handler_read_first | 797| | Handler_read_key | 6067818| | Handler_read_next| 1286221638 | | Handler_read_prev| 1193582| | Handler_read_rnd | 5116834| | Handler_read_rnd_next| 3844277714 | | Handler_rollback | 0
