Hi all,
I am migrating my application from H2 1.4.199 to H2 2.1.212. It's working
fine but the database grows and the automatic compact only has a minor
effect (separate mail will follow about that). So I copied the database
using the "BACKUP TO" command to inspect it.
I opened the copy with the
Greetings. Please try the latest snapshot. It has been fixed in 219.Sent from
my Galaxy
Original message From: Ulrich
Date: 10/06/2022 09:34 (GMT+01:00) To: H2 Database
Subject: [h2] Database corrupted after SHUTDOWN
COMPACT Hi all,I am migrating my application from H2
; Sent from my Galaxy
>
>
> Original message
> From: Ulrich
> Date: 10/06/2022 09:34 (GMT+01:00)
> To: H2 Database
> Subject: [h2] Database corrupted after SHUTDOWN COMPACT
>
> Hi all,
> I am migrating my application from H2 1.4.199 to H2 2.1.212.
I tried with the latest 219. The problem that the database corrupts when
running SHUTDOWN COMPACT still exist.
The compact is finished very fast but a .temp file remains in the database
folder.
Here is the content of the trace file:
2022-06-10 10:24:30 database: close
org.h2.message.DbException
Very strange, it must be a different problem then. Suggestions:
1) Extract the existing DB to SQL script
2) Create a new DB from that SQL script (using the 219 H2 Driver)
3) Open the new DB, close the new DB (without DEFRAG)
4) Open the new DB, SHUTDOWN DEFRAG it
You can use the Migration
Tool
I think it has something to do with the BACKUP TO command.
I have done the following tests:
1) "Offline copy"
* Shutdown my application (using 2.1.212)
* copy the mv.db to my PC
* open it with the H2 console (2.2.219)
* run "SHUTDOWN COMPACT"
=> the database file shrinked and could be opened wit
Stop, I am silly. It overlooked that the file created by the BACKUP command
is a zip file. I tried to use it as database file...
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, se
Use the UI I sent to you. It takes care of those challenges. Sent from my Galaxy
Original message From: Ulrich
Date: 10/06/2022 12:21 (GMT+01:00) To: H2 Database
Subject: Re: [h2] Database corrupted after
SHUTDOWN COMPACT Stop, I am silly. It overlooked that the file
UTC+2:
> Use the UI I sent to you. It takes care of those challenges.
>
>
>
> Sent from my Galaxy
>
>
> Original message
> From: Ulrich
> Date: 10/06/2022 12:21 (GMT+01:00)
> To: H2 Database
> Subject: Re: [h2] Database corrupted after SH
;
> > Sent from my Galaxy
> >
> >
> > Original message
> > From: Ulrich
> > Date: 10/06/2022 12:21 (GMT+01:00)
> > To: H2 Database
> > Subject: Re: [h2] Database corrupted after SHUTDOWN COMPACT
> >
> > Sto
10 matches
Mail list logo