topic Re: The transaction marked rollback error in Alfresco Archive

The transaction marked rollback error

jack_jin — Mon, 27 Apr 2009 21:51:43 GMT

Hello,Thanks for helping me out and answering my previous questions, they're very helpful.Last week while we were adding some users to the web project, we had some other webscript execute under admin for our web project. Those webscripts errored out, and adding the users timed out. The users seems

Re: The transaction marked rollback error

jack_jin — Thu, 30 Apr 2009 15:43:20 GMT

I copied the database dump and alf_data from another server, that avoided this issue. We have other development tasks that we just need the environment up and running.

But, I can forsee this occurring again, have anyone else experienced this or have a real fix for it?

Re: The transaction marked rollback error

jack_jin — Wed, 10 Jun 2009 15:40:05 GMT

This just happened to a production system - is there a way to free up the transaction once it's locked, without restoring alfresco

Re: The transaction marked rollback error

jack_jin — Wed, 01 Jul 2009 19:16:42 GMT

Re: The transaction marked rollback error

tommorris — Thu, 02 Jul 2009 10:35:08 GMT

Have you looked into customising the configuration of the DBCP connection pool?
This can perform interval-based health checks of connections in the pool.

Have a look for the file: custom-connection-pool-context.xml.sample
It is often found in 'tomcat\shared\classes\alfresco\extension\',
and it's an example of another way to configure the bean with the ID 'dataSource'.

I guess you'll want to change the 'validationQuery' property, in particular.

Maybe this is useful.

Tom
http://www.ixxus.com

Re: The transaction marked rollback error

jack_jin — Wed, 29 Jul 2009 21:19:48 GMT

Hi Tom,

Thanks for the reply. Since we use oracle, we changed our validationQuery to the following


        <property name="validationQuery" >
            <value>select 1 from dual</value>
        </property>
‍‍‍‍‍

Could this have anything to do with the transaction marked back error?