[jbpm-issues] [JBoss JIRA] Commented: (JBPM-1131) jpdl test suite hangs with pgsql
[ http://jira.jboss.com/jira/browse/JBPM-1131?page=comments#action_12399316 ]
Alejandro Guizar commented on JBPM-1131:
----------------------------------------
I installed PostgreSQL 8.2.5 on my machine and ran the test suite. It does not hang, but
the query shows even more idle database connections.
datid | datname | procpid | usesysid | usename | current_query | waiting | query_start |
backend_start | client_addr | client_port
16406 | jbpm | 176 | 16407 | jbpm | <IDLE> | f | 2008-02-13 08:53:04.656+00 |
2008-02-13 08:52:08.203+00 | 127.0.0.1 | 1428
16406 | jbpm | 2252 | 16407 | jbpm | <IDLE> | f | 2008-02-13 08:54:21.64+00 |
2008-02-13 08:15:17.875+00 | 127.0.0.1 | 4973
16406 | jbpm | 3280 | 16407 | jbpm | <IDLE> | f | 2008-02-13 08:22:02.015+00 |
2008-02-13 08:22:01.078+00 | 127.0.0.1 | 1076
16406 | jbpm | 3760 | 16407 | jbpm | <IDLE> | f | 2008-02-13 08:22:12.562+00 |
2008-02-13 08:22:11.703+00 | 127.0.0.1 | 1079
16406 | jbpm | 3752 | 16407 | jbpm | alter table JBPM_TASK add constraint FK_TSK_TSKCTRL
foreign key (TASKCONTROLLER_) references JBPM_TASKCONTROLLER | f | 2008-02-13
08:54:29.781+00 | 2008-02-13 08:54:22.109+00 | 127.0.0.1 | 1455
Looking at the log around the times indicated by backend_start, I noticed all of them
coincide with a schema export being completed. However, the schema is dropped and
recreated in every database test. Somehow, only the connections show above remain open.
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