Failed to gain exclusive lock to the Cloud Firestore client's offline persistence.

[hakobast]

Environment

• Firebase Component:

'firebase_analytics'                      : '21.2.2'
'firebase_crashlytics_gradle'             : '2.9.0'
'firebase_crashlytics'                    : '18.3.7'
'firebase_messageing'                     : '23.1.2'
'firebase_auth'                           : '22.0.0'
'firebase_storage'                        : '20.2.0'
'firestore_ktx'                           : '24.6.0'
'firebase_config_ktx'                     : '21.4.0'
'firebase_perf_ktx'                       : '20.3.2'
'functions_ktx'                           : '20.3.0'
'firebase_perf_gradle'                    : '1.4.2'
'firebase_core'                           : '21.1.1'

Problem

We are constantly receiving spikes of crashes related to the Firestore. Seems like something related to the sqlite db lock. Messages say that could be multiprocess issue when Application class gets initialized by multiple processes but we do not have it configured explicitly. I don't know any other ways that it could happen. On our devices we are not able to reproduce the issue.

Caused by java.lang.RuntimeException: java.lang.RuntimeException: Failed to gain exclusive lock to the Cloud Firestore client's offline persistence. This generally means you are using Cloud Firestore from multiple processes in your app. Keep in mind that multi-process Android apps execute the code in your Application class in all processes, so you may need to avoid initializing Cloud Firestore in your Application class. If you are intentionally using Cloud Firestore from multiple processes, you can only enable offline persistence (that is, call setPersistenceEnabled(true)) in one of them. at com.google.firebase.firestore.util.AsyncQueue$SynchronizedShutdownAwareExecutor.lambda$executeAndReportResult$1(AsyncQueue.java:30) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:457) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:301) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1162) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:636) at com.google.firebase.firestore.util.AsyncQueue$SynchronizedShutdownAwareExecutor$DelayedStartFactory.run(AsyncQueue.java:15) at java.lang.Thread.run(Thread.java:764)

Caused by android.database.sqlite.SQLiteDatabaseLockedException: database is locked (code 5): , while compiling: PRAGMA journal_mode at android.database.sqlite.SQLiteConnection.nativePrepareStatement(SQLiteConnection.java) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:903) at android.database.sqlite.SQLiteConnection.executeForString(SQLiteConnection.java:648) at android.database.sqlite.SQLiteConnection.setJournalMode(SQLiteConnection.java:334) at android.database.sqlite.SQLiteConnection.setWalModeFromConfiguration(SQLiteConnection.java:306) at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:216) at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:194) at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:493) at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:200) at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:192) at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:869) at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:854) at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:729) at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:719) at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:295) at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:238) at com.google.firebase.firestore.local.SQLitePersistence.u1(SQLitePersistence.java:17) at com.google.firebase.firestore.core.ComponentProvider.initialize(ComponentProvider.java:68) at com.google.firebase.firestore.core.FirestoreClient.initialize(FirestoreClient.java:68) at com.google.firebase.firestore.core.FirestoreClient.lambda$new$0(FirestoreClient.java:48) at com.google.firebase.firestore.util.AsyncQueue.lambda$enqueue$2(AsyncQueue.java:2) at com.google.firebase.firestore.util.AsyncQueue$SynchronizedShutdownAwareExecutor.lambda$executeAndReportResult$1(AsyncQueue.java:16) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:457) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:301) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1162) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:636) at com.google.firebase.firestore.util.AsyncQueue$SynchronizedShutdownAwareExecutor$DelayedStartFactory.run(AsyncQueue.java:15) at java.lang.Thread.run(Thread.java:764)

Stacktrace

<uses-permission
    android:name="android.permission.WRITE_EXTERNAL_STORAGE"
    android:maxSdkVersion="28" />
<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.INTERNET" />

<application
    android:name=".App"
    android:allowBackup="false"
    android:dataExtractionRules="@xml/data_extraction_rules"
    android:icon="@mipmap/ic_launcher"
    android:label="@string/app_name"
    android:localeConfig="@xml/locales_config"
    android:roundIcon="@mipmap/ic_launcher_round"
    android:supportsRtl="true"
    android:theme="@style/AppTheme">

    <activity
        android:name="***"
        android:exported="true"
        android:launchMode="singleTask"
        android:theme="@style/AppTheme.Launcher">

    </activity>
    <activity
        android:name="***"
        android:exported="true"
        android:launchMode="singleTask"
        android:theme="@style/AppTheme.Launcher">

    </activity>
    <activity
        android:name="***"
        android:exported="true"
        android:launchMode="singleTask"
        android:theme="@style/AppTheme.Launcher">

    </activity>

    <activity
        android:name=".ui.screen.splash.SplashActivity"
        android:exported="true"
        android:screenOrientation="userPortrait"
        android:theme="@style/AppTheme.Launcher">
        <intent-filter>
            <action android:name="android.intent.action.MAIN" />

            <category android:name="android.intent.category.LAUNCHER" />
        </intent-filter>
    </activity>
    <activity
        android:name=".ui.screen.main.MainActivity"
        android:screenOrientation="userPortrait"
        android:windowSoftInputMode="adjustPan" />

</application>

Android manifest

[google-oss-bot]

I found a few problems with this issue:

• I couldn't figure out how to label this issue, so I've labeled it for a human to triage. Hang tight.
• This issue does not seem to follow the issue template. Make sure you provide all the required information.

[cherylEnkidu]

Hi,
Can you share with us the manifest for your Android App? There is a chance you use multi processes and you are not aware of that. In the meantime, these are some tickets experienced similar issue #3029 #953 you might get a hint from these tickets.

[hakobast]

Hi,
Can you share with us the manifest for your Android App? There is a chance you use multi processes and you are not aware of that. In the meantime, these are some tickets experienced similar issue #3029 #953 you might get a hint from these tickets.

Sure, Added to description.

[hakobast]

@cherylEnkidu sorry for pinging you, is there anything that I can try to fix it or understand the issue?

[cherylEnkidu]

Hi @hakobast ,

I didn't find anything special in your configuration that would possibly lead to this problem. And without reproduced app we cannot further investigate on our side. Some suggestions that might be helpful is:

• Search for Thread keyword , check if there is any use inside the codebase that might related.
• If it is happened on a specific device, run the app on a real device to reproduce it.
• See if it is possible user install same app twice on their devices.