mysql_connect can't create a new thread

Justin

Hi,
I am continualy receiving the following type of error in my browser
from programs using php/mysql
Warning: mysql_connect(): Can't create a new thread (errno 11). If you
are not out of available memory, you can consult the manual for a
possible OS-dependent bug in
/home/httpd/vhosts/netvantage.com.au/httpdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php
on line 318

Cannot connect to MySQL server on 'localhost'. Please make sure you
have specified a valid MySQL database name in 'include/config.php'.
This requires me to do a manual kill and restart of mysql as it won't
restart gracefully. mysqld itself does not appear to be crashed but I
am getting the above error on all sites using mysqld (eg oscommerce,
plesk controlpanel) and need to restart it to get the sites working
again.
The mysql server version is mysql-3.23.58-1.9 and php is php-4.3.4. In
mysql I have increased the max_connections to 1024.

I am also receiving the following strange error and received it about
140 time in the last 24 hours in my httpd error_log (on RedHat 9
Apache/2.0.40 )

ERROR: can't parse '#FF0000:Busy'

There are no other associated errors or strange errors in the Apache
error logs.

Does anyone have any ideas that may help?

Regards,

Justin

ju****@netvantage.com.au

www.netvantage.com.au

Jul 17 '05 #1

Subscribe Post Reply

16997

Daniel Tryba

Justin <ju**********@netvantage.com.au> wrote:

Warning: mysql_connect(): Can't create a new thread (errno 11). If you
are not out of available memory, you can consult the manual for a
possible OS-dependent bug in [...] The mysql server version is mysql-3.23.58-1.9 and php is php-4.3.4. In
mysql I have increased the max_connections to 1024.

I am also receiving the following strange error and received it about
140 time in the last 24 hours in my httpd error_log (on RedHat 9
Apache/2.0.40 )

Without looking at mysqls documentation (like the error suggests (and
which you did?))...

Increasing max connections alone is not enough. The user running the
apache/mysql must get permission to run that many processes. To find out
if there are limits you should run ulimit as that user. A typical output
of ulimit -a (debian):

core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) unlimited
virtual memory (kbytes, -v) unlimited

It limits my open files to 1024... each mysql connection/thread probably
has at least 1 file opened, but I have not limit on processes (which a
thread also counts as on linux)...

--

Daniel Tryba

Jul 17 '05 #2

by: photoelectric | last post by:

When trying to run the below script on an apache/1.3.26 with mysql and php I get the following error message: Warning: mysql_connect() : Access denied for user: 'nobody@software-ece.rutgers.edu'...

PHP

mysql_connect() used twice

by: Alvaro G Vicario | last post by:

I need that my script retrieves data from two different databases so I use mysql_connect() to open two connections. I have only one server, user and password, just two different databases....

PHP

mysql_connect Can't create new thread

by: Justin | last post by:

Hi, I am continualy receiving the following type of error in my browser from programs using php/mysql Warning: mysql_connect(): Can't create a new thread (errno 11). If you are not out of...

MySQL Database

Help: mysql_connect() doesn't seem to return resource link indentifier.

by: Sugapablo | last post by:

I have a small test script connecting to a MySQL database. It seems to work, unless I try to use the resource link identifier returned by mysql_connect(); This works and returns all the rows in...

PHP

Cannot get mysql_connect to work

by: Michael | last post by:

Hi, I'm trying to do something which should be very simple - connect to the MySQL database. Here is the call, followed by the error msg. $conn = mysql_connect("localhost", "root", ""); ...

PHP

mysql_connect error Apache Web server to Windows hosted database

by: GD | last post by:

Hi All, I've got MySQL 5.0.21 running on Windows Server 2003, and php running on Apache on a Linux box (Fedora Core 4). Previously when the pages were running on an IIS server the connection...

PHP

how to escape mysql_connect() DNS caching?

by: hugo | last post by:

Hello people, There is a problem is that mysql_connect() somehow caches last sessions IP and is not using the one which you put into host place. Has anyone made mysql_connect() from php to...

MySQL Database

Where is mysql_connect()?

by: brett | last post by:

I'm running PHP5 on Windows Vista with mysql 5.2. I have a simple php file with <? $dbc = mysql_connect (); ?> When I run the file, I get this error: Fatal error: Call to undefined...

PHP

Fatal error: Call to undefined function mysql_connect()

by: Julian Bowler | last post by:

Please can some one help with my problem; I am running Apache web server on my lap top, plus a mysql server and php. The version of php currently installed is 5.2.5. when i write some php to connect...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

mysql_connect can't create a new thread

Similar topics