iOS App Crashed on app launch - Firebase SQL file not found

[smahajan28]

Description

Our app is crashing on early launch due to firebase.

Fatal Exception: NSInternalInconsistencyException
Could not create RMQ database at path /var/mobile/Containers/Data/Application/372D4296-3F35-46FD-B3C9-0A20877B8378/Library/Application Support/Google/FirebaseMessaging/rmq2.sqlite, error: 14 - unable to open database file

Firebase versions - 10.27.0
Dependency Manager - SPM
Coming across all the devices
95% Cases in iOS 18

Stack Trace - 
Main Thread : 
0x12e637c -[FIRMessagingRmqManager loadInitialOutgoingPersistentId] + 178 (FIRMessagingRmqManager.m:178)
0x12e6280 -[FIRMessagingRmqManager loadRmqId] + 154 (FIRMessagingRmqManager.m:154)
0x12dbbf8 -[FIRMessaging setupRmqManager] + 327 (FIRMessaging.m:327)
0x12dba9c -[FIRMessaging start] + 303 (FIRMessaging.m:303)
0x12db460 __36+[FIRMessaging componentsToRegister]_block_invoke + 193 (FIRMessaging.m:193)
0x110d980 -[FIRComponentContainer instantiateInstanceForProtocol:withBlock:] + 160 (FIRComponentContainer.m:160)
0x110dafc -[FIRComponentContainer instanceForProtocol:] + 199 (FIRComponentContainer.m:199)
0x110d884 -[FIRComponentContainer instantiateEagerComponents] + 137 (FIRComponentContainer.m:137)
0x110a8bc +[FIRApp configureWithName:options:] + 199 (FIRApp.m:199)
0x110a56c +[FIRApp configureWithOptions:] + 133 (FIRApp.m:133)
0x3cb4ec AppDelegate.application(_:didFinishLaunchingWithOptions:) + 293 (AppDelegate.swift:293)
0x3cbb30 @objc AppDelegate.application(_:didFinishLaunchingWithOptions:) + 4343839536 (<compiler-generated>:4343839536)

Crashed: com.google.firebase.crashlytics.ios.exception
SIGABRT ABORT 0x00000001e78561dc

FIRMessagingRmqManager.m - Line 505
__38-[FIRMessagingRmqManager openDatabase]_block_invoke + 505
FIRCLSProcess.c - Line 392
FIRCLSProcessRecordAllThreads + 392

FIRCLSHandler.m - Line 34
FIRCLSHandler + 34

FIRCLSException.mm - Line 240
__FIRCLSExceptionRecord_block_invoke + 240

FIRCLSException.mm - Line 242
FIRCLSExceptionRecord + 242

FIRCLSException.mm - Line 407
FIRCLSTerminateHandler() + 407

Reproducing the issue

No response

Firebase SDK Version

10.27.0

Xcode Version

16.2

Installation Method

Swift Package Manager

Firebase Product(s)

Crashlytics, Messaging, Remote Config

Targeted Platforms

iOS

Relevant Log Output

If using Swift Package Manager, the project's Package.resolved

Expand Package.resolved snippet

{
  "originHash" : "xxxx",
  "pins" : [
    {
      "identity" : "abseil-cpp-binary",
      "kind" : "remoteSourceControl",
      "location" : "https://github.com/google/abseil-cpp-binary.git",
      "state" : {
        "revision" : "194a6706acbd25e4ef639bcaddea16e8758a3e27",
        "version" : "1.2024011602.0"
      }
    },
    {
      "identity" : "app-check",
      "kind" : "remoteSourceControl",
      "location" : "https://github.com/google/app-check.git",
      "state" : {
        "revision" : "3b62f154d00019ae29a71e9738800bb6f18b236d",
        "version" : "10.19.2"
      }
    },
    {
      "identity" : "firebase-ios-sdk",
      "kind" : "remoteSourceControl",
      "location" : "https://github.com/firebase/firebase-ios-sdk.git",
      "state" : {
        "revision" : "8bcaf973b1d84e119b7c7c119abad72ed460979f",
        "version" : "10.27.0"
      }
    },
    {
      "identity" : "googleappmeasurement",
      "kind" : "remoteSourceControl",
      "location" : "https://github.com/google/GoogleAppMeasurement.git",
      "state" : {
        "revision" : "70df02431e216bed98dd461e0c4665889245ba70",
        "version" : "10.27.0"
      }
    },
    {
      "identity" : "googledatatransport",
      "kind" : "remoteSourceControl",
      "location" : "https://github.com/google/GoogleDataTransport.git",
      "state" : {
        "revision" : "a637d318ae7ae246b02d7305121275bc75ed5565",
        "version" : "9.4.0"
      }
    },
    {
      "identity" : "googleutilities",
      "kind" : "remoteSourceControl",
      "location" : "https://github.com/google/GoogleUtilities.git",
      "state" : {
        "revision" : "57a1d307f42df690fdef2637f3e5b776da02aad6",
        "version" : "7.13.3"
      }
    },
    {
      "identity" : "grpc-binary",
      "kind" : "remoteSourceControl",
      "location" : "https://github.com/google/grpc-binary.git",
      "state" : {
        "revision" : "e9fad491d0673bdda7063a0341fb6b47a30c5359",
        "version" : "1.62.2"
      }
    },
    {
      "identity" : "gtm-session-fetcher",
      "kind" : "remoteSourceControl",
      "location" : "https://github.com/google/gtm-session-fetcher.git",
      "state" : {
        "revision" : "a2ab612cb980066ee56d90d60d8462992c07f24b",
        "version" : "3.5.0"
      }
    },
    {
      "identity" : "interop-ios-for-google-sdks",
      "kind" : "remoteSourceControl",
      "location" : "https://github.com/google/interop-ios-for-google-sdks.git",
      "state" : {
        "revision" : "2d12673670417654f08f5f90fdd62926dc3a2648",
        "version" : "100.0.0"
      }
    },
    {
      "identity" : "leveldb",
      "kind" : "remoteSourceControl",
      "location" : "https://github.com/firebase/leveldb.git",
      "state" : {
        "revision" : "a0bc79961d7be727d258d33d5a6b2f1023270ba1",
        "version" : "1.22.5"
      }
    },
    {
      "identity" : "nanopb",
      "kind" : "remoteSourceControl",
      "location" : "https://github.com/firebase/nanopb.git",
      "state" : {
        "revision" : "b7e1104502eca3a213b46303391ca4d3bc8ddec1",
        "version" : "2.30910.0"
      }
    },
    {
      "identity" : "promises",
      "kind" : "remoteSourceControl",
      "location" : "https://github.com/google/promises.git",
      "state" : {
        "revision" : "540318ecedd63d883069ae7f1ed811a2df00b6ac",
        "version" : "2.4.0"
      }
    }
  ],
  "version" : 3
}

If using CocoaPods, the project's Podfile.lock

Expand Podfile.lock snippet

Replace this line with the contents of your Podfile.lock!

[google-oss-bot]

I couldn't figure out how to label this issue, so I've labeled it for a human to triage. Hang tight.

[smahajan28]

#401

[smahajan28]

#12130

[rizafran]

Thanks for reporting, @smahajan28. I tried to reproduce the issue using the quickstart, but I'm unable to get the same error. Based on the related issue you shared, I'm wondering if your app or other dependency uses sqlite library?

[smahajan28]

We are using Realm as our database. I’m not sure if any other dependencies use SQLite. However, I haven’t encountered any crashes from other dependencies.

[smahajan28]

We’ve noticed this crash only after migrating from cocoa pods to SPM. We upgraded the Firebase SDK to the latest version in the recent release, but the issue persists.

[paulb777]

Based on this and #12130 There may be a race condition with Realm and their usage of sqlite3. A reproducible example would be helpful. cc: @leojaygoogle