[OFBIZ-2041] DBCP Connection Pool - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Duplicate
Affects Version/s: Release Branch 4.0
Fix Version/s: Trunk
Component/s: framework
Labels:
None
Environment:

Windows Server Web Edition, JDk1.6, MySQL 5.0.67, ofbiz 4.0 release

Description

Hi ,

I am using ofbiz edition from a long time and facing some problems in the connection pool end, making the system unstable and crashing all the applications unless the ofbiz application killed from windows task manager and restart it.

The last error that is showing the log file is "unable to get Database connection" and resulting in unwanted errors causing series of error like duplication of server hit tables and visit tables.

In the recent editions of ofbiz , i.e. release4 i find DBCP factory is used in the entity engine to maintain the connection pool. However the problem goes to mysql as well as the XAconnection pool where connections used before are not released to the ofbiz to make reuse of the same connection.instead the connections are waiting infinitely for 8 hrs with Mysql settings. we change the setting to 1min. Even though ofbiz temporarily providing the connection but the heap memory utilizing the ofbiz service is growing up without coming down resulting in unstablility . And if one of the services fails, ofbiz is going into infinite loop blocking the CPU cycle without releasing to other process in the system.

In previous edition, i find the same problem with Minerva and the problem continues with DBCP also.Please provide information to any other further updates to solve the problem.

