记录工作中遇到的错误:Database may be already in use Locked by another process: .......“.

最新推荐文章于 2024-04-27 19:36:14 发布

只为你BUG

最新推荐文章于 2024-04-27 19:36:14 发布

阅读量2.6k

点赞数

分类专栏： SpringMVC 文章标签：数据库 jar java

本文链接：https://blog.csdn.net/dingchenxi88/article/details/122576264

版权

SpringMVC 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

配置情况

spring:
  datasource:
    url: jdbc:h2:file:.......省略..;AUTO_SERVER=TRUE;FILE_LOCK=NO
    driverClassName: org.h2.Driver
    username: sa
    password: ''
    platform: h2

日志情况

org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already in use: "Locked by another process:.....". Possible solutions: close all other connection(s); use the server mode [90020-200]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:622) ~[h2-1.4.200.jar!/:?]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2-1.4.200.jar!/:?]
	at org.h2.message.DbException.get(DbException.java:205) ~[h2-1.4.200.jar!/:?]
	at org.h2.message.DbException.get(DbException.java:181) ~[h2-1.4.200.jar!/:?]
	at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:433) ~[h2-1.4.200.jar!/:?]
	at org.h2.store.FileLock.lockFile(FileLock.java:325) ~[h2-1.4.200.jar!/:?]
	at org.h2.store.FileLock.lock(FileLock.java:108) ~[h2-1.4.200.jar!/:?]
	at org.h2.engine.Database.open(Database.java:656) ~[h2-1.4.200.jar!/:?]
	at org.h2.engine.Database.openDatabase(Database.java:307) ~[h2-1.4.200.jar!/:?]
	at org.h2.engine.Database.<init>(Database.java:301) ~[h2-1.4.200.jar!/:?]
	at org.h2.engine.Engine.openSession(Engine.java:74) ~[h2-1.4.200.jar!/:?]
	at org.h2.engine.Engine.openSession(Engine.java:192) ~[h2-1.4.200.jar!/:?]
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:171) ~[h2-1.4.200.jar!/:?]
	at org.h2.engine.Engine.createSession(Engine.java:166) ~[h2-1.4.200.jar!/:?]
	at org.h2.engine.Engine.createSession(Engine.java:29) ~[h2-1.4.200.jar!/:?]
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:340) ~[h2-1.4.200.jar!/:?]
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:173) ~[h2-1.4.200.jar!/:?]
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:152) ~[h2-1.4.200.jar!/:?]
	at org.h2.Driver.connect(Driver.java:69) ~[h2-1.4.200.jar!/:?]
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-3.4.5.jar!/:?]
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358) ~[HikariCP-3.4.5.jar!/:?]
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-3.4.5.jar!/:?]
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477) ~[HikariCP-3.4.5.jar!/:?]
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560) ~[HikariCP-3.4.5.jar!/:?]
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[HikariCP-3.4.5.jar!/:?]