Thread: [phpslash-users] mysql connections error
Brought to you by:
joestewart,
nhruby
From: Tigran <ti...@us...> - 2002-05-23 15:08:23
|
Hi, I need some help with an error message. ------------------- Warning: User usanogh@localhost has already more than 'max_user_connections' active connections in /home2/www/usanogh/phplib/php/db_mysql.inc on line 73 Database error: pconnect(localhost, usanogh, $Password) failed. MySQL Error: 0 () Please contact the webmaster and report the exact error message. Session halted. -------------------------- I know this has something to do with the block update time. But I set those times to a really high number. For some reason it still gives this error. I'm still running the old .62 version. Do you think an upgrade to the .65 will help? Also how do I recover from this error. Thanks |
From: Joe S. <jo...@cm...> - 2002-05-23 15:25:59
|
On Thu, May 23, 2002 at 08:10:37AM -0700, Tigran wrote: > Hi, > > I need some help with an error message. > > ------------------- > > Warning: User usanogh@localhost has already more than > 'max_user_connections' active connections in > /home2/www/usanogh/phplib/php/db_mysql.inc on line 73 > Database error: > pconnect(localhost, usanogh, $Password) failed. > > MySQL Error: 0 () > Please contact the webmaster and report the exact error message. > Session halted. > -------------------------- > If you are in a hosted environment, you might want to upgrade phplib. The new version defaults to non persistent db connections. http://www.sanisoft.com/phplib/manual/DB_SqlAddedInfo.php > I know this has something to do with the block update time. > But I set those times to a really high number. For some reason it still > gives this error. > Most of the block problems there were from php4.0.6. It had a bad memory allocation bug. The patch is small. > I'm still running the old .62 version. Do you think an upgrade to the .65 > will help? > Yes, the number of db connections per page is dramatically reduced. > Also how do I recover from this error. > Depends. Do you control the http and mysql servers? Are you getting a spike of incoming traffic? If you don't control the server processes, probably just replace the index page with a static page till the processes die off. |
From: Tigran <ti...@us...> - 2002-05-24 19:17:29
|
Thanks for the info. I upgraded both phplib and phpslash. The problem still exists but at this point I think its up to the hosting company to do something. Hosting company says I am allowed 15 simultaneous mysql connections at a time. Is this number way out of the limit of phpslash or am I ok and there is something wrong here? At 08:24 AM 5/23/2002, you wrote: >On Thu, May 23, 2002 at 08:10:37AM -0700, Tigran wrote: > > Hi, > > > > I need some help with an error message. > > > > ------------------- > > > > Warning: User usanogh@localhost has already more than > > 'max_user_connections' active connections in > > /home2/www/usanogh/phplib/php/db_mysql.inc on line 73 > > Database error: > > pconnect(localhost, usanogh, $Password) failed. > > > > MySQL Error: 0 () > > Please contact the webmaster and report the exact error message. > > Session halted. > > -------------------------- > > > >If you are in a hosted environment, you might want to upgrade phplib. The >new version defaults to non persistent db connections. > >http://www.sanisoft.com/phplib/manual/DB_SqlAddedInfo.php > > > I know this has something to do with the block update time. > > But I set those times to a really high number. For some reason it still > > gives this error. > > > >Most of the block problems there were from php4.0.6. It had a bad memory >allocation bug. The patch is small. > > > I'm still running the old .62 version. Do you think an upgrade to the .65 > > will help? > > > >Yes, the number of db connections per page is dramatically reduced. > > > Also how do I recover from this error. > > > >Depends. Do you control the http and mysql servers? > >Are you getting a spike of incoming traffic? > >If you don't control the server processes, probably just replace the index >page with a static page till the processes die off. |
From: nathan r. h. <na...@ds...> - 2002-05-24 19:32:14
|
On Fri, 24 May 2002, Tigran wrote: > Thanks for the info. > > I upgraded both phplib and phpslash. The problem still exists but at this > point I think its up to the hosting company to do something. > > Hosting company says I am allowed 15 simultaneous mysql connections at a > time. Is this number way out of the limit of phpslash or am I ok and there > is something wrong here? Eeep! 15 connections?! that's not a whole lot. Assume 3 connections per user browsing your site, a limit of 15 gives you a maximum limit of 5 concurrent users, 7-10 if they are on slow connections and are not looking at the front page. So yeah, 15 seems a little low, but if they're still running 3.22.xx then they have other issues as well I bet :) One way of fixing this is to use something like jpcache and its file based caching to lessen the load. Take a look at it. Joe might have some better ideas about how to implement it in the phpslash mainpages, but my thought would be like: - set it up for files based storage to /tmp - set all of your phpslash pages to have a lifetime of 5 minutes - chkeck to see if user is logged in ($auth->is_auth()) and if not then imprt the cache version, else jsut use the output compression. A fancier version would be to cache the page if it doesn't exsist in the cahe dir. After that check your availible MySQL conenctions and only serve out the cached paged if there are no availible connections. phpslash will so have internal hooks for this to happen transparently. Once the dust settles on the current crop of features we'll look into this a bit more. -n ------ nathan hruby na...@ds... ------ |
From: Tigran <ti...@us...> - 2002-05-25 00:43:46
|
for some reason its working fine for now. however I did encounter another problem with the 65 version. at the bottom of the page is says the following Fatal error: Call to a member function on a non-object in /home2/www/usanogh/phplib/php/page.inc on line 68 Anybody know what's causing it? Thanks |