Continuum

Error when running scheduler: org.jpox.exceptions.TransactionNotActiveException: Transaction is not active

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: 1.2.3, 1.3.3 (Beta)
  • Fix Version/s: None
  • Component/s: Core system
  • Environment:
    CentOS 5. Tomcat 5.5.25 and mySQL 5
  • Complexity:
    Intermediate
  • Number of attachments :
    1

Description

The attached exception occurs when trying to run a schedule. The error prevents the schedule from running and as a result all
builds associated with that schedule do not run! Builds need to run manually which defeats one of the main reasons of having a CI server.

This problem existed in version 1.2.3 and I was hoping that a fresh install (new database) of 1.3.3 would eliminate the problem.
However, week after the upgraded it started happening again.

  1. Text File
    Stacktrace.txt
    17/Jul/09 3:36 PM
    3 kB
    Andreas Christoforides

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Wendy Smoak added a comment -

Any info you have that would help us reproduce this would be appreciated.

Show
Wendy Smoak added a comment - Any info you have that would help us reproduce this would be appreciated.
Wendy Smoak made changes -
Field Original Value New Value
Fix Version/s Reviewed [ 15656 ]
Hide
Permalink
Andreas Christoforides added a comment -

I believe the problem is related to mySQL and the way the database connection pool was set-up.

We added the following settings to our datasource configuration in Tomcat:

1. The setting "autoReconnect=true" on the JDBC url parameter
2. A new parameter validationQuery="SELECT 1"

Show
Andreas Christoforides added a comment - I believe the problem is related to mySQL and the way the database connection pool was set-up. We added the following settings to our datasource configuration in Tomcat: 1. The setting "autoReconnect=true" on the JDBC url parameter 2. A new parameter validationQuery="SELECT 1"
Brett Porter made changes -
Labels backlog-to-cleanup
Fix Version/s Backlog [ 15656 ]

People

  • Assignee:
    Unassigned
    Reporter:
    Andreas Christoforides
Vote (0)
Watch (1)

Dates

  • Created:
    Updated: