[bug-notifications] [amavisd_new 0004138]: Upgrade to 2.6.3, REV=2009.04.23: postinstall fails to upgrade bdb databases

[Mantis Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://www.opencsw.org/mantis/view.php?id=4138 
====================================================================== 
Reported By:                skayser
Assigned To:                
====================================================================== 
Project:                    amavisd_new
Issue ID:                   4138
Category:                   upgrade
Reproducibility:            have not tried
Severity:                   major
Priority:                   normal
Status:                     new
====================================================================== 
Date Submitted:             2010-01-10 23:37 CET
Last Modified:              2010-01-10 23:41 CET
====================================================================== 
Summary:                    Upgrade to 2.6.3,REV=2009.04.23: postinstall fails
to upgrade bdb databases
Description: 
Reported by user "yurda" on #opencsw and observed on an OpenSolaris
installation. amavisd_new was working before the upgrade. Will have the
user add himself to the bug so that you can communicate with him in case it
is required.

/opt/csw/var/amavisn/install-20100110231645 says:

Running db_verify (before upgrade) on /opt/csw/var/amavisn/db
db_verify: /opt/csw/var/amavisn/db/cache.db: unsupported hash version: 9
db_verify: Page 0: unsupported DB version 9; extraneous errors may result
db_verify: page 1: illegal page type or format
db_verify: PANIC: Invalid argument
db_verify: cache.db: pgin failed for page 1
db_verify: cache.db: DB_RUNRECOVERY: Fatal error, run database recovery
db_verify: PANIC: fatal region error detected; run recovery
db_verify: dbenv->close: DB_RUNRECOVERY: Fatal error, run database
recovery
db_verify: /opt/csw/var/amavisn/db/nanny.db: unsupported hash version: 9
db_verify: Page 0: unsupported DB version 9; extraneous errors may result
db_verify: page 1: illegal page type or format
db_verify: PANIC: Invalid argument
db_verify: nanny.db: pgin failed for page 1
db_verify: nanny.db: DB_RUNRECOVERY: Fatal error, run database recovery
db_verify: PANIC: fatal region error detected; run recovery
db_verify: dbenv->close: DB_RUNRECOVERY: Fatal error, run database
recovery
db_verify: /opt/csw/var/amavisn/db/snmp.db: unsupported hash version: 9
db_verify: Page 0: unsupported DB version 9; extraneous errors may result
db_verify: page 1: illegal page type or format
db_verify: PANIC: Invalid argument
db_verify: snmp.db: pgin failed for page 1
db_verify: snmp.db: DB_RUNRECOVERY: Fatal error, run database recovery
db_verify: PANIC: fatal region error detected; run recovery
db_verify: dbenv->close: DB_RUNRECOVERY: Fatal error, run database
recovery
Running db_recover on /opt/csw/var/amavisn/db
Running db_upgrade on /opt/csw/var/amavisn/db
db_upgrade: /opt/csw/var/amavisn/db/cache.db: unsupported hash version: 9
db_upgrade: DB->upgrade: cache.db: DB_OLDVERSION: Database requires a
version upgrade
db_upgrade: /opt/csw/var/amavisn/db/nanny.db: unsupported hash version: 9
db_upgrade: DB->upgrade: nanny.db: DB_OLDVERSION: Database requires a
version upgrade
db_upgrade: /opt/csw/var/amavisn/db/snmp.db: unsupported hash version: 9
db_upgrade: DB->upgrade: snmp.db: DB_OLDVERSION: Database requires a
version upgrade
Running db_verify (after upgrade) on /opt/csw/var/amavisn/db
db_verify: /opt/csw/var/amavisn/db/cache.db: unsupported hash version: 9
db_verify: Page 0: unsupported DB version 9; extraneous errors may result
db_verify: page 1: illegal page type or format
db_verify: PANIC: Invalid argument
db_verify: cache.db: pgin failed for page 1
db_verify: cache.db: DB_RUNRECOVERY: Fatal error, run database recovery
db_verify: PANIC: fatal region error detected; run recovery
db_verify: dbenv->close: DB_RUNRECOVERY: Fatal error, run database
recovery
db_verify: /opt/csw/var/amavisn/db/nanny.db: unsupported hash version: 9
db_verify: Page 0: unsupported DB version 9; extraneous errors may result
db_verify: page 1: illegal page type or format
db_verify: PANIC: Invalid argument
db_verify: nanny.db: pgin failed for page 1
db_verify: nanny.db: DB_RUNRECOVERY: Fatal error, run database recovery
db_verify: PANIC: fatal region error detected; run recovery
db_verify: dbenv->close: DB_RUNRECOVERY: Fatal error, run database
recovery
db_verify: /opt/csw/var/amavisn/db/snmp.db: unsupported hash version: 9
db_verify: Page 0: unsupported DB version 9; extraneous errors may result
db_verify: page 1: illegal page type or format
db_verify: PANIC: Invalid argument
db_verify: snmp.db: pgin failed for page 1
db_verify: snmp.db: DB_RUNRECOVERY: Fatal error, run database recovery
db_verify: PANIC: fatal region error detected; run recovery
db_verify: dbenv->close: DB_RUNRECOVERY: Fatal error, run database
recovery
====================================================================== 

---------------------------------------------------------------------- 
 (0007203) skayser (administrator) - 2010-01-10 23:41
 http://www.opencsw.org/mantis/view.php?id=4138#c7203 
---------------------------------------------------------------------- 
Btw. we moved away the .db files as a workaround. postinstall went through
and amavisd_new is running again. The old .db files are still around in
case they might shed some light on this.

23:27 < yurda> what is stored in thise database?
23:27 <@skayser> two things that you could do, please
23:27 <@skayser> i don't know at all
23:28 <@skayser> you might also move them out of the way for test
purposes
23:28 <@skayser> but that's only a guess, i am not familiar with it in any
way
23:28 < yurda> mmt
23:28 <@skayser> then the new installation will very likely succeed
23:28 <@skayser> but please keep those files around, i would like to open
a bug report against CSWamavisdnew
23:30 < yurda> yes success, i keep files