I guess the real question is what you'd like to have happen... does the
fact that the databases are unavilable affect the whole site (rendering it
useless anyhow), or is it just a subset?
It's strange that the behavior of those database connections is to hang
when the database goes away (is that actually the case?) My experience
with oracle and mysql don't seem to suggest that behavior.
I'd imagine that perhaps some sort of timeout on queries would be handy,
but it might add undesirable overhead.
Bill
On Fri, 17 Feb 2006, Graeme Davis wrote:
> I've been having a problem with Roxen and some external databases (sybase
> and oracle) that I talk to (that aren't under my control). When an
> external db goes down, roxen will fill up all threads and hang.. I was
> wondering if anyone else has this problem?
>
> Pike version: Pike v7.2 release 543
> Product version: Roxen CMS 3.4.109-release4
> Operating system: SunOS 5.8 (sun4u)
> 10 threads
>
> I was thinking I might have to write some external scripts to "ping" the db
> server port and somehow turn off access to that database in roxen, but I
> shouldn't have to do that.
>
> Any ideas?
>
> Thanks,
>
> Graeme
>
|