Front Page errors

[Brodder FoamyMugs]

Warning: mysql_pconnect(): Too many connections in /home/eqtrader/public_html/library/mysql.php on line 156

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/eqtrader/public_html/library/mysql.php on line 157
eqtrader_article could not connect
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/eqtrader/public_html/library/mysql.php on line 256

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/eqtrader/public_html/articles/news_page.php on line 45
Printer Friendly version

[Quinner Sparrowhawk]

Errors also come up when searching for any recipes.

[Wyora]

The world is coming to an end. Errors.

[KyrosKrane]

Looks like it fixed itself.

These sort of errors happen periodically when the server that runs the EQTC site reboots, or when some of the services on that server are restarted. Whatever the cause, the Web server (which formats what we see) can't reach the database (which stores the raw data), and we get that error message. It usually fixes itself in 10-15 minutes. If it lasts longer than that, though, it indicates a more serious problem.

[Arfyak Reflux]

Fyi

I had to delete my off line content in MSIE to get it back up. For anyone that is still having problems.

[Maevenniia]

still getting erros despite clearing IE cache\

Warning: mysql_pconnect(): Too many connections in /home/eqtrader/public_html/library/mysql.php on line 156

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/eqtrader/public_html/library/mysql.php on line 157
eqtrader_article could not connect
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/eqtrader/public_html/library/mysql.php on line 256

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/eqtrader/public_html/articles/news_page.php on line 45

[Niami DenMother]

Yep, the durn thing burped for the second time (at least) this weekend. Both sites were unavailable for a bit again.

[Lillanu]

still getting erros despite clearing IE cache\

Warning: mysql_pconnect(): Too many connections in /home/eqtrader/public_html/library/mysql.php on line 156

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/eqtrader/public_html/library/mysql.php on line 157
eqtrader_article could not connect
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/eqtrader/public_html/library/mysql.php on line 256

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/eqtrader/public_html/articles/news_page.php on line 45

I think it was just a coincidence that the server was done hiccup'ing while the person was clearing their IE cache

[Niami DenMother]

Yep ... yesterday and the day before were a bit more prolonged than hiccups. A short while ago today was more of a proper hiccup, and it recovered far more quickly.

Ngreth's got email in to Racknine now about the recent instability.

[Caiapfas]

not..

The error is casued becasue to many people are making connections to the mysql server.
This can be casued by many things.

a). bad php coding leaving connections open
(FIX: write code to close connections)
b). search engines opening 1000's of pages ..thus opening mysql connections (FIX: limit search engine connections to 40)
c).crap server - to low ram so sql server crashes..
(FIX:: get better server.)


contact me on AOL : caiapfas
msn = caiapfas@hotmail.com
to discuss would like tyo help you fix it.

[Niami DenMother]

The ones over the weekend with too many connections may be issues with the server, search engines *or* may be a DOS attack or two. We're siccing Racknine on those.

The one today was a "typical" SQL server crash sort of error, which has a MUCH faster recovery time than the issues we saw over the weekend ... of course, the one today was while I was frantically re-entering a metric ton of EQ2 items/recipes after the tradeskill revamp over there pretty much trashed our entire recipe/item content. :O

[Ngreth Thergn]

There was a file space issue. Racknine is keeping an eye on it. (not us. it is a shared server...)