[imp] Hi guys - DESPERATE plea for help here...

[Nigel Cass]

Interesting.

Are you storing sessions on the database server? I presume you must be if
you are running 6 webmail servers....

I have just reintroduced my second webmail server and already I have started
to see the DB errors again as below.

May 07 10:15:11 HORDE [emergency] [imp] DB Error: connect failed:
[nativecode=Link to server lost, unable to reconnect] ** Array [on line 108
of "/usr/local/apache/htdocs/horde/lib/Prefs/sql.php"]

My setup is just about identical to yours so I'm really pretty stuck now.

My first punt is to disable persistent connections on the webmail server
that needs to access the database remotely. Whilst I can see this may slow
things down somewhat at least I know that the server must always initiate a
connection.

When I originally had the problems I did find that upping connect_timeout
seemed to reduce the problem a little. But that is not my favoured solution
really.

Any more hints/help/advice would be much appreciated.

I will of course post any solutions I find to the list.

Nige.

> apache 1.3.27/php 4.3.1/mysql 3.23.54a/php_accelerator 1.3.3r2
> horde 2.2.1/imp 3.2.1/turba 1.2/kronolith 1.0/mnemo 1.1/nag 1.1
> 6 imp servers: 3 are on the same subnet as the mysql server
> everything except vfs for attachments is in mysql
> mysql settings being discussed:
> connect_timeout 5
> max_connections 600
> max_used_connections 201
> wait_timeout 28800
> php.ini settings being discussed:
> mysql.allow_persistent = On
> mysql.connect_timeout = -1
> 
> Quoting Nigel Cass <N.Cass at Hull.ac.uk>:
> 
> > No - I actually have that set way too high really - 2048 connections.
> Also
> > very unlikely to hit that when timeouts are set to 10 seconds.
> >
> > Perhaps I should be looking to completely disable persistent connections
> in
> > php.ini.....
> >
> > What is everyone else doing with RELENG horde,imp and turba accessing a
> > remote mysql database for preferences ??
> >
> > Nige.
> >
> > > -----Original Message-----
> > > From: Shawn Robinson [mailto:Shawn.Robinson at telus.com]
> > > Sent: 01 May 2003 19:59
> > > To: Nigel Cass; imp
> > > Subject: Re: [imp] Hi guys - DESPERATE plea for help here...
> > >
> > > Are you hitting your maximum_connections on your mysql?
> > >
> > > You can bump that value up in your my.cnf file.
> > >
> > >
> > > At 10:43 AM 2003/05/01 +0100, Nigel Cass wrote:
> > > >Upgraded to the latest RELENG of horde, imp and turba today. Also
> started
> > > >using the custom session handler now provided in the RELENG version.
> > > >
> > > >Intermittently (but often enough to make me look stupid :( ) we are
> > > >experiencing DB errors - resulting in horde.log errors like the
> below....
> > > >
> > > >May 01 08:45:40 HORDE [emergency] [imp] DB Error: connect failed:
> > > >[nativecode=Link to server lost, unable to reconnect] ** Array [on
> line
> > > 108
> > > >of "/usr/local/apache/htdocs/horde/lib/Prefs/sql.php"]
> > > >
> > > >I'm guessing it's because I've set connection timeout to be 10
> seconds in
> > > >mysql - Which I believe I set because I was under the impression that
> > > this
> > > >was good practice as you can never guarantee that the same apache
> daemon
> > > >will perform every operation that a user does anyway.
> > > >
> > > >Please help as I'm stuck - it FEELS like a session problem yet I'm
> seeing
> > > >the problem reported as Prefs/sql.php.
> > > >
> > > >Interesting to note is that the preferences are stored on a remote
> > > database
> > > >and the sessions are stored on a local database..
> > > >
> > > >HELP ?
> > > >
> > > >Nigel.
> > > >
> > > >
> > > >
> > > >--
> > > >IMP mailing list
> > > >Frequently Asked Questions: http://horde.org/faq/
> > > >To unsubscribe, mail: imp-unsubscribe at lists.horde.org
> > >
> >
> >
> >
> > --
> > IMP mailing list
> > Frequently Asked Questions: http://horde.org/faq/
> > To unsubscribe, mail: imp-unsubscribe at lists.horde.org
> >
> 
> 
> Charlie Reitsma
> Systems Engineer
> 
> --
> IMP mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe at lists.horde.org