topic Re: LazyInitializationException when retrieving Workflows/tasks in Alfresco Archive

LazyInitializationException when retrieving Workflows/tasks

vycitalr — Thu, 10 Apr 2008 16:23:16 GMT

Hello,I am having problems getting workflows/tasks. My system started to throw LazyIntializationExceptions as to getting TaskInstance's variableInstance. This seem to came into existence when there are more (eg. 50-100) workflows/tasks in system. In other words, I get some TaskInstances via JBPMEng

Re: LazyInitializationException when retrieving Workflows/tasks

janv — Fri, 11 Apr 2008 12:21:30 GMT

Can you please post your startup log showing full build # / schema # ?

It sounds as if you might be using an old nightly/HEAD development build (just before the versioning was switched from 2.2-Dev to 2.9-Dev) rather than a release download of Community or Enterprise ?

If so, can you please see if your problem is repeatable on a test system using either 2.1-Community and/or the latest 2.9B-Community Labs.

Thanks,
Jan

Re: LazyInitializationException when retrieving Workflows/tasks

chrisb — Thu, 01 May 2008 10:46:13 GMT

We have just come across exactly this issue when trying to create over 100 workflow tasks as a result of a data import operation. We are using the Enterprise v2.1.1 (193) schema 77 running on RHEL 5 using a PostgreSQL database.

I will file a JIRA issue for this.

Is there any way to access information on the current size of the workflow.pooledTasks list outside of the Freemarker API? Our data import is initiated from the JS component of a webscript, so ideally we would like to be able to access information on the current size of the workflow task pool before initiating the data import.

Thanks,

Chris

Re: LazyInitializationException when retrieving Workflows/tasks

chrisb — Thu, 01 May 2008 11:28:13 GMT

JIRA issue raised: http://issues.alfresco.com/browse/AR-2296

Thanks, Chris

Re: LazyInitializationException when retrieving Workflows/tasks

vycitalr — Wed, 07 May 2008 13:30:08 GMT

For janv:
Yes, you are right, I am using sort of 2.2-dev based HEAD/night build. In fact it is basically revision 1038 from HEAD, so my version.properties are

version.major=2
version.minor=2
version.revision=0
version.label=dev
version.edition=Community Network
version.schema=105

But later I updated to a little later revsion, but did not update the version.properties somehow, so its difficult to say the exact scehma version. Now inspecting it back from SVN, I think it is schema 107.

I will try to restest on some release version (2.1 or so). Will inform when I have results.

Re: LazyInitializationException when retrieving Workflows/tasks

varsenault — Thu, 22 May 2008 18:15:47 GMT

Hi guys,

Continuing here the discussion we started in the workflow forum : http://forums.alfresco.com/viewtopic.php?f=4&t=12227

We didn't install the patch because, according to what I could read on JIRA, it didn't fix the problem of those with similar symptoms.

For your information, we have a 64 bit X86 FC7 machine with Alfresco 2.1, JDK 1.5.0_12 and MySQL 5.0.37.

Here are our startup hearders :


Alfresco JVM - v1.5.0_08-b03; maximum heap size 992.688MB
Alfresco started (Community Network): Current version 2.1.0 (484) schema 64 - Installed version 2.1.0 (484) schema 64
‍‍‍‍

We get this LazyInitializationException all the time. Now, we have to impose a very strict and costly operational discipline to minimize the load on the server.

Should we allocate more RAM? Is there a new community edition release that is fixing this coming up soon (I know 2.9 doesn't)? Are other solution patterns emerging at this point? Is it fixed in the enterprise edition?

This is a very irritating issue on a product that is otherwise pretty good. Help would be much much appreciated.

Thanks.

Re: LazyInitializationException when retrieving Workflows/tasks

janv — Fri, 23 May 2008 08:29:34 GMT

It would be useful to have a repeatable test case, including test data etc. The other person who applied the patch was using a dev build so their results might be inconclusive. I would recommend backing up your system and applying the AMP patch (AR-2212) to see if this resolves your specific issue. That particular fix has been integrated into the latest Enterprise releases and now also merged into 2.9 & HEAD, so will be included in the next Community release.

Regards,
Jan

Re: LazyInitializationException when retrieving Workflows/tasks

varsenault — Sun, 25 May 2008 21:02:15 GMT

Well,

I don't know how to generate a repeatable test case because the problem seems to be volume-based.Our Alfresco repository is around 60GB and there are around 500 instances of the same workflow definition running at the same time. On one of the transitions, there is an ActionHandler that is taking around 3 minutes to run, and it seems that the amount of people going through that transition will condition the occurence of the bug.

We tried to create a cloned instance of the master Alfresco system on which we are experiencing the problem, but we're having trouble just doing that. We posted our misfortune on another thread : http://forums.alfresco.com/viewtopic.php?f=13&t=12432&p=41537

When will the next community version be released? We'll continue on with trying the patch if we can get a clone of the problematic system.

You guys take care!

Re: LazyInitializationException when retrieving Workflows/tasks

varsenault — Mon, 26 May 2008 18:33:18 GMT

We have successfully built a clone instance. We will test the patch later this week and we will let you know.

Thanks,

Vincent

Re: LazyInitializationException when retrieving Workflows/tasks

jimcornmell — Tue, 08 Jul 2008 08:43:03 GMT

Has anyone fixed this? I've go the same issue on the cummunity release.