On startup E/SQLiteLog: no such table: favicons

NEW
Unassigned

Status

()

Firefox for Android
Data Providers
3 years ago
2 years ago

People

(Reporter: aaronmt, Unassigned)

Tracking

37 Branch
ARM
Android
Points:
---

Firefox Tracking Flags

(Not tracked)

Details

Attachments

(1 attachment)

(Reporter)

Description

3 years ago
Probably expected but wonder if something is happening on startup that is unnecessary:

  E/SQLiteLog(10419): (1) no such table: favicons
I think this is an internal log from sqlite, and what you get when you do DROP TABLE IF EXISTS.

Are you seeing this on every startup, only on first run, or something else?

Extra points if you:

 adb shell setprop log.tag.SQLiteDatabase VERBOSE
 adb shell setprop log.tag.SQLiteLog VERBOSE
 adb shell setprop log.tag.SQLiteStatement VERBOSE
 adb shell setprop log.tag.Databases VERBOSE
 adb shell setprop log.tag.GeckoBrowserDBHelper VERBOSE


and try again.
Component: Favicon Handling → Data Providers
Flags: needinfo?(aaron.train)
(Reporter)

Comment 2

3 years ago
Created attachment 8531627 [details]
log.log

Saw this on profile creation first-run, that's why I expect this to be expected

Only other interesting addition with logging I see is an 'abort':

E/SQLiteLog( 5838): (2067) abort at 45 in [INSERT INTO environments(sysVersion,architecture,hash,updateChannel,cpuCount,acceptLangSet,addonsID,pluginCount,screenYInMM,uiMode,appVersion,xpcomabi,version,extensionCount,isBlocklistEnabled,

Log attached
Flags: needinfo?(aaron.train)
Comment on attachment 8531627 [details]
log.log

So... this is weird. That logging indicates that it's happening during open, immediately after creation, and the creation succeeded.

All of our access is going via the content provider, which is thread-safe, so we should be sure that our onCreate has finished by this point.


D/GeckoBrowserDBHelper(13895): Creating favicons table
...
E/SQLiteLog(13895): (1) no such table: favicons


Thanks, Android and/or sqlite.
You need to log in before you can comment on or make changes to this bug.