>>>>> "BAUMEISTER" == BAUMEISTER Alexandre <alex@stripped>
> writes:
>>> > So I though that Mysql_ping() should not hang. If the server can't
>>> > be touch, shouldn't the connection be considered as down ? Shouldn't
>>> > Mysql_ping() attempt a reconnection ?
einne> my solution to this was to set an alarm (with an appropriate timeout)
einne> before calling mysql_ping, and disconnect/try reconnecting in the signal
einne> handler.
einne> this works from perl DBI as well, i'm currently using this method in a
einne> few of my scripts.
BAUMEISTER> Thanks for the tip.
BAUMEISTER> Shouldn't Mysql_ping() do that on it's own ? It would be really
BAUMEISTER> great and would simplify things.
BAUMEISTER> Alex.
Hi!
mysql_ping() will issue a write on the opened connection and if it
gets some error it will try to reconnect.
Could you recompile mysql with --with-debug and debug libmysql.c and
find out why 'simple_command' in libmysql.c doesn't notice this
problem?
Regards,
Monty