SoylentNews is people
SoylentNews
After a morning of slow query logging and cussing, a misplaced "GROUP BY" that was turning a 0.04 second query into one that took over fifteen seconds has been fixed. I'll leave the slow query log running overnight though just to make sure I didn't miss any less common ones. If you're still seeing any serious site slowdowns, let us know.
This discussion has been archived.
No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
F.S. Fitzgerald to Hemingway:
"Ernest, the rich are different from us."
Hemingway:
"Yes. They have more money."
(Score: 0) by Anonymous Coward on Tuesday January 08 2019, @07:21PM (11 children)
I'd like the "Invalid form key" errors to go away. I'm not behind a proxy or firewall (unless my ISP is doing weird things), nor did I did the damn back key. I can not determin any pattern on my end for when the errors occur. It is quite frustrating. I wonder if it only happens to those of us posting as AC.
(Score: 0) by Anonymous Coward on Tuesday January 08 2019, @11:26PM
I see those once in 50 posts or so. I don't know why it would happen more with others, when I am using a Frankenbrowser.
(Score: 0) by Anonymous Coward on Tuesday January 08 2019, @11:47PM (3 children)
I would like the "slow down cowboy" thing to disappear. Commenting, navigating to another story, reading comments and then trying to comment may take me less than the limit, which is I think 60 seconds.
(Score: 3, Interesting) by The Mighty Buzzard on Wednesday January 09 2019, @12:49AM (2 children)
Sounds good until you realize it would leave folks able to spam the complete and utter hell out of every non-archived story without so much as a speed bump. It is a thing that's extended to subscribers though. Not because they're special but because at least the site got something useful out of it if they waste a bunch of staff time cleaning up after them.
My rights don't end where your fear begins.
(Score: 2) by maxwell demon on Wednesday January 09 2019, @06:54AM (1 child)
What about enacting the time limit only for three or more posts in a row? Spammers would still get blocked, but most normal users won't run into the restriction.
The logic could be almost the same as currently: Instead of denying a new post when there was one post in the last 60 seconds, you'd deny a new post when there were 2 posts in the last 120 seconds.
The Tao of math: The numbers you can count are not the real numbers.
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @11:25AM
Doable but that'd still require formkeys. I was thinking to yoink that logic out entirely for registered users.
My rights don't end where your fear begins.
(Score: 2) by Pino P on Wednesday January 09 2019, @12:41AM (5 children)
"Invalid form key" might happen if you click Reply and then wait several hours before submitting.
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @12:50AM (4 children)
Or if you change IP addresses, yep.
My rights don't end where your fear begins.
(Score: 2) by Runaway1956 on Wednesday January 09 2019, @03:19AM (1 child)
I've seen both of those. Type a reply, get called away by the wife, come back and hit submit. Or change to VPN, or disconnect from VPN. Both easily solved - hit the "back" button, copy what you had typed, then reload the topic to which you were responding, hit the "reply" button again. It's a mild irritant, might really piss some other people off.
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @04:27AM
It'd probably be a good idea to ditch it for all registered users, honestly. If they get their spam on we have a damned easy recourse, so there's not really a need for them. Cleanup would still be annoying but not insurmountable.
My rights don't end where your fear begins.
(Score: 2) by Pino P on Wednesday January 09 2019, @02:15PM (1 child)
If I'm commenting while riding the city bus, then my IP address will change depending on what hotspots my laptop or phone happens to pick up at the time. Could the form key IP address check be made less stringent for logged-in users, or for excellent-karma logged-in users? Or is it considered a measure against account compromise?
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @02:21PM
It could likely be removed entirely for registered users. I'll need some thought time on the ramifications.
My rights don't end where your fear begins.