Transaction timeout

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

Transaction timeout

Jose Diaz-3
Hello:
 
We are having the problem of timeout yet.
For example, we are scheduling a job in webtools
But in some seconds the transaction is not active and the rollback is executed.
I see in the log these messages:   (The question is Where I must set the timeout?? any properties??
 
2007-12-29 09:57:55,630 (invoker-Thread-8) [ GenericEntity.java:394:WARN ] In entity field [AgingReportAux.payment] set the value passed in [java.math.BigDecimal] is not compatible with the Java type of the field [Double]
2007-12-29 09:57:55,631 (invoker-Thread-8) [ AccountsServices.java:113:INFO ] cont = 2505  
2007-12-29 09:57:55,631 (JotmBatch) [ TransactionImpl.java:765:INFO ] set rollback only (tx=bb14:38:0:0113c9cd0e63b4c25d...18f865:)
2007-12-29 09:57:55,632 (invoker-Thread-8) [ AccountsServices.java:114:INFO ] invoiceid=WTS246552, amount = 238.16,
2007-12-29 09:57:55,632 (invoker-Thread-8) [ AccountsHelper.java:355:INFO ] getPaymentNotApplied...
2007-12-29 09:57:55,633 (invoker-Thread-8) [ AccountsHelper.java:356:INFO ] partyId=4468
2007-12-29 09:57:55,633 (invoker-Thread-8) [ AccountsHelper.java:357:INFO ] billingAccountId=7617070039
2007-12-29 09:57:55,634 (invoker-Thread-8) [ TransactionUtil.java:77 :WARN ]
---- exception report ----------------------------------------------------------
[TransactionUtil.begin] active transaction marked for rollback in place, so no transaction begun; this stack trace shows when the exception began:
Exception: java.lang.Exception
Message: Tx Stack Placeholder
---- stack trace ---------------------------------------------------------------
java.lang.Exception: Tx Stack Placeholder
org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:535)
org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:285)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226)
java.lang.Thread.run(Thread.java:534)
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Transaction timeout

Rodrigo Lima-2
Service parameter timeout=10(ms).
But, adjust your SO,
Ex: Windows System default timeout of system is 60seconds(60.000 ms).
       Linux Systems (red hat) 50seconds.





2008/1/4, Jose Diaz <[hidden email]>:

>
> Hello:
>
> We are having the problem of timeout yet.
> For example, we are scheduling a job in webtools
> But in some seconds the transaction is not active and the rollback is
> executed.
> I see in the log these messages:   (The question is Where I must set the
> timeout?? any properties??
>
> 2007-12-29 09:57:55,630 (invoker-Thread-8) [ GenericEntity.java:394:WARN ]
> In entity field [AgingReportAux.payment] set the value passed in [
> java.math.BigDecimal] is not compatible with the Java type of the field
> [Double]
> 2007-12-29 09:57:55,631 (invoker-Thread-8) [ AccountsServices.java:113:INFO
> ] cont = 2505
> 2007-12-29 09:57:55,631 (JotmBatch) [ TransactionImpl.java:765:INFO ] set
> rollback only (tx=bb14:38:0:0113c9cd0e63b4c25d...18f865:)
> 2007-12-29 09:57:55,632 (invoker-Thread-8) [ AccountsServices.java:114:INFO
> ] invoiceid=WTS246552, amount = 238.16,
> 2007-12-29 09:57:55,632 (invoker-Thread-8) [ AccountsHelper.java:355:INFO
> ] getPaymentNotApplied...
> 2007-12-29 09:57:55,633 (invoker-Thread-8) [ AccountsHelper.java:356:INFO
> ] partyId=4468
> 2007-12-29 09:57:55,633 (invoker-Thread-8) [ AccountsHelper.java:357:INFO
> ] billingAccountId=7617070039
> 2007-12-29 09:57:55,634 (invoker-Thread-8) [ TransactionUtil.java:77 :WARN
> ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.begin] active transaction marked for rollback in place,
> so no transaction begun; this stack trace shows when the exception began:
> Exception: java.lang.Exception
> Message: Tx Stack Placeholder
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Tx Stack Placeholder
> org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(
> TransactionUtil.java:535)
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java
> :111)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:285)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226)
> java.lang.Thread.run(Thread.java:534)
>
>
Reply | Threaded
Open this post in threaded view
|

RE: Transaction timeout

Jose Diaz-3
Hello :
It parameter (timeout)  is in some properties? xml?
The sys admin says , if you can give more details about the adjust of our SO?
Please, help me. I am with it problem two weeks.
Jose.


----- Original Message -----
From: Rodrigo Souza <[hidden email]>
Sent: Fri, 1/4/2008 4:51pm
To: [hidden email]
Subject: Re: Transaction timeout

Service parameter timeout=10(ms).
But, adjust your SO,
Ex: Windows System default timeout of system is 60seconds(60.000 ms).
       Linux Systems (red hat) 50seconds.





2008/1/4, Jose Diaz <[hidden email]>:

