Gwibber

gwibber.sqlite grows too big and causes gwibber to hang

Bug #727132 reported by XceptN
70
This bug affects 15 people
Affects Status Importance Assigned to Milestone
Gwibber
Fix Released
Undecided
Unassigned

Bug Description

I am following more than 18000 accounts by my twitter account. I think just because of that the ~/.config/gwibber/gwibber.sqlite file grows very fast.

Before I cleared all my gwibber configuration and started fresh the file was 1.5 GB of size and every refresh, operation on Gwibber was taking 5 minutes where the application seemed to hang.

After I cleared the configuration and restarted, just within a day, the file became 18MB and it is growing rapidly.. Causing every operation to become slower and slower.

I also have another Twitter account to follow and Facebook, but I do not want to integrate them before this problem is solved..

AFAICS every message coming in to the Gwibber is stored in gwibber.sqlite. If there would be a feature to cleanup of tweets / messages on the GUI, it would solve my problem.

My Setup:
- Ubuntu 10.04 32-bit
- Gwibber 2.32.2
- Only one twitter account where it follows more than 18000 other twitter accounts

Revision history for this message
Victor Vargas (kamus) wrote :

Have you tried to run a "sqlite3 .config/gwibber/gwibber.sqlite" and then run a "VACUUM;"? this could help to improve in some way the performance of gwibber.

Revision history for this message
XceptN (oyuksel153) wrote :

Thanks.. Indeed that helps a bit with the performance
- but -
that does not help with the file size. Eventually the sqlite database will get very large and it would cause problems (like it was 1.5GB before I deleted the previous one). Problems like disk space, backup problems etc. I believe a user should have the option not to log everything or at least clean the logs.

Revision history for this message
XceptN (oyuksel153) wrote :

The following workaround I came up (which clears all the tweets from the sqlite3 DB) with helps if done every now and then:

1. Stop Gwibber
2. Run
   echo -e "delete from messages;\nvacuum;" | sqlite3 ~/.config/gwibber/gwibber.sqlite
on the command line.
3. Start Gwibber

Revision history for this message
Ken VanDine (ken-vandine) wrote :

This was fixed in 2.91.92

Changed in gwibber:
status: New → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.