Re: (ITS#5796) back-sql intermittently failing

[robb@wtg.cw.com]

Pierangelo Masarati wrote:

> OK, this makes sense.  In fact, back-sql does not seem to specifically 
> handle broken connections to the odbc.  It appears it would need 
> something similar to idle-timeout as in back-ldap and back-meta.

ok, this looks like it...

Nov 11 17:01:38 nops slapd[24733]: backsql_dn2id("dc=sql,dc=example,dc=com")
: error executing query ("SELECT id,keyval,oc_map_id,dn FROM 
ldap_entries WHERE dn=?", "dc=sql,dc=example,dc=com"):
Nov 11 17:01:38 nops slapd[24733]: Return code: -1
Nov 11 17:01:38 nops slapd[24733]:    nativeErrCode=2006 
SQLengineState=08S01 msg="[unixODBC][MySQL][ODBC 3.51 
Driver][mysqld-5.0.67-log]MySQL server has gone away"
Nov 11 17:01:38 nops slapd[24733]: 
<==backsql_dn2id("dc=sql,dc=example,dc=com")
: err=80

if you'd like a tarball of full logs + config just say.

Regards,

Rob