Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-1131

jpdl test suite hangs with pgsql

XMLWordPrintable

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

              aguizar_jira Alejandro Guizar (Inactive)
              akostadi1@redhat.com Aleksandar Kostadinov
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: