I think I've narrowed it down to an issue specific with terracotta quartz based jobs. I've wired it into using tomcat's jdbc connection pooling. I'm also using a super old version of it so that could be part of the problem. Interestingly this didn't happen with tomcat7 but it's more than probably some other change on my end caused this rather strange situation. Anyhow, it's probably not tomcat.
Context.xml is something like this <Resource name="jdbc/myDataSourceName" auth="Container" type="javax.sql.DataSource" maxActive="50" maxIdle="30" maxWait="10000" username="user" password="a password" driverClassName="org.postgresql.Driver" factory="my.custom.EncryptedConnectionFactory" url="jdbc:postgresql://localhost:5432/my_database" /> The encrypted connection factory extends the default one and supports a basic ciphered password On Sat, Jun 2, 2018, 1:34 PM Felix Schumacher <felix.schumacher@ internetallee.de> wrote: > > > Am 24. Mai 2018 23:30:10 MESZ schrieb Alex O'Ree <alexo...@apache.org>: > >Yes it is a tomcat managed data source with postgres. The cpu usage is > >my > >app trying to get a managed data source. Perhaps the jdbc driver is the > >issue. .. > > Care to post your configuration? Maybe there are some changes missing when > you updated to the newer version. > > Regards, > Felix > > > > >On Wed, May 23, 2018, 11:28 AM Christopher Schultz < > >ch...@christopherschultz.net> wrote: > > > >> -----BEGIN PGP SIGNED MESSAGE----- > >> Hash: SHA256 > >> > >> Alex, > >> > >> On 5/22/18 7:39 PM, Alex O'Ree wrote: > >> > I've noticed a behavioral difference from tomcat 7 to 8.5. In v7, I > >> > used to be able to put a computer to "sleep" with tomcat running. > >> > On resume, everything would be just fine. On tomcat 8.5, i'm > >> > noticing that all database connections are basically dropped and do > >> > not appear to to restart/resume when the computer resumes. Actually > >> > the whole computer runs super slow until i kill the tomcat process. > >> > I'm not entirely sure what's going on here. Has anyone else noticed > >> > this kind of behavior? > >> > >> Are you using a tomcat-configured DataSource in your application? If > >> so, what does the configuration look like? > >> > >> I wouldn't expect any problems with sleep. I'm using Tomcat 8.5.29 on > >> MacOS and I haven't noticed any problems when my laptop goes to > >sleep. > >> I'm using Oracle Java 1.8.0_131 in this particular case. > >> > >> When it's running slowly, can you tell which process is taking up all > >> the CPU (or disk)? Try using the Process Explorer to single-out a > >> process. If it's Tomcat (java.exe), take a thread dump to see what > >> Tomcat is doing. > >> > >> - -chris > >> -----BEGIN PGP SIGNATURE----- > >> Comment: GPGTools - http://gpgtools.org > >> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ > >> > >> iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlsFiIkACgkQHPApP6U8 > >> pFi70g/8D9R8EkjpCeNziAUeQmWwxHwui+jbOd1rGjG7EID21mmmJJgw5IO1O8ok > >> F7GUWC8KloqFJ59m+Ib/3NCL5QkiuE/X++AyvDxgwuI1eqlxi86Gu7Jxw6wsfUj2 > >> K1Ovp+jUeNEhuxPfx7zBiHXQPa1kN+B7ExxOyVEeybRalF27hlums2zF6IlC4VKm > >> LP2CFqMeEXMbLBEI6wXJrznxlcINwkQzYlX7EAbXzD4tOookS9wYhBeXi+3Yjugp > >> JbMUzIxOVKDzi2W8WYVRPhnhxSjVe5CVsQ32ghlwPEwzbMAgVcoQ7cwZ9r9l1Pg1 > >> Z8GMiAk4Ui9m+TlKbW5N1r2RgSKLdhk4yUETgr+ykkyaMhc8Wt46vM1bdGjIgX6W > >> CCj/BHcM5IdLb56m1L0wiG82dftYlBNfu3hAlnoJls1GiVtRg5Ph5Dit+t2xH3Kh > >> GpS9r9HhzqbA3tjv4NSR6oRj5UXc/mu1qj93CFoGPf6ZwC5QiHWOMbeegLJxOXVK > >> yuIK1gl3ehTQhgcB+B2wK+0Id3gtcwOmzdzM3by2aSH+glfpwH3vRlYPLVUpAUf9 > >> 7oNuMVwhGHFRKL+PF5o0hVldI/jFF2TqLdiQilTe4pfsRGKslgRJce0TIZT5ZSm5 > >> jsQ2nCm1En7b+HW2hOeh2JjRkwwLqa5XIu7pjB2TVY1vhIJkdXs= > >> =aQz0 > >> -----END PGP SIGNATURE----- > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > >> For additional commands, e-mail: users-h...@tomcat.apache.org > >> > >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
