Got an error I had not seen before...

Lee Sharp · Post by **Lee Sharp** » Thu Jan 24, 2008 6:19 am

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!

Post by **cordel** » Thu Jan 24, 2008 6:38 am

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

Lee Sharp · Post by **Lee Sharp** » Sat Jan 26, 2008 5:15 pm

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...

Lee Sharp · Post by **Lee Sharp** » Wed Feb 27, 2008 8:49 pm

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.

Beofres · Post by **Beofres** » Wed Feb 27, 2008 11:08 pm

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..