OFBiz › OFBiz - User

Database Timeout

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 1 message Options
Dimitri Unruh
Reply | Threaded
Open this post in threaded view
♦
♦
|

Database Timeout

Dimitri Unruh
Hi everybody,

 

I got a problem with my OFBiz site.

We have written some Services and set them to the JobList. It almost work's
fine, but sometimes something is going wrong with the scheduling.

I got this exception and can't imagine why there is a Database Timeout???

 

Maybe someone can help me or give me a starting point.

 

Kind regards

 

Dimitri Unruh

 

 

---- exception report
----------------------------------------------------------

Failure in store operation for entity [RecurrenceInfo]:
org.ofbiz.entity.GenericEntityException: Exception while updating the
following entity: [GenericEntity:RecurrenceInfo][createdStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][createdTxStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][exceptionDateTimes,(java.lang.String)][exc
eptionRuleId,null()][lastUpdatedStamp,2006-11-23
04:00:02.078(java.sql.Timestamp)][lastUpdatedTxStamp,2006-11-23
04:00:02.015(java.sql.Timestamp)][recurrenceCount,372(java.lang.Long)][recur
renceDateTimes,(java.lang.String)][recurrenceInfoId,10958(java.lang.String)]
[recurrenceRuleId,10958(java.lang.String)][startDateTime,2006-11-20
14:10:00.0(java.sql.Timestamp)] (while updating:
[GenericEntity:RecurrenceInfo][createdStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][createdTxStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][exceptionDateTimes,(java.lang.String)][exc
eptionRuleId,null()][lastUpdatedStamp,2006-11-23
04:00:02.078(java.sql.Timestamp)][lastUpdatedTxStamp,2006-11-23
04:00:02.015(java.sql.Timestamp)][recurrenceCount,372(java.lang.Long)][recur
renceDateTimes,(java.lang.String)][recurrenceInfoId,10958(java.lang.String)]
[recurrenceRuleId,10958(java.lang.String)][startDateTime,2006-11-20
14:10:00.0(java.sql.Timestamp)] (SQL Exception while executing the
following:UPDATE OFBIZ3EK.RECURRENCE_INFO SET START_DATE_TIME=?,
EXCEPTION_DATE_TIMES=?, RECURRENCE_DATE_TIMES=?, EXCEPTION_RULE_ID=?,
RECURRENCE_RULE_ID=?, RECURRENCE_COUNT=?, LAST_UPDATED_STAMP=?,
LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE
RECURRENCE_INFO_ID=? ([700]: Timeout))). Rolling back transaction.

Exception: org.ofbiz.entity.GenericEntityException

Message: Exception while updating the following entity:
[GenericEntity:RecurrenceInfo][createdStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][createdTxStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][exceptionDateTimes,(java.lang.String)][exc
eptionRuleId,null()][lastUpdatedStamp,2006-11-23
04:00:02.078(java.sql.Timestamp)][lastUpdatedTxStamp,2006-11-23
04:00:02.015(java.sql.Timestamp)][recurrenceCount,372(java.lang.Long)][recur
renceDateTimes,(java.lang.String)][recurrenceInfoId,10958(java.lang.String)]
[recurrenceRuleId,10958(java.lang.String)][startDateTime,2006-11-20
14:10:00.0(java.sql.Timestamp)] (while updating:
[GenericEntity:RecurrenceInfo][createdStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][createdTxStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][exceptionDateTimes,(java.lang.String)][exc
eptionRuleId,null()][lastUpdatedStamp,2006-11-23
04:00:02.078(java.sql.Timestamp)][lastUpdatedTxStamp,2006-11-23
04:00:02.015(java.sql.Timestamp)][recurrenceCount,372(java.lang.Long)][recur
renceDateTimes,(java.lang.String)][recurrenceInfoId,10958(java.lang.String)]
[recurrenceRuleId,10958(java.lang.String)][startDateTime,2006-11-20
14:10:00.0(java.sql.Timestamp)] (SQL Exception while executing the
following:UPDATE OFBIZ3EK.RECURRENCE_INFO SET START_DATE_TIME=?,
EXCEPTION_DATE_TIMES=?, RECURRENCE_DATE_TIMES=?, EXCEPTION_RULE_ID=?,
RECURRENCE_RULE_ID=?, RECURRENCE_COUNT=?, LAST_UPDATED_STAMP=?,
LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE
RECURRENCE_INFO_ID=? ([700]: Timeout)))

