My app size continuously increasing for one user it become 50+ GB app (#583)
Closed
Unknown opened 1 year ago

App size increasing because of siskinim_main.db-wal file On every app launch app size is increasing, after some observation I found that siskinim_main.db-wal file size is increasing and for one of my user it become 50+ GB size file.

To Reproduce Steps to reproduce the behavior:

  1. Do some communications with users
  2. Relaunch the app
  3. Observe db-wal file size

Expected behavior I made some search about this issue and I found this file size become zero KB, correct me if I am wrong.

Screenshots Please check this screenshots

| File size | File path | App Screenshot | |-|-|-| | Screenshot 2023-07-10 at 11 29 57 AM | Screenshot 2023-07-10 at 11 22 58 AM | image |

Details (please complete the following information):

  • Siskin Version: 6.1
  • Branch: master
  • Xcode version: 14.2
  • iOS version 16.5.1
  • iPhone model iPhone 14 Pro Max
Unknown commented 1 year ago

Latest version is 7.x, you can reproduce with that too?

Unknown commented 1 year ago

Latest version is 7.x, you can reproduce with that too?

Sorry I can't migrate now, is there any fix in latest version related to this issue?

Unknown commented 1 year ago

You're the first one to report such a thing, who knows?

Is this Siskin from Tigase or some custom version that you build?

Unknown commented 1 year ago

You're the first one to report such a thing, who knows?

Is this Siskin from Tigase or some custom version that you build?

This is pure Siskin from Tigase. Because I have not built any custom feature on it. Only UI is mine, rest database and all operations are as it is since I cloned Tigase repo.

Unknown commented 1 year ago

I made some search about this issue and I found this file size become zero KB, correct me if I am wrong.

WAL files should be "cleaned up" eventually and should be zero (or small). This file is a Write Ahead Log of SQLite3 (database library). We are using SQLite3 library built in the operating system (we do not ship our own version).

Here is a similar topic from SQLite3 library forum - https://sqlite.org/forum/info/54e791a519a225de

I've checked an older version of DB library wrapping SQLite3 that we are using and I think it could contain issue mentioned in this forum at that time, but as I see it is already fixed now.

Unknown commented 1 year ago

Please note that this is very old version of the application source code that you are using and we are not maintaining this version any more.

Unknown commented 1 year ago

I understand that, but if this is database access or migration related issue which may occur if user continuously update new app from AppStore then it may be issue at Tigase side.

And we are not sure if I deliver new update with latest SDK will fix this issue for that user.

If you guys can help about how I can add some block of code to reduce that file size then it will be big help.

Unknown commented 1 year ago

As I've mentioned, fix in our database wrapper for SQLite3 already fixes this issue and will resolve WAL file size - on the newest (or most likely just newer) version of Siskin IM, this issue will not take place and will be resolved if it happened already,

Unknown commented 1 year ago

As I've mentioned, fix in our database wrapper for SQLite3 already fixes this issue and will resolve WAL file size - on the newest (or most likely just newer) version of Siskin IM, this issue will not take place and will be resolved if it happened already,

Ok let me migrate to latest version.

Unknown commented 11 months ago

Latest version fixed app size issue, but now facing different issue

Now that user is facing connection time issue, that is able to send message after 2 to 3 minutes. Every time he lauches the app his Tigase connection is taking time.

Unknown commented 10 months ago

Latest version fixed app size issue, but now facing different issue

Now that user is facing connection time issue, that is able to send message after 2 to 3 minutes. Every time he lauches the app his Tigase connection is taking time.

Posted as separate issue, so closing this. https://github.com/tigase/siskin-im/issues/235

issue 1 of 1
Type
Bug
Issue Votes (0)
Watchers (0)
Reference
tigase/_clients/siskin-im#583
Please wait...
Page is in error, reload to recover