Mal: Then I call it a win. What's the problem? Inara: Should I start with the part where you're stranded in the middle of nowhere, or the part where you have no clothes?

'Trash'


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.

To-do list


Cashmere - Oct 21, 2003 10:16:46 pm PDT #5424 of 10000
Now tagless for your comfort.

and I spoke too soon--I did get a few errors. They are appearing less, though. But that could just be the low traffic at this time of night.


Tom Scola - Oct 22, 2003 2:07:33 am PDT #5425 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.

These are the facts as I understand them right now:

  • We are regularly getting refused connections from the mysql server, saying that we have exceeded 'max_user_connections' for our account.

  • According to the mysql server, the value of 'max_user_connections' is set to 100.

  • According to the MySQL manual, when you get too many connection messages, you can use the SHOW PROCESSLIST query to see all of your connections. I have verified this using MySQL on my own system at home.

  • When we connect to the mysql server and do a SHOW PROCESSLIST query, it shows that we only have one connection.

  • When we connect to the mysql server via the command line, the web server is completely locked out. We also cannot make a second connection to the mysql server from the command line.

Therefore, I have come to the following conclusion.

  • Either the mysql server is broken, and is only allowing us one concurrent connection at a time, instead of 100, or whatever number that we are allowed to have, or,

  • The mysql server is broken, and is not reporting the correct information from the SHOW PROCESSLIST query.

The first scenario is much more likely. Further evidence supporting my hypothesis that the error occurs when more than one user hits the web server simultaneously can be found by examining a sample from the access_log and error_log files. Do we have access to them?

In either event, it is my opinion that the mysql server is broken. This is not something we "mention" to them as "feedback", this is something that the ISP needs to fix, or at the very least, provide us a better explanation, using data that we don't have access to.

This, of course, is purely a technical assessment. I have no knowledge of our interpersonal relationship with the ISP.


§ ita § - Oct 22, 2003 4:26:18 am PDT #5426 of 10000
Well not canonically, no, but this is transformative fiction.

This is not something we "mention" to them as "feedback", this is something that the ISP needs to fix, or at the very least, provide us a better explanation, using data that we don't have access to.

Unfortunately, according to Kristen, they've had it with us.

I checked the error log files, and there are four connection_refuseds -- for each db_status I ran during the fifteen minutes down. The access_log isn't behaving for me right now, so I'll grab it from work.


Anne W. - Oct 22, 2003 4:39:10 am PDT #5427 of 10000
The lost sheep grow teeth, forsake their lambs, and lie with the lions.

Unfortunately, according to Kristen, they've had it with us.

Huh. I don't see us as being particularly difficult customers. Does the Phoenix really take up that much more space or whatever than other sites?


§ ita § - Oct 22, 2003 4:43:59 am PDT #5428 of 10000
Well not canonically, no, but this is transformative fiction.

Rob, what do you make of the inability to open two mysql command line connections at once?

I don't see us as being particularly difficult customers

Me neither, but I don't know what it's like on their side.


DXMachina - Oct 22, 2003 5:03:32 am PDT #5429 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.

Um, the title graphic for the Message Center (the one that says Message Center in the Buffied font) has changed into a black dot.

Are we having fun yet?


Jon B. - Oct 22, 2003 5:04:31 am PDT #5430 of 10000
A turkey in every toilet -- only in America!

The graphic looks fine to me.


DXMachina - Oct 22, 2003 5:07:53 am PDT #5431 of 10000
You always do this. We get tipsy, and you take advantage of my love of the scientific method.

Huh. It's working for me in another browser, but I can't get Mozilla to show it. Off to clear the cache. (edit: And that did it.)


Allyson - Oct 22, 2003 5:40:00 am PDT #5432 of 10000
Wait, is this real-world child support, where the money goes to buy food for the kids, or MRA fantasyland child support where the women just buy Ferraris and cocaine? -Jessica

It seems to be getting worse for me.


Elena - Oct 22, 2003 5:41:58 am PDT #5433 of 10000
Thanks for all the fish.

So, I suppose today is not a good day to die?

By which I mean, running deathmatches is not so good today?