Before pruning the voice_events table:
dave@salsero:~$ sqlite3 history.sqlite.ota24
SQLite version 3.22.0 2018-01-22 18:45:57
sqlite> select count() from voice_events;
16478
sqlite> select count() from text_events;
4254
Before pruning the voice_events table:
dave@salsero:~$ sqlite3 history.sqlite.ota24
SQLite version 3.22.0 2018-01-22 18:45:57
sqlite> select count() from voice_events;
16478
sqlite> select count() from text_events;
4254
@lduboeuf It did not freeze the apps. Both apps started - though after longer delay (there must be timeout hardcoded somewhere). But the history was not available (i.e. was shown empty).
OK, the problem is probably solved. It seems that the problem is related to the size of history database. It probably just coincided with OTA-25 install and subsequent reboot. In my case, I have kept the history database from the very start of Ubuntu Touch.. When moving to newer phone I have always copied the call and SMS history. I use to prune the SMS history but not the call history.. Now the database probably grew to such big size that the history-daemon failed to parse the db in time (which is probably hardcoded somewhere) and timeouted. After pruning the call history using sqlite3 tool both dialer and messaging app work with the history again.
Anybody knows if there are any limits imposed to history size?
DBUS error log says:
Using database at "/home/phablet/.local/share/history-service/history.sqlite
Activating service name='com.canonical.HistoryService'
Failed to activate service 'com.canonical.HistoryService': timed out
Regular update from OTA-24. More details: the history.sqlite file is still there, but when I start phone app or messaging app the history-daemon CPU usage goes to 100% and both apps take long time to start. After some time the apps do initialize but with empy history.
Hi,
after update of my Volla phone to OTA 25 I have ended with empty call history and SMS database. Anybody noticed same problem?
David H.
@stanwood Hi, this bug has been reported here: https://github.com/ubports/ubuntu-touch/issues/1977
Hi, how do I revert to previous OTA build? The goal is to verify if bug has been introduced in latest OTA.. Thanks..