Informix: connection busy handling undecisive

php.internals

Corne' cornelius

23 years ago
Hi, The Informix DB Extension has been giving a lot of -439 errors lately, especially when persistent connections are used. Error -439 means that the current connection is busy and can't process a new SQL query at the moment. Bugs related: 13459, 8267, 14254, 19416, 16145, 14314 Should i change the extension to establish a new connection automatically when: o ifx_connect()/ifx_pconnect() is called ? or o when ifx_query()/ifx_prepare()/ifx_do() is called ? Should there be an INI entry giving the user the option to let PHP connect automatically ? Should the IFX extension addopt the new_link argument feature of mysql_connect() ? NOTE: ifx_check() and php doesn't pick this up as an error because SQLSTATE is '00 000', which indicates no error. Thanks, Corne' !Exclude Disclaimer!

Unnamed Person

23 years ago
"Corne' Cornelius" <cornec@reach.co.za> a écrit dans le message de news:3F40BBE9.7070603@reach.co.za...
> Hi, > > The Informix DB Extension has been giving a lot of -439 errors lately, > especially when persistent connections are used. > Error -439 means that the current connection is busy and can't process a > new SQL query at the moment. > Bugs related: 13459, 8267, 14254, 19416, 16145, 14314
Yup I had that problem.
> > Should i change the extension to establish a new connection > automatically when: > > o ifx_connect()/ifx_pconnect() is called ? or > o when ifx_query()/ifx_prepare()/ifx_do() is called ?
The second option.
> > Should there be an INI entry giving the user the option to let PHP > connect automatically ?
No, it should just be done by default IMHO.
> > Should the IFX extension addopt the new_link argument feature of > mysql_connect() ?
If you feel so and wants to change that...
> > NOTE: ifx_check() and php doesn't pick this up as an error because > SQLSTATE is '00 000', which indicates no error. > > Thanks, > Corne'
Thank you !
> > !Exclude Disclaimer! > > >
-- Regards. M.CHAILLAN Nicolas nicos@php.net www.WorldAKT.com Hébergement de sites internets.