[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
*** This bug is a duplicate of bug 727132 *** https://bugs.launchpad.net/bugs/727132 ** This bug has been marked a duplicate of bug 727132 gwibber.sqlite grows too big and causes gwibber to hang -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/799356 Title: gwibber stores extreme number of messages in gwibber.sqlite To manage notifications about this bug go to: https://bugs.launchpad.net/gwibber/+bug/799356/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
Happening for me too, my gwibber.sqlite is 1,1 GB. Counting for current
amount of messages, I got:
sqlite select count(*) from messages;
560965
So, I just removed messages older than 30 days with:
delete from messages where time (strftime('%s','now') - 30*24*60*60);
I think Gwibber should run this garbage collect periodically, but
preserving directed and send messages unless the user asks it to delete
them too.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/799356
Title:
gwibber stores extreme number of messages in gwibber.sqlite
To manage notifications about this bug go to:
https://bugs.launchpad.net/gwibber/+bug/799356/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
My gwibber.sqlite is 3.5 GB right now. And now my gwobber.sqlite.journal is 1.2 GB and growing while I watch. I have no idea what is in there, but it is slowing the system down as well as trashing the remainder of my disk space, then space returns, only to drain away again. Totally broken it seems to me. I'm not sure what gwibber is doing for me, but I never post with it, and probably just follow my twitter account with it, since I do see notifications. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/799356 Title: gwibber stores extreme number of messages in gwibber.sqlite To manage notifications about this bug go to: https://bugs.launchpad.net/gwibber/+bug/799356/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
I have 2.5 GB of free space in $HOME, and a gwibber.sqlite file that is 3.5 GB in size Every 14 minutes gwibber starts writing a gwibber.sqlite-journal file, which fills up until I'm out of space. 2 minutes later it is deleted, and 5 minutes after that it starts filling up again. I think this has gone on for hours. So that may be a separate bug from the underlying issue of the database being wastefully big to start with, but I'm just pointing out that it can end up eating up to twice that amount of disk, and running into this pathological periodic trashing of free space. I'm running 12.04 precise, with gwibber 3.4.2-0ubuntu2. What are some workarounds? How can I e.g. temporarily just disable gwibber when I'm low on space or get rid of it entirely? What are the consequences of uninstalling it? What are alternatives to gwibber? I don't even care much about the tweet notifications -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/799356 Title: gwibber stores extreme number of messages in gwibber.sqlite To manage notifications about this bug go to: https://bugs.launchpad.net/gwibber/+bug/799356/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
** Changed in: gwibber (Ubuntu) Status: Confirmed = Triaged ** Changed in: gwibber Importance: Undecided = Medium -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/799356 Title: gwibber stores extreme number of messages in gwibber.sqlite To manage notifications about this bug go to: https://bugs.launchpad.net/gwibber/+bug/799356/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
** Tags added: sqlite -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/799356 Title: gwibber stores extreme number of messages in gwibber.sqlite To manage notifications about this bug go to: https://bugs.launchpad.net/gwibber/+bug/799356/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: gwibber (Ubuntu) Status: New = Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/799356 Title: gwibber stores extreme number of messages in gwibber.sqlite To manage notifications about this bug go to: https://bugs.launchpad.net/gwibber/+bug/799356/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
Workaround: manually execute delete from messages where operation = 'search'; and compact database. That brings down the size to 3.2 MB. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/799356 Title: gwibber stores extreme number of messages in gwibber.sqlite To manage notifications about this bug go to: https://bugs.launchpad.net/gwibber/+bug/799356/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
maybe this issue could be duplicate of bug 734917 --- Ubuntu Bug Squad volunteer triager http://wiki.ubuntu.com/BugSquad -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/799356 Title: gwibber stores extreme number of messages in gwibber.sqlite To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/gwibber/+bug/799356/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
maybe this issue could be duplicate of bug 734917 No, I don't think so. That bug is about where gwibber stores different types of data; this one is about gwibber storing too much data. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/799356 Title: gwibber stores extreme number of messages in gwibber.sqlite To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/gwibber/+bug/799356/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
** Changed in: gwibber (Ubuntu) Importance: Undecided = Medium ** Also affects: gwibber Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/799356 Title: gwibber stores extreme number of messages in gwibber.sqlite To manage notifications about this bug go to: https://bugs.launchpad.net/gwibber/+bug/799356/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
-- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/799356 Title: gwibber stores extreme number of messages in gwibber.sqlite To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/gwibber/+bug/799356/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 799356] Re: gwibber stores extreme number of messages in gwibber.sqlite
It seems that merely by invoking Refresh (F5) makes gwibber store some 100 messages in the database. Does gwibber really need to store search results in a database? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/799356 Title: gwibber stores extreme number of messages in gwibber.sqlite To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/gwibber/+bug/799356/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
