Hi,

Thanks for your mail! I am currently investigating in possible
database corruptions. So far I did find a problem when using 'shutdown
defrag'. I couldn't reproduce a problem on out of disk space yet
however. A reproducible test case would be great of course, but I
understand it might not be that easy to create one.

Regards,
Thomas




On Tue, Aug 2, 2011 at 5:36 PM, Andrew <[email protected]> wrote:
> Here's one more variation of the database corruption error condition
> following filesystem space exhaustion -- note that we are not creating
> or opening the database in read-only mode.
>
> Caused by: org.h2.jdbc.JdbcSQLException: The database is read only;
> SQL statement:
> insert into cache (key, since, access) values(?, ?, ?) [90097-155]
>        at
> org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
>        at org.h2.message.DbException.get(DbException.java:167)
>        at org.h2.message.DbException.get(DbException.java:144)
>        at org.h2.message.DbException.get(DbException.java:133)
>        at org.h2.engine.Database.checkWritingAllowed(Database.java:
> 1617)
>        at org.h2.table.Table.checkWritingAllowed(Table.java:1040)
>        at org.h2.engine.User.hasRight(User.java:111)
>        at org.h2.engine.User.checkRight(User.java:97)
>        at org.h2.command.dml.Insert.insertRows(Insert.java:93)
>        at org.h2.command.dml.Insert.update(Insert.java:84)
>        at
> org.h2.command.CommandContainer.update(CommandContainer.java:71)
>        at org.h2.command.Command.executeUpdate(Command.java:212)
>        at
> org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:
> 143)
>        at
> org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:
> 129)
>        at
> com.cerner.crawler.cache.PersistentCache.insertKey(PersistentCache.java:
> 288)
>        at
> com.cerner.crawler.cache.PersistentCache.put(PersistentCache.java:197)
>        ... 13 more
>
> --
> 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.
>
>

-- 
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.

Reply via email to