[BUG] Old SMSs are vanishing

Tracked by Jolla

asked 2015-05-22 12:36:47 +0200

IZ1IVA gravatar image

updated 2016-09-05 18:34:26 +0200

Yesterday it occurred to me that all SMSs older than a recent date are vanishing.

  • seen in 1.1.4.29, possibly still present in 2.0.1.11 as reported by @plemil (see Comments)
  • contacts are on the Jolla and linked to a CardDAV contact (Fruux)
  • I've tried rebooting the device, no change
  • I didn't accidentaly delete anything

Is there anything I can do to restore those SMSs?

Is there a practical limit in the SMSs count?

Thank you!

EDIT 0: following @chris.adams' precious instructions in the Comments, it appears that those SMSs have indeed vanished from the database... to me it seems quite a serious bug, doesn't it?

EDIT 1: at first only SMSs from a single contacts disappeared, now it's happening with other contacts too!

I'm dying to have this tracked by Jolla... am I the only one dealing with disappearing SMSs?

edit retag flag offensive close delete

Comments

3

I don't know much about the messaging area, but I can tell you the location of the commhistory database:

/home/nemo/.local/share/commhistory/commhistory.db

The "Events" table of that database should contain the messages.

Cheers, Chris.

chris.adams ( 2015-05-27 06:42:16 +0200 )edit
2

Thank you @chris.adams!

Below are the contents of the commhistory folder:

[nemo@Jolla commhistory]$ ls -la
total 14376
drwxr-xr-x 1 nemo privileged     108 2014-04-16 16:59 .
drwxr-xr-x 1 nemo nemo           920 2015-05-25 19:19 ..
-rw-r--r-- 1 nemo privileged 8386560 2015-05-26 19:54 commhistory.db
-rw-r--r-- 1 nemo privileged   32768 2015-05-27 09:28 commhistory.db-shm
-rw-r--r-- 1 nemo privileged 6296416 2015-05-27 09:28 commhistory.db-wal
drwxr-xr-x 1 nemo privileged     626 2015-05-26 21:24 data

Does anybody see something wrong in there?

IZ1IVA ( 2015-05-27 10:45:24 +0200 )edit
1

The ownership seems correct.

If you do:

$ devel-su -p sqlite3 commhistory.db "SELECT * from Events;" > results.txt

then look through the results.txt for the particular contact whose data is now missing from the Messages application, are the messages still in the database? Or are they gone from there too? I'm just wondering if this is more of a UI issue or a database / cleanup trigger issue, perhaps.

chris.adams ( 2015-05-27 12:22:11 +0200 )edit
1

They seem to be gone @chris.adams, as before May 21st each line with the contact number has no trailing text:

21151|3|1432139793|1432139858|2|0|1|0|0|0|0|/org/freedesktop/Telepathy/Account/ring/tel/account0|+1234567890||||||2015-05-20T16:36:33.966||||0|0||||0|0|0||0|0|0

+1234567890 is the contact's number.

IZ1IVA ( 2015-05-27 17:00:32 +0200 )edit
2

Now this seems to have happend to me but not for all contacts. Im running SFOS 2.0.1.11 If I do a ls -la in the commhistory folder I get a similar view to @IZ1IVA regarding ownership.

This is my curently oldest message to this contact:

2779|2|1467822051|1467822051|2|0|1|0|0|2|0|/org/freedesktop/Telepathy/Account/ring/tel/account0|XXtelephonenumberXX|||Bröd x2  fast jag kan skippa östras denna gången. Kneip eller lantbrödet funkar... Pussp|74|/ril_0/message_FF5BBD9F355D8FB76896D534C0B72384EAE6043A|1467822051||||0|0||||0|0|0||0|0|0

Any older ones look like this:

2743|3|1467474822|1467474860|2|0|1|0|0|0|0|/org/freedesktop/Telepathy/Account/ring/tel/account0|XXtelephonenumberXX||||||1467474822||||0|0||||0|0|0||0|0|0

And all my dates looks fishy, could that be because of my Swedish locale?

plemil ( 2016-07-08 12:52:15 +0200 )edit