I've been experiencing issues with my application, and finally managed
to trap the error at its source. It doesn't manifest until the program
has processed something on the order of 80,000 records, and I do not
believe it always manifests at the exact same point.
Here's the error message:
SQL State 90031
org.h2.jdbc.JdbcSQLException: IO Exception:
"java.io.SyncFailedException: sync failed";
"//ALIENLIZARD/Users/Public/VARisk/VARiskDB.h2.db" [90031-160]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:158)
at org.h2.message.DbException.convertIOException(DbException.java:315)
at org.h2.store.FileStore.sync(FileStore.java:437)
at org.h2.store.PageStore.writeVariableHeader(PageStore.java:924)
at org.h2.store.PageStore.setLogFirstPage(PageStore.java:918)
at org.h2.store.PageLog.removeUntil(PageLog.java:698)
at org.h2.store.PageStore.checkpoint(PageStore.java:415)
at org.h2.store.PageStore.commit(PageStore.java:1406)
at org.h2.engine.Database.commit(Database.java:1733)
at org.h2.engine.Session.commit(Session.java:450)
at org.h2.command.Command.stop(Command.java:144)
at org.h2.command.Command.executeUpdate(Command.java:248)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:300)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.SyncFailedException: sync failed
at java.io.FileDescriptor.sync(Native Method)
at org.h2.store.fs.FileDisk.force(FilePathDisk.java:387)
at org.h2.store.FileStore.sync(FileStore.java:435)
... 12 more
IO Exception: "java.io.SyncFailedException: sync failed";
"//ALIENLIZARD/Users/Public/VARisk/VARiskDB.h2.db" [90031-147]
Here's the command that caused the crash, though I suspect it is not
really the problem (I could be wrong)
INSERT INTO Matrix_Outputs_12_14_2011_13_53_SCENARIOTEST_Flat_Rates_Flat_HPI
VALUES('RFMSII2005HI19690815','2008','12','1305','2004-10','2004','10','4','C','31','MF_31-33','44','AGE_13_to_15','NA','NA','FIX30','2','UN','UNK','UN','PRI','LA',4.8,3.4,'-0.0059128257413356','0.312','60000','Orig_Bal_50_75','44.6555','134362','681','FICO_680_699','676.551055100121','659.54','0','6','0','299','58094.63','56972.33','42.97','LTV_lt_60','132595.142799273','Prepay_Spread_030_020','0','681','268','0.719488828872811','0.673014420957512','0.0304458803961435','0.00497854173400635','0.00199014659161782','0.00201047373329569','0.00130017850434709','0.000876576653500326','0.00686275689400644','0.00448524245935612','0.00417317856878597','0.000401418165389632','0.00566545395727093','0.000468083516404374','0.258838718692376','0.0216724524348127','TRUE','40990.9549898553','251.419558512016','38343.1996855503','1734.57274506962','283.639122588582','113.383288366026','114.541372989654','74.0741988085687','49.9406143735163','390.98725047511','255.534713524449','237.755706569802','22.8697281865727','322.774112453445','26.6678085641504','957.731189640103','14902.4889408821','1243.46848168103','40990.9549898553','TRUE','13.1859363321817','586.244451001093','7.0750164425373','0.777402091387036','49.4451439474769','47.1459035462289','2.14041897104952','1.00911986357619','81','2006-02',NULL)
As noted, about 80,000 records were already inserted using this code
before it crashed, and the error doesn't seem to be due to a
misformatted field, etc.
I am running a multithreaded app, with each thread reading from and
writing to the database; I've used this code extensively in the past
without these kinds of errors, for very large data sets, though this
one has some more complex internal work than most, the actual DB I/O
should not be at all affected, all the other code is related to
internal calculations with no DB access at all.
I'm starting the server with this:
java -cp h2-l*.jar org.h2.tools.Server -tcp -tcpPort 9091 -tcpAllowOthers
I am running within Eclipse, so that I could debug/trap the error when
it happened, but I don't think that's relevant, either.
--
=======================
Personal Blog: http://www.xanga.com/lizard_sf
Facebook: http://www.facebook.com/lizard_sf
MrLizard: Gaming and Geekery: http://www.mrlizard.com
--
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.
