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

[Nigel Cass]

[SOLVED]

For information.

I have had no further problems since I disabled persistent connections on
the webmail server that is accessing the preferences database remotely.

Whilst I realise this is undoubtedly introducing some extra overhead
(presumably on both imp and database server) at least I can be comfortable
that the user base is not affected.

Thanks everyone for your advice.

Nige.

> 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
> 
> 
> --
> IMP mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe at lists.horde.org