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

Re: DB buggy after Reboot

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

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

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
< 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
< 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.

How could I set this checkpoints?