Hi,

When I run db_checkpoint, I get the following error:

$ db_checkpoint -1 -h /home/acbell/db
db_checkpoint: open: No such file or directory

The directory /home/acbell/db exists and contains the following
DB_CONFIG file:

set_data_dir data
set_lg_dir logs

set_verbose DB_VERB_RECOVERY

Both the logs and data directories exist. All of the files in the
directory /home/acbell/db are readable by the same user as executes
db_checkpoint.

What is db_checkpoint looking for that it can't find?

Thanks,

-- Andrew Bell
andrew.bell.ia (AT) gmail (DOT) com

After a little more research, it looks like it is trying to open a
shared memory region files (db/__db.001). For whatever reason, this
doesn't exist in my filesystem. Is this a problem?

I am using an older version of bdb - 4.2.52.

Hi Andrew,

That would explain it. That version of db_checkpoint will not create
the environment -- it expects that the environment already exists.

Regards,
Michael.

OK,

But the database works fine. I can start the app, stop it, and so on.
How can the environment not exist in such a case?

Any info appreciated.

Are you using a private environment (with DB_PRIVATE set), or do you
create a DB_ENV at all in your application?

In either case (DB_PRIVATE or no explicit DB_ENV handle), no
environment region files will be created in the environment directory.
In that case, checkpoint doesn't really make sense -- it can't find a
cache to flush.

We have recently made a change to db_checkpoint -1 to force the
creation of a new log file as part of the upgrade procedure even if no
environment is found, but that doesn't sound like what you're looking
for here.

Regards,
Michael.

Thanks for the response,

What I'm trying to do is to make sure that transactions in the log
files are put into the database file so that I can delete the logs.

Anyway, the bottom line is that I'm having trouble doing a hot backup.
I restore the data and log files and run db_recover -c, seemingly
without problem, but when I restart the application, it complains of a
corrupted environment I was trying to checkpoint before I archived
the files, but it was failing, making me wonder what was going on.

Cheers,
Andrew