You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Karim Rahimpur (JIRA)" <ji...@apache.org> on 2009/03/05 11:47:56 UTC
[jira] Commented: (OFBIZ-2041) DBCP Connection Pool
[ https://issues.apache.org/jira/browse/OFBIZ-2041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12679148#action_12679148 ]
Karim Rahimpur commented on OFBIZ-2041:
---------------------------------------
I've updated [https://issues.apache.org/jira/browse/OFBIZ-2208] and proposed a new solution.
Srinivas: I don't see where this (ServerHit issue) could be related to what you say about open connections ...
> DBCP Connection Pool
> ---------------------
>
> Key: OFBIZ-2041
> URL: https://issues.apache.org/jira/browse/OFBIZ-2041
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: Release Branch 4.0
> Environment: Windows Server Web Edition, JDk1.6, MySQL 5.0.67, ofbiz 4.0 release
> Reporter: Srinivas
> Assignee: Jacques Le Roux
> Fix For: SVN trunk
>
>
> 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.linenchest.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202201/~pcategory=202202(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.linenchest.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.linenchest.com/ecommerce/control/category/~category_id=202202/~pcategory=202?a=b(java.lang.String)][requestUrl,http://www.linenchest.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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.