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

Sybase transaction log full - dump needed

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • jBPM 3.3.1 GA, jBPM 3.2.5 GA
    • None
    • None
    • None

      After multiple QA runs, the sybase transaction log becomes full and the testsuite stops

      Running org.jbpm.examples.raise.RaiseRequestTest
      Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1,001.558 sec

      As a system admin you can dump the log like this.

      [sybase@jbws ~]$ isql -Usa -P -SJBPM -Djbpmtest
      1> dump transaction jbpmtest with truncate_only
      2> go

      Please monitor db transactions and explain why there are so many open transactions the stay open for a long time.
      Run a continous test against sybase and monitor the db state.

      I fear that we have a jdbc connection leak or uncommited transactions.
      Anyway, the db should not just log because the Tx log becomes full

              rhn-support-hbraun Heiko Braun
              tdiesler@redhat.com Thomas Diesler
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: