Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

v7.17.1: Immediate Crash (invalid fts5 file format (found 0, expected 4 or 5) - run 'rebuild' | ExtraMessage: null) #13693

Closed
4 tasks done
rettichschnidi opened this issue Sep 15, 2024 · 13 comments

Comments

@rettichschnidi
Copy link

rettichschnidi commented Sep 15, 2024


Bug description

Launching 7.17.1 results in a crash after showing the signal logo. Unlike #13685, the app crashes before showing the home screen.

Steps to reproduce

Unclear

What I know:

Screenshots

Device info

Device: Fairphone 3
Android version: 13 (/e/OS 2.3-t-20240816426372-stable-FP3)
Signal version: 7.17.1

Link to debug log

Because Signal crashes immediately, captured via adb logcat:

09-15 11:22:12.994 27939 27968 E SQLiteLog: (1) statement aborts at 12: [ALTER TABLE attachment DROP COLUMN archive_thumbnail_cdn] error in trigger message_ai: invalid fts5 file format (found 0, expected 4 or 5) - run 'rebuild'
09-15 11:22:12.997 27939 27939 I libsignal: rust/bridge/jni/src/logging.rs:160: Initializing libsignal version:0.56.0
09-15 11:22:12.999 27939 27939 I ApplicationContext: onCreate()
09-15 11:22:13.000 27939 27968 E AndroidRuntime: FATAL EXCEPTION: signal-bounded-0
09-15 11:22:13.000 27939 27968 E AndroidRuntime: Process: org.thoughtcrime.securesms, PID: 27939
09-15 11:22:13.000 27939 27968 E AndroidRuntime: android.database.sqlite.SQLiteException: FullCode: 1 | ErrorCode: 1 | ExtendedErrorCode: 0 | Message: error in trigger message_ai: invalid fts5 file format (found 0, expected 4 or 5) - run 'rebuild' | ExtraMessage: null
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteConnection.nativeExecuteForChangedRowCount(Native Method)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteConnection.executeForChangedRowCount(SQLiteConnection.java:818)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteSession.executeForChangedRowCount(SQLiteSession.java:758)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:90)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteDatabase.executeSql(SQLiteDatabase.java:1992)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteDatabase.execSQL(SQLiteDatabase.java:1900)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.helpers.migration.V246_DropThumbnailCdnFromAttachments.migrate(V246_DropThumbnailCdnFromAttachments.kt:17)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.helpers.SignalDatabaseMigrations.migrate(SignalDatabaseMigrations.kt:231)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.SignalDatabase.onUpgrade(SignalDatabase.kt:176)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:403)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:302)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.SignalDatabase.getRawReadableDatabase(SignalDatabase.kt:197)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.SignalDatabase$Companion.hasTable(SignalDatabase.kt:313)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.SignalDatabase.hasTable(SignalDatabase.kt:0)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.KeyValueDatabase.lambda$onOpen$0(KeyValueDatabase.java:106)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.KeyValueDatabase.$r8$lambda$G2dZI_gAXkqExOGYLgmndIoi47k(KeyValueDatabase.java:0)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.KeyValueDatabase$$ExternalSyntheticLambda0.run(R8$$SyntheticClass:0)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1137)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at java.lang.Thread.run(Thread.java:1012)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.signal.core.util.concurrent.SignalExecutors$NumberedThreadFactory$1.run(SignalExecutors.java:109)
09-15 11:22:13.003 27939 27939 I ApplicationContext: Initializing AppDependencies.
09-15 11:22:13.004  1497 27973 I DropBoxManagerService: add tag=data_app_crash isTagEnabled=true flags=0x2
09-15 11:22:13.005  1497  3158 W ActivityTaskManager:   Force finishing activity org.thoughtcrime.securesms/.RoutingActivity
09-15 11:22:13.008 27939 27969 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:12.662  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 161252188; UID 10148; state: DISABLED
09-15 11:22:12.662  1497  1600 I ActivityTaskManager: START u0 {act=android.intent.action.MAIN cat=[android.intent.category.LAUNCHER] flg=0x10200000 cmp=org.thoughtcrime.securesms/.RoutingActivity} from uid 10169
09-15 11:22:12.663  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 265464455; UID 10148; state: DISABLED
09-15 11:22:12.663  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 265452344; UID 10148; state: DISABLED
09-15 11:22:12.663  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 266124927; UID 10148; state: DISABLED
09-15 11:22:12.664  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 265451093; UID 10148; state: DISABLED
09-15 11:22:12.664  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 265456536; UID 10148; state: DISABLED
09-15 11:22:12.664  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 255940284; UID 10148; state: DISABLED
09-15 11:22:12.664  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 236283604; UID 10148; state: DISABLED
09-15 11:22:12.664  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 263959004; UID 10148; state: DISABLED
09-15 11:22:12.664  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 264304459; UID 10148; state: DISABLED
09-15 11:22:12.665  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 264301586; UID 10148; state: DISABLED
09-15 11:22:12.665  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 254631730; UID 10148; state: DISABLED
09-15 11:22:12.665  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 273509367; UID 10148; state: DISABLED
09-15 11:22:12.665  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 263259275; UID 10148; state: DISABLED
09-15 11:22:12.666  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 194480991; UID 10148; state: ENABLED
09-15 11:22:12.667  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 174042980; UID 10148; state: DISABLED
09-15 11:22:12.669  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 184838306; UID 10148; state: DISABLED
09-15 11:22:12.670  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 185004937; UID 10148; state: DISABLED
09-15 11:22:12.670  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 181136395; UID 10148; state: DISABLED
09-15 11:22:12.671  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 197654537; UID 10148; state: ENABLED
09-15 11:22:12.673   857   857 I android.hardware.power-service-qti: Power setMode: 5 to: 1
09-15 11:22:12.673  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 205907456; UID 10148; state: ENABLED
09-15 11:22:12.674   880   921 E ANDR-PERF-OPTSHANDLER: Perflock resource /proc/sys/kernel/sched_spill_nr_run not supported
09-15 11:22:12.674   880   921 E ANDR-PERF-RESOURCEQS: Failed to apply optimization [3, 11]
09-15 11:22:12.674   880   921 E ANDR-PERF-OPTSHANDLER: Perflock resource /proc/sys/kernel/sched_restrict_cluster_spill not supported
09-15 11:22:12.674   880   921 E ANDR-PERF-RESOURCEQS: Failed to apply optimization [3, 13]
09-15 11:22:12.677  1497  1600 D CompatibilityChangeReporter: Compat change id reported: 194833441; UID 10148; state: ENABLED
09-15 11:22:12.684  1933  2114 W Parcel  : Expecting binder but got null!
09-15 11:22:12.687  1497  3158 D CompatibilityChangeReporter: Compat change id reported: 168419799; UID 10148; state: DISABLED
09-15 11:22:12.688  1497  3158 D CompatibilityChangeReporter: Compat change id reported: 273564678; UID 10148; state: DISABLED
09-15 11:22:12.691  1497  1696 D CompatibilityChangeReporter: Compat change id reported: 135634846; UID 10148; state: DISABLED
09-15 11:22:12.691  1497  1696 D CompatibilityChangeReporter: Compat change id reported: 177438394; UID 10148; state: DISABLED
09-15 11:22:12.691  1497  1696 D CompatibilityChangeReporter: Compat change id reported: 135772972; UID 10148; state: DISABLED
09-15 11:22:12.692  1497  1696 D CompatibilityChangeReporter: Compat change id reported: 135754954; UID 10148; state: ENABLED
09-15 11:22:12.692  1497  1713 D CompatibilityChangeReporter: Compat change id reported: 143937733; UID 10148; state: ENABLED
09-15 11:22:12.692  1497  9041 D CoreBackPreview: Window{c1e6ee0 u0 Splash Screen org.thoughtcrime.securesms}: Setting back callback OnBackInvokedCallbackInfo{mCallback=android.window.IOnBackInvokedCallback$Stub$Proxy@4ca505e, mPriority=0}
09-15 11:22:12.702   750   750 D Zygote  : Forked child process 27939
09-15 11:22:12.703  1497  1713 I ActivityManager: Start proc 27939:org.thoughtcrime.securesms/u0a148 for next-top-activity {org.thoughtcrime.securesms/org.thoughtcrime.securesms.RoutingActivity}
09-15 11:22:12.709  1933  2114 E OpenGLRenderer: Unable to match the desired swap behavior.
09-15 11:22:12.725 27939 27939 E crime.securesms: Not starting debugger since process cannot load the jdwp agent.
09-15 11:22:06.082     0     0 I binder  : 27939:27939 ioctl 40046210 7fd66853d0 returned -22
09-15 11:22:12.742 27939 27939 D CompatibilityChangeReporter: Compat change id reported: 171979766; UID 10148; state: ENABLED
09-15 11:22:12.764 27939 27939 W ziparchive: Unable to open '/data/app/~~ifcDwD6se68U6UPfiULIXA==/org.thoughtcrime.securesms-s-coiHqlJnG9EypjEi9cOw==/split_config.arm64_v8a.dm': No such file or directory
09-15 11:22:12.764 27939 27939 W ziparchive: Unable to open '/data/app/~~ifcDwD6se68U6UPfiULIXA==/org.thoughtcrime.securesms-s-coiHqlJnG9EypjEi9cOw==/split_config.arm64_v8a.dm': No such file or directory
09-15 11:22:12.764 27939 27939 W crime.securesms: Entry not found
09-15 11:22:12.764 27939 27939 W ziparchive: Unable to open '/data/app/~~ifcDwD6se68U6UPfiULIXA==/org.thoughtcrime.securesms-s-coiHqlJnG9EypjEi9cOw==/split_config.xxhdpi.dm': No such file or directory
09-15 11:22:12.764 27939 27939 W ziparchive: Unable to open '/data/app/~~ifcDwD6se68U6UPfiULIXA==/org.thoughtcrime.securesms-s-coiHqlJnG9EypjEi9cOw==/split_config.xxhdpi.dm': No such file or directory
09-15 11:22:12.765 27939 27939 W crime.securesms: Entry not found
09-15 11:22:12.768 27939 27939 W crime.securesms: JIT profile information will not be recorded: profile file does not exist.
09-15 11:22:12.768 27939 27939 W crime.securesms: JIT profile information will not be recorded: profile file does not exist.
09-15 11:22:12.778 27939 27939 V GraphicsEnvironment: ANGLE Developer option for 'org.thoughtcrime.securesms' set to: 'default'
09-15 11:22:12.779 27939 27939 V GraphicsEnvironment: ANGLE GameManagerService for org.thoughtcrime.securesms: false
09-15 11:22:12.779 27939 27939 V GraphicsEnvironment: Neither updatable production driver nor prerelease driver is supported.
09-15 11:22:12.781 27939 27939 D NetworkSecurityConfig: No Network Security Config specified, using platform default
09-15 11:22:12.781 27939 27939 D NetworkSecurityConfig: No Network Security Config specified, using platform default
09-15 11:22:12.790 27939 27939 I MultiDex: VM with version 2.1.0 has multidex support
09-15 11:22:12.790 27939 27939 I MultiDex: Installing application
09-15 11:22:12.790 27939 27939 I MultiDex: VM has multidex support, MultiDex support library is disabled.
09-15 11:22:12.799 27939 27939 D CompatibilityChangeReporter: Compat change id reported: 183155436; UID 10148; state: ENABLED
09-15 11:22:12.806 27939 27939 I FirebaseApp: Device unlocked: initializing all Firebase APIs for app [DEFAULT]
09-15 11:22:12.818 27939 27939 I FirebaseInitProvider: FirebaseApp initialization successful
09-15 11:22:12.965 27939 27939 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:12.971 27939 27939 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:12.974 27939 27968 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:12.980 27939 27968 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:12.994 27939 27968 E SQLiteLog: (1) statement aborts at 12: [ALTER TABLE attachment DROP COLUMN archive_thumbnail_cdn] error in trigger message_ai: invalid fts5 file format (found 0, expected 4 or 5) - run 'rebuild'
09-15 11:22:12.997 27939 27939 I libsignal: rust/bridge/jni/src/logging.rs:160: Initializing libsignal version:0.56.0
09-15 11:22:12.999 27939 27939 I ApplicationContext: onCreate()
09-15 11:22:13.000 27939 27968 E AndroidRuntime: FATAL EXCEPTION: signal-bounded-0
09-15 11:22:13.000 27939 27968 E AndroidRuntime: Process: org.thoughtcrime.securesms, PID: 27939
09-15 11:22:13.000 27939 27968 E AndroidRuntime: android.database.sqlite.SQLiteException: FullCode: 1 | ErrorCode: 1 | ExtendedErrorCode: 0 | Message: error in trigger message_ai: invalid fts5 file format (found 0, expected 4 or 5) - run 'rebuild' | ExtraMessage: null
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteConnection.nativeExecuteForChangedRowCount(Native Method)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteConnection.executeForChangedRowCount(SQLiteConnection.java:818)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteSession.executeForChangedRowCount(SQLiteSession.java:758)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:90)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteDatabase.executeSql(SQLiteDatabase.java:1992)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteDatabase.execSQL(SQLiteDatabase.java:1900)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.helpers.migration.V246_DropThumbnailCdnFromAttachments.migrate(V246_DropThumbnailCdnFromAttachments.kt:17)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.helpers.SignalDatabaseMigrations.migrate(SignalDatabaseMigrations.kt:231)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.SignalDatabase.onUpgrade(SignalDatabase.kt:176)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:403)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at net.zetetic.database.sqlcipher.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:302)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.SignalDatabase.getRawReadableDatabase(SignalDatabase.kt:197)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.SignalDatabase$Companion.hasTable(SignalDatabase.kt:313)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.SignalDatabase.hasTable(SignalDatabase.kt:0)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.KeyValueDatabase.lambda$onOpen$0(KeyValueDatabase.java:106)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.KeyValueDatabase.$r8$lambda$G2dZI_gAXkqExOGYLgmndIoi47k(KeyValueDatabase.java:0)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.thoughtcrime.securesms.database.KeyValueDatabase$$ExternalSyntheticLambda0.run(R8$$SyntheticClass:0)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1137)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at java.lang.Thread.run(Thread.java:1012)
09-15 11:22:13.000 27939 27968 E AndroidRuntime:        at org.signal.core.util.concurrent.SignalExecutors$NumberedThreadFactory$1.run(SignalExecutors.java:109)
09-15 11:22:13.003 27939 27939 I ApplicationContext: Initializing AppDependencies.
09-15 11:22:13.004  1497 27973 I DropBoxManagerService: add tag=data_app_crash isTagEnabled=true flags=0x2
09-15 11:22:13.005  1497  3158 W ActivityTaskManager:   Force finishing activity org.thoughtcrime.securesms/.RoutingActivity
09-15 11:22:13.008 27939 27969 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.012 27939 27939 I ApplicationContext: Installed AesGcmProvider: 1
09-15 11:22:13.018 27939 27939 V NativeCrypto: Registering org/conscrypt/NativeCrypto's 288 native methods...
09-15 11:22:13.027 27939 27939 I ApplicationContext: Installed Conscrypt provider: 2
09-15 11:22:13.031  1497  1694 I ActivityManager: Showing crash dialog for package org.thoughtcrime.securesms u0
09-15 11:22:13.032 27939 27969 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.155  1497  6959 W Parcel  : Expecting binder but got null!
09-15 11:22:13.161  1497  1694 D CoreBackPreview: Window{7a62a17 u0 Application Error: org.thoughtcrime.securesms}: Setting back callback OnBackInvokedCallbackInfo{mCallback=android.window.WindowOnBackInvokedDispatcher$OnBackInvokedCallbackWrapper@854aa6e, mPriority=0}
09-15 11:22:13.161  1497  1694 W Looper  : Slow dispatch took 119ms android.ui h=com.android.server.am.ActivityManagerService$UiHandler c=com.android.server.am.ErrorDialogController$$ExternalSyntheticLambda3@fbf6fa5 m=0
09-15 11:22:13.177  1497  6959 E OpenGLRenderer: Unable to match the desired swap behavior.
09-15 11:22:13.187 27939 27978 I CellServiceConstraintOb: [API 33] Cell service available.
09-15 11:22:13.230 27939 27981 D JobManager: Starting initialization: Thread[signal-JobManager,5,main]
09-15 11:22:13.237 27939 27981 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.241 27939 27939 D ApplicationMigrations: About to update. Clearing deprecation flag.
09-15 11:22:13.243 27939 27939 D ApplicationMigrations: currentVersion: 114,  lastSeenVersion: 111
09-15 11:22:13.256 27939 27939 I ApplicationMigrations: About to enqueue 2 migration(s).
09-15 11:22:13.275 27939 27981 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.276 27939 27981 I JobDatabase: onOpen()
09-15 11:22:13.278 27939 27983 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.286 27939 27939 I ApplicationMigrations: Migration set is non-UI-blocking.
09-15 11:22:13.293 27939 27939 I ApplicationContext: App is no longer visible.
09-15 11:22:13.294 27939 27983 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.300 27939 27981 D FastJobStorage: [init] fetch-min-jobs: 50.89, sort-min-jobs: 2.76, fetch-full-jobs: 10.65, fetch-constraints: 3.53, fetch-dependencies: 0.89, total: 68.74
09-15 11:22:13.300 27939 27983 I SignalDatabase: Upgrading database: 245, 246
09-15 11:22:13.301 27939 27983 I SignalDatabaseMigration: Running migration for version 246: V246_DropThumbnailCdnFromAttachments. Foreign keys: false
09-15 11:22:13.306   866   866 E WifiHAL : get_wifi_interface_info: QCA_WLAN_VENDOR_ATTR_LL_STATS_IFACE_INFO_TS_DUTY_CYCLE not found
09-15 11:22:13.306   866   866 E WifiHAL : nl80211: requestResponse->nl_recvmsgs failed: -5
09-15 11:22:13.307  1497  1867 E WifiVendorHal: getWifiLinkLayerStats_1_6_Internal(l.1199) failed {.code = ERROR_INVALID_ARGS, .description = }
09-15 11:22:13.307 27939 27983 E SQLiteLog: (1) statement aborts at 12: [ALTER TABLE attachment DROP COLUMN archive_thumbnail_cdn] error in trigger message_ai: invalid fts5 file format (found 0, expected 4 or 5) - run 'rebuild'
09-15 11:22:13.311 27939 27983 W SignalUncaughtException: FTS in invalid state! Resetting FTS index.
09-15 11:22:13.314  1497  9041 D CompatibilityChangeReporter: Compat change id reported: 161145287; UID 10148; state: DISABLED
09-15 11:22:13.314  1497  1712 W BroadcastQueue: Skipping deliver [background] BroadcastRecord{efb9eb8 u-1 android.intent.action.BATTERY_CHANGED} to ReceiverList{87c3b2a 27939 org.thoughtcrime.securesms/10148/u0 remote:d248c15}: process gone or crashing
09-15 11:22:13.316  1497  1712 W BroadcastQueue: Skipping deliver [background] BroadcastRecord{127ee64 u-1 android.net.conn.CONNECTIVITY_CHANGE} to ReceiverList{6fadff6 27939 org.thoughtcrime.securesms/10148/u0 remote:5ced491}: process gone or crashing
09-15 11:22:13.318 27939 27939 W RemoteConfig: Tried to read android.internalUser before initialization. Initializing now.
09-15 11:22:13.321 27939 27939 I RemoteConfig: init() {android.animatedStickerMinMemory=193, android.animatedStickerMinTotalMemory=3072, android.attachments.maxCount=32, android.automaticSessionReset.2=true, android.calling.ad.hoc.3=false, android.calling.fieldTrial.anyAddressPortsKillSwitch=true, android.calling.hardwareAecBlockList=Redmi Note 5,FP2,M1901F7*,ASUS_I006D,motorola one power,FP3,FP4,S22 FLIP,Mi Note 10,SM-S215DL, android.calling.oboeDeployment=true, android.calling.softwareAecBlockList=false, android.calling.telecomAllowList=false, android.calling.telecomModelBlockList=SM-G930F,SM-G950F,SM-N950*,SM-J737V,SC-02*,SM-A105*,SM-A530*, android.calling.useActiveCallManager.6=true, android.calling.useHardwareAecIfOlderThanApi29=false, android.cameraXMixedModelBlockList=Pixel 3,Pixel 4,Pixel 4 XL,SM-G930T,SM-G930V,YAL-L21,YAL-AL00,YAL-TL00,VOG-L29,VOG-L09,VOG-AL00,VOG-TL00,VOG-L04,VOG-AL10,HW-02L,EVR-L29,EVR-AL00,EVR-TL00,CPH2583,CPH2573,CPH2581,SM-A336E,MAR-LX1A,FP4,NX769J, android.cameraXModelBlockList=ALE-L21,GT-N7100,GT-N8000,COL-L29,C66,C66_EEA, android.cds.hardLimit=50000, android.cds.libsignal.4=true, android.connectivityWarningConfig={"thresholdHours":72,"percentDebugPrompt":3}, android.crashPromptConfig.2=[{"name":"RuntimeException","percent":1},{"name":"MissingRecipientException","percent":1}], android.customVideoMuxer.1=true, android.defaultMaxBackoff=60, android.deviceSpecificNotificationConfig=[{"model":"AI2202*","link":"https://support.signal.org/hc/articles/7516008763674-Zenfone-9-and-Zenfone-10-Notifications","showConditionCode":"has-battery-optimization-on","localePercent":"*:1000000","version":1},{"model":"AI2302","link":"https://support.signal.org/hc/articles/7516008763674-Zenfone-9-and-Zenfone-10-Notifications","showConditionCode":"has-battery-optimization-on","localePercent":"*:1000000","version":1},{"manufacturer":"asus","link":"https://support.signal.org/hc/articles/7821813263386-Zenfone-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"manufacturer":"huawei","link":"https://support.signal.org/hc/articles/7739243072026-Huawei-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"model":"ANE-*","link":"https://support.signal.org/hc/en-us/articles/7739243072026-Huawei-P20-Lite-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"manufacturer":"xiaomi","link":"https://support.signal.org/hc/articles/7821674889242-Xiaomi-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"model":"M2003J15S*","link":"https://support.signal.org/hc/articles/7698371275034-Xiaomi-Redmi-Note-9-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"manufacturer":"samsung","link":"https://support.signal.org/hc/articles/7874157231002-Samsung-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"model":"SM-A546*","link":"https://support.signal.org/hc/articles/7874151545114-Samsung-A54-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"model":"CPH24*","link":"https://support.signal.org/hc/articles/7923771909274-OnePlus-11-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"model":"PHB110","link":"https://support.signal.org/hc/articles/7923771909274-OnePlus-11-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"manufacturer":"oneplus","link":"https://support.signal.org/hc/articles/7923742948250-OnePlus-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1}], android.ideal.donations.5=true, android.internalUser=false, android.libsignalWebSocketEnabled=false, android.linkedDeviceLifespanSeconds=2592000, android.logs.promptNotifications=*:2000, android.media.audioRemux.1=true, android.media.sourceTranscodeVideo.m
09-15 11:22:13.321 27939 27939 I RemoteConfig: axBytes=4294967296, android.media.videoCaptureDefaultZoom=true, android.mediaQuality.levels=1:2,61:2,81:2,82:2,65:2,31:2,47:2,41:2,32:2,385:2,971:2,974:2,49:2,33:2,*:1, android.messageProcessor.alarmIntervalMins=180, android.notificationThumbnailProductBlocklist=begonia,daisy, android.okhttpAutomaticRetry=true, android.oneTimePayPalDonations.2=true, android.payments.requestActivateFlow=true, android.promptBatterySaver=*:250000, android.recurringPayPalDonations.3=true, android.retryReceipts=true, android.retryRespondMaxAge=2592000000, android.senderKeyMaxAge=1209600000, android.sepa.debit.donations.5=true, cds.foregroundSyncInterval.seconds=14400, cds.syncInterval.seconds=86400, global.attachments.maxBytes=104857600, global.calling.maxGroupCallRingSize=16, global.donations.ccDisabledRegions=98,963,53,850,7 978,7 365,7 869,7 941,7,375, global.donations.gpayDisabledRegions=98,963,53,850,7 978,7 365,7 869,7 941,7,375,1 242,1 246,1 264,1 284,1 340,1 345,1 441,1 473,1 649,1 664,1 670,1 671,1 721,1 758,1 767,1 784,1 787,1 939,1 868,1 869,1 876,211,216,218,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,245,246,248,249,250,251,252,253,255,256,257,258,260,261,263,264,265,266,267,268,269,290,291,297,298,299,350,354,356,357,373,374,376,377,378,379,381,382,383,386,387,389,423,44 1481,44 1534,44 1624,500,501,502,503,504,505,506,508,509,53,58,591,592,593,594,595,596,597,670,672,673,674,675,676,677,678,679,680,681,682,683,685,686,687,688,689,690,691,692,82,850,853,855,856,86,880,91,93,95,960,963,964,967,970,975,976,977,98,992,993,995,996,998, global.donations.idealEnabledRegions=31, global.donations.paypalDisabledRegions=98,963,53,850,7 978,7 365,7 869,7 941,7,375,1 340,1 670,1 671,1 684,1 721,1 787,1 939,211,218,231,233,236,240,246,249,350,383,509,53,670,672,690,850,853,880,90,92,93,95,961,963,964,970,98,998, global.donations.sepaEnabledRegions=30,32,33,34,36,39,351,352,353,354,356,357,358,359,370,371,372,376,377,378,379,385,386,40,41,43,44,45,46,47,48,49,420,421,423, global.groupsv2.groupSizeHardLimit=1001, global.groupsv2.maxGroupSize=151, global.payments.disabledRegions=98,963,53,850,7 978,7 365,7 869,7 941}
09-15 11:22:13.323  2294  2936 D QCNEJ/WlanStaInfoRelay: Received action: android.net.wifi.RSSI_CHANGED
09-15 11:22:13.326 27939 27939 D DeadlockDetector: Ending deadlock monitoring.
09-15 11:22:13.328 27939 27939 D MemoryTracker: Ending memory monitoring.
09-15 11:22:13.329 27939 27981 I IncomingMessageObserver: Initializing! (58500938)
09-15 11:22:13.332 27939 27989 I IncomingMessageObserver: Waiting for websocket state change....
09-15 11:22:13.334  1497  9041 D ConnectivityService: requestNetwork for uid/pid:10148/27939 activeRequest: null callbackRequest: 11315 [NetworkRequest [ REQUEST id=11316, [ Capabilities: INTERNET&NOT_RESTRICTED&TRUSTED&NOT_VCN_MANAGED Uid: 10148 RequestorUid: 10148 RequestorPkg: org.thoughtcrime.securesms UnderlyingNetworks: Null] ]] callback flags: 0 order: 2147483647
09-15 11:22:13.336 27939 27939 D DynamicTheme: Setting to follow system expecting: 32
09-15 11:22:13.339 27939 27981 D JobManager: Initialized
09-15 11:22:13.340 27939 27983 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.343 27939 27981 W JobController: [JOB::fe80a2e8-3c67-46f8-abf4-814184f463c1][BackfillDigestsMigrationJob] Already at the max instance count. Factory limit: 1, Queue limit: -1. Skipping. (Time Since Submission: 93 ms, Lifespan: Immortal, Run Attempt: 1/Unlimited, Queue: MIGRATION)
09-15 11:22:13.348  1497  1875 D ConnectivityService: NetReassign [11316 : null → 102]
09-15 11:22:13.351 27939 27990 D NetworkConnectionListen: ConnectivityManager.NetworkCallback onAvailable()
09-15 11:22:13.354  2357  2357 D PhoneSwitcherNetworkRequstListener: got request NetworkRequest [ REQUEST id=11316, [ Capabilities: INTERNET&NOT_RESTRICTED&TRUSTED&NOT_VCN_MANAGED Uid: 10148 RequestorUid: 10148 RequestorPkg: org.thoughtcrime.securesms UnderlyingNetworks: Null] ]
09-15 11:22:13.355  1497  1867 D UntrustedWifiNetworkFactory: got request NetworkRequest [ REQUEST id=11316, [ Capabilities: INTERNET&NOT_RESTRICTED&TRUSTED&NOT_VCN_MANAGED Uid: 10148 RequestorUid: 10148 RequestorPkg: org.thoughtcrime.securesms UnderlyingNetworks: Null] ]
09-15 11:22:13.356  1497  1867 D OemPaidWifiNetworkFactory: got request NetworkRequest [ REQUEST id=11316, [ Capabilities: INTERNET&NOT_RESTRICTED&TRUSTED&NOT_VCN_MANAGED Uid: 10148 RequestorUid: 10148 RequestorPkg: org.thoughtcrime.securesms UnderlyingNetworks: Null] ]
09-15 11:22:13.356  1497  1867 D MultiInternetWifiNetworkFactory: got request NetworkRequest [ REQUEST id=11316, [ Capabilities: INTERNET&NOT_RESTRICTED&TRUSTED&NOT_VCN_MANAGED Uid: 10148 RequestorUid: 10148 RequestorPkg: org.thoughtcrime.securesms UnderlyingNetworks: Null] ]
09-15 11:22:13.362 27939 27939 D CachedInflater: Clearing view cache.
09-15 11:22:13.368 27939 27939 I RemoteConfig: init() {android.animatedStickerMinMemory=193, android.animatedStickerMinTotalMemory=3072, android.attachments.maxCount=32, android.automaticSessionReset.2=true, android.calling.ad.hoc.3=false, android.calling.fieldTrial.anyAddressPortsKillSwitch=true, android.calling.hardwareAecBlockList=Redmi Note 5,FP2,M1901F7*,ASUS_I006D,motorola one power,FP3,FP4,S22 FLIP,Mi Note 10,SM-S215DL, android.calling.oboeDeployment=true, android.calling.softwareAecBlockList=false, android.calling.telecomAllowList=false, android.calling.telecomModelBlockList=SM-G930F,SM-G950F,SM-N950*,SM-J737V,SC-02*,SM-A105*,SM-A530*, android.calling.useActiveCallManager.6=true, android.calling.useHardwareAecIfOlderThanApi29=false, android.cameraXMixedModelBlockList=Pixel 3,Pixel 4,Pixel 4 XL,SM-G930T,SM-G930V,YAL-L21,YAL-AL00,YAL-TL00,VOG-L29,VOG-L09,VOG-AL00,VOG-TL00,VOG-L04,VOG-AL10,HW-02L,EVR-L29,EVR-AL00,EVR-TL00,CPH2583,CPH2573,CPH2581,SM-A336E,MAR-LX1A,FP4,NX769J, android.cameraXModelBlockList=ALE-L21,GT-N7100,GT-N8000,COL-L29,C66,C66_EEA, android.cds.hardLimit=50000, android.cds.libsignal.4=true, android.connectivityWarningConfig={"thresholdHours":72,"percentDebugPrompt":3}, android.crashPromptConfig.2=[{"name":"RuntimeException","percent":1},{"name":"MissingRecipientException","percent":1}], android.customVideoMuxer.1=true, android.defaultMaxBackoff=60, android.deviceSpecificNotificationConfig=[{"model":"AI2202*","link":"https://support.signal.org/hc/articles/7516008763674-Zenfone-9-and-Zenfone-10-Notifications","showConditionCode":"has-battery-optimization-on","localePercent":"*:1000000","version":1},{"model":"AI2302","link":"https://support.signal.org/hc/articles/7516008763674-Zenfone-9-and-Zenfone-10-Notifications","showConditionCode":"has-battery-optimization-on","localePercent":"*:1000000","version":1},{"manufacturer":"asus","link":"https://support.signal.org/hc/articles/7821813263386-Zenfone-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"manufacturer":"huawei","link":"https://support.signal.org/hc/articles/7739243072026-Huawei-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"model":"ANE-*","link":"https://support.signal.org/hc/en-us/articles/7739243072026-Huawei-P20-Lite-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"manufacturer":"xiaomi","link":"https://support.signal.org/hc/articles/7821674889242-Xiaomi-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"model":"M2003J15S*","link":"https://support.signal.org/hc/articles/7698371275034-Xiaomi-Redmi-Note-9-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"manufacturer":"samsung","link":"https://support.signal.org/hc/articles/7874157231002-Samsung-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"model":"SM-A546*","link":"https://support.signal.org/hc/articles/7874151545114-Samsung-A54-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"model":"CPH24*","link":"https://support.signal.org/hc/articles/7923771909274-OnePlus-11-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"model":"PHB110","link":"https://support.signal.org/hc/articles/7923771909274-OnePlus-11-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1},{"manufacturer":"oneplus","link":"https://support.signal.org/hc/articles/7923742948250-OnePlus-Notifications","showConditionCode":"has-slow-notifications","localePercent":"*:1000000","version":1}], android.ideal.donations.5=true, android.internalUser=false, android.libsignalWebSocketEnabled=false, android.linkedDeviceLifespanSeconds=2592000, android.logs.promptNotifications=*:2000, android.media.audioRemux.1=true, android.media.sourceTranscodeVideo.m
09-15 11:22:13.369 27939 27939 I RemoteConfig: axBytes=4294967296, android.media.videoCaptureDefaultZoom=true, android.mediaQuality.levels=1:2,61:2,81:2,82:2,65:2,31:2,47:2,41:2,32:2,385:2,971:2,974:2,49:2,33:2,*:1, android.messageProcessor.alarmIntervalMins=180, android.notificationThumbnailProductBlocklist=begonia,daisy, android.okhttpAutomaticRetry=true, android.oneTimePayPalDonations.2=true, android.payments.requestActivateFlow=true, android.promptBatterySaver=*:250000, android.recurringPayPalDonations.3=true, android.retryReceipts=true, android.retryRespondMaxAge=2592000000, android.senderKeyMaxAge=1209600000, android.sepa.debit.donations.5=true, cds.foregroundSyncInterval.seconds=14400, cds.syncInterval.seconds=86400, global.attachments.maxBytes=104857600, global.calling.maxGroupCallRingSize=16, global.donations.ccDisabledRegions=98,963,53,850,7 978,7 365,7 869,7 941,7,375, global.donations.gpayDisabledRegions=98,963,53,850,7 978,7 365,7 869,7 941,7,375,1 242,1 246,1 264,1 284,1 340,1 345,1 441,1 473,1 649,1 664,1 670,1 671,1 721,1 758,1 767,1 784,1 787,1 939,1 868,1 869,1 876,211,216,218,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,245,246,248,249,250,251,252,253,255,256,257,258,260,261,263,264,265,266,267,268,269,290,291,297,298,299,350,354,356,357,373,374,376,377,378,379,381,382,383,386,387,389,423,44 1481,44 1534,44 1624,500,501,502,503,504,505,506,508,509,53,58,591,592,593,594,595,596,597,670,672,673,674,675,676,677,678,679,680,681,682,683,685,686,687,688,689,690,691,692,82,850,853,855,856,86,880,91,93,95,960,963,964,967,970,975,976,977,98,992,993,995,996,998, global.donations.idealEnabledRegions=31, global.donations.paypalDisabledRegions=98,963,53,850,7 978,7 365,7 869,7 941,7,375,1 340,1 670,1 671,1 684,1 721,1 787,1 939,211,218,231,233,236,240,246,249,350,383,509,53,670,672,690,850,853,880,90,92,93,95,961,963,964,970,98,998, global.donations.sepaEnabledRegions=30,32,33,34,36,39,351,352,353,354,356,357,358,359,370,371,372,376,377,378,379,385,386,40,41,43,44,45,46,47,48,49,420,421,423, global.groupsv2.groupSizeHardLimit=1001, global.groupsv2.maxGroupSize=151, global.payments.disabledRegions=98,963,53,850,7 978,7 365,7 869,7 941}
09-15 11:22:13.376 27939 27939 D CallManager: Loading ringrtc library
09-15 11:22:13.378 27939 27991 D BlobProvider: No attachment drafts exist. Skipping.
09-15 11:22:13.379 27939 27991 I BlobProvider: Initialized.
09-15 11:22:13.379 27939 27983 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.387 27939 27983 I SignalDatabase: Upgrading database: 245, 246
09-15 11:22:13.388 27939 27983 I SignalDatabaseMigration: Running migration for version 246: V246_DropThumbnailCdnFromAttachments. Foreign keys: false
09-15 11:22:13.395 27939 27983 E SQLiteLog: (1) statement aborts at 12: [ALTER TABLE attachment DROP COLUMN archive_thumbnail_cdn] error in trigger message_ai: invalid fts5 file format (found 0, expected 4 or 5) - run 'rebuild'
09-15 11:22:13.417 27939 27939 I CallManager: CallManager.initialize(): (release build, field trials = RingRTC-AnyAddressPortsKillSwitch/Enabled/WebRTC-Bwe-ProbingConfiguration/skip_if_est_larger_than_fraction_of_max:0.99/RingRTC-PruneTurnPorts/Enabled/)
09-15 11:22:13.419 27939 27939 I org.webrtc.Logging: NativeLibrary: Loading native library: jingle_peerconnection_so
09-15 11:22:13.428 27939 27981 I Job     : [JOB::ac487b26-bf4d-46d0-9f94-aefcc9d7fb31][MigrationCompleteJob] onSubmit() (Time Since Submission: 143 ms, Lifespan: Immortal, Run Attempt: 1/Unlimited, Queue: MIGRATION)
09-15 11:22:13.428 27939 27981 W JobController: [JOB::d5d3392e-7772-47b0-ba12-2791dabb7aab][SyncCallLinksMigrationJob] Already at the max instance count. Factory limit: 1, Queue limit: -1. Skipping. (Time Since Submission: 175 ms, Lifespan: Immortal, Run Attempt: 1/Unlimited, Queue: MIGRATION)
09-15 11:22:13.431 27939 27981 I Job     : [JOB::28bab38d-e709-4a0f-84f0-de1143aca6ea][MigrationCompleteJob] onSubmit() (Time Since Submission: 145 ms, Lifespan: Immortal, Run Attempt: 1/Unlimited, Queue: MIGRATION)
09-15 11:22:13.431 27939 27939 I CallManager: CallManager.initialize() returned
09-15 11:22:13.435 27939 27939 D AppStartup: [init] sqlcipher-init: 86, signal-store: 32, logging: 8, app-dependencies: 6, anr-detector: 1, security-provider: 21, crash-handling: 0, rx-init: 2, event-bus: 1, scrubber: 0, first-launch: 0, app-migrations: 262, lifecycle-observer: 36, message-retriever: 8, dynamic-theme: 27, proxy-init: 0, blob-provider: 2, remote-config: 4, ring-rtc: 62, glide: 1, tracer: 1, schedule-non-blocking: 0, total: 561
09-15 11:22:13.439 27939 27939 D ApplicationContext: onCreate() took 568 ms
09-15 11:22:13.443 27939 27978 W JobController: [JOB::b0b24533-709a-439f-b8a3-b0c692356af4][FcmRefreshJob] Already at the max instance count. Factory limit: 1, Queue limit: -1. Skipping. (Time Since Submission: 0 ms, Lifespan: 21600000 ms, Run Attempt: 1/3, Queue: FcmRefreshJob)
09-15 11:22:13.444 27939 27971 I PreKeysSyncJob: Scheduling a prekey refresh. Time since last full refresh: 173596993 ms
09-15 11:22:13.445 27939 27978 I PersistentAlarmManagerL: [RotateSignedPreKeyListener] onReceive(signal.ACTION_SCHEDULE)
09-15 11:22:13.446 27939 27971 W JobController: [JOB::8fe6b9af-8758-453d-ace4-dcf8315eadd2][PreKeysSyncJob] Already at the max instance count. Factory limit: 1, Queue limit: -1. Skipping. (Time Since Submission: 1 ms, Lifespan: 2592000000 ms, Run Attempt: 1/Unlimited, Queue: PreKeysSyncJob)
09-15 11:22:13.447 27939 27978 D CompatibilityChangeReporter: Compat change id reported: 160794467; UID 10148; state: ENABLED
09-15 11:22:13.449 27939 27978 I PersistentAlarmManagerL: [RotateSignedPreKeyListener] scheduling alarm for: 1726564562888
09-15 11:22:13.454 27939 27978 I PersistentAlarmManagerL: [DirectoryRefreshListener] onReceive(signal.ACTION_SCHEDULE)
09-15 11:22:13.455 27939 27978 I PersistentAlarmManagerL: [DirectoryRefreshListener] scheduling alarm for: 1726423194393
09-15 11:22:13.457 27939 27992 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.458 27939 27978 I PersistentAlarmManagerL: [LocalBackupListener] onReceive(signal.ACTION_SCHEDULE)
09-15 11:22:13.469  1497  9041 D CompatibilityChangeReporter: Compat change id reported: 171306433; UID 10148; state: ENABLED
09-15 11:22:13.469  1497  9041 D CompatibilityChangeReporter: Compat change id reported: 226439802; UID 10148; state: DISABLED
09-15 11:22:13.470 27939 27978 I PersistentAlarmManagerL: [LocalBackupListener] scheduling exact alarm for: 1726359205000 hasManagerPermission: true
09-15 11:22:13.471  1497  9041 D CompatibilityChangeReporter: Compat change id reported: 218533173; UID 10148; state: ENABLED
09-15 11:22:13.472 27939 27978 I PersistentAlarmManagerL: [RotateSenderCertificateListener] onReceive(signal.ACTION_SCHEDULE)
09-15 11:22:13.473 27939 27992 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.475 27939 27978 I PersistentAlarmManagerL: [RotateSenderCertificateListener] scheduling alarm for: 1726423194565
09-15 11:22:13.478 27939 27978 I RoutineMessageFetchRece: Alarm scheduled to repeat at interval 10800000
09-15 11:22:13.478 27939 27978 I PersistentAlarmManagerL: [AnalyzeDatabaseAlarmListener] onReceive(signal.ACTION_SCHEDULE)
09-15 11:22:13.478 27939 27939 W crime.securesms: Accessing hidden field Ljava/util/Collections$SynchronizedCollection;->mutex:Ljava/lang/Object; (max-target-o, reflection, denied)
09-15 11:22:13.480 27939 27939 W crime.securesms: Accessing hidden method Ljava/util/Collections$SynchronizedSet;-><init>(Ljava/util/Set;Ljava/lang/Object;)V (max-target-o, reflection, denied)
09-15 11:22:13.480 27939 27939 W crime.securesms: Accessing hidden method Ljava/util/Collections$SynchronizedCollection;-><init>(Ljava/util/Collection;Ljava/lang/Object;)V (max-target-o, reflection, denied)
09-15 11:22:13.481 27939 27978 I PersistentAlarmManagerL: [AnalyzeDatabaseAlarmListener] scheduling exact alarm for: 1726366220000 hasManagerPermission: true
09-15 11:22:13.481 27939 27992 I SignalDatabase: Upgrading database: 245, 246
09-15 11:22:13.482 27939 27992 I SignalDatabaseMigration: Running migration for version 246: V246_DropThumbnailCdnFromAttachments. Foreign keys: false
09-15 11:22:13.484 27939 27978 D StorageSyncHelper: Scheduling a sync. Last sync was 55741633 ms ago.
09-15 11:22:13.485 27939 27939 D AppCompatDelegate: Checking for metadata for AppLocalesMetadataHolderService : Service not found
09-15 11:22:13.486 27939 27978 W JobController: [JOB::0112fd31-57ee-4782-829f-5c9b0b18b988][StorageSyncJob] Already at the max instance count. Factory limit: 2, Queue limit: -1. Skipping. (Time Since Submission: 0 ms, Lifespan: 86400000 ms, Run Attempt: 1/3, Queue: StorageSyncingJobs)
09-15 11:22:13.490 27939 27992 E SQLiteLog: (1) statement aborts at 12: [ALTER TABLE attachment DROP COLUMN archive_thumbnail_cdn] error in trigger message_ai: invalid fts5 file format (found 0, expected 4 or 5) - run 'rebuild'
09-15 11:22:13.494 27939 27992 W SignalUncaughtException: FTS in invalid state! Resetting FTS index.
09-15 11:22:13.496 27939 28000 I JobRunner: [JOB::cbe19097-072b-46b0-a751-27d55e7846a3][BackfillDigestsMigrationJob][1] Running job. (Time Since Submission: 8769111 ms, Lifespan: Immortal, Run Attempt: 1/Unlimited, Queue: MIGRATION)
09-15 11:22:13.499 27939 27939 I AppStartup: Received first critical render event.
09-15 11:22:13.500 27939 28000 I MigrationJob: About to run BackfillDigestsMigrationJob
09-15 11:22:13.502 27939 27991 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.504 27939 27939 D DynamicTheme: Previous night mode has changed previous: 0 now: 32
09-15 11:22:13.504 27939 27939 D CachedInflater: Clearing view cache.
09-15 11:22:13.506  1497  1696 W ActivityTaskManager: Activity top resumed state loss timeout for ActivityRecord{b79cf74 u0 org.thoughtcrime.securesms/.RoutingActivity} t11173 f}}
09-15 11:22:13.508 27939 27990 D NetworkConnectionListen: ConnectivityManager.NetworkCallback onBlockedStatusChanged()
09-15 11:22:13.511 27939 27939 D PassphraseRequiredActiv: routeApplicationState(), state: 0
09-15 11:22:13.511 27939 27939 D BaseActivity: [MainActivity] onCreate()
09-15 11:22:13.512 27939 27989 D IncomingMessageObserver: [Needs Connection] Network: true, Foreground: false, Time Since Last Interaction: 6 ms (within limit), FCM: true, Stay open requests: [], Registered: true, Proxy: false, Force websocket: false
09-15 11:22:13.512 27939 27989 I IncomingMessageObserver: Making websocket connection....
09-15 11:22:13.517 27939 27991 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.518 27939 27989 D IncomingMessageObserver: WebSocket State: DISCONNECTED
09-15 11:22:13.525 27939 27989 I OkHttpWebSocketConnection: [normal:166902436] connect()
09-15 11:22:13.526 27939 27991 I SignalDatabase: Upgrading database: 245, 246
09-15 11:22:13.527  1497  1696 W ActivityTaskManager: Activity pause timeout for ActivityRecord{b79cf74 u0 org.thoughtcrime.securesms/.RoutingActivity} t11173 f}}
09-15 11:22:13.527 27939 27991 I SignalDatabaseMigration: Running migration for version 246: V246_DropThumbnailCdnFromAttachments. Foreign keys: false
09-15 11:22:13.534 27939 27991 E SQLiteLog: (1) statement aborts at 12: [ALTER TABLE attachment DROP COLUMN archive_thumbnail_cdn] error in trigger message_ai: invalid fts5 file format (found 0, expected 4 or 5) - run 'rebuild'
09-15 11:22:13.538 27939 27991 W SignalUncaughtException: FTS in invalid state! Resetting FTS index.
09-15 11:22:13.546  3692  3769 E OpenGLRenderer: Unable to match the desired swap behavior.
09-15 11:22:13.556   459   459 I lowmemorykiller: Kill 'foundation.e.blissweather' (26212), uid 10095, oom_score_adj 955 to free 40536kB rss, 42792kB swap; reason: low watermark is breached and swap is low (115600kB < 182756kB)
09-15 11:22:13.560 27939 27994 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.571  1497  1697 W InputManager-JNI: Input channel object 'c1e6ee0 Splash Screen org.thoughtcrime.securesms (client)' was disposed without first being removed with the input manager!
09-15 11:22:13.574 27939 27978 D EmojiFiles: Verifying all name files exist.
09-15 11:22:13.580 27939 27994 I SQLiteConnection: Database keying operation returned:0
09-15 11:22:13.603   857   857 I android.hardware.power-service-qti: Power setMode: 5 to: 0
@rettichschnidi rettichschnidi changed the title v7.17.1: Immediate Crash (SQLiteException - invalid fts5 file format) v7.17.1: Immediate Crash (error in trigger message_ai: invalid fts5 file format (found 0, expected 4 or 5) - run 'rebuild') Sep 15, 2024
@rettichschnidi rettichschnidi changed the title v7.17.1: Immediate Crash (error in trigger message_ai: invalid fts5 file format (found 0, expected 4 or 5) - run 'rebuild') v7.17.1: Immediate Crash (invalid fts5 file format (found 0, expected 4 or 5) - run 'rebuild' | ExtraMessage: null) Sep 15, 2024
@wiregrasscoder
Copy link

