dhis2-devs team mailing list archive

[Halvdan Grelland <halvdanhg@xxxxxxxxx>]

Hi,

The (failed) job you are seeing in the logs is an internal (!) cleanup task
which is ran at 2AM every 24H. In short, the task is necessary maintenance
which removes orphaned files (FileResources) which have been posted to the
instance but are marked for deletion.

Normally this task would run at 2AM, check for any orphaned files and, if
any are found, delete them (and their DB references). In most realistic
cases we are talking about a very small number of deletions, and more often
than not none; not really a 'batch job' as such.

Unfortunately there seems to be a bug with the implementation which causes
the exception you're seeing. I'll have to look into that and get a fix out.

The good news, though, is that it's entirely unproblematic to leave this as
is for now. It is just a failed background task which consumes virtually no
resources and dies immediately after execution start. It should not affect
anything else, but if you are indeed using the file storage capabilities
(for data values/tracker) in your instance you might theoretically
experience orphaned files piling up in case of client side issues. These
are easy to remove once there is a fix released, though, not to worry.

As for configuring the time at which this task is ran (or if it is ran at
all) this is not in place yet but will be more flexible in future versions.
As said, though, it really should not affect your use case at all.

Hope that answers your question. Thanks for reporting!

Halvdan Grelland, DHIS 2 Core developer

2016-01-25 14:26 GMT+01:00 Uwe Wahser <uwe@xxxxxxxxx>:

> Dear all,
>
> since we are doing nightly data-loads into DHIS2 with a 3rd party
> ETL-tool, we
> are obliged to control the DHIS2 background jobs as much as possible via
> api to
> avoid conflicts with the loading processes.
>
> Although I turned of all of the batch-functionalities in
> Maintenance-Scheduling,
> there is an error message every night at 2:00 in catalina.out: "Could not
> obtain
> transaction-synchronized Session for current thread" (more at the end of
> this
> mail)
>
> The error message appears at a time, when my jobs are already through, and
> I
> don't see any negative side aspects (getting a clean log would be nice,
> though).
> But I'd need to know what else is scheduled in the background
> out-of-the-box,
> how to stop it and how to trigger it via api, as I want to avoid locks,
> memory
> shortages etc. due to colliding batches.
>
> DHIS2, Version 22, Build 21765, Standard Ubuntu 14.04 & Oracle 8
>
> Any hint would be appreciated,
>
> Thanks a lot, Uwe
>
> --- catalina.out ---
> * ERROR 2016-01-25 02:00:00,015 Unexpected error occurred in scheduled
> task.
> (TaskUtils.java [taskScheduler-8])
> org.hibernate.HibernateException: Could not obtain transaction-synchronized
> Session for current thread
>         at
>
> org.springframework.orm.hibernate4.SpringSessionContext.currentSession(SpringSessionContext.java:134)
>         at
>
> org.hibernate.internal.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:993)
>         at
>
> org.hisp.dhis.hibernate.HibernateGenericStore.getSharingCriteria(HibernateGenericStore.java:205)
>         at
>
> org.hisp.dhis.hibernate.HibernateGenericStore.getSharingCriteria(HibernateGenericStore.java:200)
>         at
>
> org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.getAllLeCreated(HibernateIdentifiableObjectStore.java:404)
>         at
>
> org.hisp.dhis.fileresource.DefaultFileResourceService.getOrphanedFileResources(DefaultFileResourceService.java:138)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>         at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:497)
>         at
>
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>         at
>
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
>         at com.sun.proxy.$Proxy78.getOrphanedFileResources(Unknown Source)
>         at
>
> org.hisp.dhis.fileresource.FileResourceCleanUpTask.run(FileResourceCleanUpTask.java:58)
>         at
>
> org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
>         at
>
> org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
>         at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>         at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>         at
>
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
>         at
>
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
>         at
>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>         at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>         at java.lang.Thread.run(Thread.java:745)
> --- catalina.out ---
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>