Skip to content
GitLab
Closed
Created by mondlicht-und-sterne@mondlicht-und-sterne

F-Droid 1.14-alpha4 - crashing when switched to background

APP_VERSION_NAME=1.14-alpha4
DISPLAY=0.currentSizeRange.smallest=[1080,1001]
0.currentSizeRange.largest=[2176,2176]
0.flags=FLAG_SUPPORTS_PROTECTED_BUFFERS+FLAG_SECURE
0.height=2176
0.metrics.density=3.0
0.metrics.densityDpi=480
0.metrics.scaledDensity=x3.0
0.metrics.widthPixels=1080
0.metrics.heightPixels=2176
0.metrics.xdpi=422.03
0.metrics.ydpi=423.333
0.name=Integrierter Bildschirm
0.orientation=0
0.pixelFormat=1
0.realMetrics.density=3.0
0.realMetrics.densityDpi=480
0.realMetrics.scaledDensity=x3.0
0.realMetrics.widthPixels=1080
0.realMetrics.heightPixels=2400
0.realMetrics.xdpi=422.03
0.realMetrics.ydpi=423.333
0.realSize=[1080,2400]
0.rectSize=[0,0,1080,2176]
0.refreshRate=60.000004
0.rotation=ROTATION_0
0.size=[1080,2176]
0.width=1080
0.isValid=true
STACK_TRACE_HASH=feda4d88
USER_COMMENT=
STACK_TRACE=java.lang.RuntimeException: An error occurred while executing doInBackground()
	at androidx.loader.content.ModernAsyncTask$3.done(ModernAsyncTask.java:164)
	at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:383)
	at java.util.concurrent.FutureTask.setException(FutureTask.java:252)
	at java.util.concurrent.FutureTask.run(FutureTask.java:271)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
	at java.lang.Thread.run(Thread.java:920)
