org.h2.jdbc.JdbcSQLException

tip

Check if you're not creating unused SQL entities, as it might cause this exception.


rafael

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Cannot Connect over TCP - I suck
    via by bxgrant,
  • #1: {code} 06:11:43.940 ERROR [pool-15-thread-1] [DownloadFilesHandler:152] Read timed out java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) ~[na:1.8.0_92] at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) ~[na:1.8.0_92] at java.net.SocketInputStream.read(SocketInputStream.java:170) ~[na:1.8.0_92] at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[na:1.8.0_92] at sun.security.ssl.InputRecord.readFully(InputRecord.java:465) ~[na:1.8.0_92] at sun.security.ssl.InputRecord.readV3Record(InputRecord.java:593) ~[na:1.8.0_92] at sun.security.ssl.InputRecord.read(InputRecord.java:532) ~[na:1.8.0_92] at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:973) ~[na:1.8.0_92] at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:930) ~[na:1.8.0_92] at sun.security.ssl.AppInputStream.read(AppInputStream.java:105) ~[na:1.8.0_92] at org.apache.http.impl.conn.LoggingInputStream.read(LoggingInputStream.java:87) ~[httpclient-4.5.1.jar:4.5.1] at org.apache.http.impl.io.SessionInputBufferImpl.streamRead(SessionInputBufferImpl.java:139) ~[httpcore-4.4.3.jar:4.4.3] at org.apache.http.impl.io.SessionInputBufferImpl.fillBuffer(SessionInputBufferImpl.java:155) ~[httpcore-4.4.3.jar:4.4.3] at org.apache.http.impl.io.SessionInputBufferImpl.read(SessionInputBufferImpl.java:208) ~[httpcore-4.4.3.jar:4.4.3] at org.apache.http.impl.io.ContentLengthInputStream.read(ContentLengthInputStream.java:178) ~[httpcore-4.4.3.jar:4.4.3] at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:137) ~[httpclient-4.5.1.jar:4.5.1] at org.apache.commons.io.input.ProxyInputStream.read(ProxyInputStream.java:98) ~[commons-io-2.4.jar:2.4] at java.io.FilterInputStream.read(FilterInputStream.java:133) ~[na:1.8.0_92] at java.io.PushbackInputStream.read(PushbackInputStream.java:186) ~[na:1.8.0_92] at java.util.zip.InflaterInputStream.fill(InflaterInputStream.java:238) ~[na:1.8.0_92] at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:158) ~[na:1.8.0_92] at java.util.zip.ZipInputStream.read(ZipInputStream.java:194) ~[na:1.8.0_92] at java.io.FilterInputStream.read(FilterInputStream.java:107) ~[na:1.8.0_92] at org.apache.commons.io.input.ProxyInputStream.read(ProxyInputStream.java:77) ~[commons-io-2.4.jar:2.4] at java.nio.file.Files.copy(Files.java:2908) ~[na:1.8.0_92] at java.nio.file.Files.copy(Files.java:3027) ~[na:1.8.0_92] at com.liferay.sync.engine.documentlibrary.handler.DownloadFileHandler.copyFile(DownloadFileHandler.java:210) ~[com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.documentlibrary.handler.DownloadFilesHandler.doHandleResponse(DownloadFilesHandler.java:146) ~[com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.documentlibrary.handler.BaseHandler.handleResponse(BaseHandler.java:194) [com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.documentlibrary.handler.BaseHandler.handleResponse(BaseHandler.java:55) [com.liferay.sync.engine-3.1.1.jar:na] at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:222) [httpclient-4.5.1.jar:4.5.1] at com.liferay.sync.engine.session.Session.execute(Session.java:305) [com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.session.Session$2.run(Session.java:273) [com.liferay.sync.engine-3.1.1.jar:na] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_92] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_92] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_92] 06:11:43.941 DEBUG [pool-15-thread-1] [DownloadFilesHandler:162] Unexpected end of ZLIB input stream java.io.EOFException: Unexpected end of ZLIB input stream at java.util.zip.InflaterInputStream.fill(InflaterInputStream.java:240) ~[na:1.8.0_92] at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:158) ~[na:1.8.0_92] at java.util.zip.ZipInputStream.read(ZipInputStream.java:194) ~[na:1.8.0_92] at java.util.zip.ZipInputStream.closeEntry(ZipInputStream.java:140) ~[na:1.8.0_92] at java.util.zip.ZipInputStream.getNextEntry(ZipInputStream.java:118) ~[na:1.8.0_92] at com.liferay.sync.engine.documentlibrary.handler.DownloadFilesHandler.doHandleResponse(DownloadFilesHandler.java:102) ~[com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.documentlibrary.handler.BaseHandler.handleResponse(BaseHandler.java:194) [com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.documentlibrary.handler.BaseHandler.handleResponse(BaseHandler.java:55) [com.liferay.sync.engine-3.1.1.jar:na] at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:222) [httpclient-4.5.1.jar:4.5.1] at com.liferay.sync.engine.session.Session.execute(Session.java:305) [com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.session.Session$2.run(Session.java:273) [com.liferay.sync.engine-3.1.1.jar:na] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_92] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_92] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_92] {code} #2: {code} 08:53:46.516 DEBUG [pool-9-thread-3] [SyncAccountService:240] IO Exception: "java.net.UnknownHostException: Liferays-MacBook-Pro-21.local: Liferays-MacBook-Pro-21.local: unknown error" [90028-174] org.h2.jdbc.JdbcSQLException: IO Exception: "java.net.UnknownHostException: Liferays-MacBook-Pro-21.local: Liferays-MacBook-Pro-21.local: unknown error" [90028-174] at org.h2.message.DbException.getJdbcSQLException(DbException.java:332) ~[h2-1.3.174.jar:1.3.174] at org.h2.message.DbException.get(DbException.java:161) ~[h2-1.3.174.jar:1.3.174] at org.h2.message.DbException.convert(DbException.java:276) ~[h2-1.3.174.jar:1.3.174] at org.h2.util.NetUtils.getLocalAddress(NetUtils.java:263) ~[h2-1.3.174.jar:1.3.174] at org.h2.server.TcpServer.getURL(TcpServer.java:195) ~[h2-1.3.174.jar:1.3.174] at org.h2.tools.Server.start(Server.java:462) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Database.startServer(Database.java:713) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Database.open(Database.java:577) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Database.openDatabase(Database.java:236) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Database.<init>(Database.java:231) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Engine.openSession(Engine.java:56) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Engine.openSession(Engine.java:160) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Engine.createSessionAndValidate(Engine.java:139) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Engine.createSession(Engine.java:122) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Engine.createSession(Engine.java:28) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:323) ~[h2-1.3.174.jar:1.3.174] at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105) ~[h2-1.3.174.jar:1.3.174] at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90) ~[h2-1.3.174.jar:1.3.174] at org.h2.Driver.connect(Driver.java:73) ~[h2-1.3.174.jar:1.3.174] at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[na:1.8.0_92] at java.sql.DriverManager.getConnection(DriverManager.java:208) ~[na:1.8.0_92] at com.j256.ormlite.jdbc.JdbcConnectionSource.makeConnection(JdbcConnectionSource.java:252) ~[ormlite-jdbc-4.48.jar:na] at com.j256.ormlite.jdbc.JdbcPooledConnectionSource.getReadWriteConnection(JdbcPooledConnectionSource.java:136) ~[ormlite-jdbc-4.48.jar:na] at com.j256.ormlite.jdbc.JdbcPooledConnectionSource.getReadOnlyConnection(JdbcPooledConnectionSource.java:111) ~[ormlite-jdbc-4.48.jar:na] at com.j256.ormlite.dao.BaseDaoImpl.queryForId(BaseDaoImpl.java:221) ~[ormlite-core-4.48.jar:na] at com.liferay.sync.engine.service.SyncAccountService.fetchSyncAccount(SyncAccountService.java:236) ~[com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.filesystem.SyncWatchEventProcessor.run(SyncWatchEventProcessor.java:134) [com.liferay.sync.engine-3.1.1.jar:na] {code}
    via by Shinn Lok,
    • org.h2.jdbc.JdbcSQLException: ファイル "/Users/taichi" を作成中にエラーが発生しました Error while creating file "/Users/taichi" [90062-190] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.store.fs.FilePathDisk.createDirectory(FilePathDisk.java:274) at org.h2.store.fs.FileUtils.createDirectory(FileUtils.java:42) at org.h2.store.fs.FileUtils.createDirectories(FileUtils.java:309) at org.h2.store.fs.FileUtils.createDirectories(FileUtils.java:308) at org.h2.store.fs.FileUtils.createDirectories(FileUtils.java:308) at org.h2.store.fs.FileUtils.createDirectories(FileUtils.java:308) at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:73) at org.h2.engine.Database.getPageStore(Database.java:2450) at org.h2.engine.Database.open(Database.java:672) at org.h2.engine.Database.openDatabase(Database.java:269) at org.h2.engine.Database.<init>(Database.java:263) at org.h2.engine.Engine.openSession(Engine.java:65) at org.h2.engine.Engine.openSession(Engine.java:175) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:153) at org.h2.engine.Engine.createSession(Engine.java:136) at org.h2.engine.Engine.createSession(Engine.java:28) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:107) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:91) at org.h2.Driver.connect(Driver.java:72) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at dao.MutterDAO.findAll(MutterDAO.java:25) at model.GetMutterListLogic.execute(GetMutterListLogic.java:11) at servlet.Main.doGet(Main.java:27) at javax.servlet.http.HttpServlet.service(HttpServlet.java:624) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)

    Users with the same issue

    Andreas Häber
    114 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    144 more bugmates