h2 crash

[corwin]

Hi after server restart i got the following error:

[ SEVERE ] > DbManager could not retrive a connection. org.h2.jdbc.JdbcSQLException: General error: java.lang.Error: File ID mismatch got=0 expected=21 pos=43003 true org.h2.store.DiskFile@6badc6a5 blockCount:0; SQL statement:
INFO | jvm 1 | 2010/08/27 16:43:43 | CREATE INDEX PUBLIC.BLIST_696D70657269616C436861745A6F6E65_OWNER_IDX ON PUBLIC.BLIST_696D70657269616C436861745A6F6E65(OWNER) [HY000-60]

We have pretty much stuff in the buddy lists and I would appreciate any hints how to restore the data from those files...

[corwin]

Fixed it - added temporary in config file:

<DatabaseManager active="true">
<Driver>org.h2.Driver</Driver>
<ConnectionString>jdbc:h2:tcp://localhost:9004/__sfscore__;Recover=1</ConnectionString>

<UserName>sa</UserName>
<Password></Password>

<TestSQL><![CDATA[SELECT 1]]></TestSQL>

<MaxActive>10</MaxActive>
<MaxIdle>10</MaxIdle>

<OnExhaustedPool>fail</OnExhaustedPool>
<BlockTime>5000</BlockTime>
</DatabaseManager>

Started server, removed it, restarted and now everything seems ok. But still don't have a clue why it crashed initially. Guess will go entirely custom mysql...

[Lapo]

Could be that the database file got corrupted, but it's just a guess.