Thanks for the patch Emile:
it took some time but finally got the log messages when it
errored:
[Thu May 3 10:19:04 2001] [debug] mod_midgard.c(1195):
[client 203.167.246.101] midgard_translate_handler(latin1,
http:
//smartweb002-admin.e2-media.co.nz:80/rcs/browse/)
Midgard: mgd_select_db(SmartWEB_002) failed: Commands out of
sync; You can't run this command now (-1)
Midgard: mgd_select_db(SmartWEB_002) failed: Commands out of
sync; You can't run this command now (-1)
[Thu May 3 10:19:04 2001] [warn] [client 203.167.246.101]
Midgard: switching to SmartWEB_002 failed
I had applyed your patch (more chatty log) and Alan's
select_db.h patch
I have also pushed the mysql error vars out from the default
10's to 100
(eg max_connect_errors -- i know it was a long shot)
On Fri, 27 Apr 2001 13:31:11 +0200
Emiliano <[EMAIL PROTECTED]> wrote:
> Carl Bowden wrote:
>
>
> > Yes all DB's have a common user and pass (its also the
> user
> > mysqld process runs as) and i have mysql seet to a max
> of
> > 1000 connections (sometimes it gets over 150
> maxconnections)
> > and the machine is not in heavy use yet
>
> OK, that's ruled out then. What about the opposite, are
> the sites OK if
> you do have unique usernames for each (in which case no
> switching will
> occur)?
>
> > Is there any where we may be able to check messages as
> to
> > why the errors show?
>
> I think you allready have loglevel set to debug, in which
> case, no.
> But you could try to apply the attached patch, which
> should make
> midgard-lib more chatty about the failure.
>
> > would it be fair to say that php is proberly not
> involed?
>
> Yes. mod_midgard is the one that does the database
> juggling.
>
> > if so, it must be mainly a midgard lib thing (re apache
> > comment above) so we installed the 1.4.1-5 tarball(the
> ones
> > just after the corrupt bzip's), is there any newer?
>
> Nope.
>
> > ( thats
> > relavent) and could it have linked across anything in
> the
> > LinuxPPC kit that may be an issue?
>
> Not too likely.
>
> Emile
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
