Re: [h2] Database Recovery

2014-09-15 Thread D. Aldenderfer
I have just run into the same scenario again. If the transaction log contains data, why isn't it automatically applied to the database when recovering? Thanks On Tuesday, July 22, 2014 10:10:42 AM UTC-4, Noel Grandin wrote: No, you would have to edit and apply that section by hand. On

[h2] Database Hangs on schema update

2014-09-09 Thread D. Aldenderfer
When our application starts it performs schema updates to the H2 database as needed. Before performing updates we SET EXCLUSIVE 1 and make sure that no table locks exists ( SELECT COUNT(*) FROM information_schema.locks ). The following schema update statement hangs the application: alter

[h2] Re: Database Hangs on schema update

2014-09-09 Thread D. Aldenderfer
Further testing shows that when 'SET EXCLUSIVE 1' is NOT executed first, the statement runs normally. On Tuesday, September 9, 2014 1:23:30 PM UTC-4, D. Aldenderfer wrote: When our application starts it performs schema updates to the H2 database as needed. Before performing updates we SET

[h2] Re: Database Recovery

2014-07-22 Thread D. Aldenderfer
How is the information in the -Transaction log - portion of the recover script to be used? On Monday, July 14, 2014 11:43:33 AM UTC-4, Dora Aldenderfer wrote: I'm trying to recover a corrupt database. When I using the Recover/RunScript tools I am able to recover the database