Error Executing Database Query.
|
Data source rejected establishment of connection, message from server: "Too many connections"
|
|
The error occurred in C:\inetpub\wwwroot\realestateonline\Includes\STATLISTINGVIEWS.cfm: line 9
Called from C:\inetpub\wwwroot\AmericanAssociates\view.cfm: line 47
Called from C:\inetpub\wwwroot\AmericanAssociates\view.cfm: line 2
Called from C:\inetpub\wwwroot\AmericanAssociates\view.cfm: line 1
Called from C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm: line 11
|
7 : VALUES ('#GetHomes.mls#','#mls_id#',#GetHomes.price#,'#reReplace(tempaddress, " ", " ", "ALL")#','#GetHomes.city#','#GetHomes.zip#'<cfif isDefined("GetHomes.listdate")>,#CreateODBCdatetime(GetHomes.listdate)#</cfif>,'#REReplace(reReplace(templisting,'[[:space:]]','','ALL'),'[^0-9A-Za-z ]','','all')#')
8 : ON DUPLICATE KEY UPDATE <cfif GetHomes.Broker_Order contains "1"><cfif SiteType is "Broker">DetailViewsB = DetailViewsB+1,<cfelse>DetailViewsA = DetailViewsA+1,</cfif><cfelse>DetailViewsO = DetailViewsO+1,</cfif>
9 : Today = Today+1, Visitors = <cfif isDefined("cookie.ContactID") and IsNumeric(cookie.ContactID)>LEFT(CONCAT('c#cookie.ContactID#,',Visitors), 5000)<cfelse>LEFT(CONCAT('#REReplace(cgi.remote_addr,"\.","","all")#,',Visitors), 5000)</cfif>
10 : </CFQUERY>
11 : </cfif>
|
|
SQL |
INSERT INTO stats_listing (mls,mls_id,price,address,city,zip,listdate,listingid)
VALUES ('ecami50148533','ecar',74900,'4412 Cheyenne ','Flint','48507',{ts '2024-07-15 14:02:51'},'4412Cheyenne48507')
ON DUPLICATE KEY UPDATE DetailViewsO = DetailViewsO+1,
Today = Today+1, Visitors = LEFT(CONCAT('3149255168,',Visitors), 5000) |
DATASOURCE |
RealEstateStats |
VENDORERRORCODE |
1040 |
SQLSTATE |
08004 |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
3.149.255.168 |
Referrer |
|
Date/Time |
27-Sep-24 05:32 PM |
|
Stack Trace
|
at cfSTATLISTINGVIEWS2ecfm2121376329.runPage(C:\inetpub\wwwroot\realestateonline\Includes\STATLISTINGVIEWS.cfm:9) at cfview2ecfm530345731._factor5(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:47) at cfview2ecfm530345731._factor33(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:2) at cfview2ecfm530345731.runPage(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:1) at cfquery_redirect2ecfm887604138.runPage(C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm:11)
java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections"
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1018)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2568)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:562)
at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
at java.lang.Thread.run(Thread.java:534)
|
|