Caused by: android.database.sqlite.SQLiteException: near ")": syntax error (code 1 SQLITE_ERROR[1]): , while compiling: SELECT fdroid_app.rowid as _id, fdroid_app.rowid, fdroid_app.repoId, fdroid_app.compatible, fdroid_app.name, fdroid_app.summary, fdroid_app.icon, fdroid_app.description, fdroid_app.whatsNew, fdroid_app.license, fdroid_app.author, fdroid_app.email, fdroid_app.webURL, fdroid_app.trackerURL, fdroid_app.sourceURL, fdroid_app.translation, fdroid_app.video, fdroid_app.changelogURL, fdroid_app.donateURL, fdroid_app.bitcoinAddr, fdroid_app.litecoinAddr, fdroid_app.flattrID, fdroid_app.liberapayID, fdroid_app.openCollective, fdroid_app.upstreamVersion, fdroid_app.upstreamVercode, fdroid_app.added, fdroid_app.lastUpdated, fdroid_app.antiFeatures, fdroid_app.requirements, fdroid_app.iconUrl, fdroid_app.featureGraphic, fdroid_app.promoGraphic, fdroid_app.tvBanner, fdroid_app.phoneScreenshots, fdroid_app.sevenInchScreenshots, fdroid_app.tenInchScreenshots, fdroid_app.tvScreenshots, fdroid_app.wearScreenshots, fdroid_app.preferredSigner, fdroid_app.suggestedVercode, fdroid_app.isApk, fdroid_app.isLocalized, suggestedApk.version AS suggestedApkVersion, installed.versionCode AS installedVersionCode, installed.versionName AS installedVersionName, installed.sig AS installedSig, fdroid_package.packageName AS package_packageName FROM fdroid_package JOIN fdroid_app ON (fdroid_app.packageId = fdroid_package.rowid)  JOIN fdroid_repo ON (fdroid_app.repoId = fdroid_repo._id)  LEFT JOIN fdroid_categoryAppMetadataJoin ON (fdroid_app.rowid = fdroid_categoryAppMetadataJoin.appMetadataId)  LEFT JOIN fdroid_category ON (fdroid_category.rowid = fdroid_categoryAppMetadataJoin.categoryId)  LEFT JOIN fdroid_apk AS suggestedApk ON (fdroid_app.suggestedVercode = suggestedApk.vercode AND fdroid_app.rowid = suggestedApk.appId) LEFT JOIN fdroid_installedApp AS installed ON (installed.packageId = fdroid_package.rowid) WHERE  ( (fdroid_app.antiFeatures IS NULL OR ()) AND (fdroid_package.preferredMetadata = fdroid_app.rowid) ) AND (COALESCE(fdroid_repo.isSwap, 0) = 0)  GROUP BY fdroid_app.rowid ORDER BY fdroid_app.isLocalized DESC, fdroid_app.name IS NULL ASC, CASE WHEN fdroid_app.icon IS NULL        AND fdroid_app.iconUrl IS NULL        THEN 1 ELSE 0 END, fdroid_app.summary IS NULL ASC, fdroid_app.description IS NULL ASC, CASE WHEN fdroid_app.phoneScreenshots IS NULL        AND fdroid_app.sevenInchScreenshots IS NULL        AND fdroid_app.tenInchScreenshots IS NULL        AND fdroid_app.tvScreenshots IS NULL        AND fdroid_app.wearScreenshots IS NULL        AND fdroid_app.featureGraphic IS NULL        AND fdroid_app.promoGraphic IS NULL        AND fdroid_app.tvBanner IS NULL        THEN 1 ELSE 0 END, CASE WHEN date(fdroid_app.added)  >= date(fdroid_app.lastUpdated)        AND date((SELECT lastUpdated FROM fdroid_repo                  WHERE _id=fdroid_app.repoId                  ),'-14 days')           < date(fdroid_app.lastUpdated)        THEN 0 ELSE 1 END, fdroid_app.whatsNew IS NULL ASC, fdroid_app.lastUpdated DESC, fdroid_app.added ASC LIMIT 200
	at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
	at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1478)
	at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:916)
	at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:590)
	at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:63)
	at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
	at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:46)
	at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:2088)
	at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:2027)
	at org.fdroid.fdroid.data.LoggingQuery.rawQuery(LoggingQuery.java:68)
	at org.fdroid.fdroid.data.LoggingQuery.rawQuery(LoggingQuery.java:165)
	at org.fdroid.fdroid.data.AppProvider.runQuery(AppProvider.java:917)
	at org.fdroid.fdroid.data.AppProvider.query(AppProvider.java:889)
	at android.content.ContentProvider.query(ContentProvider.java:1520)
	at android.content.ContentProvider.query(ContentProvider.java:1616)
	at android.content.ContentProvider$Transport.query(ContentProvider.java:286)
	at android.content.ContentResolver.query(ContentResolver.java:1226)
	at android.content.ContentResolver.query(ContentResolver.java:1158)
	at androidx.core.content.ContentResolverCompat.query(ContentResolverCompat.java:81)
	at androidx.loader.content.CursorLoader.loadInBackground(CursorLoader.java:63)
	at androidx.loader.content.CursorLoader.loadInBackground(CursorLoader.java:41)
	at androidx.loader.content.AsyncTaskLoader.onLoadInBackground(AsyncTaskLoader.java:307)
	at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:60)
	at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:48)
	at androidx.loader.content.ModernAsyncTask$2.call(ModernAsyncTask.java:141)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	... 3 more
