Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections'. ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException MESSAGE: Too many connections STACKTRACE: 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:2985) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2924) at com.mysql.jdbc.Connection.<init>(Connection.java:1555) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:614) at coldfusion.server.j2ee....
 
The error occurred in D:/vsites/GolfTripscom/root/html/_templates/stayandplay/golfpackage.cfm: line 29
Called from D:/vsites/GolfTripscom/root/html/_templates/stayandplay/golfpackage.cfm: line 1
Called from D:/vsites/GolfTripscom/root/html/stayandplay/golfpackage.cfm: line 1
27 : 			AND IFNULL(TourOperatorState.State,'') = '#application.State#'
28 : 		LEFT OUTER JOIN Casinos ON Casinos.Id = Coupon_StayPlay.CasinoID			
29 :     WHERE SPID = #id#
30 : 	AND Coupon_stayplay.Coupon <> ''	
31 : </cfquery>

SQLSTATE   08001
DATASOURCE   GolfTrips_661
SQL    SELECT Coupon_stayplay.Coupon, spid, Coupon_stayplay.CouponExp, Coupon_stayplay.CouponDesc, Coupon_stayplay.price, Coupon_stayplay.rounds, Coupon_stayplay.nights, Coupon_stayplay.phone, bookitnow, IFNULL(IFNULL(IFNULL(IFNULL(Courses.URL, TourOperators.URL), GolfTrails.URL), Coupon_StayPlay.webSite), Casinos.webSite) as website, packagecode, (IFNULL(IFNULL(IFNULL(IFNULL(Courses.id, TourOperators.id), Destinations.AreaId), GolfTrails.TrailID),Casinos.Id)) as id, IFNULL(IFNULL(IFNULL(IFNULL(Courses.Name, TourOperators.Name), Destinations.Area), GolfTrails.Trail), Casinos.Name) as Name, IFNULL(IFNULL(Courses.City, TourOperators.City), Casinos.City) as City, IFNULL(Courses.Address, TourOperators.Address) as Address, IFNULL(Courses.Zip, TourOperators.Zip) as Zip, IFNULL(IFNULL(IFNULL(IFNULL(Courses.State, TourOperators.State), Destinations.State), GolfTrails.State), Casinos.State) as State, IFNULL(IFNULL(IFNULL(IFNULL(Courses.courselogo, TourOperators.Logo), Destinations.AreaLogo), GolfTrails.TrailLogo), Casinos.Logo) as courselogo, IFNULL(IFNULL(IFNULL(IFNULL(Courses.courselogoheight, TourOperators.logoheight), Destinations.logoheight), GolfTrails.Logoheight), Casinos.Logoheight) as courselogoheight, IFNULL(IFNULL(IFNULL(IFNULL(Courses.courselogowidth, TourOperators.logowidth), Destinations.logowidth), GolfTrails.logoWidth), Casinos.LogoWidth) as courselogowidth, Coupon_stayplay.Authorized, Courses.ID as CourseID, TourOperatorsID, DestinationsId, TrailsId, golftrails.LocalPage as TrailLocalPage, Destinations.LocalPage as DestinationLocalPage, Coupon_StayPlay.CasinoId, Destinations.Page as Page, courses.image2 as image, touroperators.image1 as tourimage, GolfTrails.topImage as golftrailimage, Destinations.topImage as destinationimage, Casinos.image as casinoimage FROM Coupon_stayplay LEFT OUTER JOIN Courses ON WiGolfID = ID LEFT OUTER JOIN touroperators on touroperators.ID = Coupon_StayPlay.TourOperatorsID LEFT OUTER JOIN Destinations on Destinations.AreaId = Coupon_StayPlay.DestinationsID LEFT OUTER JOIN GolfTrails on GolfTrails.TrailId = Coupon_StayPlay.TrailsId LEFT OUTER JOIN TourOperatorState on TourOperatorState.TourOperators = TourOperators.ID AND IFNULL(TourOperatorState.State,'') = 'USA' LEFT OUTER JOIN Casinos ON Casinos.Id = Coupon_StayPlay.CasinoID WHERE SPID = 6856 AND Coupon_stayplay.Coupon <> ''
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   18.212.243.191
Referrer  
Date/Time   24-Jun-19 04:32 AM
Stack Trace
at cfgolfpackage2ecfm1506227843._factor16(D:/vsites/GolfTripscom/root/html/_templates/stayandplay/golfpackage.cfm:29) at cfgolfpackage2ecfm1506227843.runPage(D:/vsites/GolfTripscom/root/html/_templates/stayandplay/golfpackage.cfm:1) at cfgolfpackage2ecfm2003991382.runPage(D:/vsites/GolfTripscom/root/html/stayandplay/golfpackage.cfm:1)

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections'.

** BEGIN NESTED EXCEPTION ** 

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException
MESSAGE: Too many connections

STACKTRACE:

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:2985)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2924)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:614)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.lang.Thread.run(Thread.java:745)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2997)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:614)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.lang.Thread.run(Thread.java:745)