Having exactly the same issue with 7.17.1. Same as 7.16.4, just crashes faster. Completely unusable.

Samsung S21
Android 14
Around 18GB of message data
Downloaded from Play Store

@sddhrthrt
Copy link

Same issue on 7.16.4, Samsung S23. Unusable.

@cody-signal
Copy link
Contributor

Thanks folks, looks like the hopeful fix for the fts file format crash didn't quite catch everything. We'll get another attempt out in 7.17.2 soon.

@devurandom
Copy link

devurandom commented Sep 16, 2024

  1. Is there a rough ETA already for 7.17.2 to arrive in Google Play Store stable branch?
  2. Would it possible (for the future) to contain such failures more? Assuming "FTS" stands for Full Text Search: I can live without search for a week while it is being fixed, but being unable to send and receive messages for a day, to stay in touch with important people, is a catastrophe.

@cody-signal
Copy link
Contributor

Submitting a 7.17.2 to the play store today, will likely crash once again after updating, but that should trigger the repair and the second start should work.

@devurandom
Copy link

devurandom commented Sep 16, 2024

Submitting a 7.17.2 to the play store today, will likely crash once again after updating, but that should trigger the repair and the second start should work.

Since it seems to take quite a while for Google Play Store to roll out updates (7.17.1 still has not arrived on my device, and it's already 3 days old), will 7.17.2 also be available from https://signal.org/android/apk/ (in addition to submitting it to the Play Store) for immediate (manual) update?

@rettichschnidi
Copy link
Author

rettichschnidi commented Sep 17, 2024

v7.17.2 fixed the issue. Thanks a lot!

@devurandom
Copy link

Since it seems to take quite a while for Google Play Store to roll out updates (7.17.1 still has not arrived on my device, and it's already 3 days old), [...]

Figured it out: 7.17.1 and 7.17.2 are beta versions. I had to join the beta programme via Google Play, wait several hours until it offered the update to me, update, then leave the beta programme again.

@greyson-signal
Copy link
Contributor

Duplicate of #13675

@greyson-signal greyson-signal marked this as a duplicate of #13675 Sep 17, 2024
@rettichschnidi
Copy link
Author

Duplicate of #13675

To my non-signal-dev eyes, those issues are not duplicates:

@pneutig
Copy link

pneutig commented Sep 18, 2024

Is there any expectation when the update will be available at https://signal.org/android/apk/?
Currently this is still 7.16.4.

Further: since Signal keeps crashing directly, will the app be able to update automatically on its own? Or will I need to reinstall the app? At the moment I am still hoping to preserve contacts and messages that are only saved within my signal app and not backed up but since I rely heavily on using the app and it has not worked for my anymore since Sunday, I would appreciate an indication if it's worth waiting or if that data will be lost anyways.
Thank you for your work. @cody-signal, @greyson-signal and everyone else

@greyson-signal
Copy link
Contributor

@pneutig Traditionally we update the website once the play store is rolled out to 100% (we rely on the play store rollout to catch bugs, since our website build has no rollout mechanism). However, given the circumstances, I've just kicked off a build now, so it should be available in 15min or so.

If you have the same issue as everyone else in this thread, you will not lose any data. You will likely need to install the build from the website manually, as the auto-update mechanism won't work.

Hope that helps!

@pneutig
Copy link

pneutig commented Sep 19, 2024

@pneutig Traditionally we update the website once the play store is rolled out to 100% (we rely on the play store rollout to catch bugs, since our website build has no rollout mechanism). However, given the circumstances, I've just kicked off a build now, so it should be available in 15min or so.

If you have the same issue as everyone else in this thread, you will not lose any data. You will likely need to install the build from the website manually, as the auto-update mechanism won't work.

Hope that helps!

@greyson-signal Thank you very much! I can indeed confirm that the update helped and my Signal app is working again. Unfortunately, messages which could not be delivered between the beginning of the problem and the update have so far not caught up (roughly 18h after update) but at least the app itself is working again.
Also FYI: to my surprise, auto-update worked. I did receive a notification by the app between 4-5am CEST, that an update was available. Tapping the notification to trigger the update did work (had to tap it twice though) and it is now version 7.17.4. I did however not receive the usual notification that the update had completed. Then, as expected, the app crashed after the first launch post-update and worked normally since then.
Hope this feedback helped. Again, thank you for your work.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

7 participants