Member registration issues

stuarttunstall · 2019-05-20 5:42 pm

Hi

I have had a genuine member try to join my website but received an error that it could not connect to the database..

I have also notice very few registrations today which may or may not be correct but seems odd... I have checked the logs and there is a load of entries all look to b spam..

Any idea if there has been an issue?

Stuart

Alex Kemp · 2019-05-20 6:52 pm

Yes. There is a vast uptick in spam from new emails not yet in SFS. See SFS report + OSM report.

Added later:
Then again, the API seems to have died (0 unique enquiries on the Stats page) so maybe it is that. I've sent an email to prod pedigree, so we will see.

NeoFox · 2019-05-21 4:24 pm

My HPs are still doing the usual roughly 15-20 reports/hour so my end is still sending them in.

Alex Kemp · 2019-05-21 4:59 pm

On unique clients only:
May 16, 17, 18, 19 & 20 == ~2,000 enquiries/day, and at some point between it twice dropped to zero.
May 21 is currently (17:56 BST) back up to >78,000, so seems to have recovered.

stuarttunstall · 2019-05-21 5:30 pm

So it seems there was an issue with forums accessing the forum spam database?

I have had registrations today OK

NeoFox · 2019-05-21 5:34 pm

@Alex I had had fun for like 10 minutes just hovering over the countries....lol. XD

Alex Kemp · 2019-05-21 7:45 pm

@stuarttunstall:
It seems that way. pedigree is the only guy that has Admin access to the API, so until he reports we are all mostly blind as to what was happening.

@NeoTiger:
The amount of time that the whole thing takes to load I should hope that someone manages to get a little fun from it. BTW Ukraine has been #1 like forever.

Alex Kemp · 2019-05-22 8:41 am

I'm not sure if the API or the Stats package (or both) has crashed. 'Unique Clients' seems to bump along the bottom although today's figure is always normal (but never yesterday's). I've sent a 2nd message to pedigree.

pedigree · 2019-05-22 11:21 pm

checking in

the stats here were broken entirely by me changing the way that they are recorded. before they were taken from the API updating memcache on just the www.stopforumspam.com/api query, but I changed that so that it recorded all the unique clients across all the load balanced nodes.

I did have a dead node on a server, but traffic stopped routing to that quickly, within seconds. My monitoring also blew up over a 12 hour period, just as I went to bed as it happened, which resulted in a lot of "flapping" on/off of queries to servers but that was entirely my side and limited to only the VPN connection between the monitoring box as the server, nothing that would impact the servers ability to do API queries

What api endpoint are you using for your queries? www.stopforumspam.com/api or api.stopforumspam.org/api?

pedigree · 2019-05-22 11:45 pm

well, i just looked at my code and realised that i should not code at 2am. I'll reset the stats figures for those dates after the code stat data is inserted tomorrow.

Bit of a false herring sorry, but if there is an api problem, i want to fix it

Alex Kemp · 2019-05-23 12:00 am

Thanks ped.

pedigree · 2019-05-23 1:41 am

well, i messed that up again, sigh. I'll restore last nights database backup and restore that stats table to fix the mess

hint ... don't forget the "... where stats_date = now()";

Alex Kemp · 2019-05-23 5:48 am

Hah! 'Unique Clients' has literally flat-lined (every month shows '41,983'). This is the moment to discover that backup() has never worked properly.

pedigree · 2019-05-23 9:28 am

backup() works thanks to the glory of a slave replica with an hour ZFS snapshot

#1 2019-05-20 5:42 pm

Member registration issues

#2 2019-05-20 6:52 pm

Re: Member registration issues

#3 2019-05-21 4:24 pm

Re: Member registration issues

#4 2019-05-21 4:59 pm

Re: Member registration issues

#5 2019-05-21 5:30 pm

Re: Member registration issues

#6 2019-05-21 5:34 pm

Re: Member registration issues

#7 2019-05-21 7:45 pm

Re: Member registration issues

#8 2019-05-22 8:41 am

Re: Member registration issues

#9 2019-05-22 11:21 pm

Re: Member registration issues

#10 2019-05-22 11:45 pm

Re: Member registration issues

#11 2019-05-23 12:00 am

Re: Member registration issues

#12 2019-05-23 1:41 am

Re: Member registration issues

#13 2019-05-23 5:48 am

Re: Member registration issues

#14 2019-05-23 9:28 am

Re: Member registration issues

Board footer