[jbpm-issues] [JBoss JIRA] Commented: (JBPM-1131) jpdl test suite hangs with pgsql

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: Fady Matar 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.