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\STATLISTINGS.cfm: line 7
Called from C:\inetpub\wwwroot\AmericanAssociates\results.cfm: line 73
Called from C:\inetpub\wwwroot\AmericanAssociates\results.cfm: line 1
|
5 : <CFQUERY NAME="StatListing" DATASOURCE="RealEstateStats">
6 : UPDATE stats_listing SET <cfif GetHomes.Broker_Order lte 2><cfif SiteType is "Agent">SummaryViewsA = SummaryViewsA+1,<cfelse>SummaryViewsB = SummaryViewsB+1,</cfif><cfelse>SummaryViewsO = SummaryViewsO+1,</cfif>
7 : TodaySums = TodaySums+1 WHERE listingid IN (#REReplace(gethomeslist,",$","")#)
8 : </CFQUERY>
9 : </cfif>
|
|
SQL |
UPDATE stats_listing SET SummaryViewsO = SummaryViewsO+1,
TodaySums = TodaySums+1 WHERE listingid IN ("38371HuronPointeDrive48045","37540Lakeshore48045","35196Jeffers48045","37340JEFFERSON48045","32737River48045","33120VENETIANPOINTE48045","38487HuronPointe48045","41626CongerBay48045","33124NorthRiver48045","31700NRiverRd48045","39456ARCHER48045","38008Seaway48045","34280JEFFERSON48045","35174JEFFERSON48045","37645Lakeville48045","32257RIVER48045","38044Seaway48045","30Evergreen48045","49SeaRay48045","31074SanJuan48045","26022FELICITY48045","37337LAKESHORES48045","30361MANSE48045","35610Jeffers48045","37864TRILLIUM48045","39463ARCHER48045","26131HARBOURPOINTEDRN48045","34296Jefferson48045","29379SEAWAYCt48045","67SeaRay48045","65SeaRay48045","39329Nautical48045","41343Windmill48045","37827Lakeville48045","27852RIVIERA48045","39360Rivercrest48045","39345Canterbury48045","41235BELVIDERE48045","27705Ashland48045","37899Hazel48045","38414JEFFERSON48045","59SeaRay48045","37882Jefferson48045","37977ELMLANE48045","26485CROCKER48045")
|
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 |
18.188.178.181 |
Referrer |
|
Date/Time |
27-Sep-24 05:24 PM |
|
Stack Trace
|
at cfSTATLISTINGS2ecfm1372315581.runPage(C:\inetpub\wwwroot\realestateonline\Includes\STATLISTINGS.cfm:7) at cfresults2ecfm1305424200._factor18(C:\inetpub\wwwroot\AmericanAssociates\results.cfm:73) at cfresults2ecfm1305424200.runPage(C:\inetpub\wwwroot\AmericanAssociates\results.cfm:1)
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)
|
|