h2 crash

Need help with SmartFoxServer? You didn't find an answer in our documentation? Please, post your questions here!

Moderators: Lapo, Bax

Posts: 77
Joined: 17 Jul 2009, 08:19

h2 crash

Postby corwin » 27 Aug 2010, 13:09

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...
Posts: 77
Joined: 17 Jul 2009, 08:19

Postby corwin » 27 Aug 2010, 14:08

Fixed it - added temporary in config file:

<DatabaseManager active="true">


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



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...
User avatar
Site Admin
Posts: 21009
Joined: 21 Mar 2005, 09:50
Location: Italy

Postby Lapo » 29 Aug 2010, 06:39

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

Return to “SmartFoxServer 1.x Discussions and Help”

Who is online

Users browsing this forum: No registered users and 17 guests