Arch Linux

marcob

Member

From: B-town USA

Registered: 2004-11-10

Posts: 38

Website

db_upgrade - Berkely DB

Just ran a pacman -Syu when I meant to run pacman -SyU, and received this  message:

upgrading db... done.
ATTENTION DB PACKAGE:
Please consider to run db_upgrade on Berkeley DB databases with a major db version number update.

Looks like I upgraded from 4.3.29-2 to 4.4.20-3.  Does anybody know if I should actually run db_upgrade?  And if so, is there a certain way to do it?  The sleepycat page on db_upgrade is a little confusing, and the part about the upgrade being 'potentially destructive' is a little scary.

http://www.sleepycat.com/docs/utility/db_upgrade.html

FWIW, I had just upgraded another server using pacman -SyU and I did not get this message.  Both servers were last upgraded around April 21, so I guess they were halfway between Noodle and Gimmick, both running kernel 2.6, and both are using bdb for openldap.

Thanks for any help

JGC

Developer

Registered: 2003-12-03

Posts: 1,664

Re: db_upgrade - Berkely DB

If you have a berkeley DB, for example, openldap, you need to run db_upgrade in the directory that contains the DB (/var/lib/openldap/openldap-data for example). This converts the DB 4.3 file format to 4.4, so the new version of OpenLDAP can use it. This is the same for programs like subversion for all your repositories, or the spamassassin bayes database.

Purch

Member

From: Finland

Registered: 2006-02-23

Posts: 229

Re: db_upgrade - Berkely DB

Just in case, is there a way to find out Berkeley db's on your hard disk? Some specific file types or locations?

dogfin

Member

From: WA, USA

Registered: 2006-04-04

Posts: 10

Re: db_upgrade - Berkely DB

I'm also curiouse how to find Berkeley db's on my disk.  some searching found over 50 .db files.  How do I tell if they are Berkeley files?  Thanks.

Ryan -

silvik

Member

From: Bucharest/Romania

Registered: 2006-11-08

Posts: 110

Re: db_upgrade - Berkely DB

silvik@morgana:/etc$ file vsftpd_login.db
vsftpd_login.db: Berkeley DB (Hash, version 8, native byte-order)

"file tests each argument in an attempt to classify it.  There are three sets of tests, performed in this order: filesystem tests, magic number tests, and language tests.  The first test that succeeds causes the file type to be printed."

this is what you want:
find / -name '*.db' > temp
file -f temp | grep Berkeley
rm -f temp

umm... interesting... 28 files to upgrade

dogfin

Member

From: WA, USA

Registered: 2006-04-04

Posts: 10

Re: db_upgrade - Berkely DB

That is exactly what I needed, Thank you!

Ryan -

silvik

Member

From: Bucharest/Romania

Registered: 2006-11-08

Posts: 110

Re: db_upgrade - Berkely DB

glad it helped

quayrodent

Member

Registered: 2007-01-18

Posts: 7

Re: db_upgrade - Berkely DB

Thanks much, this is just the info I was looking for

I didn't realize that spamassassin depended on BerkeleyDB as well.  I wondered why I was having such trouble with it after upgrades.

admasnd

Member

Registered: 2009-05-28

Posts: 11

Re: db_upgrade - Berkely DB

Sorry, I'm a bit confused. I get how to find the Berkeley DB files, but I do not get how to use the db_upgrade program. I went into the directory that one of the .db files was stored and ran

db_upgrade <file name>

I'm not sure if I'm suppose to be using the -s argument as the file is a Berkeley DB 1.85, but the explanation of the argument confuses me.