• Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
UBports Robot Logo UBports Forum
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

OTA 25 - call history and SMS db gone

Scheduled Pinned Locked Moved Unsolved Support
18 Posts 5 Posters 820 Views 3 Watching
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • D Offline
      daha
      last edited by 2 Apr 2023, 16:33

      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.

      Volla
      Fairphone 2
      BQ Aquaris M10 FHD

      D I 2 Replies Last reply 2 Apr 2023, 17:29 Reply Quote 0
      • D Offline
        domubpkm @daha
        last edited by 2 Apr 2023, 17:29

        @daha No, everything is fine at this level on my Volla.
        How did you install OTA-25 ?
        Or you sure you haven't accidentally deleted the calls and mms files ?
        If you call now and text, do you have any record of them?

        1 Reply Last reply Reply Quote 0
        • I Online
          Ian @daha
          last edited by 2 Apr 2023, 17:47

          @daha No such problems on the Volla Phone X when updating to OTA-25.

          1 Reply Last reply Reply Quote 0
          • D Offline
            daha
            last edited by 2 Apr 2023, 18:17

            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.

            Volla
            Fairphone 2
            BQ Aquaris M10 FHD

            D 1 Reply Last reply 2 Apr 2023, 18:23 Reply Quote 0
            • D Offline
              daha
              last edited by 2 Apr 2023, 18:23

              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

              Volla
              Fairphone 2
              BQ Aquaris M10 FHD

              L 1 Reply Last reply 2 Apr 2023, 19:05 Reply Quote 0
              • D Offline
                domubpkm @daha
                last edited by 2 Apr 2023, 18:23

                @daha Maybe something went wrong during the update to OTA-25. You should try the installer to flash again without wipe

                1 Reply Last reply Reply Quote 0
                • L Offline
                  lduboeuf @daha
                  last edited by 2 Apr 2023, 19:05

                  @daha said in OTA 25 - call history and SMS db gone:

                  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

                  Do you see more logs before that one ?.
                  Nothing have been done regarding history db on Xenial. Wonder what is happening.

                  D 1 Reply Last reply 2 Apr 2023, 19:56 Reply Quote 0
                  • D Offline
                    daha @lduboeuf
                    last edited by 2 Apr 2023, 19:56

                    Anybody knows if there are any limits imposed to history size?

                    Volla
                    Fairphone 2
                    BQ Aquaris M10 FHD

                    L 1 Reply Last reply 2 Apr 2023, 20:17 Reply Quote 0
                    • D Offline
                      daha
                      last edited by 2 Apr 2023, 20:15

                      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.

                      Volla
                      Fairphone 2
                      BQ Aquaris M10 FHD

                      L 1 Reply Last reply 2 Apr 2023, 21:07 Reply Quote 0
                      • L Offline
                        lduboeuf @daha
                        last edited by 2 Apr 2023, 20:17

                        @daha said in OTA 25 - call history and SMS db gone:

                        Anybody knows if there are any limits imposed to history size?

                        There is no limit afaik, but bigger db means slower queries. But still should'nt freeze the app.
                        Meanwhile, after a backup you can remove the database to avoid that freeze

                        D 1 Reply Last reply 2 Apr 2023, 20:22 Reply Quote 0
                        • D Offline
                          daha @lduboeuf
                          last edited by 2 Apr 2023, 20:22

                          @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).

                          Volla
                          Fairphone 2
                          BQ Aquaris M10 FHD

                          1 Reply Last reply Reply Quote 0
                          • L Offline
                            lduboeuf @daha
                            last edited by 2 Apr 2023, 21:07

                            @daha said in OTA 25 - call history and SMS db gone:

                            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.

                            Just for curiosity, what the output of:
                            sqlite3 /home/phablet/.local/share/history-service/history.sqlite "SELECT COUNT(*) FROM text_events;"

                            M 1 Reply Last reply 3 Apr 2023, 05:25 Reply Quote 0
                            • M Offline
                              mihael @lduboeuf
                              last edited by mihael 4 Mar 2023, 05:53 3 Apr 2023, 05:25

                              @lduboeuf Same here: no calls history, no sms history after the update. The result output of the above command: 16595. And from voice_events: 25868. And history-daemon is using 100% of one of the cpus.

                              M 1 Reply Last reply 3 Apr 2023, 05:30 Reply Quote 0
                              • M Offline
                                mihael @mihael
                                last edited by 3 Apr 2023, 05:30

                                This post is deleted!
                                1 Reply Last reply Reply Quote 0
                                • D Offline
                                  daha
                                  last edited by 3 Apr 2023, 06:06

                                  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

                                  Volla
                                  Fairphone 2
                                  BQ Aquaris M10 FHD

                                  L 1 Reply Last reply 3 Apr 2023, 06:39 Reply Quote 0
                                  • L Offline
                                    lduboeuf @daha
                                    last edited by 3 Apr 2023, 06:39

                                    @daha said in OTA 25 - call history and SMS db gone:

                                    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

                                    Ok, it is not so big database. Already tested with more than that without issue iirc.

                                    M 1 Reply Last reply 3 Apr 2023, 06:43 Reply Quote 0
                                    • M Offline
                                      mihael @lduboeuf
                                      last edited by mihael 4 Mar 2023, 09:22 3 Apr 2023, 06:43

                                      @lduboeuf I deleted the first (oldest) 10000 records from voice_events and then restarted the phone and now I have again calls and texts history.

                                      L 1 Reply Last reply 15 Apr 2023, 21:16 Reply Quote 0
                                      • L Offline
                                        lduboeuf @mihael
                                        last edited by 15 Apr 2023, 21:16

                                        @mihael said in OTA 25 - call history and SMS db gone:

                                        @lduboeuf I deleted the first (oldest) 10000 records from voice_events and then restarted the phone and now I have again calls and texts history.

                                        interesting, so we have an issue when voice history is getting too big.
                                        That is why i've done a way to clean them in the UI meanwhile.
                                        But we could launch a clean process each time we reboot the phone to avoid that

                                        1 Reply Last reply Reply Quote 0
                                        • First post
                                          Last post