>
> Hello:
>
> We are having the problem of timeout yet.
> For example, we are scheduling a job in webtools
> But in some seconds the transaction is not active and the rollback is
> executed.
> I see in the log these messages:   (The question is Where I must set the
> timeout?? any properties??
>
> 2007-12-29 09:57:55,630 (invoker-Thread-8) [ GenericEntity.java:394:WARN ]
> In entity field [AgingReportAux.payment] set the value passed in [
> java.math.BigDecimal] is not compatible with the Java type of the field
> [Double]
> 2007-12-29 09:57:55,631 (invoker-Thread-8) [ AccountsServices.java:113:INFO
> ] cont = 2505
> 2007-12-29 09:57:55,631 (JotmBatch) [ TransactionImpl.java:765:INFO ] set
> rollback only (tx=bb14:38:0:0113c9cd0e63b4c25d...18f865:)
> 2007-12-29 09:57:55,632 (invoker-Thread-8) [ AccountsServices.java:114:INFO
> ] invoiceid=WTS246552, amount = 238.16,
> 2007-12-29 09:57:55,632 (invoker-Thread-8) [ AccountsHelper.java:355:INFO
> ] getPaymentNotApplied...
> 2007-12-29 09:57:55,633 (invoker-Thread-8) [ AccountsHelper.java:356:INFO
> ] partyId=4468
> 2007-12-29 09:57:55,633 (invoker-Thread-8) [ AccountsHelper.java:357:INFO
> ] billingAccountId=7617070039
> 2007-12-29 09:57:55,634 (invoker-Thread-8) [ TransactionUtil.java:77 :WARN
> ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.begin] active transaction marked for rollback in place,
> so no transaction begun; this stack trace shows when the exception began:
> Exception: java.lang.Exception
> Message: Tx Stack Placeholder
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Tx Stack Placeholder
> org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(
> TransactionUtil.java:535)
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java
> :111)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:285)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226)
> java.lang.Thread.run(Thread.java:534)
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Transaction timeout

David E Jones

Based on the error message you included it may not be a transaction  
timeout problem. It could be that a service called by another service  
had an error and marked the transaction for rollback, then when  
another service wanted to run that required a transaction it  
complained with the error you've given.

Which version/revision of OFBiz are you using, BTW? In the fairly  
recent past some things related to this have been improved to make  
tracking down the real problem easier, and handling them better too.

For now though, what else is in the log around this? That may tell you  
where the original problem happened.

-David


On Jan 4, 2008, at 3:09 PM, Jose Diaz wrote:

> Hello :
> It parameter (timeout)  is in some properties? xml?
> The sys admin says , if you can give more details about the adjust  
> of our SO?
> Please, help me. I am with it problem two weeks.
> Jose.
>
>
> ----- Original Message -----
> From: Rodrigo Souza <[hidden email]>
> Sent: Fri, 1/4/2008 4:51pm
> To: [hidden email]
> Subject: Re: Transaction timeout
>
> Service parameter timeout=10(ms).
> But, adjust your SO,
> Ex: Windows System default timeout of system is 60seconds(60.000 ms).
>       Linux Systems (red hat) 50seconds.
>
>
>
>
>
> 2008/1/4, Jose Diaz <[hidden email]>:
>>
>> Hello:
>>
>> We are having the problem of timeout yet.
>> For example, we are scheduling a job in webtools
>> But in some seconds the transaction is not active and the rollback is
>> executed.
>> I see in the log these messages:   (The question is Where I must  
>> set the
>> timeout?? any properties??
>>
>> 2007-12-29 09:57:55,630 (invoker-Thread-8) [ GenericEntity.java:
>> 394:WARN ]
>> In entity field [AgingReportAux.payment] set the value passed in [
>> java.math.BigDecimal] is not compatible with the Java type of the  
>> field
>> [Double]
>> 2007-12-29 09:57:55,631 (invoker-Thread-8) [ AccountsServices.java:
>> 113:INFO
>> ] cont = 2505
>> 2007-12-29 09:57:55,631 (JotmBatch) [ TransactionImpl.java:
>> 765:INFO ] set
>> rollback only (tx=bb14:38:0:0113c9cd0e63b4c25d...18f865:)
>> 2007-12-29 09:57:55,632 (invoker-Thread-8) [ AccountsServices.java:
>> 114:INFO
>> ] invoiceid=WTS246552, amount = 238.16,
>> 2007-12-29 09:57:55,632 (invoker-Thread-8) [ AccountsHelper.java:
>> 355:INFO
>> ] getPaymentNotApplied...
>> 2007-12-29 09:57:55,633 (invoker-Thread-8) [ AccountsHelper.java:
>> 356:INFO
>> ] partyId=4468
>> 2007-12-29 09:57:55,633 (invoker-Thread-8) [ AccountsHelper.java:
>> 357:INFO
>> ] billingAccountId=7617070039
>> 2007-12-29 09:57:55,634 (invoker-Thread-8) [ TransactionUtil.java:
>> 77 :WARN
>> ]
>> ---- exception report
>> ----------------------------------------------------------
>> [TransactionUtil.begin] active transaction marked for rollback in  
>> place,
>> so no transaction begun; this stack trace shows when the exception  
>> began:
>> Exception: java.lang.Exception
>> Message: Tx Stack Placeholder
>> ---- stack trace
>> ---------------------------------------------------------------
>> java.lang.Exception: Tx Stack Placeholder
>> org
>> .ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(
>> TransactionUtil.java:535)
>> org
>> .ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java
>> :111)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 285)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 216)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>> 123)
>> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:
>> 80)
>> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226)
>> java.lang.Thread.run(Thread.java:534)
>>
>>


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: Transaction timeout

Jose Diaz-3
One question:
 
I am not setting the parameter transaction-timeout. Maybe it is the problem.
 
But my question is: What is the default value? Where it is configured?
 
<service name="test" engine="java" transaction-timeout="300"
             location="org.ofbiz.test" invoke="receiveRmaAcknowledge" auth="false">
         <description>Service Test</description>
         <attribute name="test" type="String" mode="IN" optional="false"/>
</service>
 
I am trying again with it parameter...I notify if get the same error again.
 
Jose From Peru.
 


----- Original Message -----
From: David E Jones <[hidden email]>
Sent: Fri, 1/4/2008 5:15pm
To: [hidden email]
Subject: Re: Transaction timeout


Based on the error message you included it may not be a transaction  
timeout problem. It could be that a service called by another service  
had an error and marked the transaction for rollback, then when  
another service wanted to run that required a transaction it  
complained with the error you've given.

Which version/revision of OFBiz are you using, BTW? In the fairly  
recent past some things related to this have been improved to make  
tracking down the real problem easier, and handling them better too.

For now though, what else is in the log around this? That may tell you  
where the original problem happened.

-David


On Jan 4, 2008, at 3:09 PM, Jose Diaz wrote:

> Hello :
> It parameter (timeout)  is in some properties? xml?
> The sys admin says , if you can give more details about the adjust  
> of our SO?
> Please, help me. I am with it problem two weeks.
> Jose.
>
>
> ----- Original Message -----
> From: Rodrigo Souza <[hidden email]>
> Sent: Fri, 1/4/2008 4:51pm
> To: [hidden email]
> Subject: Re: Transaction timeout
>
> Service parameter timeout=10(ms).
> But, adjust your SO,
> Ex: Windows System default timeout of system is 60seconds(60.000 ms).
>       Linux Systems (red hat) 50seconds.
>
>
>
>
>
> 2008/1/4, Jose Diaz <[hidden email]>:
>>
>> Hello:
>>
>> We are having the problem of timeout yet.
>> For example, we are scheduling a job in webtools
>> But in some seconds the transaction is not active and the rollback is
>> executed.
>> I see in the log these messages:   (The question is Where I must  
>> set the
>> timeout?? any properties??
>>
>> 2007-12-29 09:57:55,630 (invoker-Thread-8) [ GenericEntity.java:
>> 394:WARN ]
>> In entity field [AgingReportAux.payment] set the value passed in [
>> java.math.BigDecimal] is not compatible with the Java type of the  
>> field
>> [Double]
>> 2007-12-29 09:57:55,631 (invoker-Thread-8) [ AccountsServices.java:
>> 113:INFO
>> ] cont = 2505
>> 2007-12-29 09:57:55,631 (JotmBatch) [ TransactionImpl.java:
>> 765:INFO ] set
>> rollback only (tx=bb14:38:0:0113c9cd0e63b4c25d...18f865:)
>> 2007-12-29 09:57:55,632 (invoker-Thread-8) [ AccountsServices.java:
>> 114:INFO
>> ] invoiceid=WTS246552, amount = 238.16,
>> 2007-12-29 09:57:55,632 (invoker-Thread-8) [ AccountsHelper.java:
>> 355:INFO
>> ] getPaymentNotApplied...
>> 2007-12-29 09:57:55,633 (invoker-Thread-8) [ AccountsHelper.java:
>> 356:INFO
>> ] partyId=4468
>> 2007-12-29 09:57:55,633 (invoker-Thread-8) [ AccountsHelper.java:
>> 357:INFO
>> ] billingAccountId=7617070039
>> 2007-12-29 09:57:55,634 (invoker-Thread-8) [ TransactionUtil.java:
>> 77 :WARN
>> ]
>> ---- exception report
>> ----------------------------------------------------------
>> [TransactionUtil.begin] active transaction marked for rollback in  
>> place,
>> so no transaction begun; this stack trace shows when the exception  
>> began:
>> Exception: java.lang.Exception
>> Message: Tx Stack Placeholder
>> ---- stack trace
>> ---------------------------------------------------------------
>> java.lang.Exception: Tx Stack Placeholder
>> org
>> .ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(
>> TransactionUtil.java:535)
>> org
>> .ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java
>> :111)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 285)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
>> 216)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
>> 123)
>> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:
>> 80)
>> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226)
>> java.lang.Thread.run(Thread.java:534)
>>
>>