Thomas, I have a backup of the database before dropping all objects and I can reproduce it :-)
1st: Dropping the database I performed a DROP TABLE for all tables. All depending objects seem to be dropped automatically (one view, automatic sequences and indexes). 2nd: I am using H2 1.2.142 which also created the database 3rd: Recover tool: I started the recover tool but it crashed with the following exception: Error: org.h2.message.DbException: IO Exception: "java.io.IOException: Negative seek offset"; "/home/uli/dbtest/test.h2.db" [90031-142] The sql file created so far is: CREATE ALIAS IF NOT EXISTS READ_BLOB FOR "org.h2.tools.Recover.readBlob"; CREATE ALIAS IF NOT EXISTS READ_CLOB FOR "org.h2.tools.Recover.readClob"; CREATE ALIAS IF NOT EXISTS READ_BLOB_DB FOR "org.h2.tools.Recover.readBlobDb"; CREATE ALIAS IF NOT EXISTS READ_CLOB_DB FOR "org.h2.tools.Recover.readClobDb"; -- pageSize: 2048 writeVersion: 3 readVersion: 3 // error: org.h2.message.DbException: IO Exception: "java.io.IOException: Negative seek offset"; "/home/uli/dbtest/ test.h2.db" [90031-142] 4th: Dropping all objects: These are the filesizes of my steps: Before dropping: -rw-r--r-- 1 uli users 5.0G 2010-09-24 13:01 test.h2.db drwxr-xr-x 2 uli users 4.0K 2010-09-24 13:01 test.lobs.db -rw-r--r-- 1 uli users 99 2010-09-24 13:01 test.lock.db After dropping all: -rw-r--r-- 1 uli users 7.1G 2010-09-24 13:10 test.h2.db drwxr-xr-x 2 uli users 4.0K 2010-09-24 13:10 test.lobs.db -rw-r--r-- 1 uli users 99 2010-09-24 13:01 test.lock.db After shutdown compact: -rw-r--r-- 1 uli users 2.7G 2010-09-24 13:15 test.h2.db drwxr-xr-x 2 uli users 4.0K 2010-09-24 13:10 test.lobs.db -rw-r--r-- 1 uli users 1.1K 2010-09-24 13:15 test.trace.db I also compared 1.2.142 and 1.2.143 and observed the same behaviour (dropping all tables, shutdown compact, Recover). I hope these information helps you to track down the reason. Uli P.S.: I cannot answer you within the next two weeks but then I will be able to do some more tests. On 24 Sep., 10:25, Thomas Mueller <[email protected]> wrote: > Hi, > > > I dropped my complete database > > How did you do that? Did you use DROP ALL OBJECTS? > > What version of H2 do you use, and with what version was the database > created? To find this out, use SELECT * FROM > INFORMATION_SCHEMA.SETTINGS WHERE NAME='CREATE_BUILD'; > > Could you run the Recover tool to find out what takes up so much space? > > Regards, > Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
