I deleted DB in /var/lib/postgrey/ and started postgrey to create fresh DB. That was on Friday. It is Monday and I see DB is corrupted again.
# db_verify /var/lib/postgrey/*.db
db_verify: Page 466: incorrect next_pgno 583 found in leaf chain (should be 204)
db_verify: Page 204: incorrect prev_pgno 583 found in leaf chain (should be 466)
db_verify: Page 369: incorrect next_pgno 584 found in leaf chain (should be 239)
db_verify: /var/lib/postgrey/postgrey.db: DB_VERIFY_BAD: Database verification failed
Verification of /var/lib/postgrey/postgrey_clients.db succeeded.
Verification of /var/lib/postgrey/postgrey.db failed.
Once postgrey is restarted, DB is fixed. This happened second time today...
# service postgrey restart
# db_verify /var/lib/postgrey/*db
Verification of /var/lib/postgrey/postgrey_clients.db succeeded.
Verification of /var/lib/postgrey/postgrey.db succeeded.
Notice: /etc/init.d/postgrey script is broken and has to be modified. Script distributed with U12.04 will report that postgrey was restarted but it was not restarted!
I deleted DB in /var/lib/postgrey/ and started postgrey to create fresh DB. That was on Friday. It is Monday and I see DB is corrupted again.
# db_verify /var/lib/ postgrey/ *.db
db_verify: Page 466: incorrect next_pgno 583 found in leaf chain (should be 204) postgrey/ postgrey. db: DB_VERIFY_BAD: Database verification failed postgrey/ postgrey_ clients. db succeeded. postgrey/ postgrey. db failed.
db_verify: Page 204: incorrect prev_pgno 583 found in leaf chain (should be 466)
db_verify: Page 369: incorrect next_pgno 584 found in leaf chain (should be 239)
db_verify: /var/lib/
Verification of /var/lib/
Verification of /var/lib/
Once postgrey is restarted, DB is fixed. This happened second time today...
# service postgrey restart postgrey/ *db
# db_verify /var/lib/
Verification of /var/lib/ postgrey/ postgrey_ clients. db succeeded. postgrey/ postgrey. db succeeded.
Verification of /var/lib/
Notice: /etc/init. d/postgrey script is broken and has to be modified. Script distributed with U12.04 will report that postgrey was restarted but it was not restarted!