Page 1 of 1
Got an error I had not seen before...
Posted: Thu Jan 24, 2008 6:19 am
by Lee Sharp
I was working on a problem system that had been causing me to use "creative" language for a while. (Turned out to be a "slightly" bad stick of ram...) Any, fix it all, and make it go. Now go to hook up a client on an AMD system with the S3 Unichrome video, and got this in my montage screens.
Code: Select all
Warning: mysql_pconnect() [function.mysql-pconnect]: Too many connections in /usr/share/zoneminder/zm_db.php on line 21
Could not co
A reboot or two fixed it, but it was weird, and only on that client. Another Ubuntu system, and 2 windows systems (one with IE and one with FireFox) had no problems. It is a Core2Duo server with 2(should be 4) gig of ram, and 24 cameras... Now I am just curious. That and I want to prevent it from happening again!
Posted: Thu Jan 24, 2008 6:38 am
by cordel
Pconnect is part of the php-mysql module to open a persistant connection to the database, there by avoiding having to restart a new connection on each request of a web page. It may require some tuning in some distros by adjust max connections in apache and/or mysql.
http://us2.php.net/manual/en/features.p ... ctions.php
Posted: Sat Jan 26, 2008 5:15 pm
by Lee Sharp
The odd part was that it only happened on one client. Later I had 3 clients at once and never had the problem, but before the client reboot it would happen when it was the only thing connected... Like I said, odd...
Posted: Wed Feb 27, 2008 8:49 pm
by Lee Sharp
This came up again. Same location. No problems in all of the other locations I have ZM installed. That system has had some wierdness in other ways as well.
Posted: Wed Feb 27, 2008 11:08 pm
by Beofres
Try updating your ethernet / wifi drivers, or perhaps try using a different NIC altogether.
I had a similar problem with an integrared nic on a laptop. Would spam millions of packets and open a ton of connections randomly. Replacing the nic fixed the issue, and a few months later after a format the original nic worked fine..