[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: DB buggy after Reboot

matthew sporleder wrote:
On 9/24/06, Matthias Spork <hallo@matthiasspork.de> wrote: 
Hello,

my database is buggy after rebooting my SLES9 Server/OpenLDAP 2.3.27
after 1 Week of running.
Could someone help investigating my problem?

DB_CONFIG
set_cachesize   0       26214400        0
set_lg_max      10485760
set_lg_bsize    2097152
set_lg_dir      /var/lib/ldap/transactionlog
set_tmp_dir     /tmp

For example:
# diff before_reboot.ldif  after_reboot.ldif
716,723c716,723
< userPassword:: e0NSWVBUfVdOZ1luTWRqQ2FKZjI=
< shadowLastChange: 13413
< sambaPwdCanChange: 1158833231
< sambaPwdMustChange: 1164017231
< sambaLMPassword: D541B1602D3165C209752A3293831D17
< sambaNTPassword: 37B2C7161DAB4C6475452CE9A44850B2
< sambaPwdLastSet: 1158833231
< entryCSN: 20060921100711Z#000002#00#000000
---
> userPassword:: e0NSWVBUfTFPcGcvRllqZDh3b2s=
> shadowLastChange: 13368
> sambaPwdCanChange: 1154944101
> sambaPwdMustChange: 1160128101
> sambaLMPassword: D541B1602D3165C236077A718CCDF409
> sambaNTPassword: 33605EA53E136734C78F145EA8C5E842
> sambaPwdLastSet: 1154944101
> entryCSN: 20060807094821Z#000002#00#000000
725c725
< modifyTimestamp: 20060921100711Z


Maybe you could be a little more clear about the actual problem?  This
just looks like a diff.  Did you lose a month of transactions?  (I'm
just guessing by the dates I see)

It looks like some transactions got rolled back, probably because there wasn't a recent enough checkpoint and the logs for the latest transactions didn't get flushed to disk. Setting a more frequent checkpoint interval would probably help.

--
  -- Howard Chu
  Chief Architect, Symas Corp.  http://www.symas.com
  Director, Highland Sun        http://highlandsun.com/hyc
  OpenLDAP Core Team            http://www.openldap.org/project/