android.database.sqlite.SQLiteException: near ")": syntax error (code 1 SQLITE_ERROR[1]): , while compiling: SELECT fdroid_app.rowid as _id, fdroid_app.rowid, fdroid_app.repoId, fdroid_app.compatible, fdroid_app.name, fdroid_app.summary, fdroid_app.icon, fdroid_app.description, fdroid_app.whatsNew, fdroid_app.license, fdroid_app.author, fdroid_app.email, fdroid_app.webURL, fdroid_app.trackerURL, fdroid_app.sourceURL, fdroid_app.translation, fdroid_app.video, fdroid_app.changelogURL, fdroid_app.donateURL, fdroid_app.bitcoinAddr, fdroid_app.litecoinAddr, fdroid_app.flattrID, fdroid_app.liberapayID, fdroid_app.openCollective, fdroid_app.upstreamVersion, fdroid_app.upstreamVercode, fdroid_app.added, fdroid_app.lastUpdated, fdroid_app.antiFeatures, fdroid_app.requirements, fdroid_app.iconUrl, fdroid_app.featureGraphic, fdroid_app.promoGraphic, fdroid_app.tvBanner, fdroid_app.phoneScreenshots, fdroid_app.sevenInchScreenshots, fdroid_app.tenInchScreenshots, fdroid_app.tvScreenshots, fdroid_app.wearScreenshots, fdroid_app.preferredSigner, fdroid_app.suggestedVercode, fdroid_app.isApk, fdroid_app.isLocalized, suggestedApk.version AS suggestedApkVersion, installed.versionCode AS installedVersionCode, installed.versionName AS installedVersionName, installed.sig AS installedSig, fdroid_package.packageName AS package_packageName FROM fdroid_package JOIN fdroid_app ON (fdroid_app.packageId = fdroid_package.rowid)  JOIN fdroid_repo ON (fdroid_app.repoId = fdroid_repo._id)  LEFT JOIN fdroid_categoryAppMetadataJoin ON (fdroid_app.rowid = fdroid_categoryAppMetadataJoin.appMetadataId)  LEFT JOIN fdroid_category ON (fdroid_category.rowid = fdroid_categoryAppMetadataJoin.categoryId)  LEFT JOIN fdroid_apk AS suggestedApk ON (fdroid_app.suggestedVercode = suggestedApk.vercode AND fdroid_app.rowid = suggestedApk.appId) LEFT JOIN fdroid_installedApp AS installed ON (installed.packageId = fdroid_package.rowid) WHERE  ( (fdroid_app.antiFeatures IS NULL OR ()) AND (fdroid_package.preferredMetadata = fdroid_app.rowid) ) AND (COALESCE(fdroid_repo.isSwap, 0) = 0)  GROUP BY fdroid_app.rowid ORDER BY fdroid_app.isLocalized DESC, fdroid_app.name IS NULL ASC, CASE WHEN fdroid_app.icon IS NULL        AND fdroid_app.iconUrl IS NULL        THEN 1 ELSE 0 END, fdroid_app.summary IS NULL ASC, fdroid_app.description IS NULL ASC, CASE WHEN fdroid_app.phoneScreenshots IS NULL        AND fdroid_app.sevenInchScreenshots IS NULL        AND fdroid_app.tenInchScreenshots IS NULL        AND fdroid_app.tvScreenshots IS NULL        AND fdroid_app.wearScreenshots IS NULL        AND fdroid_app.featureGraphic IS NULL        AND fdroid_app.promoGraphic IS NULL        AND fdroid_app.tvBanner IS NULL        THEN 1 ELSE 0 END, CASE WHEN date(fdroid_app.added)  >= date(fdroid_app.lastUpdated)        AND date((SELECT lastUpdated FROM fdroid_repo                  WHERE _id=fdroid_app.repoId                  ),'-14 days')           < date(fdroid_app.lastUpdated)        THEN 0 ELSE 1 END, fdroid_app.whatsNew IS NULL ASC, fdroid_app.lastUpdated DESC, fdroid_app.added ASC LIMIT 200
	at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
	at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1478)
	at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:916)
	at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:590)
	at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:63)
	at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
	at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:46)
	at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:2088)
	at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:2027)
	at org.fdroid.fdroid.data.LoggingQuery.rawQuery(LoggingQuery.java:68)
	at org.fdroid.fdroid.data.LoggingQuery.rawQuery(LoggingQuery.java:165)
	at org.fdroid.fdroid.data.AppProvider.runQuery(AppProvider.java:917)
	at org.fdroid.fdroid.data.AppProvider.query(AppProvider.java:889)
	at android.content.ContentProvider.query(ContentProvider.java:1520)
	at android.content.ContentProvider.query(ContentProvider.java:1616)
	at android.content.ContentProvider$Transport.query(ContentProvider.java:286)
	at android.content.ContentResolver.query(ContentResolver.java:1226)
	at android.content.ContentResolver.query(ContentResolver.java:1158)
	at androidx.core.content.ContentResolverCompat.query(ContentResolverCompat.java:81)
	at androidx.loader.content.CursorLoader.loadInBackground(CursorLoader.java:63)
	at androidx.loader.content.CursorLoader.loadInBackground(CursorLoader.java:41)
	at androidx.loader.content.AsyncTaskLoader.onLoadInBackground(AsyncTaskLoader.java:307)
	at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:60)
	at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:48)
	at androidx.loader.content.ModernAsyncTask$2.call(ModernAsyncTask.java:141)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
	at java.lang.Thread.run(Thread.java:920)
PHONE_MODEL=SM-G991B
CUSTOM_DATA=
PACKAGE_NAME=org.fdroid.fdroid
BRAND=samsung
ANDROID_VERSION=12
AVAILABLE_MEM_SIZE=73229041664
PRODUCT=o1sxeea
TOTAL_MEM_SIZE=114057785344

photo1639341044

Edited by Licaon_Kter
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information