Forum Discussion

sn0oby_138639's avatar
sn0oby_138639
Icon for Nimbostratus rankNimbostratus
Oct 30, 2014

Web UI SQL Java Error

Since we updated our Cluster from 11.4.1 HF5 to the Version 11.5.1 HF5 I receive some errors while accessing the WEBUI.

 

It happens sometimes that i get that basic Layout but nothing more. It looks like the following Screenshot then.

 

I collected the WebUI.log from /var/log/webui.log and it throws a lot of Java SQL Exceptions.

 

This is one example:

 

java.sql.SQLException: General error in statement [SELECT COUNT(*) FROM logical_disk WHERE name LIKE 'MD%']

 

Did anyone also have this issue or is it a client issue with the java version on the Client? We changed our Java version recently but it happend before as well. The right now used java version is: "1.8.0_20"

 

With our second Big IP Cluster which is also on 11.5.1 HF5 we don't have that issue. Does anybody know what to do against this issue?

 

  • R_Eastman_13667's avatar
    R_Eastman_13667
    Historic F5 Account

    Make this HA unit standby, take it offline, reinstall 11.5.1 HF5 into a new partition, load the current config and reboot into the new partition to see if the issue is resolved.

     

  • Thank you for your reply but I'm a bit unsure about that reinstalling will fix this issue since it is present on both members of the HA cluster.

     

    I will reninstall on the secondary cluster member and see what's happening ;)

     

  • Since I'm not that happy with reinstalling the system I will try to do other things before. I will keep this question onging with my tries and the results of it.

     

    First of all i restarted the tomcat service. Till now it looks good and no errors where received at the moment. Since the Errors happend somehow random I'm not sure yet whether the issue is fixed now.

     

    • sn0oby_138639's avatar
      sn0oby_138639
      Icon for Nimbostratus rankNimbostratus
      If someone could close this Question it would be great. Restarting the TomCat did resolve the issue
    • sn0oby_138639's avatar
      sn0oby_138639
      Icon for Nimbostratus rankNimbostratus
      I Attached the Official Part of the Answer from the F5 Support: There is no traffic related impact when restarting these services. tmsh restart sys service tomcat httpd Please let me know the results of accessing the Web Configuration Utility after this has completed.