ET Terrible site problems

nitro

nitro

I am getting errors almost every time I try to browse ET. Here is some debug output:

Code: 
Error Executing Database Query.  
Too many connections  
  
The error occurred in /Volumes/Sites/et_main/public/index.cfm: line 5
 
3 : <cfif IsDefined("cookie.bbuserid")>
4 : <cfquery datasource="elitedata" name="get_user_info">
5 : select username, ignorelist, lastvisit from user where userid = #cookie.bbuserid#
6 : </cfquery>
7 : <cfquery datasource="elitedata" name="get_unread_pms">
 

--------------------------------------------------------------------------------
 
SQLSTATE   08004 
SQL    select username, ignorelist, lastvisit from user where userid = 8288  
VENDORERRORCODE   1040 
DATASOURCE   elitedata 
 
Resources: 
Check the ColdFusion documentation to verify that you are using the correct syntax. 
Search the Knowledge Base to find a solution to your problem. 

 
Browser   Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.04506.30) 
Remote Address   127.0.0.1 
Referrer    
Date/Time   17-Jan-08 01:57 PM 
 
Stack Trace (click to expand)  
at cfindex2ecfm802696536.runPage(/Volumes/Sites/et_main/public/index.cfm:5) 


com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:868)
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3355)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1238)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2743)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:589)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.lang.Thread.run(Thread.java:613)
 
Quote from nitro:

I am getting errors almost every time I try to browse ET. Here is some debug output:

Code: 
Error Executing Database Query.  
Too many connections  
  
The error occurred in /Volumes/Sites/et_main/public/index.cfm: line 5
 
3 : <cfif IsDefined("cookie.bbuserid")>
4 : <cfquery datasource="elitedata" name="get_user_info">
5 : select username, ignorelist, lastvisit from user where userid = #cookie.bbuserid#
6 : </cfquery>
7 : <cfquery datasource="elitedata" name="get_unread_pms">
 

--------------------------------------------------------------------------------
 
SQLSTATE   08004 
SQL    select username, ignorelist, lastvisit from user where userid = 8288  
VENDORERRORCODE   1040 
DATASOURCE   elitedata 
 
Resources: 
Check the ColdFusion documentation to verify that you are using the correct syntax. 
Search the Knowledge Base to find a solution to your problem. 

 
Browser   Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.04506.30) 
Remote Address   127.0.0.1 
Referrer    
Date/Time   17-Jan-08 01:57 PM 
 
Stack Trace (click to expand)  
at cfindex2ecfm802696536.runPage(/Volumes/Sites/et_main/public/index.cfm:5) 


com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:868)
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3355)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1238)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2743)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:589)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.lang.Thread.run(Thread.java:613)
More...

did you install any software on your PC or make any changes to your internet explorer/firefox options recently?

is your firewall/spyware software running?

Also, try shutting down your PC until it turns off and then restart (cold boot). sometimes is a magical fix...
 
nitro knows what he's doing.


I too get lots of connect problems, slow response etc as of late. The surfing experience here is not 'crisp' as before. but not terrible or even 'bad'.

I assume Baron is aware.
 
No error messages for me but the site can be very slow from time to time. If I'm not mistaken Baron recently mentioned they were in the process of doing something with the servers.
 
I'm aware of the issues, and I apologize for the inconvenience. We are in the midst of quite a few changes on the backend, but we will get it all sorted out over the next couple days.
 
Quote from Baron:

I'm aware of the issues, and I apologize for the inconvenience. We are in the midst of quite a few changes on the backend, but we will get it all sorted out over the next couple days.
More...

Kewl, i get database error things all the time-does it REALLY send tech staff an email everytime? I kinda feel bad about that, maybe its the email aspect that overloads things:)



Of course, if you read nitro's thread title carefully, and slowly, there is a funny aspect.:D
 
i want to report you still got problems..

every time i post i can't conndct afterwards for about 5 mins..

startin to spook me.

better get it resolved ..soon
or youj'll be livin off your trading profits alone

and whatevr else you've socked away :D
 
Quote from Baron:

I'm aware of the issues, and I apologize for the inconvenience. We are in the midst of quite a few changes on the backend, but we will get it all sorted out over the next couple days.
More...
So that explains my ET "Death Screen" that is becoming a regular visitor on my monitors...
ETdeathscreen.jpg
 
You must log in or register to reply here.
Back
Top