On Thu, 03 May 2001 12:23:36 +0200
Emiliano <[EMAIL PROTECTED]> wrote:
> Carl Bowden wrote:
>
> > 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
>
> Has anyone else seen this? The cause of this error would
> seem to be (from the mysql docs) that we don't execute
> mysql_store_result after a query, but that's actually done
in the same function that
> executes the query. If we were on multi-threading I could
understand,
> but since a handler child has full, uninterrupted control
of the
> database connection for the duration of the request I
don't see how this
> could be happening.
I had applyed Alans patch of select_db.h for Bug no. 183
<snip>
ap_log_rerror(APLOG_MARK, APLOG_WARNING | APLOG_NOERRNO,
r, "Midgard: switching to %s failed",
dbc->name);
- return 0;
+ /* DONT GIVE UP try disconnect and reconnect!*/
+ mgd_close( dbc->handle->mgd);
+ return assert_conn
+ ? mgd_assert_db_connection(rcfg->mgd,
+ dbc->name, dbc->handle->username,
dbc->handle->password)
+ : 1;
+
+
+
}
}
dbc->handle->current = dbc;
could this create the out of sync thing as its asked for a
mgd_close
(the bug tracker has reported this as commited to cvs --
could it be assuming any other changes from cvs?)
alan has reported success with this patch, and problems seem
the same
Also some of the dbs are older 1.4b5(ish?) which dont
require updating as we are moving
most of the content to the newer dbs -- but may troubling
the switching?
> Ideas, anyone?
>
> Emile
>
> Oh, BTW, you triggered the Quoting Cruisader:
>
> without the context I'm completely lost.
ops sorry...
> PS: Please, please, _please_ people, when replying to a
> message, put
>
>
thanks for trying Emile
Cheers carl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
