[ic] mysql having problems reconnecting on catalog reconfig

[Peter]

On 11/11/11 08:17, Mike Heins wrote:
> Quoting Peter (peter at pajamian.dhs.org):
>> On 11/11/11 03:29, Mike Heins wrote:
>>>> Going forward, perhaps it makes sense to reset %DBI_connect_bad
>>>> on a catalog reconfig.
>>
>> That's not a bad idea either, where would that be done, or how?
>>
> 
> I think it might make sense to put in a (couple of?) SpecialSub
> link(s). Perhaps 
> 
> 	SpecialSub   pre_reconfig   global_reset_dbi
> 	SpecialSub   post_reconfig   global_reset_dbi
> 
> Then in your global sub:
> 
> GlobalSub <<EOS
> sub global_reset_dbi {
> 	%Vend::Table::DBI::DBI_connect_bad = ();
> }
> EOS
> 
> I don't think we want to touch this by default in the current version.
> I doubt there are many, if any, using ALT_DSN, though, and that would
> be ripe for removal in future versions.

I've now seen the exact same problem (with the same fix) on perl 5.12.1
with postgresql.  It would seem that my initial assumption that it is
specific to mysql was incorrect.  I will investigate further when I get
the chance.


Peter