Skip to content

SQLite error bind on a busy prepared statement #1552

Closed
@SchroterQuentin

Description

@SchroterQuentin

Library Version

Version 3.0.0

.NET Runtime

dotnet 7.0

Operating System / Device Details

mcr.microsoft.com/dotnet/aspnet:7.0

Log Output

2023-7-3 02:00:16.029+00:00 [.NET ThreadPool Worker]| ERROR) [Database] SQLite error (code 21): bind on a busy prepared statement: [SELECT purgeCnt FROM kvmeta WHERE name=?]
2023-7-3 02:00:16.029+00:00 [.NET ThreadPool Worker]| ERROR) [Database] SQLite error (code 21): misuse at line 84119 of [0c1fcf4711]
2023-7-3 02:00:16.031+00:00 [.NET ThreadPool Worker]| ERROR) [Database] another row available (21/0)

2023-7-3 02:01:16.189+00:00 [.NET ThreadPool Worker]| ERROR) [Database] SQLite error (code 21): bind on a busy prepared statement: [SELECT purgeCnt FROM kvmeta WHERE name=?]
2023-7-3 02:01:16.189+00:00 [.NET ThreadPool Worker]| ERROR) [Database] SQLite error (code 21): misuse at line 84119 of [0c1fcf4711]
2023-7-3 02:01:16.189+00:00 [.NET ThreadPool Worker]| ERROR) [Database] not an error (21/0)

2023-7-3 01:59:38.032+00:00 [.NET ThreadPool Worker]| ERROR) [Database] SQLite error (code 21): misuse at line 84119 of [0c1fcf4711]
2023-7-3 01:59:38.032+00:00 [.NET ThreadPool Worker]| ERROR) [Database] bad parameter or other API misuse (21/21)
[13:59:38 ERR] [Grpc.AspNetCore.Server.ServerCallHandler] Error when executing service method 'Get'.
Couchbase.Lite.CouchbaseSQLiteException: CouchbaseLiteException (SQLiteDomain / 21): bad parameter or other API misuse.
at LiteCore.Interop.NativeHandler.ThrowOrHandle()
at LiteCore.Interop.NativeHandler.Execute(C4TryLogicDelegate2 block)
at Couchbase.Lite.Support.ThreadSafety.DoLockedBridge(C4TryLogicDelegate2 a)
at Couchbase.Lite.Internal.Query.NQuery.Execute()

Expected behavior

No error.

Steps To Reproduce

Unfortunately it seems to appear since we use dotnet 7 and version 3.0 of couchbase lite. It randomly appears and may cause the application to crash completely after some time.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions