[FirebaseAnalytics][I-ACS023061] Data loss issue when sending events using firebase analytics #15256
Description
Description
Issue when sending the events using firebase analytics
**9.6.0 - [FirebaseAnalytics][I-ACS023061] Data loss. Unable to update daily event counts. Name, error: AuthenticationSuccess, Error Domain=com.google.gmp.measurement.ErrorDomain Code=3 "Database operation "execute statement" failed with sqlite code 8 and error message "attempt to write a readonly database"" UserInfo={NSLocalizedDescription=Database operation "execute statement" failed with sqlite code 8 and error message "attempt to write a readonly database", APMMonitorContext=execute statement,8,A,4}
9.6.0 - [FirebaseAnalytics][I-ACS023061] Data loss. Unable to update daily event counts. Name, error: OfflineFactor, Error Domain=com.google.gmp.measurement.ErrorDomain Code=3 "Database operation "execute statement" failed with sqlite code 8 and error message "attempt to write a readonly database"" UserInfo={NSLocalizedDescription=Database operation "execute statement" failed with sqlite code 8 and error message "attempt to write a readonly database", APMMonitorContext=execute statement,8,A,4}**
Hello Firebase team we started seeing this issue recently with Firebase analytics events, not sure how to resolve this, any suggestions would be appreciated
Reproducing the issue
No response
Firebase SDK Version
9.6.0
Xcode Version
16
Installation Method
CocoaPods
Firebase Product(s)
Analytics
Targeted Platforms
macOS
Relevant Log Output
9.6.0 - [FirebaseAnalytics][I-ACS023051] Logging event: origin, name, params: app, DisplayScreenChanged, {
DeviceUUID = 748006BD-C9B7-5E9C-A698-21BC27384DD3;
ga_event_origin (_o) = app;
Model = Mac14,6;
OktaDeviceID = 49F5BCFD-FDD1-4026-9E19-9C31F7E4D48C;
OktaOrgDomain = https://okta.okta.com;
OsVersion = 15.6.0;
TraceId = ffe24e229fe34a1d81c1c1249a69d398;
}
9.6.0 - [FirebaseAnalytics][I-ACS023073] Debug mode is enabled. Marking event as debug and real-time. Event name, parameters: DisplayScreenChanged, {
DeviceUUID = 748006BD-C9B7-5E9C-A698-21BC27384DD3;
ga_debug (_dbg) = 1;
ga_event_origin (_o) = app;
ga_realtime (_r) = 1;
Model = Mac14,6;
OktaDeviceID = 49F5BCFD-FDD1-4026-9E19-9C31F7E4D48C;
OktaOrgDomain = https://okta.okta.com;
OsVersion = 15.6.0;
TraceId = ffe24e229fe34a1d81c1c1249a69d398;
}
9.6.0 - [FirebaseAnalytics][I-ACS023061] Data loss. Unable to update daily event counts. Name, error: DisplayScreenChanged, Error Domain=com.google.gmp.measurement.ErrorDomain Code=3 "Database operation "execute statement" failed with sqlite code 8 and error message "attempt to write a readonly database"" UserInfo={NSLocalizedDescription=Database operation "execute statement" failed with sqlite code 8 and error message "attempt to write a readonly database", APMMonitorContext=execute statement,8,A,4}
9.6.0 - [FirebaseAnalytics][I-ACS012056] Transaction failed. Transaction failed
9.6.0 - [FirebaseAnalytics][I-ACS023024] No data to upload. Upload task will not be scheduled
9.6.0 - [FirebaseAnalytics][I-ACS023051] Logging event: origin, name, params: app, OfflineFactorEnrollmentStarted, {
DeviceUUID = 748006BD-C9B7-5E9C-A698-21BC27384DD3;
FactorType = Offline|OTP;
ga_event_origin (_o) = app;
Model = Mac14,6;
OktaDeviceID = 49F5BCFD-FDD1-4026-9E19-9C31F7E4D48C;
OktaOrgDomain = https://okta.okta.com;
OsVersion = 15.6.0;
TraceId = ffe24e229fe34a1d81c1c1249a69d398;
}
9.6.0 - [FirebaseAnalytics][I-ACS023073] Debug mode is enabled. Marking event as debug and real-time. Event name, parameters: OfflineFactorEnrollmentStarted, {
DeviceUUID = 748006BD-C9B7-5E9C-A698-21BC27384DD3;
FactorType = Offline|OTP;
ga_debug (_dbg) = 1;
ga_event_origin (_o) = app;
ga_realtime (_r) = 1;
Model = Mac14,6;
OktaDeviceID = 49F5BCFD-FDD1-4026-9E19-9C31F7E4D48C;
OktaOrgDomain = https://okta.okta.com;
OsVersion = 15.6.0;
TraceId = ffe24e229fe34a1d81c1c1249a69d398;
}
9.6.0 - [FirebaseAnalytics][I-ACS023061] Data loss. Unable to update daily event counts. Name, error: OfflineFactorEnrollmentStarted, Error Domain=com.google.gmp.measurement.ErrorDomain Code=3 "Database operation "execute statement" failed with sqlite code 8 and error message "attempt to write a readonly database"" UserInfo={NSLocalizedDescription=Database operation "execute statement" failed with sqlite code 8 and error message "attempt to write a readonly database", APMMonitorContext=execute statement,8,A,4}
9.6.0 - [FirebaseAnalytics][I-ACS023051] Logging event: origin, name, params: app, DeviceRecoveryEnrollmentSucceeded, {
DeviceUUID = 748006BD-C9B7-5E9C-A698-21BC27384DD3;
ga_event_origin (_o) = app;
Model = Mac14,6;
OktaDeviceID = 49F5BCFD-FDD1-4026-9E19-9C31F7E4D48C;
OktaOrgDomain = https://okta.okta.com;
OsVersion = 15.6.0;
TraceId = ffe24e229fe34a1d81c1c1249a69d398;
}
9.6.0 - [FirebaseAnalytics][I-ACS023073] Debug mode is enabled. Marking event as debug and real-time. Event name, parameters: DeviceRecoveryEnrollmentSucceeded, {
DeviceUUID = 748006BD-C9B7-5E9C-A698-21BC27384DD3;
ga_debug (_dbg) = 1;
ga_event_origin (_o) = app;
ga_realtime (_r) = 1;
Model = Mac14,6;
OktaDeviceID = 49F5BCFD-FDD1-4026-9E19-9C31F7E4D48C;
OktaOrgDomain = https://okta.okta.com;
OsVersion = 15.6.0;
TraceId = ffe24e229fe34a1d81c1c1249a69d398;
}
9.6.0 - [FirebaseAnalytics][I-ACS023061] Data loss. Unable to update daily event counts. Name, error: DeviceRecoveryEnrollmentSucceeded, Error Domain=com.google.gmp.measurement.ErrorDomain Code=3 "Database operation "execute statement" failed with sqlite code 8 and error message "attempt to write a readonly database"" UserInfo={NSLocalizedDescription=Database operation "execute statement" failed with sqlite code 8 and error message "attempt to write a readonly database", APMMonitorContext=execute statement,8,A,4}
9.6.0 - [FirebaseAnalytics][I-ACS012056] Transaction failed. Transaction failed
9.6.0 - [FirebaseAnalytics][I-ACS023024] No data to upload. Upload task will not be scheduledIf using Swift Package Manager, the project's Package.resolved
Expand Package.resolved snippet
Replace this line with the contents of your Package.resolved.
If using CocoaPods, the project's Podfile.lock
Expand Podfile.lock snippet
PODS:
- AppCenter (5.0.4):
- AppCenter/Analytics (= 5.0.4)
- AppCenter/Crashes (= 5.0.4)
- AppCenter/Analytics (5.0.4):
- AppCenter/Core
- AppCenter/Core (5.0.4)
- AppCenter/Crashes (5.0.4):
- AppCenter/Core
- Base32 (1.1.2)
- BlueCryptor (1.0.32)
- BlueECC (1.2.5)
- BlueRSA (1.0.200)
- CocoaLumberjack (3.6.2):
- CocoaLumberjack/Core (= 3.6.2)
- CocoaLumberjack/Core (3.6.2)
- CocoaLumberjack/Swift (3.6.2):
- CocoaLumberjack/Core
- DirectAuth (1.2.0)
- Firebase/AnalyticsWithoutAdIdSupport (9.6.0):
- Firebase/CoreOnly
- FirebaseAnalytics/WithoutAdIdSupport (~> 9.6.0)
- Firebase/CoreOnly (9.6.0):
- FirebaseCore (= 9.6.0)
- Firebase/Crashlytics (9.6.0):
- Firebase/CoreOnly
- FirebaseCrashlytics (~> 9.6.0)
- Firebase/Messaging (9.6.0):
- Firebase/CoreOnly
- FirebaseMessaging (~> 9.6.0)
- Firebase/RemoteConfig (9.6.0):
- Firebase/CoreOnly
- FirebaseRemoteConfig (~> 9.6.0)
- FirebaseABTesting (9.6.0):
- FirebaseCore (~> 9.0)
- FirebaseAnalytics/WithoutAdIdSupport (9.6.0):
- FirebaseCore (~> 9.0)
- FirebaseInstallations (~> 9.0)
- GoogleAppMeasurement/WithoutAdIdSupport (= 9.6.0)
- GoogleUtilities/AppDelegateSwizzler (~> 7.7)
- GoogleUtilities/MethodSwizzler (~> 7.7)
- GoogleUtilities/Network (~> 7.7)
- "GoogleUtilities/NSData+zlib (~> 7.7)"
- nanopb (< 2.30910.0, >= 2.30908.0)
- FirebaseCore (9.6.0):
- FirebaseCoreDiagnostics (~> 9.0)
- FirebaseCoreInternal (~> 9.0)
- GoogleUtilities/Environment (~> 7.7)
- GoogleUtilities/Logger (~> 7.7)
- FirebaseCoreDiagnostics (9.6.0):
- GoogleDataTransport (< 10.0.0, >= 9.1.4)
- GoogleUtilities/Environment (~> 7.7)
- GoogleUtilities/Logger (~> 7.7)
- nanopb (< 2.30910.0, >= 2.30908.0)
- FirebaseCoreInternal (9.6.0):
- "GoogleUtilities/NSData+zlib (~> 7.7)"
- FirebaseCrashlytics (9.6.0):
- FirebaseCore (~> 9.0)
- FirebaseInstallations (~> 9.0)
- GoogleDataTransport (< 10.0.0, >= 9.1.4)
- GoogleUtilities/Environment (~> 7.7)
- nanopb (< 2.30910.0, >= 2.30908.0)
- PromisesObjC (~> 2.1)
- FirebaseInstallations (9.6.0):
- FirebaseCore (~> 9.0)
- GoogleUtilities/Environment (~> 7.7)
- GoogleUtilities/UserDefaults (~> 7.7)
- PromisesObjC (~> 2.1)
- FirebaseMessaging (9.6.0):
- FirebaseCore (~> 9.0)
- FirebaseInstallations (~> 9.0)
- GoogleDataTransport (< 10.0.0, >= 9.1.4)
- GoogleUtilities/AppDelegateSwizzler (~> 7.7)
- GoogleUtilities/Environment (~> 7.7)
- GoogleUtilities/Reachability (~> 7.7)
- GoogleUtilities/UserDefaults (~> 7.7)
- nanopb (< 2.30910.0, >= 2.30908.0)
- FirebaseRemoteConfig (9.6.0):
- FirebaseABTesting (~> 9.0)
- FirebaseCore (~> 9.0)
- FirebaseInstallations (~> 9.0)
- GoogleUtilities/Environment (~> 7.7)
- "GoogleUtilities/NSData+zlib (~> 7.7)"
- GoogleAppMeasurement/WithoutAdIdSupport (9.6.0):
- GoogleUtilities/AppDelegateSwizzler (~> 7.7)
- GoogleUtilities/MethodSwizzler (~> 7.7)
- GoogleUtilities/Network (~> 7.7)
- "GoogleUtilities/NSData+zlib (~> 7.7)"
- nanopb (< 2.30910.0, >= 2.30908.0)
- GoogleDataTransport (9.2.5):
- GoogleUtilities/Environment (~> 7.7)
- nanopb (< 2.30910.0, >= 2.30908.0)
- PromisesObjC (< 3.0, >= 1.2)
- GoogleUtilities/AppDelegateSwizzler (7.12.0):
- GoogleUtilities/Environment
- GoogleUtilities/Logger
- GoogleUtilities/Network
- GoogleUtilities/Environment (7.12.0):
- PromisesObjC (< 3.0, >= 1.2)
- GoogleUtilities/Logger (7.12.0):
- GoogleUtilities/Environment
- GoogleUtilities/MethodSwizzler (7.12.0):
- GoogleUtilities/Logger
- GoogleUtilities/Network (7.12.0):
- GoogleUtilities/Logger
- "GoogleUtilities/NSData+zlib"
- GoogleUtilities/Reachability
- "GoogleUtilities/NSData+zlib (7.12.0)"
- GoogleUtilities/Reachability (7.12.0):
- GoogleUtilities/Logger
- GoogleUtilities/UserDefaults (7.12.0):
- GoogleUtilities/Logger
- GRDB.swift/SQLCipher (6.20.2):
- SQLCipher (>= 3.4.2)
- Instabug (13.4.2)
- KituraContracts (1.2.1):
- LoggerAPI (~> 1.7)
- libfido2 (1.14.0)
- LoggerAPI (1.9.200):
- Logging (~> 1.1)
- Logging (1.4.0)
- nanopb (2.30909.1):
- nanopb/decode (= 2.30909.1)
- nanopb/encode (= 2.30909.1)
- nanopb/decode (2.30909.1)
- nanopb/encode (2.30909.1)
- OCMock (3.4.3)
- OktaAnalytics (2.2):
- AppCenter (~> 5)
- Firebase/AnalyticsWithoutAdIdSupport
- OktaLogger/Core (~> 1)
- OktaSQLiteStorage (~> 0.0.4)
- OneTimePassword (3.2.0):
- Base32 (~> 1.1.2)
- PromisesObjC (2.3.1)
- Resolver (1.5.0)
- RNCryptor-objc (3.0.6)
- SAMKeychain (1.5.2)
- Sentry (8.53.2):
- Sentry/Core (= 8.53.2)
- Sentry/Core (8.53.2)
- SQLCipher (4.5.5):
- SQLCipher/standard (= 4.5.5)
- SQLCipher/common (4.5.5)
- SQLCipher/standard (4.5.5):
- SQLCipher/common
- SwiftBase32 (0.8.0)
- SwiftCBOR (0.4.6)
- SwiftJWT (3.6.200):
- BlueCryptor (~> 1.0)
- BlueECC (~> 1.1)
- BlueRSA (~> 1.0)
- KituraContracts (~> 1.2)
- LoggerAPI (~> 1.7)
- SwiftLint (0.53.0)
- ViewInspector (0.10.0)
DEPENDENCIES:
- Firebase/AnalyticsWithoutAdIdSupport (= 9.6.0)
- Firebase/Crashlytics (= 9.6.0)
- Firebase/Messaging (= 9.6.0)
- Firebase/RemoteConfig (= 9.6.0)
- Resolver (= 1.5.0)
- SAMKeychain (= 1.5.2)
- Sentry (= 8.53.2)
- SQLCipher (~> 4.5.5)
- SwiftBase32 (~> 0.8.0)
- SwiftCBOR (= 0.4.6)
- SwiftJWT (~> 3.6.2)
- SwiftLint (= 0.53.0)
- ViewInspector (= 0.10.0)
SPEC REPOS:
trunk:
- AppCenter
- Base32
- BlueCryptor
- BlueECC
- BlueRSA
- CocoaLumberjack
- Firebase
- FirebaseABTesting
- FirebaseAnalytics
- FirebaseCore
- FirebaseCoreDiagnostics
- FirebaseCoreInternal
- FirebaseCrashlytics
- FirebaseInstallations
- FirebaseMessaging
- FirebaseRemoteConfig
- GoogleAppMeasurement
- GoogleDataTransport
- GoogleUtilities
- GRDB.swift
- Instabug
- KituraContracts
- LoggerAPI
- Logging
- nanopb
- OCMock
- OktaAnalytics
- OktaLogger
- OktaOidc
- OktaSQLiteStorage
- PromisesObjC
- Resolver
- RNCryptor-objc
- SAMKeychain
- Sentry
- SQLCipher
- SwiftBase32
- SwiftCBOR
- SwiftJWT
- SwiftLint
- ViewInspector
EXTERNAL SOURCES:
CHECKOUT OPTIONS:
SPEC CHECKSUMS:
COCOAPODS: 1.15.2