-
Bug
-
Resolution: Done
-
Major
-
SOA 4.2 CP02
-
None
-
None
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.