Chris,

I am using HikariCP for connection pooling. If the database is leaking
connections then I should see connection not available exception.

How do I find out which file descriptors are leaking ?  these are not files
open on disk as there is no explicit disk file I/O in this application.

I just use the below command to check for open file descriptors:

watch "sudo ls /proc/`cat /var/run/tomcat8.pid`/fd/ | wc -l"

Thanks and Regards
Ayub

On Sun, Jun 21, 2020 at 8:18 PM Christopher Schultz <
ch...@christopherschultz.net> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> Ayub,
>
> On 6/20/20 11:51, Ayub Khan wrote:
> > Sorry we are using  8.0.32 version of tomcat.
> >
> > below is the configuration:
> >
> > Server version: Apache Tomcat/8.0.32 (Ubuntu) Server built:   Jan
> > 24 2020 16:24:30 UTC Server number:  8.0.32.0 OS Name:
> > Linux OS Version:     4.4.0-1087-aws Architecture:   amd64 JVM
> > Version:    1.8.0_181-b13 JVM Vendor:     Oracle Corporation
> >
> > I use the below command to check the file descriptors:
> >
> > watch "sudo ls /proc/`cat /var/run/tomcat8.pid`/fd/ | wc -l"
>
> So you know there is some kind of increase in file-handle use, but you
> don't know what types of file handles are increasing, right?
>
> Can you try to find out which kinds of file handles are increasing?
>
> I have a sneaking suspicion that it's your database connections and
> not actually files open on the disk.
>
> Are you using a database connection pool? If not, you should really
> use one and limit the number of connections to something sane. If you
> are using one, are you monitoring it to see how many connections are
> actually being used? Are you sure you are using proper resource
> management[1]? Even a single code-path that leaks connections can leak
> them quickly under load.
>
> > When there an issue related to broken files, this value keeps
> > increasing, the only way to bring it down is to remove vm instance
> > from AWS load balancer.> Which version of tomcat should I install
> > ?
>
> Tomcat 8.0.x hasn't been supported since its last release on 29 June
> 2018. That was 8.0.53. Your release is from 8 February 2016 and is
> dangerously out of date (unless you are using the Ubuntu-packaged
> version, in which case I hope they kept-up with security patches thee
> past 4 years).
>
> - -chris
>
> > On Sat, Jun 20, 2020 at 6:28 PM Christopher Schultz <
> > ch...@christopherschultz.net> wrote:
> >
> > Ayub,
> >
> > On 6/19/20 16:46, Ayub Khan wrote:
> >>>> tomcat 8.5 broken pipe increases open files on ubuntu AWS
> >
> > Which exact version of Tomcat 8.5? If you aren't running the
> > latest version (8.5.56), please upgrade and re-test.
> >
> >>>> If there is slow response from db I see this stack trace and
> >>>> the open files goes high and the only way to open files go
> >>>> down is to remove the instance from Amazon load balancer.
> >>>>
> >>>> Is there a way to keep the open files low even when Broken
> >>>> pipe error is thrown ?
> >
> > What is your evidence that file handles are being left open?
> >
> > Which file handles are being left open?
> >
> > -chris
> >>
> >> ---------------------------------------------------------------------
> >>
> >>
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> >> For additional commands, e-mail: users-h...@tomcat.apache.org
> >>
> >>
> >
> -----BEGIN PGP SIGNATURE-----
> Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/
>
> iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAl7vlj0ACgkQHPApP6U8
> pFiCqBAAqDO2+sUHpjcL8c5qwQbc0EG1XjgawI/ggjegVNSLTZ6mjdCVmxU3V10T
> IAdAmckT+o5qkZKQSVAQHpNW7i5A21U0dOUF1r1EWq0WZIN3fE1dcpQVsOlvUSqD
> qZ+gnGzg3UasSMJFyOj2hnU1+PBnhSFWvKcHwTda9gelqmgHp24rwpCvHFFFmH+2
> I/QrHoQc1W9F0bUmGOsfBy5+eC981KMUfZrIJmUBQFOhopaD19W+yofZCl0S15E7
> dxfIcqvFSF7FzZ1FraKGVd+nEUlW6PLuNqHkqpNGIstMWuQuo1RkukdXeP3FqjeA
> 36W5GOo6tlJTPGjbGaVPLnKw+hQuQa9he5Dv4E03C9vk1cbU6g+3hguKGhIfV3FM
> 2Pg4SE4LwVv3LMY1uxuuHGPgrs6CqHmMaDA6FQARhm/5iD5WJQBrXwzCYztHK/Z+
> +QILfdBa1VZl9qyujBneY9oJ9yc7HeBb1DDZAAqZFrOJctRmDrdZQrUwZ+b6vUzL
> kBr7fCSnzEqUbPzv5DiY6qfD2x2f1GfJFLY6LuJ36g4P0YSItRTaR2nX/VOzVM9D
> oZsDFZhlSZa0U7KpdaQDpi1dw6wgW83gfc7GxrbYvQsgXZPnm25JeU/UI5p1O+cQ
> q+iynFZ8poxSOIjx+2A9anwCXAiiWbyVRJ6Rmy2NwkCbXH/VhwY=
> =oNTV
> -----END PGP SIGNATURE-----
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>

-- 
--------------------------------------------------------------------
Sun Certified Enterprise Architect 1.5
Sun Certified Java Programmer 1.4
Microsoft Certified Systems Engineer 2000
http://in.linkedin.com/pub/ayub-khan/a/811/b81
mobile:+966-502674604
----------------------------------------------------------------------
It is proved that Hard Work and kowledge will get you close but attitude
will get you there. However, it's the Love
of God that will put you over the top!!

Reply via email to