[jbpm-issues] [JBoss JIRA] Commented: (JBPM-1131) jpdl test suite hangs with pgsql
[ http://jira.jboss.com/jira/browse/JBPM-1131?page=comments#action_12399392 ]
Alejandro Guizar commented on JBPM-1131:
----------------------------------------
From the 'Advanced Problems' page of the Hibernate site
(http://www.hibernate.org/117.html):
<--
Hibernate is leaking JDBC connections!
There are three possible reasons why Hibernate might not be closing connections
1. You are forgetting to call Session.close().
2. Hibernate is doing connection pooling.
3. You are supplying your own connection.
-->
Since (3) is definitely not the case and (1) seems unlikely, I went for (2) and disabled
connection pooling. Doing so eliminated the four idle connections reported in my previous
comment. I have yet to see the effect of this setting in the QA labs; it looks promising,
tough.
Disabling Hibernate's connection pooling might seem bad, but it is not. From the same
page:
<--
You should never use Hibernate's built-in connection pooling in production; it is
non-scalable and non-fault-tolerant. Instead, use DBCP or C3P0 (or, even better, an
application server datasource)
-->
jpdl test suite hangs with pgsql
--------------------------------
Key: JBPM-1131
URL: http://jira.jboss.com/jira/browse/JBPM-1131
Project: JBoss jBPM
Issue Type: Bug
Affects Versions: jBPM 3.2.2 SOA 1
Reporter: Aleksandar Kostadinov
Assigned To: Alejandro Guizar
Fix For: jBPM 3.2.2 SOA 1
jpdl test suite hangs when run on pgsql. When looking at database connections I see:
select * from pg_stat_activity where usename='jbpmsoa';
datid | datname | procpid | usesysid | usename | current_query
| waiting | query_start | backend_start |
client_addr | client_port
----------+---------+---------+----------+---------+----------------------------------------------------+---------+-------------------------------+-------------------------------+-------------+-------------
25965744 | jbpmsoa | 6880 | 25965743 | jbpmsoa | alter table JBPM_JOB drop constraint
FK_JOB_PRINST | t | 2008-02-07 12:52:20.042304-05 | 2008-02-07 12:52:17.339142-05 |
10.18.0.131 | 58016
25965744 | jbpmsoa | 5781 | 25965743 | jbpmsoa | <IDLE> in transaction
| f | 2008-02-07 12:52:17.334733-05 | 2008-02-07
12:32:49.631273-05 | 10.18.0.131 | 57703
When I killed 5781 then test suite continued. Then hanged again on:
25965744 | jbpmsoa | 18794 | 25965743 | jbpmsoa | <IDLE> in transaction
| f | 2008-02-08 10:07:40.825724-05 | 2008-02-08
10:07:40.734023-05 | 10.18.0.131 | 59979
25965744 | jbpmsoa | 18795 | 25965743 | jbpmsoa | alter table JBPM_JOB drop constraint
FK_JOB_PRINST | t | 2008-02-08 10:07:44.991683-05 | 2008-02-08 10:07:40.853339-05 |
10.18.0.131 | 59980
Probably a test is not finishing transaction. I hope to see it failed after the build.
Will comment later with the results.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira