looks like you are running on a network drive, and I'd guess the network is
becoming temporarily unavailable.
Lizard Lizard wrote:
> 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.
>
--
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.
