search

jparyani / Tiny-Tiny-RSS

A PHP and Ajax feed reader
http://tt-rss.org/
GNU General Public License v2.0
10 stars 6 forks source link

Fix purge #1

Open ocdtrekkie opened 10 years ago

ocdtrekkie commented 10 years ago

I emailed about it, but I figured I'd grab Issue #1 on here. ;) Still not a priority, though my Tiny-Tiny-RSS grain is up at 56 MB so far.

I'm actually trying to debug it myself though. You call update.php --feeds, which calls update_daemon_common in rssfuncs.php, which calls update_rss_feed, which calls purge_feed. So it's not that you're missing a cron job or something, it's just not working as intended.

ocdtrekkie commented 10 years ago

Actually, what I currently don't get, is what IS calling the update.php. You call it both in php.sh and the Dockerfile. But I didn't think Sandstorm used the Dockerfile, and I don't see anywhere else php.sh is called.

jparyani commented 10 years ago

Sorry, this is a bit convoluted (and undocumented). I'm using phusion's docker baseimage (https://github.com/phusion/baseimage-docker), and the line with ADD php.sh /etc/service/php/run is copying php.sh to the service directory. /sbin/my_init will run everything in /etc/service upon startup.

ocdtrekkie commented 10 years ago

And that's why I've strayed away from porting PHP apps. o_o

Alright, so, revised theories: I cut the pruning time way down, to a week, and from the UI, it seems to be following it, I can't scroll past that in old posts. Size never went down though, I just can't go past the purge date. With the horrible navigational strategy of browsing the backup file's database tables using Notepad++ (I do not recommend this), it seems ttrss_entries.ibd (15 MB in my file) is not getting cleaned out.

Purge function is on line 215 of https://github.com/gothfox/Tiny-Tiny-RSS/blob/fc1f0a6847c9c9fb4f265be85a3b66a5e4eb5b12/include/functions.php seems to delete from ttrss_user_entries (9 MB in my file), but I don't see deleting from ttrss_entries at all.

I may have to actually set up a normal Tiny Tiny RSS somewhere so I can see what's up with that with trusty old phpMyAdmin. ibdata1 is 18 MB in my file, but it's very definitely not meant to be opened in a text editor.