Jon, we've been getting "too many connections" errors. When the error hits while someone is trying to post, the database increments but doesn't record the post, so we're getting a lot of gaps.
'Serenity'
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.
Should we go to peoplesforum for awhile and see if it still happens?
We really should have somewhere we can display a status message -- one like:
"We know about the max_connections message, please be aware there will be many skipped message numbers, working on it."
I've looked at the daily numbers, and we must have been hitting over our max_connections every damned moment. Here's the table for the month:
Hourly Statistics for September 2003
Hour Hits Files Pages KBytes Avg Total Avg Total Avg Total Avg Total
0549120891.21%38183871.29%388421.10%63581398851.19% 131669650.69%21146550.71%235100.67%3774830360.70% 223251040.51%16336010.55%214630.61%2860629150.53% 332671880.72%23351290.79%286320.83%4425973580.83% 4576126771.26%36981271.25%5111331.49%72341591561.35% 5778171281.71%490107981.66%7115752.07%95462100081.78% 61247274532.74%799175972.70%9921922.88%162903583743.04% 72067454844.54%1395306964.71%17338064.99%258885695334.83% 82904638926.37%1994438846.73%22148626.38%342197528176.38% 93306727527.26%2247494397.58%25656477.41%384558460207.17% 103393746577.45%2222488957.50%26558417.66%399498788887.45% 113636800027.98%2299505787.76%27660807.98%428219420717.98% 123470763537.61%2185480907.38%25856767.45%408558988107.62% 133598791747.90%2362519727.97%28562848.24%432599517008.06% 143074676366.75%1984436606.70%23752246.85%348007655956.49% 152579567455.66%1582348255.34%19342505.58%297056535065.54% 162226489834.89%1394306714.70%17237894.97%252355551764.70% 171898417584.16%1186260944.00%14732384.25%218444805764.07% 181851407284.06%1219268314.11%13630083.95%224694943174.19% 192097461354.60%1334293534.50%14030864.05%241975323334.51% 201862409784.09%1195262974.03%11826163.43%205284516083.83% 211502330503.30%986216953.33%10322692.98%171123764623.19% 221220268452.68%810178352.74%8719242.52%140533091632.62% 23859189141.89%588129411.98%5812801.68%105162313601.96%
I don't know whether this is at all relavent to the wonkiness (I'm getting the error message pretty regularly too), but I had the links to the message center disappear from the botton of the page, and the left-hand column. Refreshing my browser (I'm running Mozilla) didn't fix it, but shutting the thing down completely and restarting it caused the links to appear again--it might just be a quirk on my end, but I've never noticed that sort of thing happening before so I just thought I'd mention it.
Leigh, it was probably just luck of the draw that they came back when you restarted, as opposed to refreshing.
Sorry. I thought I wasn't skipping and skimming, but I guess I was. I saw posts about the error messages but not about skipped post numbers.
Jon, FYI, ita just closed the board to everybody but stompies.
And I'm still getting frelling connection errors. See post number.
Isn't there something where open connections linger for x minutes and then are automatically closed? How long is "x"?
ita checked. It's still 5 minutes. Which means there's no frelling way we should be having this problem now.
Trying to post for the fourth time...