Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-2389

ReDirect_Checker:java.net.SocketException if the JBoss server is idle for long time and user submits the Repots.

    Details

      Description

      Test Condition :Jboss server is idle for more than 14 hrs.

      It is observed that after submitting the report, it was not redirecting to Report Lists page and got the exception like

      (http-192.168.70.85-8080-4) com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 54,956,230 milliseconds ago. The last packet sent successfully to the server was 54,956,231 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

      2010-09-30 02:16:15,590 ERROR [STDERR] (http-192.168.70.85-8080-4) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

      2010-09-30 02:16:15,590 ERROR [STDERR] (http-192.168.70.85-8080-4) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

      2010-09-30 02:16:15,591 ERROR [STDERR] (http-192.168.70.85-8080-4) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

      2010-09-30 02:16:15,591 ERROR [STDERR] (http-192.168.70.85-8080-4) at java.lang.reflect.Constructor.newInstance(Constructor.java:532)

      2010-09-30 02:16:15,591 ERROR [STDERR] (http-192.168.70.85-8080-4) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)

      2010-09-30 02:16:15,591 ERROR [STDERR] (http-192.168.70.85-8080-4) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)

      2010-09-30 02:16:15,591 ERROR [STDERR] (http-192.168.70.85-8080-4) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3317)

      ***Note detailed log is attached.

      but we were getting the email notification about the generated report.

      Also clicking on show Reports didn't show anything....

      After restarting the jboss everything is working fine.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: