org.h2.jdbc.JdbcSQLException

tip

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


rafaelrafael

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: Connection is broken: "java.net.ConnectException: Connection refused: connect: localhost" [90067-174] at org.h2.message.DbException.getJdbcSQLException(DbException.java:332) at org.h2.message.DbException.get(DbException.java:161) at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:417) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:305) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90) at org.h2.Driver.connect(Driver.java:73) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source)

    Users with the same issue

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