org.h2.jdbc.JdbcSQLException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
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.

  • Database may be already in use
    via GitHub by ENMAGames
    ,
  • 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: Database may be already in use: "Locked by another computer: 169.254.80.204". Possible solutions: close all other connection(s); use the server mode [90020-181] 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.FileLock.getExceptionAlreadyInUse(FileLock.java:461) at org.h2.store.FileLock.lockSocket(FileLock.java:397) at org.h2.store.FileLock.lock(FileLock.java:138) at org.h2.engine.Database.open(Database.java:631) at org.h2.engine.Database.openDatabase(Database.java:266) at org.h2.engine.Database.<init>(Database.java:260) at org.h2.engine.Engine.openSession(Engine.java:60) at org.h2.engine.Engine.openSession(Engine.java:167) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145) at org.h2.engine.Engine.createSession(Engine.java:128) at org.h2.engine.Engine.createSession(Engine.java:26) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92) at org.h2.Driver.connect(Driver.java:72) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.esotericsoftware.clippy.util.DataStore.openConnection(DataStore.java:161) at com.esotericsoftware.clippy.util.DataStore.open(DataStore.java:116) at com.esotericsoftware.clippy.ClipDataStore.<init>(ClipDataStore.java:41) at com.esotericsoftware.clippy.Clippy.<init>(Clippy.java:84) at com.esotericsoftware.clippy.Clippy$5.run(Clippy.java:186) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$500(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source)

    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