---- stack trace
---------------------------------------------------------------

org.ofbiz.entity.GenericEntityException: Exception while updating the
following entity: [GenericEntity:RecurrenceInfo][createdStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][createdTxStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][exceptionDateTimes,(java.lang.String)][exc
eptionRuleId,null()][lastUpdatedStamp,2006-11-23
04:00:02.078(java.sql.Timestamp)][lastUpdatedTxStamp,2006-11-23
04:00:02.015(java.sql.Timestamp)][recurrenceCount,372(java.lang.Long)][recur
renceDateTimes,(java.lang.String)][recurrenceInfoId,10958(java.lang.String)]
[recurrenceRuleId,10958(java.lang.String)][startDateTime,2006-11-20
14:10:00.0(java.sql.Timestamp)] (while updating:
[GenericEntity:RecurrenceInfo][createdStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][createdTxStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][exceptionDateTimes,(java.lang.String)][exc
eptionRuleId,null()][lastUpdatedStamp,2006-11-23
04:00:02.078(java.sql.Timestamp)][lastUpdatedTxStamp,2006-11-23
04:00:02.015(java.sql.Timestamp)][recurrenceCount,372(java.lang.Long)][recur
renceDateTimes,(java.lang.String)][recurrenceInfoId,10958(java.lang.String)]
[recurrenceRuleId,10958(java.lang.String)][startDateTime,2006-11-20
14:10:00.0(java.sql.Timestamp)] (SQL Exception while executing the
following:UPDATE OFBIZ3EK.RECURRENCE_INFO SET START_DATE_TIME=?,
EXCEPTION_DATE_TIMES=?, RECURRENCE_DATE_TIMES=?, EXCEPTION_RULE_ID=?,
RECURRENCE_RULE_ID=?, RECURRENCE_COUNT=?, LAST_UPDATED_STAMP=?,
LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE
RECURRENCE_INFO_ID=? ([700]: Timeout)))

org.ofbiz.entity.datasource.GenericDAO.customUpdate(GenericDAO.java:239)

org.ofbiz.entity.datasource.GenericDAO.update(GenericDAO.java:230)

org.ofbiz.entity.datasource.GenericHelperDAO.store(GenericHelperDAO.java:217
)

org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1057)

org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1030)

org.ofbiz.entity.GenericValue.store(GenericValue.java:125)

org.ofbiz.service.calendar.RecurrenceInfo.incrementCurrentCount(RecurrenceIn
fo.java:178)

org.ofbiz.service.calendar.RecurrenceInfo.incrementCurrentCount(RecurrenceIn
fo.java:169)

org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:139)

org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:74)

org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226)

java.lang.Thread.run(Thread.java:534)

org.ofbiz.entity.GenericEntityException: while updating:
[GenericEntity:RecurrenceInfo][createdStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][createdTxStamp,2006-11-20
14:01:56.015(java.sql.Timestamp)][exceptionDateTimes,(java.lang.String)][exc
eptionRuleId,null()][lastUpdatedStamp,2006-11-23
04:00:02.078(java.sql.Timestamp)][lastUpdatedTxStamp,2006-11-23
04:00:02.015(java.sql.Timestamp)][recurrenceCount,372(java.lang.Long)][recur
renceDateTimes,(java.lang.String)][recurrenceInfoId,10958(java.lang.String)]
[recurrenceRuleId,10958(java.lang.String)][startDateTime,2006-11-20
14:10:00.0(java.sql.Timestamp)] (SQL Exception while executing the
following:UPDATE OFBIZ3EK.RECURRENCE_INFO SET START_DATE_TIME=?,
EXCEPTION_DATE_TIMES=?, RECURRENCE_DATE_TIMES=?, EXCEPTION_RULE_ID=?,
RECURRENCE_RULE_ID=?, RECURRENCE_COUNT=?, LAST_UPDATED_STAMP=?,
LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE
RECURRENCE_INFO_ID=? ([700]: Timeout))

