Stream: hapi
Topic: HAPI Errors on Ubuntu
Ozair Bajwa (Jul 08 2020 at 22:46):
Hi,
I deployed HAPI in Tomcat Container in Ubuntu. It was working fine earlier. (Built the war file in Windows and deployed in Ubuntu.)
However recently I am having issues and I am not able able to launch HAPI from Ubuntu.
I checked the Apache logs (Catalina..out) and saw the following Mysql errors.
24-Jun-2020 11:44:30.628 INFO [Abandoned connection cleanup thread] org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading Illegal access: this web application instance has been st$
at com.mysql.cj.jdbc.AbandonedConnectionCleanupThread.checkContextClassLoaders(AbandonedConnectionCleanupThread.java:96)
at com.mysql.cj.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:69)
I also found other errors (Mysql timezone errors)
[localhost-startStop-1] ERROR o.h.e.jdbc.spi.SqlExceptionHelper [SqlExceptionHelper.java:142] Cannot create PoolableConnectionFactory (The server time zone value 'PDT' is unrecognized
or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value
if you want to utilize time zone support.)
As a background, my timezone has changed from America/PDT to America/CDT since the time I first deployed the application.
In order to remedy that I made the following changes:
Changed the Ubuntu system timezone from America/LosAngeles to America/Chicago and verified the change went through.
I also checked the timezone in Mysql and it was still displaying the old time zone. since it was configured to use the system timezone, I restarted the Mysql service and the time change took effect.
I can also verify that I can connect to Mysql from Ubuntu using the credentials in the Hapi (properties file).
After making these changes I restarted Tomcat and I am still getting the errors. The only difference is that this time instead to 'PDT' I am getting the "The server time zone value 'CDT' is unrecognized" errors.
I will appreciate any help or recommendations in resolving this issue.
Thanks
Ozair
Last updated: Apr 12 2022 at 19:14 UTC
