It's mapped as a network drive, but it's a physical location on my c:\ drive, which is where the server and my code are also physically located.
I'll trying changing the mapping. My long-term intent is to have network access; is there a good workaround for this for when it happens? On Thu, Dec 15, 2011 at 2:56 AM, Noel Grandin <[email protected]> wrote: > > 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. >> > > -- ======================= 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.
