SQLite 锁定问题

收藏

本帖最后由 jacke_he 于 2022-8-3 11:55 编辑

在设计器环境下工作，正常只有我一个人工作，但发现部分数据库更新没有，查询一堆这种locked，是否有什么设置需要处理，若是正式环境不能更加麻烦

SQLite error (261): database is locked in "select a.[型体编号] as C0,a.[ID] as C1 from [main].[项目档案主表] as a Where a.[项目编号] = @p0 ORDER BY a.[ID] ASC"
SQLite error (261): database is locked in "

RAGMA journal_mode = WAL

RAGMA legacy_alter_table = true"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[全名] = @p0  ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[用户名] = @p0  ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[全名] = @p0  ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[ID] as C0 from [main].[任务接收与分派主表] as a  Where a.[ID] = @p0  ORDER BY a.[ID] ASC limit 1"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[全名]  is null ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[用户名] = @p0  ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[用户名] = @p0  ORDER BY a.[用户名] ASC"
Tid:64 2022-07-29 08:34:02: Set ServerInfo to NUll
Tid:60 2022-07-29 08:34:03: InitialServerInfos
Tid:60 2022-07-29 08:34:03: infoStr.length:122406
Tid:60 2022-07-29 08:34:03: Init ServerInfo
Tid:63 2022-07-29 08:34:04: InitialPageAuthorizeInfos
Tid:65 2022-07-29 08:34:09: Begin EnsureHiddenUserInfoTable
Tid:65 2022-07-29 08:34:09: End EnsureHiddenUserInfoTable
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[用户名]  is null ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "

RAGMA journal_mode = WAL

RAGMA legacy_alter_table = true"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[全名] = @p0  ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[用户名] = @p0  ORDER BY a.[用户名] ASC"
SQLite error (261): database is locked in "select a.[用户名] as C0 from [main].[用户信息视图] as a  Where a.[用户名] = @p0  ORDER BY a.[用户名] ASC"
Tid:89 2022-07-29 08:48:29: Set ServerInfo to NUll
Tid:89 2022-07-29 08:48:29: InitialServerInfos
Tid:89 2022-07-29 08:48:29: infoStr.length:122431
Tid:89 2022-07-29 08:48:29: Init ServerInfo
Tid:89 2022-07-29 08:48:31: InitialPageAuthorizeInfos
Tid:94 2022-07-29 08:48:35: Begin EnsureHiddenUserInfoTable
Tid:94 2022-07-29 08:48:35: End EnsureHiddenUserInfoTable