I'm developing a website that uses PHP and MySQL. It has features such as users registering and logging in, and sending posts and private messages etc.
The database so far is small (a handful of test data)...

I'm running an apache2 server and mySQL on my machine to test the site.
Every now and then, seemingly unlinked to any one specific event, i get the following error (well, once i remove the error handling):

Warning: mysql_pconnect(): 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...

The error is thrown by the line which tries to connect to the database, in my standard include file

$db_conn = mysql_pconnect('localhost', 'jafwachat');

Any idea how to fix this? I don't think I'm out of membory - memturbo reports all is fine...

Server and software stats:
OS: Win98SE
PHP: 4.3.3
Apache: 2.0.47
MySQL: mysql-3.23.38

CPU: PIII 800Mhz
RAM: 384MB PC133
HDD: 1.4GB Free

Thanks,
Kefka

    Incase it helps shed some light on the problem, here's how I get around it.

    To start up the server, I run the shortcut to Start Apache in Console, which has a target of
    C:\Apache\Apache2\bin\Apache.exe -w -f "C:\Apache\Apache2\conf\httpd.conf" -d "C:\Apache\Apache2."

    To start mySQL, i run the winmysqladmin shortcut, which has a target of
    C:\mysql\bin\winmysqladmin.exe

    I then usually run MySQL-Front 2.5

    When the problem arises, i first showdown MySQL by rightclicking the traffic light in the system tray and selecting 'Shutdown both' (the trafficlight is still green to indicate the server is running...)

    I then kill the Apache console window (usually via Ctrl+C or just closing the window - half the time it crashes it anyway😛)

    Once theyre killed (and MySQL-Front too), I Ctrl-Alt-Del to make sure no instances of mysqloldapp or anything are running in the background, then i restart them all as above.
    This fixes the problem for a while ('while' is seemingly fairly random though)

    Thanks again
    Kefka

      Write a Reply...