Deleting the Derby transaction log to silence errors will corrupt the database

Flash (Alert)


Abstract

Never delete or manipulate *ANY* files in a Derby database directory structure. Doing so will corrupt the database.

Content

The bottom line: Never delete or manipulate *ANY* files in a Derby database directory structure. Doing so will corrupt the database.

The problem: Some Derby users have discovered that deleting the files in the log subdirectory of the database will silence recovery errors and allow access the database. Removing the logfiles, even on a database that is not reporting problems, will corrupt the database. The data integrity and possibly the internal structure of the database will be irreparably damaged. Such corruptions are silent and could go unnoticed for long periods of time.

Please help: If you find any documents that recommend removing files from the Derby database folders please report them to the Derby Community (see below) or correct these reference.

Critical Best Practice: Make regular backups of your databases. Restoring the database from backup is the only way to recover a corrupt system.

Report problems or ask questions: Obtain assistance, post information or ask questions regarding Cloudscape or Derby via the Apache Derby maillists.


Related information

IBM Cloudscape and Apache Derby forum
Apache Derby Mail Lists

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cloudscape
All (General)

Software version:

5, 10

Operating system(s):

AIX, Linux, Mac OS, OS/400, Solaris, Windows, z/OS, zSeries

Software edition:

All Editions

Reference #:

1261294

Modified date:

2010-07-21

Translate my page

Machine Translation

Content navigation