I got into the dreaded situation where after a crash of the process, my databse was left with a lock file. After removing the lock file and trying to open the database in read-only mode (ACCESS_MODE_DATA=r) I kept getting the error message: The database is read only [90097-188] 90097/90097 When I tried to open the database in writable mode, I got out of memory conditions.
After allocating a huge amount of memory (120G), I could open the database in writable mode, close it and since then opening in writable mode works again and I can create new tables or select data from existing tables. HOWEVER, when I try to open the database in readonly mode, I still just get an exception and the error message The database is read only [90097-188] 90097/90097 I am using h2-1.4.188.jar and all my databases are created using MV_STORE=FALSE (because many of the operations I need appear to be much slower with MV_STORE=TRUE). My database is quite big - over 350G of data in dozens of tables, so I am really paranoid of not being able to recover from this. I also need to be able to open the database as read-only because all my programs that only select data from its tables are written to do that. Is there any way to recover from that error message and that problem? -- 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, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
