NIS exception when starting up

Tech Support
#1

Hi all,

when starting it, my NIS (6.73) loads blocks for a while - last according log entry is

INFORMATION loadBlocks (from height 431602 to height 431701).

Then, it stops saying

WARN SQL Error: 50000, SQLState: HY000 (org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions)

and

SELECT t.*, tm.id as id1, tm.dbMosaicId as dbMosaicId1, tm.quantity as quantity1 FROM transfers t LEFT OUTER JOIN transferredMosaics tm ON tm.transferId = t.id WHERE blockid > ? AND blockid < ? ORDER BY blockid ASC [50000-176] (org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions)

followed by

something really bad happened: java.util.concurrent.CompletionException: org.hibernate.exception.GenericJDBCException: could not extract ResultSet (org.nem.nis.NisMain b)

Is there any way this can be fixed or should I delete all local data and synchronize again from scratch?

Thanks in advance!
Derek

#2

Never a bad idea.

#3

No fix for the corrupt database, either download from scratch (shut down nis, delete db and restart nis) or download the db from bob to speed up things (download db, shutdown nis, replace current db with downloaded one and start nis again)

DB on bob: bob.nem.ninja/nis5_mainnet.h2.db.zip

#4

How to Delete Your Local Copy of the Blockchain: http://blog.nem.io/how-to-delete-your-local-copy-of-the-blockchain/

#5

Thanks guys, everything is fine now!