Hello Andreas, > The third issue is somewhere inside taskomatic and I don't have any > idea > where to start. I have zero expierience with Hibernate or Quartz and > I > have no idea how to even track which framework leaves the transaction > open. Taskomatic opens a whole lot of database connections and two of > them idle in a transaction forever.
If the number of open transactions doesn't grow in time, I'd say it's not that bad. :-) When the taskomatic tasks open separate DB connections for their runs and then they close the connections, it's also totally OK. Taskomatic may keep an open connection to the DB just because of the xmlrpc handler that is used for communication with tomcat. Quartz needs a separate connection to the DB, since it's configuration is stored in there. So, I'd tolerate these two connections and would start worry about the issue if the number of open connection would just grow. > My (obvious not too) educated guess was it might be in > SchedulerKernel.initializeAllSatSchedules() because the dangling > connections are never reused for anything and so I guesses it has to > do > with initialization. However, calling commitTransaction() and/or > closeSession() at the end of initializeAllSatSchedules() doesn't help > at > all. > > On the other hand I have no idea wether this is supposed to work. > (can I > commit a transaction via hibernate that was started implicitly by the > database server?) Hmm, none of the connections are started by the DB server. All of them are triggered from the spacewalk services like tomcat, rhn-search, ... and yes, you may commit transactions or close whole sessions any time - when needed. Regards, Tomas -- Tomas Lestach RHN Satellite Engineering, Red Hat > > Anyone with a pointer or two on how to track that issue? > > Regards, > Andreas > -- > Solvention Ltd. & Co. KG > Egermannstr. 6-8 > 53359 Rheinbach > > Tel: +49 2226 158179-0 > Fax: +49 2226 158179-9 > > http://www.solvention.de > mailto:i...@solvention.de > > _______________________________________________ > Spacewalk-devel mailing list > Spacewalk-devel@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-devel > _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
