[ic] mysql having problems reconnecting on catalog reconfig

Mike Heins mike at perusion.com
Thu Nov 10 18:50:25 UTC 2011


Quoting Peter (peter at pajamian.dhs.org):
> On 11/11/11 03:15, Mike Heins wrote:
> > It's a part of the alternate DSN stuff, where you can fall back to a
> > different database server if one is down.
> 
> Well it does seem to make at least some sense to me that if the first db
> server goes down to retry the connection to that before falling back to
> an alternate DSN or giving up entirely.

I believe our approach is that we delegate that level of connection 
robustness to the DBI module.

> 
> > But the bigger question is -- why did your connect fail originally,
> > so that you have a connection marked as bad?
> 
> Yes, I agree, unfortunately I'm at a loss for how to discover this.  It
> took enough digging for me to find this bit of code.
> 
> That said, I highly suspect it has something to do with either (1) newer
> version of perl, (2) newer version of DBI or (3) newer version of
> DBD::mysql (I don't think it's this last one because I initially
> suspected it and went back about 10 versions and the issue was still there).

Did you see my suggestion about emptying %DBI_connect_bad on a
reconfiguration?

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.328.4479  <mike at perusion.com>

Life isn't fair, but it's good. -- Regina Brett



More information about the interchange-users mailing list