[jira] Created: (OFBIZ-1148) Bug when it register the visit in the tables with mysql 5

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] Created: (OFBIZ-1148) Bug when it register the visit in the tables with mysql 5

Nicolas Malin (Jira)
Bug when it register the visit in the tables with mysql 5
---------------------------------------------------------

                 Key: OFBIZ-1148
                 URL: https://issues.apache.org/jira/browse/OFBIZ-1148
             Project: OFBiz
          Issue Type: Bug
          Components: site
    Affects Versions: Release Branch 4.0
         Environment: Linux, mysql 5, ofbiz release branch 4.0
            Reporter: Fabien Carrion
            Priority: Minor


---- exception report ----------------------------------------------------------
Failure in create operation for entity [ServerHit]: org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`))))). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))))
---- stack trace ---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))))
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:532)
org.ofbiz.entity.GenericValue.create(GenericValue.java:112)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:654)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:208)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255)
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:248)
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:595)
org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`))))
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:171)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:532)
org.ofbiz.entity.GenericValue.create(GenericValue.java:112)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:654)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:208)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255)
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:248)
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:595)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:166)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:532)
org.ofbiz.entity.GenericValue.create(GenericValue.java:112)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:654)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:208)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255)
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:248)
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:595)
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`))
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1012)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710)
com.mysql.jdbc.Connection.execSQL(Connection.java:2436)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1402)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1694)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1608)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1593)
org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:166)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:532)
org.ofbiz.entity.GenericValue.create(GenericValue.java:112)
org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:654)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:208)
org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85)
org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255)
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:248)
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:595)
--------------------------------------------------------------------------------


--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (OFBIZ-1148) Bug when it register the visit in the tables with mysql 5

Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-1148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacopo Cappellato updated OFBIZ-1148:
-------------------------------------

    Component/s:     (was: site)
                 framework

Fabien,

could you please try to rebuild your test instance and db and see if the error disappear?


> Bug when it register the visit in the tables with mysql 5
> ---------------------------------------------------------
>
>                 Key: OFBIZ-1148
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1148
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: Release Branch 4.0
>         Environment: Linux, mysql 5, ofbiz release branch 4.0
>            Reporter: Fabien Carrion
>            Priority: Minor
>
> ---- exception report ----------------------------------------------------------
> Failure in create operation for entity [ServerHit]: org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`))))). Rolling back transaction.
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))))
> ---- stack trace ---------------------------------------------------------------
> org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))))
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:532)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:112)
> org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:654)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:208)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85)
> org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255)
> 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:248)
> 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:595)
> org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`))))
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:171)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:532)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:112)
> org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:654)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:208)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85)
> org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255)
> 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:248)
> 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:595)
> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:166)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:532)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:112)
> org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:654)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:208)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85)
> org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255)
> 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:248)
> 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:595)
> com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`))
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1012)
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938)
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601)
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710)
> com.mysql.jdbc.Connection.execSQL(Connection.java:2436)
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1402)
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1694)
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1608)
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1593)
> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:166)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:532)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:112)
> org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:654)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:208)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85)
> org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255)
> 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:248)
> 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:595)
> --------------------------------------------------------------------------------

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Closed: (OFBIZ-1148) Bug when it register the visit in the tables with mysql 5

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-1148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fabien Carrion closed OFBIZ-1148.
---------------------------------

    Resolution: Fixed

The stack doesn't appear any more.

Thanks

> Bug when it register the visit in the tables with mysql 5
> ---------------------------------------------------------
>
>                 Key: OFBIZ-1148
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1148
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: Release Branch 4.0
>         Environment: Linux, mysql 5, ofbiz release branch 4.0
>            Reporter: Fabien Carrion
>            Priority: Minor
>
> ---- exception report ----------------------------------------------------------
> Failure in create operation for entity [ServerHit]: org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`))))). Rolling back transaction.
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))))
> ---- stack trace ---------------------------------------------------------------
> org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(java.lang.String)] (while inserting: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))))
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:532)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:112)
> org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:654)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:208)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85)
> org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255)
> 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:248)
> 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:595)
> org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:ServerHit][contentId,lasala.FindGiro(java.lang.String)][createdStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][createdTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][hitStartDateTime,2007-07-15 23:19:29.521(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2007-07-15 23:19:30.749(java.sql.Timestamp)][lastUpdatedTxStamp,2007-07-15 23:19:30.708(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://127.0.0.1:8443/lasala/control/FindMedio(java.lang.String)][requestUrl,https://127.0.0.1:8443/lasala/control/FindGiro(java.lang.String)][runningTimeMillis,1183(java.lang.Long)][serverHostName,Fabs(java.lang.String)][serverIpAddress,127.0.1.1(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10010(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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`))))
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:171)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:532)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:112)
> org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:654)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:208)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85)
> org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255)
> 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:248)
> 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:595)
> 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:166)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:532)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:112)
> org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:654)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:208)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85)
> org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255)
> 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:248)
> 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:595)
> com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`ofbiz/SERVER_HIT`, CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`))
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1012)
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938)
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601)
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710)
> com.mysql.jdbc.Connection.execSQL(Connection.java:2436)
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1402)
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1694)
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1608)
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1593)
> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:166)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:113)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:532)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:112)
> org.ofbiz.webapp.stats.ServerHitBin.saveHit(ServerHitBin.java:654)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:208)
> org.ofbiz.webapp.stats.ServerHitBin.countHit(ServerHitBin.java:85)
> org.ofbiz.webapp.stats.ServerHitBin.countRequest(ServerHitBin.java:58)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:255)
> 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:248)
> 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:595)
> --------------------------------------------------------------------------------

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.