Looking at my stack traces it seems pretty clear. Tomcat can't lookup/establish a connection to the database because the postgres jdbc driver failed because of a socket exception, "the network is unreachable". I'm not sure why this behavior is different from tomcat 7 to 8.5 but it's becoming a bit of an issue. SQLException, cannot create PoolableConnectionFactory (The connection attempt failed) from org.apache.toimcat.dbcp.dbcp2.BasicDataSource....
I do recall there being something different related to database pooling with tomcat 7 vs 8. Perhaps the delta is there? On Sun, Jun 3, 2018 at 11:13 AM, Alex O'Ree <alexo...@apache.org> wrote: > I did not copy any tomcat specific jars. I have validation queries > implemented programmatically. > > On Sun, Jun 3, 2018 at 8:44 AM, Felix Schumacher <felix.schumacher@ > internetallee.de> wrote: > >> >> >> Am 02.06.2018 um 20:51 schrieb Alex O'Ree: >> >>> 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. >>> >> >> You copied the jdbc pool jars from tomcat 7 into tomcat 8.5? Why? >> >> >>> 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" >>> /> >>> >> >> You could enable validation queries, so that the pool will check the >> connections validity before handing it out to your application. >> >> Regards, >> Felix >> >> >>> 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 >>>> >>>> >>>> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >> >
