Eclipse Community Forums: Eclipse Process Manager (Stardust) » IPP 5.3.4 resource busy and acquire with NOWAIT specified or timeout expired

Home » Archived » Eclipse Process Manager (Stardust) » IPP 5.3.4 resource busy and acquire with NOWAIT specified or timeout expired

IPP 5.3.4 resource busy and acquire with NOWAIT specified or timeout expired [message #930945]

Tue, 02 October 2012 15:41

Eclipse User

Hi,

We are using IPP 5.3.4 in production environment. We have a timer activity which runs every 3 minutes. Occasionally, IPP throws following error which stops timer daemon. Any idea? Our integration stops running becasue of this error. The solution is to restart the daemon manually. Thanks.

26 Jul 2012 00:01:10 WARN - [Thread-275383 ] ApplicationException - BPMRT03601 - Concurrent attempt to lock object of type class ag.carnot.workflow.runtime.beans.daemons.DaemonLog with OID 2, row not selected.
java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1313)
at org.tranql.connector.jdbc.StatementHandle.executeQuery(StatementHandle.java:49)
at ag.carnot.db.jdbc.Session.executeLockQuery(Session.java:2326)
at ag.carnot.db.jdbc.Session.lock(Session.java:2900)
at ag.carnot.db.jdbc.IdentifiablePersistentBean.lock(IdentifiablePersistentBean.java:50)
at ag.carnot.workflow.runtime.beans.daemons.DaemonAction$ExecuteDaemonAction.lock(DaemonAction....

Re: IPP 5.3.4 resource busy and acquire with NOWAIT specified or timeout expired [message #931370 is a reply to message #930945]

Wed, 03 October 2012 02:05

Eclipse User

What does this timer do? Can it so happen that it executes for more than 3 minutes and a new timer process is kicked off? Also, what is the value of useLockTables in carnot.properties? One of the workaround that I can suggest is to have a cron job which checks the status of this timer daemon. If the daemon is down, then start it automatically. This is quite simple to achieve using shell scripts and IPP console command.

Re: IPP 5.3.4 resource busy and acquire with NOWAIT specified or timeout expired [message #949482 is a reply to message #931370]

Thu, 18 October 2012 22:39

Eclipse User

Florian, which version is this. We have stabilized the daemon further in several releases.
In a spring deployment this is an option:
http://wiki.eclipse.org/STP/Stardust/KnowledgeBase/SystemAdministration/Daemons/DaemonWatchdog

Re: IPP 5.3.4 resource busy and acquire with NOWAIT specified or timeout expired [message #968888 is a reply to message #949482]

Fri, 02 November 2012 16:57

Eclipse User

I am sorry that it took me so long to reply. I never received any notification on this.

To answer your questions,

1. Can it so happen that it executes for more than 3 minutes and a new timer process is kicked off?

This might be possible. Will it help if the interval is set to 5 minutes?

2. What is the value of useLockTables in carnot.properties

AuditTrail.UseLockTables is set to false

3. which version is this?

This is happening in IPP 5.3.4. Can you provide more details on how to implement Daemonwatchdog?

Re: IPP 5.3.4 resource busy and acquire with NOWAIT specified or timeout expired [message #969286 is a reply to message #968888]

Sat, 03 November 2012 00:49

Eclipse User

1. might, but you should avoid to have such a long running transaction.
why is that required? Any way to implement this asynchronously?

2. Should stay false for Oracle

3. Have you seen the wiki article? What other information do you require?

Previous Topic:	Eclipse Plugin Installation IPP 7.0.1
Next Topic:	Build Process

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 30 17:12:18 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter