Database Connection trouble with MySQL

XMLWordPrintable

    • Type: Bug
    • Resolution: Won't Fix
    • Priority: Medium
    • None
    • Affects Version/s: 1.4.3
    • Component/s: None
    • Environment:

      Tomcat 4.1.12 on Solaris , MySQL 3.23.52 on Solaris , the jdbc driver formely known as the 'mm' mysql driver (now mysql-connector-java-2.0.14)

    • 1.04

      I've run JIRA under JBoss with at last count 2+ weeks of uptime.

      Just recently switched to Tomcat on the above platform, and over the weekend, something must have happened to the db connections?

      Anything involving more than a read of the database (meaning, updating or deleting) now fails with the following generic error:

      Exception: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following: SELECT ID, pname, URL, LEAD, DESCRIPTION, pkey, pcounter FROM project WHERE ID=? (Communication link failure: java.io.IOException)

      Each error trace is slightly different. For example, sometimes there will be "ERROR [some webwork action]" in at the beginning of the trace. Other times it's absent, and you have to look inside the stack to see that you were trying to do com.atlassian.jira.action.issue.IssueCreate.doExecute()

      Restarting Tomcat seems to have solved the problems.

      Anyone else getting these connection troubles on Tomcat ?

            Assignee:
            Scott Farquhar
            Reporter:
            Mike Curwen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: