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

[ando@sys-net.it]

robb@wtg.cw.com wrote:
> Full_Name: Robert Brooks
> Version: 2
> OS: 2.4.12
> URL: ftp://ftp.openldap.org/incoming/
> Submission from: (NULL) (62.49.19.14)
> 
> 
> Set up is a pair of centos 4 hosts, one acts as primary, the other is a syncrepl
> consumer and mysql slave. Apart from syncrepl config/myqsl slave all config and
> software versions are the same. Mysql queries on both hosts are to localhost via
> socket.
> 
> After a period of operation (24-48 hours) the slave host drops the back-sql part
> of directory for some queries (same query will suceed some times). Using strace
> it can been seen that the ldap searches are not resulting in queries to mysql.
> Back-sql is a subordinate db and results from hdb backed part of directory are
> returned.
> 
> Restarting slapd fixes the problem, but start-up reports the shutdown was
> unclean on hdb db. Operation of primary is reliable.

I have no possibility to setup a back-sql with mysql right now.  Can you 
post your configuration?  Can you post some (verbose) logs of operations 
affecting back-sql (e.g. with BACKSQL_TRACE manually #defined in 
back-sql/back-sql.h)?  Can you step thru a search into backsql_search() 
and see if it gets called and why it doesn't get to contacting the rdbms?

p.


Ing. Pierangelo Masarati
OpenLDAP Core Team

SysNet s.r.l.
via Dossi, 8 - 27100 Pavia - ITALIA
http://www.sys-net.it
-----------------------------------
Office:  +39 02 23998309
Mobile:  +39 333 4963172
Fax:     +39 0382 476497
Email:   ando@sys-net.it
-----------------------------------