Re: Tomcat session management with Redisson

2019-02-18 Thread John Dale
This might be what you're looking for: Unsubscription: Send a blank email to users-unsubscr...@tomcat.apache.org http://tomcat.apache.org/lists.html On 2/18/19, Malith Pamuditha Fernando wrote: > How to unsubscribe this? > > Thank You > > Regards > Malith Pamuditha Fernando > Director >

Re: Tomcat connection error

2019-02-18 Thread Mark Thomas
On 18/02/2019 10:24, fai...@bestercapitalmedia.com wrote: > Hi Ted, > > Yes, you are right. > I just need to restart the tomcat to get back it on. > There is no need to restart the mySql in my case. > > Any clue please. Sounds like a connection leak in the web application. I expect the

Re: Tomcat connection error

2019-02-18 Thread Luis Rodríguez Fernández
Hello Faisal, It looks like your problem is more related with your hikari connection pool than with tomcat itself. I would recommend you to double check your hikari configuration properties. Pay specially attention on how you are configuring your connection pool (minimum and maximum size,

Re: Tomcat connection error

2019-02-18 Thread Ted Spradley
Hi Faisal, Your application(s) run as expected for a while, then you get the SQL Connection error? Then the only way to “fix it” is to restart Tomcat? At the same time are you also restarting MySQL? Thanks, Ted > On Feb 18, 2019, at 02:17, Luis Rodríguez Fernández wrote: > > Hello Faisal,

RE: Tomcat connection error

2019-02-18 Thread faisal
Hi Ted, Yes, you are right. I just need to restart the tomcat to get back it on. There is no need to restart the mySql in my case. Any clue please. Faisal Zaidi -Original Message- From: Ted Spradley [mailto:ted.k.sprad...@gmail.com] Sent: Monday, February 18, 2019 1:52 PM To: Tomcat

Re: Tomcat connection error

2019-02-18 Thread John Dale
I agree - release your connection, commit transaction (if you have auto-commit set to false), and null-out your connection references. The analogy in c++ is you need deallocate memory. Java has GC in Java at a base level, but we also have some resource reclamation at higher levels of abstraction

RE: Tomcat connection error

2019-02-18 Thread faisal
Hi John, I am working in spring boot (maven) project. I am not doing exclusive null-out of the connection feeling that spring boot will manage it, do I still need to manage it myself? If you want I can list the dependencies here. I have just added the following dependency but didn’t try yet on

Re: Tomcat connection error

2019-02-18 Thread John Dale
Greetings; If you can, send some code that uses the connection. From that I think we can rule out an improperly handled connection. There are a few patterns to look for in connection handling that can cause this type of issue. I had a case once where I opened two connections and only closed

Re: Tomcat session management with Redisson

2019-02-18 Thread Herb Burnswell
On Fri, Feb 15, 2019 at 12:21 PM Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Herb, > > On 2/14/19 12:41, Herb Burnswell wrote: > > Tomcat 8.5.23 RHEL 7.5 > > > > We are looking to set up session management via Redisson to

Re: Tomcat session management with Redisson

2019-02-18 Thread Harpreet Sandhu
If you want to go with redis in HA environment. You should opt redis sentinel over master-slave architecture. On Tue 19 Feb, 2019, 12:29 AM Herb Burnswell On Fri, Feb 15, 2019 at 12:21 PM Christopher Schultz < > ch...@christopherschultz.net> wrote: > > > -BEGIN PGP SIGNED MESSAGE- > >

Re: Tomcat session management with Redisson

2019-02-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Herb, On 2/18/19 13:59, Herb Burnswell wrote: > On Fri, Feb 15, 2019 at 12:21 PM Christopher Schultz < > ch...@christopherschultz.net> wrote: > > Herb, > > On 2/14/19 12:41, Herb Burnswell wrote: Tomcat 8.5.23 RHEL 7.5 We are

Re: Tomcat connection error

2019-02-18 Thread Christopher Schultz
-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

Re: [OT] Tomcat connection error

2019-02-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 John, On 2/18/19 07:45, John Dale wrote: > I agree - release your connection, commit transaction (if you have > auto-commit set to false), and null-out your connection > references. > > The analogy in c++ is you need deallocate memory.

Re: Tomcat session management with Redisson

2019-02-18 Thread John Dale
Regarding clustering and state recovery, I opted some time ago to store session information in the database - I prefer full control over session state for security/obscurity reasons. Load balancing is straightforward this way. I'm not sure I would ever need more than 2 nodes for my purposes,

Re: Tomcat session management with Redisson

2019-02-18 Thread Malith Pamuditha Fernando
How to unsubscribe this? Thank You Regards Malith Pamuditha Fernando Director RevPort (Pvt.) Ltd. malith.ferna...@revport.net | +94 713 76 92 17 From: John Dale Sent: Tuesday, February 19, 2019 1:57:10 AM To: Tomcat Users List Subject: Re: Tomcat session

Re: [OT] Tomcat connection error

2019-02-18 Thread John Dale
Chris, On 2/18/19, Christopher Schultz wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > John, > > On 2/18/19 07:45, John Dale wrote: >> I agree - release your connection, commit transaction (if you have >> auto-commit set to false), and null-out your connection >> references. >> >>