Page 1 of 1

nEwZ[NZB] Spammer, stuck with 13.7 million headers which I c

PostPosted: Tue Jan 31, 2017 12:30 pm
by MVer
Hi Folks,

In a.b.teevee, I have an 8.1GB Storage.db3 file, which equates to around 13.7 million from this donkey.

I'm on 6.73rc2 (4820) now but didn't notice this idiot until it was too late.

If I kill nbpro and reload 7 days of headers, it comes up with the 13.7 mill. I can scroll down and delete around 1000 posts at a time (takes a few mins each) but if I scroll to much greater number, (say half or quarter of the scroll bar), then nbpro hangs then seems to do no more.

I lastly tried the mechanism someone else described, "delete all posts from this poster", that was done at 12:55 yesterday, around 28hrs ago and there has been no change to the database access time or size since then.

Aside from deleting the database totally and clean downloading (I'm already about 2 weeks behind); which would take forever and three quarters for me (at around 2.5 mill post each day) as I only have 6mbits; is there anything else anyone can suggest please, I'm kind of stuck now and getting further behind each day.

Many thanks and best wishes to all, Martin.

Re: nEwZ[NZB] Spammer, stuck with 13.7 million headers which

PostPosted: Tue Jan 31, 2017 4:27 pm
by Quade
1 - Considering how DMCA has pretty much made older files useless, why bother with older posts? I'd wipe the DB then pull the last couple days worth of headers. You can do that "Download Age".

2 - Deleting will never shrink the database. Only compacting the DB after delete will make it small. The "Post Storage" section of the right click menu gives access so some DB related commands.

Re: nEwZ[NZB] Spammer, stuck with 13.7 million headers which

PostPosted: Wed Feb 15, 2017 10:53 pm
by vspazv
He started using random usernames but his subject lines are a bit unique due to always having \::blah.234blah.blah::/ in them

The following filter works well to kill them without seeming to catch anything else:

Reject if Subject Contains \\::\S+::\/