-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Faisal,
On 2/18/19 00:32, fai...@bestercapitalmedia.com wrote: > Dear all, > > > > I am working on a project and I am facing following issue on almost > every second day. I need to restart tomcat to get it running > again. > > Can someone guide me on it. Ask if you need some other insight to > look into it. > > > > 2019-02-18 04:49:35.572 WARN 20698 --- [io-4200-exec-15] > o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: > null > > 2019-02-18 04:49:35.572 ERROR 20698 --- [io-4200-exec-15] > o.h.engine.jdbc.spi.SqlExceptionHelper : HikariPool-1 - > Connection is not available, request timed out after 30000ms. > > 2019-02-18 04:49:35.573 WARN 20698 --- [io-4200-exec-15] > o.s.s.o.provider.endpoint.TokenEndpoint : Handling error: > InternalAuthenticationServiceException, Unable to acquire JDBC > Connection; nested exception is > org.hibernate.exception.JDBCConnectionException: Unable to acquire > JDBC Connection > > > > Server is Ubuntu (aws) > > Database is mySql > > java version "1.8.0_181" > > Java(TM) SE Runtime Environment (build 1.8.0_181-b13) > > Java HotSpot(TM) 64-Bit Server VM (build 25.181-b13, mixed mode) My guess is that you have a connection leak in your code. Might I suggest reading this? https://blog.christopherschultz.net/index.php/2009/03/16/properly-handli ng-pooled-jdbc-connections/ - -chris -----BEGIN PGP SIGNATURE----- Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/ iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlxrB3MACgkQHPApP6U8 pFjUNQ/8C5NP0GXYusuOZi2RO1qzOh+SlmdjqAUK9L7fE219XdoXRHdgBPzTr2tK BdW5n/l3ypZ4J9UPmXZlAfkuF775lahi5iiCdFLUCJUaBcYVn22z8i/jgcGXUWwS BZq9i12Av0qRgiEZTs8UC28f+yBjHs3SXo/WxsdbuE159Wdo6kxqqSpUsebjAa5z gWurE7fxDiyiXOak5Zb7Puay2X1Zxg9vTugDFqZXqpNVxyzFGkkaHWYg/TpUphmW JHB0ucPRK0MIOsdov3onceTfwMF2/HuBJv3GGKSvggleDRYbeRoMOgGas3YipX+j /lz+wrxhIDAZqBHoGWSJFytkkinLECHZEtubxbZG1HkU4+ntasoXvj4LkE/cARya Z1YYKydgHHAk8AMVbBRUwW2Xw2lULXzEY26Y8gKezoL7V/yU7ASPeNujgoMxPzEx wg3PjShAQf1ajsRWC0QylYNelFEzjclnZI/4VQ7GIJan1FOmHNP44wKgeBxmVtA4 C8X3LV7TObBZYGCD59CRE107BUudLF5003keGjixxODc4ygTuhBuQbaPBLt3y+Yb tIsnilVYQM0jHeOOtXoQZWmEjhcpCxB8Otrke3mYGmmo+398quLoLJuzdOuGCwrF Ggl8ed7pv2uR+8DPst0TIn793opcjXRZ1W7ALRD9aTudX8XsnRA= =T7C6 -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org