struct | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DataSource | store2008 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Detail | Communications link failure The last packet successfully received from the server was 2,658,817 milliseconds ago. The last packet sent successfully to the server was 2,658,817 milliseconds ago. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ErrorCode | 08S01 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Exceptions |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Message | Error Executing Database Query. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
NativeErrorCode | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RootCause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQLState | 08S01 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sql | SELECT product.product_id, product.product_name,product.is_active, product.date_created,product.old_id,product.cloud_map , man.man_id, man.man_name, man.MAN_TITLE ,man.auth_dealer,Product_detail.weight, Product_detail.dim_weight, Product_detail.X, Product_detail.Y, Product_detail.Z, Product_detail.MAP, Product_detail.use_map, Product_detail.qty_in_stock, Product_detail.eta, Product_detail.days_till_ship, product_detail.ARcust_code ,Product_detail.UPC, Product_detail.SKU, Product_detail.use_ALOC ,Product_detail.Has_image, Product_detail.Product_note, Product_detail.sale_price,Product_detail.Offer_Tradein, Product_detail.Pre_Sale_QTY,Product_detail.POP_Discount,Product_detail.POP_Discount_backUP,Product_detail.List_Price,Product_detail.man_Warranty,product.is_active, (SELECT ONHAND FROM arinv99 where ITEM = left(product_detail.ARcust_code,50) limit 1) as ONHAND, (select product_name from product p where product_id=Product_detail.Free_product) as Free_product_name, (select product_kit_name from product p where product_id=Product_detail.Free_product) as Free_kit_name, Product_detail.Free_product as Free_product_id,Product_detail.Block_Search, Product_detail.Demo_URL, Product_detail.PDF_URL, Product_detail.Product_note_start, Product_detail.Product_note_end, Product_detail.fk_Warranty_id, Product_detail.show_Ship_USA_only, Product_detail.ship_ground_only,Product_detail.show_please_call, Product_detail.Block_cart ,stock_type.stock_type_id, stock_type.stock_type_name, stock_type.stock_type_color, stock_type.stock_type_name_internal, product_condition.product_condition_id, product_condition.product_condition_name, Product_rebate.Product_rebate_id, Product_rebate.rebate_url, Product_rebate.rebate_text, Product_rebate.rebate_amount, Product_rebate.from_date, Product_rebate.to_date, Product_description.features, Product_description.spec, Product_description.spec_Mobile, Product_description.bulletpoint1,Product_description.bulletpoint2,Product_description.bulletpoint3,Product_description.bulletpoint4,Product_description.bulletpoint5, Product_description.caption, Product_to_cat_sub.fk_Cat_sub_id, Product_detail.alt_item, Product_description.meta_title, Product_description.meta_Description, Product_description.meta_Keywords, Cat_sub.Cat_sub_id, Cat_sub.sub_name, Cat_Category.Cat_Category_id, Cat_Category.Category_name, Cat_department.Cat_department_id, Cat_department.Department_name, (SELECT shipping_type.shipmentDesc FROM product_shipping INNER JOIN shipping_type ON product_shipping.fk_shipping_type = shipping_type.shipping_type_id WHERE (shipping_type.stateCode IS NOT NULL) AND (shipping_type.countryCode = 'US') AND (product_shipping.fk_product_id = product.product_id) ORDER BY shipping_type.shipping_type_id DESC limit 1 ) AS shipping, product_store.Price, product_store.fk_store_id, '' as SG_URL , (SELECT fk_product_id FROM feature_value inner join product_to_feature on feature_value.feature_value_id = product_to_feature.fk_feature_value_id WHERE feature_value_id = 6 and fk_product_id=product.product_id LIMIT 1) as made_in_usa , (SELECT HTML_page from man_store WHERE FK_MAN_ID=man.MAN_ID and fk_store_id =product_store.fk_store_id) AS HTML_page , (SELECT ALOC FROM arinv99 where ITEM = left(product_detail.ARcust_code,50) limit 1) as ALOC, page_rank.rank FROM product INNER JOIN Product_detail ON Product_detail.fk_product_id = product.product_id INNER JOIN Product_description ON product.product_id = Product_description.fk_product_id INNER JOIN product_condition ON Product_detail.fk_product_condition_id = product_condition.product_condition_id INNER JOIN stock_type ON Product_detail.fk_stock_type_id = stock_type.stock_type_id inner join product_store ON product_store.fk_product_id = product.product_id LEFT OUTER JOIN Cat_sub LEFT OUTER JOIN Product_to_cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id LEFT OUTER JOIN Cat_Category ON Cat_sub.fk_Cat_Category_id = Cat_Category.Cat_Category_id LEFT OUTER JOIN Cat_department ON Cat_Category.fk_Cat_department_id = Cat_department.Cat_department_id ON product.product_id = Product_to_cat_sub.fk_product_id LEFT OUTER JOIN Product_rebate ON product.product_id = Product_rebate.fk_product_id LEFT OUTER JOIN man ON product.fk_man_id = man.man_id left outer join page_rank on product.product_id = page_rank.fk_product_id WHERE (product_store.fk_store_id = 17) AND product.product_id = 47417 AND product.FK_MAN_ID <>224 AND product.FK_MAN_ID <> 85 AND product.FK_MAN_ID <> 262 and Product_detail.Block_cart <> 3 and product_detail.fk_stock_type_id not in (12) AND (product.is_active = 1) AND (product_store.is_active = 1) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
StackTrace | coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:739) at cfqry_product2ecfm333286336._factor4(E:\inetpub\Websites\global\qry\qry_product.cfm:63) at cfqry_product2ecfm333286336.runPage(E:\inetpub\Websites\global\qry\qry_product.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795) at cfindex2ecfm1814390410.runPage(E:\inetpub\Websites\itinscales.com\product\index.cfm:14) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:64) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 2,658,817 milliseconds ago. The last packet sent successfully to the server was 2,658,817 milliseconds ago. at sun.reflect.GeneratedConstructorAccessor263.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3706) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2506) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439) at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:829) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:923) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1451) at coldfusion.sql.Executive.executeQuery(Executive.java:1201) at coldfusion.sql.Executive.executeQuery(Executive.java:1131) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688) ... 44 more Caused by: java.net.SocketException: Software caused connection abort: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111) at java.net.SocketOutputStream.write(SocketOutputStream.java:155) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3688) ... 57 more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Suppressed |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TagContext |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Type | Database | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
queryError | Communications link failure The last packet successfully received from the server was 2,658,817 milliseconds ago. The last packet sent successfully to the server was 2,658,817 milliseconds ago. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
where | [empty string] |