You know, I think we like to blame a spider because it's easy to find a bad guy in the problem. But that doesn't make it likely. Do we even have any reason to believe we've been spidered?
Here is your cup of coffee. Brewed from the finest Colombian lighter fluid.
Xander ,'Chosen'
Buffistas Building a Better Board
Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
bon bon - Oct 16, 2003 5:43:49 am PDT #5236 of 10000
It's five thousand for kissing, ten thousand for snuggling... End of list.
DXMachina - Oct 16, 2003 5:45:39 am PDT #5237 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
I'm wondering if we should close the board again to see if they go away, as we did last time it happened. Because they didn't, even with just the stompies posting.
Did we get slashdotted somewhere?
amych - Oct 16, 2003 5:47:31 am PDT #5238 of 10000
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?
Actually, I think a spider is less and less likely as this goes on -- the fact that it's been doing this for 24 hours now, whereas a spider should clog things up (causing anything from slowness to the errors we're seeing to a clog big enough to cause suspension) while it crawls through all the lengths and then leave.
Ed, I know you said that you had error messages before the latest code change, but are you sure? I haven't been able to get through consistently enough to go hunting back in both bureau and BBaBB to check on the times those two things got mentioned.
DXMachina - Oct 16, 2003 5:54:43 am PDT #5239 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
http://www.buffistas.org/showthread.php?thread_id=32&post_id=5170
amy, I got an error message at 8:17 board time. ita didn't mention she'd changed the code until 9:58. Certainly she would've done it earlier than that, but I'm pretty sure I was still seeing the mangled title bar after I got the error.
I think Tuesday was a much busier day than yesterday. We put close to a thousand posts into Natter alone, and we weren't getting errors. Here's another thought. Did the expiration date on open connections get reset to default somehow, so that the connections aren't getting released in a timely fashion? IIRC, the last time this happened, it was right after the hosting service instituted some changes.
amych - Oct 16, 2003 5:56:22 am PDT #5240 of 10000
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?
Thanks, Ed. I was frustrated by having a nagging thought and not being able to check one way or the other.
§ ita § - Oct 16, 2003 6:43:11 am PDT #5241 of 10000
Well not canonically, no, but this is transformative fiction.
I definitely didn't change the code until after DX saw the errors.
As for spidering -- I'm downloading the logs right now. We'll see. Last time it definitely wasn't excessive usage.
Consuela - Oct 16, 2003 7:09:05 am PDT #5242 of 10000
We are Buffistas. This isn't our first apocalypse. -- Pix
I just got an error, and it wasn't even associated with posting, just clicking on a thread to read it.
Consuela - Oct 16, 2003 7:09:43 am PDT #5243 of 10000
We are Buffistas. This isn't our first apocalypse. -- Pix
And another one:
October 16, 2003, 9:09 am Consuela[45]: ERROR [2] mysql_connect(): User bufforg_phoenix has already more than 'max_user_connections' active connections line 78 of file /home/bufforg/public_html/classes/giles.php
There has been an error. It's of the type we call fatal. Please don't be scared. You're not the one that's going to die.
Okay, where the $$&#&(@#& are the developers?
Dana - Oct 16, 2003 7:18:12 am PDT #5244 of 10000
I'm terrifically busy with my ennui.
If I understand correctly, it happens any time the site tries to make a connection to the database. Which means that sometimes it's when you try to pull posts to read, sometimes when you try to post, and sometimes when the site is trying to load thread information.
Theodosia - Oct 16, 2003 7:19:46 am PDT #5245 of 10000
'we all walk this earth feeling we are frauds. The trick is to be grateful and hope the caper doesn't end any time soon"
As long as we're not hurting anything (i.e. frelling up the indexes to the tables) by getting these errors, it's safe to continue using the board?