sqlite> select * from requests; 1|com.nokia.heremaps_here|0|1423348965594967842|1 2|com.ubuntu.clock_clock|0|1423391392833202085|1 3|uber-ubuntu.daniel-mcguire351_Uber|0|1424819347207143724|1 4|me.yohanboniface.osmtouch_OSMTouch|0|1425821748981867115|1 5|com.ubuntu.developer.liu-xiao-guo.map_map|0|1429173412780625245|1 6|com.ubuntu.developer.mzanetti.fahrplan2_fahrplan2|0|1429352667149627245|1 7|com.popey.forecast_forecast|0|1429397745410816664|1 8|com.mikeasoft.cachemere_cachemere|0|1429603220000160561|1 9|tmon.mzanetti_app|0|1431566036020279135|1 10|com.popey.osm_osm|0|1431567888282451734|1 11|com.ubuntu.developer.webapps.webapp-googlemaps_webapp-googlemaps|0|1431567916291332735|1 12|com.nokia.heremaps_here|0|1431568057787601282|0 13|com.popey.forecast_forecast|0|1431568058286133744|0 14|com.ubuntu.developer.liu-xiao-guo.map_map|0|1431568059931874897|0 15|tmon.mzanetti_app|0|1431568062045077898|0 16|me.yohanboniface.sensorsstatus_SensorsStatus|0|1431568400695075687|1 17|com.ubuntu.developer.mzanetti.getmewheels2_getmewheels2|0|1431569481390583059|1 18|tmon.mzanetti_app|0|1431569992116618936|1 19|com.nokia.heremaps_here|0|1432858922021890962|1 20|com.popey.forecast_forecast|0|1433067149821733158|1 21|com.ubuntu.developer.liu-xiao-guo.map_map|0|1433067151425318082|1 22|osmscout.fransschreuder_OSMScout|0|1433274473507330108|1 23|com.ubuntu.developer.derjasper.tankenapp_tanken|0|1434362427218537082|1 24|googleapps.mattirn_googleapps|0|1441560173518531787|0 25|com.ubuntu.developer.webapps.webapp-googlemaps_webapp-googlemaps|0|1443717701994305080|0 26|com.ubuntu.developer.webapps.webapp-googlemaps_webapp-googlemaps|0|1443717703138252233|1 27|com.nokia.heremaps_here|0|1444215511146908240|0 28|com.nokia.heremaps_here|0|1444215512591317624|1 29|uber-ubuntu.daniel-mcguire351_Uber|0|1445519649670519038|0 30|tmon.mzanetti_app|0|1445519650168852269|0 31|osmscout.fransschreuder_OSMScout|0|1445519650606646346|0 32|me.yohanboniface.sensorsstatus_SensorsStatus|0|1445519651012150346|0 33|com.ubuntu.developer.liu-xiao-guo.map_map|0|1445519652932123653|0 34|com.ubuntu.developer.derjasper.tankenapp_tanken|0|1445519654039834499|0 35|com.popey.forecast_forecast|0|1445519655507682040|0 Comparing with what's installed: 1|com.nokia.heremaps_here installed, functional 2|com.ubuntu.clock_clock installed, functional 3|uber-ubuntu.daniel-mcguire351_Uber *NOT* installed *NOT* functional (was only installed through store) 4|me.yohanboniface.osmtouch_OSMTouch installed, functional 5|com.ubuntu.developer.liu-xiao-guo.map_map *NOT* installed, *NOT* functional (was sideloaded with SDK at some point) 6|com.ubuntu.developer.mzanetti.fahrplan2_fahrplan2 installed, functional 7|com.popey.forecast_forecast *NOT* installed, *NOT* functional (was only installed through store) 8|com.mikeasoft.cachemere_cachemere installed, functional 9|tmon.mzanetti_app *NOT* installed, *NOT* functional (was sideloaded at some point) 10|com.popey.osm_osm installed, functional 11|com.ubuntu.developer.webapps.webapp-googlemaps_webapp-googlemaps installed, functional 12|com.nokia.heremaps_here DUPLICATE of 1??? Only one shows up in systemsettings 13|com.popey.forecast_forecast DUPLICATE of 7 14|com.ubuntu.developer.liu-xiao-guo.map_map duplicate of 5 15|tmon.mzanetti_app DUPLICATE of 9 16|me.yohanboniface.sensorsstatus_SensorsStatus *NOT* installed, *NOT* functional 17|com.ubuntu.developer.mzanetti.getmewheels2_getmewheels2 installed, functional 18|tmon.mzanetti_app DUPLICATE of 9 and 15 19|com.nokia.heremaps_here DUPLICATE of 1 and 12 20|com.popey.forecast_forecast DUPLICATE of 13 and 7 21|com.ubuntu.developer.liu-xiao-guo.map_map DUPLICATE of 5 22|osmscout.fransschreuder_OSMScout *NOT* installed, *NOT* functional (was installed through OpenStore) 23|com.ubuntu.developer.derjasper.tankenapp_tanken *NOT* installed, *NOT* functional 24|googleapps.mattirn_googleapps *NOT* installed 25|com.ubuntu.developer.webapps.webapp-googlemaps_webapp-googlemaps *NOT* installed (installed through store) 26|com.ubuntu.developer.webapps.webapp-googlemaps_webapp-googlemaps *NOT* installed (installed through store) 27|com.nokia.heremaps_here DUPE 28|com.nokia.heremaps_here DUPE 29|uber-ubuntu.daniel-mcguire351_Uber *NOT* installed, (was installed through store) 30|tmon.mzanetti_app DUPE 31|osmscout.fransschreuder_OSMScout DUPE 32|me.yohanboniface.sensorsstatus_SensorsStatus DUPE 33|com.ubuntu.developer.liu-xiao-guo.map_map DUPE 34|com.ubuntu.developer.derjasper.tankenapp_tanken DUPE 35|com.popey.forecast_forecast DUPE Deduped: 1|com.nokia.heremaps_here installed 2|com.ubuntu.clock_clock installed 3|uber-ubuntu.daniel-mcguire351_Uber *NOT* installed (was installed from store) 4|me.yohanboniface.osmtouch_OSMTouch installed 5|com.ubuntu.developer.liu-xiao-guo.map_map *NOT* installed (was sideloaded with SDK) 6|com.ubuntu.developer.mzanetti.fahrplan2_fahrplan2 installed 7|com.popey.forecast_forecast *NOT* installed (was installed from store) 8|com.mikeasoft.cachemere_cachemere installed 9|tmon.mzanetti_app *NOT* installed (was sideloaded with SDK) 10|com.popey.osm_osm installed 11|com.ubuntu.developer.webapps.webapp-googlemaps_webapp-googlemaps installed 16|me.yohanboniface.sensorsstatus_SensorsStatus *NOT* installed (was installed through store) 17|com.ubuntu.developer.mzanetti.getmewheels2_getmewheels2 installed 22|osmscout.fransschreuder_OSMScout *NOT* installed (was installed through store AND sideloaded through OpenStore) 23|com.ubuntu.developer.derjasper.tankenapp_tanken *NOT* installed (was installed through store) 24|googleapps.mattirn_googleapps *NOT* installed (was installed through store) shown in systemsettings: total: 16 entries (matches with deduped list) working: 8 entries (cachemere, here, osm, clock, fahrplan2, getmewheels2, googlemaps, osmtouch) (matches wtih installed list) broken: 8 entries ( 5 installed through official store, 3 sideloaded) Result: This indeed seems to be entries for apps that were installed at some point but got removed. However, it does *not* only apply to sideloaded packages but also packages installed from the official store.