Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-2041

DBCP Connection Pool

    XMLWordPrintableJSON

    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:
              jleroux Jacques Le Roux
              Reporter:
              varadasrini Srinivas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: