Users - timeout issues with scheduled jobs

[Joachim Müller]

Hi All.

I have problems running jobs. From time to time I get the
non-reproducable exception:



[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:517)
org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:117)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:279)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
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)


it seems a transaction timeout has occured. does anybody know about issues
like this? can someone point me to where i can fix this issue, i.e.
increase the timeout?


my config:

- Linux
- java 1.4.2_08
- sequoia 0.8.0
- postgres 7.4.8


Thanks in advance,

Joachim


 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Jacopo Cappellato]

Hi Joachim,

you can set the transaction timeout in the service definition, for example:

     <service name="calculateAllProductsCosts" engine="simple"
auth="true" transaction-timout="7200"
 
location="org/ofbiz/manufacturing/cost/CostServices.xml"
invoke="calculateAllProductsCosts">
         <description>Calculates estimated costs for all the
products</description>
         <attribute mode="IN" name="currencyUomId" optional="false"
type="String"/>
     </service>

Hope this helps,

Jacopo

Joachim Müller wrote:

> Hi All.
>
> I have problems running jobs. From time to time I get the
> non-reproducable exception:
>
>
>
> [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:517)
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:117)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:279)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
> 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)
>
>
> it seems a transaction timeout has occured. does anybody know about issues
> like this? can someone point me to where i can fix this issue, i.e.
> increase the timeout?
>
>
> my config:
>
> - Linux
> - java 1.4.2_08
> - sequoia 0.8.0
> - postgres 7.4.8
>
>
> Thanks in advance,
>
> Joachim
>
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Jacopo Cappellato]

This is strange...

is this a typo in the services.xsd (transaction-timout instead of
transaction-timeout)?

<xs:attribute type="xs:string" name="transaction-timout"/>

Jacopo

Jacopo Cappellato wrote:

> Hi Joachim,
>
> you can set the transaction timeout in the service definition, for example:
>
>     <service name="calculateAllProductsCosts" engine="simple"
> auth="true" transaction-timout="7200"
>
> location="org/ofbiz/manufacturing/cost/CostServices.xml"
> invoke="calculateAllProductsCosts">
>         <description>Calculates estimated costs for all the
> products</description>
>         <attribute mode="IN" name="currencyUomId" optional="false"
> type="String"/>
>     </service>
>
> Hope this helps,
>
> Jacopo
>
> Joachim Müller wrote:
>
>> Hi All.
>>
>> I have problems running jobs. From time to time I get the
>> non-reproducable exception:
>>
>>
>>
>> [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:517)
>>
>> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:117)
>>
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:279)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
>> 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)
>>
>>
>> it seems a transaction timeout has occured. does anybody know about
>> issues
>> like this? can someone point me to where i can fix this issue, i.e.
>> increase the timeout?
>>
>>
>> my config:
>>
>> - Linux
>> - java 1.4.2_08
>> - sequoia 0.8.0
>> - postgres 7.4.8
>>
>>
>> Thanks in advance,
>>
>> Joachim
>>
>>
>>  
>> _______________________________________________
>> Users mailing list
>> [hidden email]
>> http://lists.ofbiz.org/mailman/listinfo/users
>>
>
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[David E. Jones]

Yeah... Unfortunately it was written this way from the beginning and  
kept to avoid backward compatibility issues. Maybe someday we'll  
throw those to the wind anyway and fix/change this... In the mean  
time one can always entertain one's self with mailing list, or even  
Google, searches... ;)

-David


On Dec 21, 2005, at 3:08 AM, Jacopo Cappellato wrote:

