Must be called during a transaction (CouchbaseLite Android v3.1.0-425@33 (EE/release, Commit/3f009a25f8@934af6e32f2a Core/3.1.0 (356) at 2023-04-14T04:06:14.503123Z) on Java; Android 12; SM-T500)

Mobile
1

Sometimes we are facing this issue, as it gets triggered during the data-saving process into the database, but the data is not being saved. We encounter the following error:

Note: We are unable to catch the error all the time, but errors are being recorded in production, and data is not being saved.

Couchbase version: “com.couchbase.lite:couchbase-lite-android-ee:3.1.0”

Error: “must be called during a transaction”
(CouchbaseLite Android v3.1.0-425@33 (EE/release, Commit/3f009a25f8@934af6e32f2a Core/3.1.0 (356) at 2023-04-14T04:06:14.503123Z) on Java; Android 12; SM-T500)

Code:
return withContext(backgroundDispatcher) {

        val queryResult = kotlin.runCatching {

            val map = converter.toMap(model).toMutableMap().apply {
                this.remove("_id")
            }
            val document = MutableDocument(id, map)
            
            cbHelper.getDataBase().defaultCollection?.save(
                document
            ) { newDoc, curDoc ->
                if (curDoc == null) {
                    // No existing document, treat it as creation
                    true
                } else {
                    val resolvedDoc = MutableDocument(newDoc.id)

                    // Remove the _id key from newDoc before merging
                    val newDataMap: MutableMap<String, Any> = newDoc.toMap().toMutableMap()
                    newDataMap.remove("_id")

                    // Merge the data from newDoc and curDoc

                    val mergedDataMap: MutableMap<String, Any> = mutableMapOf()
                    mergedDataMap.putAll(curDoc.toMap())
                    mergedDataMap.putAll(newDataMap)
                    resolvedDoc.setData(mergedDataMap)
                    true
                }
            }
            

            document.id
        }

        queryResult.getOrNull()
            ?.let { docId -> getDocument(docId) }
            ?: kotlin.run {
                val error =queryResult.exceptionOrNull()!!
                Log.d("Error Save/Update",error.toString())
                QueryResult.error(error)
            }
    }

Please help us to fix the error

2

I realize that it may be difficult but I am going to need a stack trace to have any chance of addressing this.

3

Thanks for the reply but we are not able to get this in development as i told, we are able to see logs in production, please find the logs below,

QueryResultError -StackTrace : CouchbaseLiteException{CouchbaseLite,17,‘must be called during a transaction
(CouchbaseLite Android v3.1.0-425@33 (EE/release, Commit/3f009a25f8@934af6e32f2a Core/3.1.0 (356) at 2023-04-14T04:06:14.503123Z) on Java; Android 13; SM-T575)’}
at com.couchbase.lite.Collection.saveInTransaction(Collection.java:904)
at com.couchbase.lite.Collection.saveLocked(Collection.java:670)
at com.couchbase.lite.Collection.saveWithConflictHandler(Collection.java:613)
at com.couchbase.lite.Collection.save(Collection.java:257)
at xxxx.xxxxxxxx.xxxxx.data.internal.impl.DataSourceImplSession$saveUserSession$$inlined$saveDocument$1.invokeSuspend(DeModelQuery.kt:96)
at xxxx.xxxxxxxx.xxxxx.data.internal.impl.DataSourceImplSession$saveUserSession$$inlined$saveDocument$1.invoke(Unknown Source:8)
at xxxx.xxxxxxxx.xxxxx.data.internal.impl.DataSourceImplSession$saveUserSession$$inlined$saveDocument$1.invoke(Unknown Source:4)
at kotlinx.coroutines.intrinsics.UndispatchedKt.startUndispatchedOrReturn(Undispatched.kt:89)
at kotlinx.coroutines.BuildersKt__Builders_commonKt.withContext(Builders.common.kt:166)
at kotlinx.coroutines.BuildersKt.withContext(Unknown Source:1)
at xxxx.xxxxxxxx.xxxxx.data.internal.impl.DataSourceImplSession.saveUserSession(DataSourceImplSession.kt:123)
at xxxx.xxxxxxxx.xxxxx.data.dataSources.repos.RepoSession.saveUserSession(RepoSession.kt:17)
at xxxx.xxxxxxxx.xxxxx.features.session.ForegroundBackgroundListener.createNewAppSession$addAppSessionToUserSession(ForegroundBackgroundListener.kt:123)
at xxxx.xxxxxxxx.xxxxx.features.session.ForegroundBackgroundListener.access$createNewAppSession$addAppSessionToUserSession(ForegroundBackgroundListener.kt:21)
at xxxx.xxxxxxxx.xxxxx.features.session.ForegroundBackgroundListener$createNewAppSession$1.invokeSuspend(ForegroundBackgroundListener.kt:145)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:106)
at kotlinx.coroutines.internal.LimitedDispatcher.run(LimitedDispatcher.kt:42)
at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:95)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:570)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:749)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:677)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:664)
Caused by: LiteCoreException{1, 17, “must be called during a transaction”}
at com.couchbase.lite.internal.core.C4Document.createFromSlice(Native Method)
at com.couchbase.lite.internal.core.C4Document.create(C4Document.java:52)
at com.couchbase.lite.internal.core.C4Collection.createDocument(C4Collection.java:182)
at com.couchbase.lite.Collection.createC4Document(Collection.java:585)
at com.couchbase.lite.Collection.saveInTransaction(Collection.java:898)
… 22 more

4

I’m not entirely sure what is going on, here: I haven’t had time, yet, to examine it in detail. Looking at the code, I would say that it is impossible.

Here is the code that is producing the error:

        db.beginTransaction();
        try {
            try {
                saveInTransaction(document, (baseDoc == null) ? null : baseDoc.getC4doc(), deleting);
                commit = true;
                return;
            }
            catch (CouchbaseLiteException e) {
                if (!CouchbaseLiteException.isConflict(e)) { throw e; }
            }
            ...

The call to saveInTransaction cannot be reached except within a transaction, in the normal execution of this code.

I’m going to wildly point an accusing finger at Kotlin coroutines.

I have opened ticket CBL-4978 to track this issue.

5

@Sreenivasulu
Is there any chance you can show me the code for the method:

xxxx.xxxxxxxx.xxxxx.data.internal.impl.DataSourceImplSession$saveUserSession

It would be a huge help.

Also of considerable help would be logs from around the time this error takes place.

FWIW, I cannot find any way to attribute this to an issue with the use of Kotlin Coroutines.

6

@blake.meike
We are just sending the pojo to above model

override suspend fun saveUserSession(userSession: UserSession): Boolean {
return DatabseModelQuery.from(heelper)
.saveDocument(userSession)
.getOrNull() != null
}

If the database becomes locked, will we encounter this issue?

7

I’m not exactly sure of what you mean when you say “if the database becomes locked”.

Here’s what I can say: Database use is, essentially, single threaded. Nearly every call to a method that uses the database will seize a lock that prevents any other access until the first call completes. It is possible to do some concurrent processing by opening two different instances of the same database… but even then, file access is single threaded: a long running query, for instance, will block all other access until it completes.

Can you tell me which of the methods in saveUserSession are suspend methods?

As I say, if you can share logs that would be tremendously helpful.

8

@blake.meike saveDocument(userSession) is the one is suspend function, As I told earlier we didn’t faced this in development environment, If I get it will post it immediately.

9

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.