ItinScales.com - Scales, Balances and Force Gauges
struct
Cause
struct
ErrorCode 1040
Message Data source rejected establishment of connection, message from server: "Too many connections"
SQLState 08004
StackTrace java.sql.SQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections" at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:667) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) at java.base/java.lang.Thread.run(Thread.java:842)
Suppressed
array[empty]
TagContext
array[empty]
Type java.sql.SQLNonTransientConnectionException
DataSource store
Detail Data source rejected establishment of connection, message from server: "Too many connections"
ErrorCode 08004
Exceptions
array
1
struct
class java.sql.SQLNonTransientConnectionException
message Data source rejected establishment of connection, message from server: "Too many connections"
Message Error Executing Database Query.
NativeErrorCode 1040
RootCause
struct
ErrorCode 1040
Message Data source rejected establishment of connection, message from server: "Too many connections"
SQLState 08004
StackTrace java.sql.SQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections" at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:667) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) at java.base/java.lang.Thread.run(Thread.java:842)
Suppressed
array[empty]
TagContext
array[empty]
Type java.sql.SQLNonTransientConnectionException
SQLState 08004
Sql SELECT cart.cart_id, cart.the_datetime, cart.fk_customer_id, cart.IP, cart.fk_campain_id,cart.fk_store_id, cart.IP, cart.shippint_type, cart.paypal_token, cart.google_shoppingcart, cart.promo, cart.COUNTRYCODE, cart_detail.fk_product_id, cart_detail.Arcust_id, cart_detail.product_name, cart_detail.qty, cart_detail.price_ea, cart_detail.weight, Product_detail.dim_weight,Product_detail.SKU,cart_detail.source,cart_detail.Block_Promo, stock_type.stock_type_name,stock_type.stock_type_color,stock_type.stock_type_id,Product_detail.fk_product_condition_id as product_condition_id, cart_detail.cart_detail_id, Product_detail.use_map, Product_detail.cost,Product_detail.Only_With_Scale, Product_detail.qty_in_stock, Product_detail.qty_in_stock,Product_detail.Flat_Shipping, Product_detail.qty_in_stock as ONHAND, Product_detail.man_Warranty,Product_detail.buy_upc, product_detail.fk_shipping_template_id, product_detail.alt_item, Product_detail.show_Ship_USA_only, Product_detail.ship_ground_only, Product_detail.days_till_ship,Product_detail.fk_Warranty_id, Product_detail.eta, Product_detail.Pre_Sale_QTY, (SELECT Cat_sub.fk_Cat_Category_id FROM Cat_sub INNER JOIN Product_to_cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id WHERE (Product_to_cat_sub.fk_product_id = cart_detail.fk_product_id) limit 1 ) AS fk_Cat_Category_id, product.fk_man_id,product.old_id, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 10 limit 1) as ship_10, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 20 limit 1) as ship_20, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 30 limit 1) as ship_30, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 32 limit 1) as ship_32, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 34 limit 1) as ship_34, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 36 limit 1) as ship_36, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 40 limit 1) as ship_40, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 42 limit 1) as ship_42, (SELECT fk_acc_id FROM product_to_acc where fk_product_id = product.product_id limit 1) as has_ACC, 0 as ALOC, (SELECT GSAIFF FROM gsa_price_list where fk_product_id = product_detail.fk_product_id and Com_name = 'ItinScales' limit 1) as gsa_price FROM product RIGHT OUTER JOIN cart_detail ON product.product_id = cart_detail.fk_product_id LEFT OUTER JOIN Product_detail ON cart_detail.fk_product_id = Product_detail.fk_product_id RIGHT OUTER JOIN cart ON cart_detail.fk_cart_id = cart.cart_id LEFT OUTER JOIN stock_type ON stock_type.stock_type_id=Product_detail.fk_stock_type_id WHERE (cart.cart_id = (param 1) ) and (product.is_active = (param 2) ) union SELECT distinct cart.cart_id, cart.the_datetime, cart.fk_customer_id, cart.IP, cart.fk_campain_id,cart.fk_store_id, cart.IP, cart.shippint_type, cart.paypal_token, cart.google_shoppingcart, cart.promo, cart.COUNTRYCODE, cart_detail.fk_product_id, cart_detail.Arcust_id, cart_detail.product_name, cart_detail.qty, cart_detail.price_ea, cart_detail.weight, Product_detail.dim_weight,Product_detail.SKU,cart_detail.source,cart_detail.Block_Promo, stock_type.stock_type_name,stock_type.stock_type_color,stock_type.stock_type_id,Product_detail.fk_product_condition_id as product_condition_id, cart_detail.cart_detail_id, Product_detail.use_map, Product_detail.cost, Product_detail.Only_With_Scale, Product_detail.qty_in_stock, Product_detail.qty_in_stock,Product_detail.Flat_Shipping, Product_detail.qty_in_stock as ONHAND, Product_detail.man_Warranty,Product_detail.buy_upc, product_detail.fk_shipping_template_id,product_detail.alt_item, Product_detail.show_Ship_USA_only, Product_detail.ship_ground_only, Product_detail.days_till_ship,Product_detail.fk_Warranty_id, Product_detail.eta, Product_detail.Pre_Sale_QTY, (SELECT Cat_sub.fk_Cat_Category_id FROM Cat_sub INNER JOIN Product_to_cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id WHERE (Product_to_cat_sub.fk_product_id = cart_detail.fk_product_id) limit 1 ) AS fk_Cat_Category_id, product.fk_man_id,product.old_id, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 10 limit 1) as ship_10, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 20 limit 1) as ship_20, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 30 limit 1) as ship_30, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 32 limit 1) as ship_32, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 34 limit 1) as ship_34, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 36 limit 1) as ship_36, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 40 limit 1) as ship_40, (SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 42 limit 1) as ship_42, (SELECT count(fk_product_id) FROM product_to_acc where fk_product_id = product.product_id limit 1) as has_ACC, 0 as ALOC, (SELECT GSA_Price FROM product_gsa where FK_PRODUCT_ID = product.product_id limit 1) as GSA_Price FROM product RIGHT OUTER JOIN cart_detail ON product.product_id = cart_detail.fk_product_id LEFT OUTER JOIN Product_detail ON cart_detail.fk_product_id = Product_detail.fk_product_id RIGHT OUTER JOIN cart ON cart_detail.fk_cart_id = cart.cart_id LEFT OUTER JOIN stock_type ON stock_type.stock_type_id=Product_detail.fk_stock_type_id WHERE (cart.cart_id = (param 3) ) and (cart_detail.fk_product_id = (param 4) )
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfqry_cart2ecfm710284135._factor1(E:\inetpub\Websites\global\qry\qry_cart.cfm:194) at cfqry_cart2ecfm710284135._factor3(E:\inetpub\Websites\global\qry\qry_cart.cfm:118) at cfqry_cart2ecfm710284135.runPage(E:\inetpub\Websites\global\qry\qry_cart.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfApplication2ecfc218594068$funcONREQUESTSTART._factor12(E:\inetpub\Websites\itinscales.com\CheckOutNew\Application.cfc:511) at cfApplication2ecfc218594068$funcONREQUESTSTART._factor14(E:\inetpub\Websites\itinscales.com\CheckOutNew\Application.cfc:339) at cfApplication2ecfc218594068$funcONREQUESTSTART.runFunction(E:\inetpub\Websites\itinscales.com\CheckOutNew\Application.cfc:10) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:321) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:286) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:562) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:763) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: java.sql.SQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections" at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:667) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) ... 1 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 194
RAW_TRACE at cfqry_cart2ecfm710284135._factor1(E:\inetpub\Websites\global\qry\qry_cart.cfm:194)
TEMPLATE E:\inetpub\Websites\global\qry\qry_cart.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_QRY_CART
LINE 118
RAW_TRACE at cfqry_cart2ecfm710284135._factor3(E:\inetpub\Websites\global\qry\qry_cart.cfm:118)
TEMPLATE E:\inetpub\Websites\global\qry\qry_cart.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_QRY_CART
LINE 1
RAW_TRACE at cfqry_cart2ecfm710284135.runPage(E:\inetpub\Websites\global\qry\qry_cart.cfm:1)
TEMPLATE E:\inetpub\Websites\global\qry\qry_cart.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 511
RAW_TRACE at cfApplication2ecfc218594068$funcONREQUESTSTART._factor12(E:\inetpub\Websites\itinscales.com\CheckOutNew\Application.cfc:511)
TEMPLATE E:\inetpub\Websites\itinscales.com\CheckOutNew\Application.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_APPLICATION
LINE 339
RAW_TRACE at cfApplication2ecfc218594068$funcONREQUESTSTART._factor14(E:\inetpub\Websites\itinscales.com\CheckOutNew\Application.cfc:339)
TEMPLATE E:\inetpub\Websites\itinscales.com\CheckOutNew\Application.cfc
TYPE CFML
6
struct
COLUMN 0
ID CF_APPLICATION
LINE 10
RAW_TRACE at cfApplication2ecfc218594068$funcONREQUESTSTART.runFunction(E:\inetpub\Websites\itinscales.com\CheckOutNew\Application.cfc:10)
TEMPLATE E:\inetpub\Websites\itinscales.com\CheckOutNew\Application.cfc
TYPE CFML
Type Database
queryError Data source rejected establishment of connection, message from server: "Too many connections"
where (param 1) = [type='IN', class='java.lang.Double', value='2.9677214E7', sqltype='CF_SQL_INTEGER'] , (param 2) = [type='IN', class='java.lang.String', value='1', sqltype='CF_SQL_INTEGER'] , (param 3) = [type='IN', class='java.lang.Double', value='2.9677214E7', sqltype='CF_SQL_INTEGER'] , (param 4) = [type='IN', class='java.lang.String', value='0', sqltype='CF_SQL_INTEGER']
Untitled