Re: [hibernate-dev] Missing transaction hangs the testsuite

2015-08-19 Thread Martin Simka
teve Ebersole" > To: "Sanne Grinovero" > Cc: "Hibernate.org" > Sent: Saturday, 18 July, 2015 12:04:01 AM > Subject: Re: [hibernate-dev] Missing transaction hangs the testsuite > > So this is definitely not limited to 5.0. This happens in 4.3 as well. I &g

Re: [hibernate-dev] Missing transaction hangs the testsuite

2015-07-17 Thread Steve Ebersole
So this is definitely not limited to 5.0. This happens in 4.3 as well. I pointed 4.3 locally to my MariaDB instance and it is hanging. In every case I have seen so far, this is problems in the test code though. On Fri, Jul 17, 2015 at 1:33 PM Steve Ebersole wrote: > Here is something else in

Re: [hibernate-dev] Missing transaction hangs the testsuite

2015-07-17 Thread Steve Ebersole
Here is something else interesting... So at the point that the test hang against MySQL for me, I have: MariaDB [(none)]> SHOW FULL processlist; +-++-++-+--+-++--

Re: [hibernate-dev] Missing transaction hangs the testsuite

2015-07-17 Thread Steve Ebersole
Process != test. Process here == connection. You have multiple. On Fri, Jul 17, 2015, 11:12 AM Sanne Grinovero wrote: > On 17 July 2015 at 16:25, Steve Ebersole wrote: > > It would seem that this is a regression with ORM, I agree. However, we > do > > not know how recent of a regression. An

Re: [hibernate-dev] Missing transaction hangs the testsuite

2015-07-17 Thread Sanne Grinovero
On 17 July 2015 at 16:25, Steve Ebersole wrote: > It would seem that this is a regression with ORM, I agree. However, we do > not know how recent of a regression. And that is the problem. We have no > idea how far back to look. Because the ORM CI jobs against MySQL, > PostrgreSQL, Oracle, etc

Re: [hibernate-dev] Missing transaction hangs the testsuite

2015-07-17 Thread Steve Ebersole
It would seem that this is a regression with ORM, I agree. However, we do not know how recent of a regression. And that is the problem. We have no idea how far back to look. Because the ORM CI jobs against MySQL, PostrgreSQL, Oracle, etc have not been running for many months. IIRC even when th

Re: [hibernate-dev] Missing transaction hangs the testsuite

2015-07-17 Thread Sanne Grinovero
Thanks Steve, I wasn't sure if I had found a problem. Still, it looks like the Hibernate Search tests are not benefiting from auto-commit, or I wouldn't have this problem right? Our testing configuration properties have been the same for years and I'm just re-enabling tests which haven't been run f

Re: [hibernate-dev] Missing transaction hangs the testsuite

2015-07-16 Thread Steve Ebersole
For what it is worth, I am running into the same problems on MySQL for the ORM tests in terms of blocks on dropping tables. PGSQL at least finishes, although I run into 55 errors which I still need to triage. On Thu, Jul 16, 2015 at 5:59 PM Steve Ebersole wrote: > There is really nothing to imp

Re: [hibernate-dev] Missing transaction hangs the testsuite

2015-07-16 Thread Steve Ebersole
There is really nothing to improve. What would you suggest as an improvement? I mean from a ORM perspective, we have an auto-commit Connection (presumably) and run a query. How on earth would we know to expect that the database is holding locks for that? As far as "requiring transactions" I hav

[hibernate-dev] Missing transaction hangs the testsuite

2015-07-16 Thread Sanne Grinovero
I finally got to re-enable MariaDB and PostgreSQL based tests for Hibernate Search - which has been running on H2 only for some months - and had to debug a case of a single test hanging for a long time. Essentially it would block - for hours - on the SessionFactory#close() method, attempting to dr