0 Replies Latest reply on May 21, 2014 5:14 PM by jbrock777

    CF 10 getting random resets : Detail: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset).

    jbrock777 Level 1

        These resets appear to coincide with a clearing of the cached queries for the DSN from memory, breaking all my sub queries that try to use the initial cached one.  I am grasping at straws to discover the reset culprit, the DSN tests always show OK, there is not packet loss at the switch level.  If anyone has some suggestions, I am all ears!

       

        The resets are completely random and under no load.  My sql 2008 r2 box is set to unlimited connections.

       

      An example of a DSN setup is :

       

      Maintain Connections [x]

      String Format [ ]

      Max Pooled Statements 100

      Timeout 20 Interval 7

      Query Timeout 0

       

      Login Timeout 30

      CLOB [ ]

      BLOB [ ]

      Long Text Buffer 64000

      Blob Buffer 64000

      Validate Connection [ ]

       

      I am running the following :

      CF Enterprise 10,0,13,287689

      Tomcat 7.0.23.0

      Ubuntu 1204 x64

      Java VM 20.4-b02

      Java 1.6 (Sun Microsystems Inc)

       

       

        I have seen it suggested to uncheck the maintain connections advanced options but this doesn't seem like a good approach to the problem and will cause more stress on the sql box IMHO.

       

        I have also seen it suggested to enable Validate Connection but documentation on this is a bit sparse...

       

       

      Here are more examples of the initial reset error and then the subsequent cache related errors :

       

      Database Error Information:

      Native Error Code: 0

      SQL State: 08S01

      Query Error: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.

      Custom Error Code: 08S01

       

      Database Error Information:

      Native Error Code: 0

      SQL State: n/a

      Query Error:
      Query Of Queries runtime error.
      Table named GlobalDetails was not found in memory. The name is misspelled or the table is not defined.

      Custom Error Code: n/a

       

      Thanks in advance to anyone who has a suggestion.