[JBoss JIRA] Created: (JBPM-1131) jpdl test suite hangs with pgsql
by Aleksandar Kostadinov (JIRA)
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.
--
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