---- exception report ---------------
2008-11-11 13:08:34,593 (http-0.0.0.0-80-Processor20) [ ServerHitBin.java:659:ERROR]
---- exception report ----------------------------------------------------------
Could not save ServerHit:
Exception: org.ofbiz.entity.GenericEntityException
Message: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,ecommerce.product(java.lang.String)][createdStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:08:32.906(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/product/~category_id=202202201/~product_id=184717(java.lang.String)][runningTimeMillis,1469(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976088(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,ecommerce.product(java.lang.String)][createdStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:08:32.906(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/product/~category_id=202202201/~product_id=184717(java.lang.String)][runningTimeMillis,1469(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976088(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976088-ecommerce.product-2008-11-11 13:08:32-REQUEST' for key 1")))
---- stack trace ---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,ecommerce.product(java.lang.String)][createdStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:08:32.906(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/product/~category_id=202202201/~product_id=184717(java.lang.String)][runningTimeMillis,1469(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976088(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,ecommerce.product(java.lang.String)][createdStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:08:32.906(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/product/~category_id=202202201/~product_id=184717(java.lang.String)][runningTimeMillis,1469(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976088(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976088-ecommerce.product-2008-11-11 13:08:32-REQUEST' for key 1")))
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546)
org.ofbiz.entity.GenericValue.create(GenericValue.java:115)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:657)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:ServerHit][contentId,ecommerce.product(java.lang.String)][createdStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:08:32.906(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:08:34.39(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/product/~category_id=202202201/~product_id=184717(java.lang.String)][runningTimeMillis,1469(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976088(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976088-ecommerce.product-2008-11-11 13:08:32-REQUEST' for key 1"))
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546)
org.ofbiz.entity.GenericValue.create(GenericValue.java:115)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:657)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976088-ecommerce.product-2008-11-11 13:08:32-REQUEST' for key 1")
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:433)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546)
org.ofbiz.entity.GenericValue.create(GenericValue.java:115)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:657)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976088-ecommerce.product-2008-11-11 13:08:32-REQUEST' for key 1"
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
com.mysql.jdbc.Connection.execSQL(Connection.java:2281)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1825)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1667)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546)
org.ofbiz.entity.GenericValue.create(GenericValue.java:115)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:657)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2008-11-11 13:09:15,703 (http-0.0.0.0-80-Processor23) [ ControlServlet.java:195:ERROR]
---- exception report ----------------------------------------------------------
Error in request handler:
Exception: org.apache.catalina.connector.ClientAbortException
Message: null
---- cause ---------------------------------------------------------------------
Exception: java.net.SocketException
Message: Connection reset by peer: socket write error
---- stack trace ---------------------------------------------------------------
java.net.SocketException: Connection reset by peer: socket write error
java.net.SocketOutputStream.socketWrite0(Native Method)
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
java.net.SocketOutputStream.write(SocketOutputStream.java:136)
org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:746)
org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:433)
org.apache.coyote.http11.InternalOutputBuffer.flush(InternalOutputBuffer.java:304)
org.apache.coyote.http11.Http11Processor.action(Http11Processor.java:991)
org.apache.coyote.Response.action(Response.java:182)
org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:322)
org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:293)
org.apache.catalina.connector.Response.flushBuffer(Response.java:537)
org.apache.catalina.connector.ResponseFacade.flushBuffer(ResponseFacade.java:276)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:654)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:429)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:192)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2008-11-11 13:09:15,718 (http-0.0.0.0-80-Processor23) [ ControlServlet.java:209:ERROR] An error occurred, going to the errorPage: /error/error.jsp
2008-11-11 13:09:15,718 (http-0.0.0.0-80-Processor23) [ ControlServlet.java:216:ERROR] Including errorPage: /error/error.jsp
2008-11-11 13:10:33,953 (http-0.0.0.0-80-Processor1) [ ControlServlet.java:195:ERROR]
---- exception report ----------------------------------------------------------
Error in request handler:
Exception: org.apache.catalina.connector.ClientAbortException
Message: null
---- cause ---------------------------------------------------------------------
Exception: java.net.SocketException
Message: Connection reset by peer: socket write error
---- stack trace ---------------------------------------------------------------
java.net.SocketException: Connection reset by peer: socket write error
java.net.SocketOutputStream.socketWrite0(Native Method)
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
java.net.SocketOutputStream.write(SocketOutputStream.java:136)
org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:746)
org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:433)
org.apache.coyote.http11.InternalOutputBuffer.flush(InternalOutputBuffer.java:304)
org.apache.coyote.http11.Http11Processor.action(Http11Processor.java:991)
org.apache.coyote.Response.action(Response.java:182)
org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:322)
org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:293)
org.apache.catalina.connector.Response.flushBuffer(Response.java:537)
org.apache.catalina.connector.ResponseFacade.flushBuffer(ResponseFacade.java:276)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:654)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:429)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:192)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2008-11-11 13:10:33,953 (http-0.0.0.0-80-Processor1) [ ControlServlet.java:209:ERROR] An error occurred, going to the errorPage: /error/error.jsp
2008-11-11 13:10:33,953 (http-0.0.0.0-80-Processor1) [ ControlServlet.java:216:ERROR] Including errorPage: /error/error.jsp
2008-11-11 13:10:33,968 (http-0.0.0.0-80-Processor1) [ GenericDelegator.java:591:ERROR]
---- exception report ----------------------------------------------------------
Failure in create operation for entity [ServerHit]: org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,ecommerce.category(java.lang.String)][createdStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:10:31.796(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][runningTimeMillis,2157(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976105(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,ecommerce.category(java.lang.String)][createdStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:10:31.796(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][runningTimeMillis,2157(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976105(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976105-ecommerce.category-2008-11-11 13:10:31-REQUEST' for key 1"))). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,ecommerce.category(java.lang.String)][createdStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:10:31.796(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][runningTimeMillis,2157(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976105(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,ecommerce.category(java.lang.String)][createdStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:10:31.796(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][runningTimeMillis,2157(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976105(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976105-ecommerce.category-2008-11-11 13:10:31-REQUEST' for key 1")))
---- stack trace ---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,ecommerce.category(java.lang.String)][createdStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:10:31.796(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][runningTimeMillis,2157(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976105(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,ecommerce.category(java.lang.String)][createdStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:10:31.796(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][runningTimeMillis,2157(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976105(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976105-ecommerce.category-2008-11-11 13:10:31-REQUEST' for key 1")))
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546)
org.ofbiz.entity.GenericValue.create(GenericValue.java:115)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:657)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:ServerHit][contentId,ecommerce.category(java.lang.String)][createdStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:10:31.796(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][runningTimeMillis,2157(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976105(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976105-ecommerce.category-2008-11-11 13:10:31-REQUEST' for key 1"))
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546)
org.ofbiz.entity.GenericValue.create(GenericValue.java:115)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:657)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976105-ecommerce.category-2008-11-11 13:10:31-REQUEST' for key 1")
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:433)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546)
org.ofbiz.entity.GenericValue.create(GenericValue.java:115)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:657)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976105-ecommerce.category-2008-11-11 13:10:31-REQUEST' for key 1"
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
com.mysql.jdbc.Connection.execSQL(Connection.java:2281)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1825)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1667)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546)
org.ofbiz.entity.GenericValue.create(GenericValue.java:115)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:657)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2008-11-11 13:10:34,093 (http-0.0.0.0-80-Processor1) [ ServerHitBin.java:659:ERROR]
---- exception report ----------------------------------------------------------
Could not save ServerHit:
Exception: org.ofbiz.entity.GenericEntityException
Message: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,ecommerce.category(java.lang.String)][createdStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:10:31.796(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][runningTimeMillis,2157(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976105(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,ecommerce.category(java.lang.String)][createdStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:10:31.796(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][runningTimeMillis,2157(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976105(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976105-ecommerce.category-2008-11-11 13:10:31-REQUEST' for key 1")))
---- stack trace ---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,ecommerce.category(java.lang.String)][createdStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:10:31.796(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][runningTimeMillis,2157(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976105(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,ecommerce.category(java.lang.String)][createdStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:10:31.796(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][runningTimeMillis,2157(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976105(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976105-ecommerce.category-2008-11-11 13:10:31-REQUEST' for key 1")))
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546)
org.ofbiz.entity.GenericValue.create(GenericValue.java:115)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:657)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:ServerHit][contentId,ecommerce.category(java.lang.String)][createdStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][createdTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][hitStartDateTime,2008-11-11 13:10:31.796(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][lastUpdatedTxStamp,2008-11-11 13:10:33.953(java.sql.Timestamp)][referrerUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.xyzxyz.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][runningTimeMillis,2157(java.lang.Long)][serverHostName,blade2(java.lang.String)][serverIpAddress,192.168.16.152(java.lang.String)][visitId,2976105(java.lang.String)] (SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976105-ecommerce.category-2008-11-11 13:10:31-REQUEST' for key 1"))
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546)
org.ofbiz.entity.GenericValue.create(GenericValue.java:115)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:657)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO SERVER_HIT (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES, RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL, SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID, PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976105-ecommerce.category-2008-11-11 13:10:31-REQUEST' for key 1")
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:433)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546)
org.ofbiz.entity.GenericValue.create(GenericValue.java:115)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:657)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Duplicate entry '2976105-ecommerce.category-2008-11-11 13:10:31-REQUEST' for key 1"
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
com.mysql.jdbc.Connection.execSQL(Connection.java:2281)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1825)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1667)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:169)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:68)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:546)
org.ofbiz.entity.GenericValue.create(GenericValue.java:115)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:657)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:211)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:88)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:61)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:258)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

The error listed above may be resulted because of some problem in the services going down. This is very important for me to fix in our application,please provide information or guide how to resolve.

if you need any other information, let me know.

Attachments

Activity

People

Assignee:: Jacques Le Roux

Reporter:: Srinivas

Votes:: 0 Vote for this issue

Watchers:: 0 Start watching this issue

Dates

Created:: 11/Nov/08 20:50

Updated:: 28/Jan/10 10:40

Resolved:: 28/Feb/09 20:39