h2 crash

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

Moderators: Lapo, Bax

corwin
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...
corwin
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">
<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...
User avatar
Lapo
Site Admin
Posts: 21014
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.
Lapo
--
gotoAndPlay()
...addicted to flash games

Return to “SmartFoxServer 1.x Discussions and Help”

Who is online

Users browsing this forum: Google [Bot] and 14 guests