[Serusers] DB disconnects with MySQL 5.0.27
sip
sip at arcdiv.com
Mon Feb 5 16:52:18 CET 2007
Okay... apparently, as of 5.0.3, there's a timeout on the connection and the
option to auto-reconnect has been turned off. In order to turn it back ON, one
has to modify the connection with MYSQL_OPT_RECONNECT.
I added a few lines to the my_con.c file in the mysql modules dir, and we'll
see how it fares.
Added:
my_bool my_true;
And below the mysql_init(ptr->con); line, I added:
mysql_options(ptr->con, MYSQL_OPT_RECONNECT, &my_true);
Has anyone done anything similar and had decent results (incidentally, if you
have mysql 5.0.18 or lower, the MYSQL_OPT_RECONNECT is reset as soon as you
call mysql_real_connect, so it has to be set afterward) ?
N.
On Mon, 5 Feb 2007 07:38:04 -0500, sip wrote
> Something I've never run into before when I was using MySQL 4.x, but
> now crops up on MySQL 5.0.27... I get these errors:
>
> Feb 5 07:30:40 qabalah ser[26765]: submit_query(): MySQL server has
> gone away
> Feb 5 07:30:40 qabalah ser[26765]: db_update: Error while
> submitting query
> Feb 5 07:30:40 qabalah ser[26765]: db_upd_ucontact(): Error while updating
> database
>
> Feb 5 07:30:40 qabalah ser[26765]: wb_timer(): Error while updating
> contact in db
>
> I assume there's some sort of timeout of the SER connection to
> mysql? Is there a standard way to rectify this? Is this something
> new in MySQL 5?
>
> N.
> _______________________________________________
> Serusers mailing list
> Serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
More information about the sr-users
mailing list