> This is strange...
>
> is this a typo in the services.xsd (transaction-timout instead of  
> transaction-timeout)?
>
> <xs:attribute type="xs:string" name="transaction-timout"/>
>
> Jacopo
>
> Jacopo Cappellato wrote:
>> Hi Joachim,
>> you can set the transaction timeout in the service definition, for  
>> example:
>>     <service name="calculateAllProductsCosts" engine="simple"  
>> auth="true" transaction-timout="7200"
>> location="org/ofbiz/manufacturing/cost/CostServices.xml"  
>> invoke="calculateAllProductsCosts">
>>         <description>Calculates estimated costs for all the  
>> products</description>
>>         <attribute mode="IN" name="currencyUomId" optional="false"  
>> type="String"/>
>>     </service>
>> Hope this helps,
>> Jacopo
>> Joachim Müller wrote:
>>> Hi All.
>>>
>>> I have problems running jobs. From time to time I get the
>>> non-reproducable exception:
>>>
>>>
>>>
>>> [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.setTransactionBeginStac
>>> k(TransactionUtil.java:517)
>>> org.ofbiz.entity.transaction.TransactionUtil.begin
>>> (TransactionUtil.java:117)
>>> org.ofbiz.service.ServiceDispatcher.runSync
>>> (ServiceDispatcher.java:279)
>>> org.ofbiz.service.ServiceDispatcher.runSync
>>> (ServiceDispatcher.java:213)
>>> org.ofbiz.service.GenericDispatcher.runSync
>>> (GenericDispatcher.java:110)
>>> 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)
>>>
>>>
>>> it seems a transaction timeout has occured. does anybody know  
>>> about issues
>>> like this? can someone point me to where i can fix this issue, i.e.
>>> increase the timeout?
>>>
>>>
>>> my config:
>>>
>>> - Linux
>>> - java 1.4.2_08
>>> - sequoia 0.8.0
>>> - postgres 7.4.8
>>>
>>>
>>> Thanks in advance,
>>>
>>> Joachim
>>>
>>>
>>>  _______________________________________________
>>> Users mailing list
>>> [hidden email]
>>> http://lists.ofbiz.org/mailman/listinfo/users
>>>
>> _______________________________________________
>> Users mailing list
>> [hidden email]
>> http://lists.ofbiz.org/mailman/listinfo/users
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Jacopo Cappellato]

I've created a (low priority) Jira issue to remember this:

http://jira.undersunconsulting.com/browse/OFBIZ-642

Jacopo

David E. Jones wrote:

>
> Yeah... Unfortunately it was written this way from the beginning and  
> kept to avoid backward compatibility issues. Maybe someday we'll  throw
> those to the wind anyway and fix/change this... In the mean  time one
> can always entertain one's self with mailing list, or even  Google,
> searches... ;)
>
> -David
>
>
> On Dec 21, 2005, at 3:08 AM, Jacopo Cappellato wrote:
>
>> This is strange...
>>
>> is this a typo in the services.xsd (transaction-timout instead of  
>> transaction-timeout)?
>>
>> <xs:attribute type="xs:string" name="transaction-timout"/>
>>
>> Jacopo
>>
>> Jacopo Cappellato wrote:
>>
>>> Hi Joachim,
>>> you can set the transaction timeout in the service definition, for  
>>> example:
>>>     <service name="calculateAllProductsCosts" engine="simple"  
>>> auth="true" transaction-timout="7200"
>>> location="org/ofbiz/manufacturing/cost/CostServices.xml"  
>>> invoke="calculateAllProductsCosts">
>>>         <description>Calculates estimated costs for all the  
>>> products</description>
>>>         <attribute mode="IN" name="currencyUomId" optional="false"  
>>> type="String"/>
>>>     </service>
>>> Hope this helps,
>>> Jacopo
>>> Joachim Müller wrote:
>>>
>>>> Hi All.
>>>>
>>>> I have problems running jobs. From time to time I get the
>>>> non-reproducable exception:
>>>>
>>>>
>>>>
>>>> [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.setTransactionBeginStac
>>>> k(TransactionUtil.java:517)
>>>> org.ofbiz.entity.transaction.TransactionUtil.begin
>>>> (TransactionUtil.java:117)
>>>> org.ofbiz.service.ServiceDispatcher.runSync
>>>> (ServiceDispatcher.java:279)
>>>> org.ofbiz.service.ServiceDispatcher.runSync
>>>> (ServiceDispatcher.java:213)
>>>> org.ofbiz.service.GenericDispatcher.runSync
>>>> (GenericDispatcher.java:110)
>>>> 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)
>>>>
>>>>
>>>> it seems a transaction timeout has occured. does anybody know  about
>>>> issues
>>>> like this? can someone point me to where i can fix this issue, i.e.
>>>> increase the timeout?
>>>>
>>>>
>>>> my config:
>>>>
>>>> - Linux
>>>> - java 1.4.2_08
>>>> - sequoia 0.8.0
>>>> - postgres 7.4.8
>>>>
>>>>
>>>> Thanks in advance,
>>>>
>>>> Joachim
>>>>
>>>>
>>>>  _______________________________________________
>>>> Users mailing list
>>>> [hidden email]
>>>> http://lists.ofbiz.org/mailman/listinfo/users
>>>>
>>> _______________________________________________
>>> Users mailing list
>>> [hidden email]
>>> http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>> _______________________________________________
>> Users mailing list
>> [hidden email]
>> http://lists.ofbiz.org/mailman/listinfo/users
>
>
>
> ------------------------------------------------------------------------
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users