org.ofbiz.entity.datasource.GenericDAO.singleUpdate(GenericDAO.java:297)

org.ofbiz.entity.datasource.GenericDAO.customUpdate(GenericDAO.java:236)

org.ofbiz.entity.datasource.GenericDAO.update(GenericDAO.java:230)

org.ofbiz.entity.datasource.GenericHelperDAO.store(GenericHelperDAO.java:217
)

org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1057)

org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1030)

org.ofbiz.entity.GenericValue.store(GenericValue.java:125)

org.ofbiz.service.calendar.RecurrenceInfo.incrementCurrentCount(RecurrenceIn
fo.java:178)

org.ofbiz.service.calendar.RecurrenceInfo.incrementCurrentCount(RecurrenceIn
fo.java:169)

org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:139)

org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:74)

org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226)

java.lang.Thread.run(Thread.java:534)

org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
the following:UPDATE OFBIZ3EK.RECURRENCE_INFO SET START_DATE_TIME=?,
EXCEPTION_DATE_TIMES=?, RECURRENCE_DATE_TIMES=?, EXCEPTION_RULE_ID=?,
RECURRENCE_RULE_ID=?, RECURRENCE_COUNT=?, LAST_UPDATED_STAMP=?,
LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE
RECURRENCE_INFO_ID=? ([700]: Timeout)

org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:438)

org.ofbiz.entity.datasource.GenericDAO.singleUpdate(GenericDAO.java:294)

org.ofbiz.entity.datasource.GenericDAO.customUpdate(GenericDAO.java:236)

org.ofbiz.entity.datasource.GenericDAO.update(GenericDAO.java:230)

org.ofbiz.entity.datasource.GenericHelperDAO.store(GenericHelperDAO.java:217
)

org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1057)

org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1030)

org.ofbiz.entity.GenericValue.store(GenericValue.java:125)

org.ofbiz.service.calendar.RecurrenceInfo.incrementCurrentCount(RecurrenceIn
fo.java:178)

org.ofbiz.service.calendar.RecurrenceInfo.incrementCurrentCount(RecurrenceIn
fo.java:169)

org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:139)

org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:74)

org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226)

java.lang.Thread.run(Thread.java:534)

com.sap.dbtech.jdbc.exceptions.TimeoutException: [700]: Timeout

com.sap.dbtech.jdbc.ConnectionSapDB.tryReconnect(ConnectionSapDB.java:944)

com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:563)

com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:444)

com.sap.dbtech.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.ja
va:439)

com.sap.dbtech.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.ja
va:311)

com.sap.dbtech.jdbc.CallableStatementSapDB.executeUpdate(CallableStatementSa
pDB.java:776)

org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedSt
atementInPool.java:82)

org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:435)

org.ofbiz.entity.datasource.GenericDAO.singleUpdate(GenericDAO.java:294)

org.ofbiz.entity.datasource.GenericDAO.customUpdate(GenericDAO.java:236)

org.ofbiz.entity.datasource.GenericDAO.update(GenericDAO.java:230)

org.ofbiz.entity.datasource.GenericHelperDAO.store(GenericHelperDAO.java:217
)

org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1057)

org.ofbiz.entity.GenericDelegator.store(GenericDelegator.java:1030)

org.ofbiz.entity.GenericValue.store(GenericValue.java:125)

org.ofbiz.service.calendar.RecurrenceInfo.incrementCurrentCount(RecurrenceIn
fo.java:178)

org.ofbiz.service.calendar.RecurrenceInfo.incrementCurrentCount(RecurrenceIn
fo.java:169)

org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:139)

org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:74)

org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226)

java.lang.Thread.run(Thread.java:534)

----------------------------------------------------------------------------
----

Free forum by Nabble Edit this page