The database file is locked (database is locked)

来源：互联网发布：asp源码修改工具编辑：程序博客网时间：2024/05/21 11:10

java.lang.RuntimeException: org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)
at UserManager.addContract(UserManager.java:154)
at UserManager.run(UserManager.java:234)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)
at org.sqlite.core.DB.newSQLException(DB.java:918)
at org.sqlite.core.DB.newSQLException(DB.java:930)
at org.sqlite.core.DB.throwex(DB.java:895)
at org.sqlite.core.NativeDB.prepare(Native Method)
at org.sqlite.core.DB.prepare(DB.java:227)
at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:41)
at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30)
at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:48)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:254)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:226)
at UserManager.addContract(UserManager.java:147)
... 2 more

Linux环境并发运行执行对sqlite数据库文件的操作会出现如上报错，Win下暂时未发现这样的问题(100个线程，同时读写操作)。暂未解决...

0 0