You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Mark Maciolek <ma...@unh.edu> on 2015/02/23 15:46:15 UTC
Tomcat 6 database connection issue
hi,
operating system:
Scientific Linux release 6.6 (Carbon)
postgres version
postgresql-server-8.4.2
tomcat version
tomcat6-6.0.24
Tomcat starts and I can reach page at the 8080 port on the server
when I add the following xml file and restart tomcat I get this error:
Feb 23, 2015 9:28:16 AM org.apache.catalina.startup.ContextConfig
processContextConfig
SEVERE: Parse error in context.xml for /cooa
org.xml.sax.SAXParseException; systemId:
file:///etc/tomcat6/Catalina/localhost/cooa.xml; lineNumber: 21;
columnNumber: 12; Error at (21, 12: null
<?xml version="1.0" encoding="UTF-8"?>
<Context>
path="/web/opal/webapps"
docBase="/web/opal/webapps/ROOT"
debug="5"
reloadable="true"
allowLinking="true"
<Resource>
name="jdbc/postgres"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://127.0.0.1:5432/cooa"
username="dbuser"
password="*****"
maxActive="20"
maxIdle="10"
maxWait="10000"
</Resource>
</Context>
Line #21 is the </Resource> ran file past xml parse checker and reports
everything okay.
Been googling it for two days now and can not figure out what I have
done wrong.
Mark
--
Mark Maciolek
Network Administrator
Morse Hall Room 339
603-862-3050
https://www.unh.edu/research/support-units/research-computing-center
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 6 database connection issue
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Mark,
On 2/24/15 10:49 AM, Mark Maciolek wrote:
> seeing this in the logs:
>
> [Tue Feb 24 10:17:12 2015] [error] (70007)The timeout specified
> has expired: proxy: read response failed from (null) (*) [Tue Feb
> 24 10:17:14 2015] [error] ajp_read_header: ajp_ilink_receive
> failed [Tue Feb 24 10:17:14 2015] [error] (70007)The timeout
> specified has expired: proxy: read response failed from (null) (*)
>
>
> just restarting tomcat it immediately makes ~200 connections
>
> still investigating what the issue might be
FYI this has nothing to do with your JDBC connection pool. It looks
like a bad mod_proxy_ajp configuration.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: GPGTools - http://gpgtools.org
iQIcBAEBCAAGBQJU7LP6AAoJEBzwKT+lPKRY8LkP/20uvc8cQpKNLp7FR5MvSl7f
nLQh7kWoJ5i/Fdwwy7Fb237kDd2ZG8hdQaPJcsy4Q2a+yV2Rev32dxozcIXyxaqh
YKtCTrjOhJIFD/EbliGAPp/kltrAC3q8jzTAICbY+RnwIvdH20y4vilpM5vPBmaT
4SQkPnSFeYuQv4d8PwsXacKV7KMe96Xpn7RtAmxoT9uEKcf1RUuKtN3KpBC5/4NC
sqm0if0Dvt56rPTcjN74XUoBhTZtbm4iws7zztfoi0nPSCPrcWQ2H1VUzXBlaDAw
qW6flzrBjxlWMBShNlzqHjUC1MLEcnr4OG3wvrUjFyyMIduro7EB5w/bi8pvGygY
rxarOypSLIm2UCVz0kYdGGtmdhuevR315OmGCo+urAqlcZODIKnAnwze6uGe/QyB
hMKAVgJxYTjNF3hTKfAKsg8s70cIjlaZcYMW+bhB3bq8C97yuX458CMg/DhNJYKd
KxkcbJSttM1FMfXGthxJLNSDRhdcm8V5NZ+T+ryJpuKXKegEyaIbxbgZ/33HnftB
BTY6OZbdgfmEZ92/B3wabCtdGDSaj+St32kXLS+feEoMBl7xCaTkjYRxM7mtsMh/
eE4V+bLGQTiifHlwhLirPtkfZldlj9DgYSwEpmbZ43MUNbGTq94PRn8OmOAO4pxm
vrfvMCzflKf0ITzl7G3P
=gv62
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 6 database connection issue
Posted by Mark Maciolek <ma...@unh.edu>.
hi,
seeing this in the logs:
[Tue Feb 24 10:17:12 2015] [error] (70007)The timeout specified has
expired: proxy: read response failed from (null) (*)
[Tue Feb 24 10:17:14 2015] [error] ajp_read_header: ajp_ilink_receive failed
[Tue Feb 24 10:17:14 2015] [error] (70007)The timeout specified has
expired: proxy: read response failed from (null) (*)
just restarting tomcat it immediately makes ~200 connections
still investigating what the issue might be
Mark
On 2/24/2015 10:18 AM, Christopher Schultz wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> Mark,
>
> On 2/24/15 10:08 AM, Mark Maciolek wrote:
>> added this line to my context xml and pool connections start
>>
>> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" had to get
>> older tomcat-jdbc.jar now on to updating my web pages to use this
> Why would you have to modify your web pages to use a different
> connection pool? This is a JNDI-defined pool using standard
> Java-defined interfaces. The JSP pages shouldn't have to change by a
> single byte.
>
> - -chris
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
> Comment: GPGTools - http://gpgtools.org
>
> iQIcBAEBCAAGBQJU7JY0AAoJEBzwKT+lPKRYgsMQAMEw+Ezel+1DrCUH+j/QfKY1
> lT5CEyL7sJBJGHjDPtfeIfR2TSA1Bq45VF0Mf/gshhzxwJuzW97G6RfeNvVEIkRF
> QICD3nkxix21F9wQaHb/QJ9gal9tkZ5HjXIsEcVww8DCj5IkAc4uYDvFmsw+D7Cq
> Ityhlbh6FReMnxPsizZFMIRrQD6ZfFqYAVsIOxtRy+uvdOjMQtEcivl6ecYDXHzI
> Um8SnkkPhu7z56yLckosg1uJ3E1Ly+GHFBH+lbHW/IOIivM+p8yFH+UwpGqTwQOY
> SS74Bvn/u5WxU1TUe8yKqYsSd0N7yQfn06eOMuTgfX5QxXXOuBZzKHmTFTteDL4Q
> uw2+1xxJ1weJ5yZeLEUeUZ7AcjH3CkoCwelMuNX5Lk4vHOtKN1w4w+EWZSwD96dg
> cv0pvgpkTYfuc2Jy1zrEeLtUQ6evP8wFL2ySlw/NiJ7L2mUwzyaNO/YbTn0R2Z5Z
> Y8k5vt1HBdjmi5VeqFNwbQVyz837Q9DwQ6qbLe9oozhYjPj58macbGFhJJxkShDM
> ZxuHEq6dTlDZLeYic6EhKDIqqRt5qNvrm4m/DhwPiOiSrzpRXWleMxpp3Cqmbz+F
> KznP+hE+Q66jQPUV3LTact0lakU5RMOIh4OIL2gNAe7SFk3kwq9FmSL2Q1DW5Apd
> YPeFmRUhvVC0Ct1m7JMv
> =2TID
> -----END PGP SIGNATURE-----
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
--
Mark Maciolek
Network Administrator
Morse Hall Room 339
603-862-3050
https://www.unh.edu/research/support-units/research-computing-center
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 6 database connection issue
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Mark,
On 2/24/15 10:08 AM, Mark Maciolek wrote:
> added this line to my context xml and pool connections start
>
> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" had to get
> older tomcat-jdbc.jar now on to updating my web pages to use this
Why would you have to modify your web pages to use a different
connection pool? This is a JNDI-defined pool using standard
Java-defined interfaces. The JSP pages shouldn't have to change by a
single byte.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: GPGTools - http://gpgtools.org
iQIcBAEBCAAGBQJU7JY0AAoJEBzwKT+lPKRYgsMQAMEw+Ezel+1DrCUH+j/QfKY1
lT5CEyL7sJBJGHjDPtfeIfR2TSA1Bq45VF0Mf/gshhzxwJuzW97G6RfeNvVEIkRF
QICD3nkxix21F9wQaHb/QJ9gal9tkZ5HjXIsEcVww8DCj5IkAc4uYDvFmsw+D7Cq
Ityhlbh6FReMnxPsizZFMIRrQD6ZfFqYAVsIOxtRy+uvdOjMQtEcivl6ecYDXHzI
Um8SnkkPhu7z56yLckosg1uJ3E1Ly+GHFBH+lbHW/IOIivM+p8yFH+UwpGqTwQOY
SS74Bvn/u5WxU1TUe8yKqYsSd0N7yQfn06eOMuTgfX5QxXXOuBZzKHmTFTteDL4Q
uw2+1xxJ1weJ5yZeLEUeUZ7AcjH3CkoCwelMuNX5Lk4vHOtKN1w4w+EWZSwD96dg
cv0pvgpkTYfuc2Jy1zrEeLtUQ6evP8wFL2ySlw/NiJ7L2mUwzyaNO/YbTn0R2Z5Z
Y8k5vt1HBdjmi5VeqFNwbQVyz837Q9DwQ6qbLe9oozhYjPj58macbGFhJJxkShDM
ZxuHEq6dTlDZLeYic6EhKDIqqRt5qNvrm4m/DhwPiOiSrzpRXWleMxpp3Cqmbz+F
KznP+hE+Q66jQPUV3LTact0lakU5RMOIh4OIL2gNAe7SFk3kwq9FmSL2Q1DW5Apd
YPeFmRUhvVC0Ct1m7JMv
=2TID
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 6 database connection issue
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Mark,
Sorry... I just can't read through all those
reply-to-reply-to-reply-to lines anymore. I'm snipping them out since
they are less relevant, now.
On 2/24/15 10:50 AM, Mark Maciolek wrote:
> Should have mentioned this:
>
> Switched to tomcat 7, since no matter what I tried connection pool
> would not start.
Is this a new application, or something that has been working that
needs to be modified? If you are supporting an old application, then
you should change as little as possible until you solve your problem.
If this is a new application, you should go all the way up to Tomcat
8. The servlet spec is backward-compatible, so you aren't really
risking anything by using the current highest version. It's also the
one likely to be supported the longest.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: GPGTools - http://gpgtools.org
iQIcBAEBCAAGBQJU7LSvAAoJEBzwKT+lPKRY/c4P/1hOK3Cp6KW8x2fEUPls8mrB
UHp1RD2el5Ox4wE92L4dxiVev/ZRLVmos9KK5VGWSRjgPEt2b8RpwZe3t1NcQuVv
TwpE8qplaR7hsx2+xLM0r8arYzj/jTUQVyXVBLQO+llIE3RNvef4W3TwyG+oPciJ
qu7wnVR8HSpBOW5SC5d6sZfOiYyTSYR08FL+qZyyDTtOEzJVgWxldv3wtMWBVEjY
KzPhRri64FazSr+d5Cw8NPTXJRDaS8lt5UOP4piPAcI0D+QEYIaNPvsZCXoVbPRS
fTzZX/BUWf5l1B4cw0qAfIGnYUbVepnWXxIQXoaBWzPG+SDh53kgCAW4Oe0s/4fk
VaR9N7PoUZjcu/8O89EL/MrESNcp5NCHVqdbguo+clAkqjNVWPn0vXL1tyfwDPV4
LGgc05e6Ki9/JNEvVCPVsG4e8RnmbxYpMQ68RsAet9/g/bZVKdx7oizCjAFBDElC
5U0SBwQaXpoEMgD0vw3sb9apl7YYf0TGRZthgNfjguWETqHflb9Wqp76iul63TOv
OyjSenanWqczk4BtAxmwOM8z+nlOJ0Z5hdyKjsf/FOo4NXhG+RnSmAxcKNn7qKuk
21Q6oVvpvWUp/tdnyzlLQ2Wy1PZJlMKComYhgmtOGtN1UQpLw6E9Rv8PFj79xdVW
4gq7M1WgVFW/cc2wh6Eg
=qkWF
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 6 database connection issue
Posted by Mark Maciolek <ma...@unh.edu>.
On 2/24/2015 10:22 AM, Daniel Mikusa wrote:
> On Tue, Feb 24, 2015 at 10:08 AM, Mark Maciolek <ma...@unh.edu>
> wrote:
>
>> On 2/23/2015 2:46 PM, Daniel Mikusa wrote:
>>
>>> On Feb 23, 2015 12:49 PM, "Mark Maciolek" <ma...@unh.edu> wrote:
>>>
>>>> On 2/23/2015 12:37 PM, Daniel Mikusa wrote:
>>>>
>>>>> On Mon, Feb 23, 2015 at 12:25 PM, Mark Maciolek <ma...@unh.edu>
>>>>> wrote:
>>>>>
>>>>> On 2/23/2015 9:55 AM, Daniel Mikusa wrote:
>>>>>> On Mon, Feb 23, 2015 at 9:46 AM, Mark Maciolek <mark.maciolek@unh.edu
>>>>>>> wrote:
>>>>>>>
>>>>>>> hi,
>>>>>>>
>>>>>>>> operating system:
>>>>>>>> Scientific Linux release 6.6 (Carbon)
>>>>>>>>
>>>>>>>> postgres version
>>>>>>>> postgresql-server-8.4.2
>>>>>>>>
>>>>>>>> tomcat version
>>>>>>>> tomcat6-6.0.24
>>>>>>>>
>>>>>>>> Tomcat starts and I can reach page at the 8080 port on the server
>>>>>>>> when I add the following xml file and restart tomcat I get this
>>>>>>>> error:
>>>>>>>>
>>>>>>>> Feb 23, 2015 9:28:16 AM org.apache.catalina.startup.ContextConfig
>>>>>>>> processContextConfig
>>>>>>>> SEVERE: Parse error in context.xml for /cooa
>>>>>>>> org.xml.sax.SAXParseException; systemId:
>>>>>>>> file:///etc/tomcat6/Catalina/
>>>>>>>> localhost/cooa.xml;
>>>>>>>> lineNumber: 21; columnNumber: 12; Error at (21, 12: null
>>>>>>>>
>>>>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>>>>>
>>>>>>>> <Context>
>>>>>>>> path="/web/opal/webapps"
>>>>>>>> docBase="/web/opal/webapps/ROOT"
>>>>>>>> debug="5"
>>>>>>>> reloadable="true"
>>>>>>>> allowLinking="true"
>>>>>>>>
>>>>>>>> <Resource>
>>>>>>>> name="jdbc/postgres"
>>>>>>>> auth="Container"
>>>>>>>> type="javax.sql.DataSource"
>>>>>>>> driverClassName="org.postgresql.Driver"
>>>>>>>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>>>>>>>> username="dbuser"
>>>>>>>> password="*****"
>>>>>>>> maxActive="20"
>>>>>>>> maxIdle="10"
>>>>>>>> maxWait="10000"
>>>>>>>> </Resource>
>>>>>>>>
>>>>>>>> This could be the list or a copy / paste issue, but you should not
>>>>>>>>
>>>>>>> have
>>>> the
>>>>>>> ">" on the opening resource tag. It should be after your last
>>>>>>>
>>>>>> attribute
>>>> (i.e. after maxWait. You also don't need the closing Resource tag.
>>>>>>> Ex:
>>>>>>>
>>>>>>> <Context
>>>>>>> path="/web/opal/webapps"
>>>>>>> docBase="/web/opal/webapps/ROOT"
>>>>>>> debug="5"
>>>>>>> reloadable="true"
>>>>>>> allowLinking="true">
>>>>>>> <Resource
>>>>>>> name="jdbc/postgres"
>>>>>>> auth="Container"
>>>>>>> type="javax.sql.DataSource"
>>>>>>> driverClassName="org.postgresql.Driver"
>>>>>>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>>>>>>> username="dbuser"
>>>>>>> password="*****"
>>>>>>> maxActive="20"
>>>>>>> maxIdle="10"
>>>>>>> maxWait="10000" />
>>>>>>> </Context>
>>>>>>>
>>>>>>> Dan
>>>>>>>
>>>>>>> PS: Remove "path", it's not valid here. Remove "debug", I don't
>>>>>>> think
>>>>>>> that does anything. Also, you probably want to remove docBase because
>>>>>>> you're pointing to something in the webapps folder (i.e. appBase), and
>>>>>>>
>>>>>> you
>>>> should only use docBase if your app is outside of the appBase folder.
>>>>>>>
>>>>>>>
>>>>>>> </Context>
>>>>>>>> Line #21 is the </Resource> ran file past xml parse checker and
>>>>>>>>
>>>>>>> reports
>>>> everything okay.
>>>>>>>> Been googling it for two days now and can not figure out what I have
>>>>>>>>
>>>>>>> done
>>>> wrong.
>>>>>>>> Mark
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>>
>>>>>>>> Mark Maciolek
>>>>>>>> Network Administrator
>>>>>>>> Morse Hall Room 339
>>>>>>>> 603-862-3050
>>>>>>>> https://www.unh.edu/research/support-units/research-computing-center
>>>>>>>>
>>>>>>>>
>>>>>>>> ------------------------------------------------------------
>>>>>>>> ---------
>>>>>>>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>>>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>>>>>>
>>>>>>>>
>>>>>>>> hi,
>>>>>>>>
>>>>>>> Changing the xml file per your suggestions loads now and my jsp pages
>>>>> now
>>>> load as long as they don't need a database connection.
>>>>>> I expect to see new postgres processes similar to this from a working
>>>>>> server:
>>>>>>
>>>>>> postgres 407 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>>>>>> eosearthdata 127.0.0.1(60176) idle
>>>>>> postgres 408 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>>>>>> eosearthdata 127.0.0.1(60177) idle
>>>>>> postgres 409 7734 0 Feb17 ? 00:01:01 postgres: dbuser
>>>>>> eosearthdata 127.0.0.1(60178) idle
>>>>>> postgres 410 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>>>>>> eosearthdata 127.0.0.1(60179) idle
>>>>>> postgres 411 7734 0 Feb17 ? 00:01:01 postgres: dbuser
>>>>>> eosearthdata 127.0.0.1(60180) idle
>>>>>>
>>>>>> Starting tomcat does not start the additional postgres processes on my
>>>>>> server.
>>>>>> It is trying to though:
>>>>>>
>>>>>> Do you have Postgres running on the same machine as Tomcat? Looks
>>>>> like
>>>>> it's waiting trying to make a connection, although it's a little hard to
>>>>> say because it looks like you're using a custom pool
>>>>> (edu.unh.sr.cooa.DBPool?).
>>>>>
>>>>> Dan
>>>>>
>>>>> hi,
>>>> yes, postgres and tomcat are on same server,
>>>>
>>> OK. It does seem like its hanging on connection. Have you actually tried
>>> the connection details outside of Tomcat? Perhaps with a command line tool
>>> or simple Java app?
>>>
>>> it is a custom pool because when moved to production server it will be
>>> sharing tomcat and postgres resources with other web sites.
>>>
>>> I don't know your circumstances but as an fyi Tomcat can share connection
>>> pools across multiple apps on one server.
>>>
>>> For testing purposes I would be willing to make it a standard pool.
>>> If you could, that would be helpful.
>>>
>>> Thanks
>>>
>>> Dan
>>>
>> hi,
>>
>> added this line to my context xml and pool connections start
>>
>> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
>>
> For what it's worth, this is not the default pool used by Tomcat 6. Tomcat
> 6 is going to use a repackaged version of DBCP. If you simply remove the
> "factory" attribute, Tomcat should create your with the default.
>
>
>> had to get older tomcat-jdbc.jar
>> now on to updating my web pages to use this
>>
> +1 to Chris' comment. You shouldn't need to change anything. You code
> should be fetching a connection from the pool through JNDI. It shouldn't
> know or care what pool you're using. Perhaps your code is creating / using
> the pool directly?
>
> http://tomcat.apache.org/tomcat-6.0-doc/jndi-resources-howto.html#Using_resources
>
> Dan
>
HI,
Should have mentioned this:
Switched to tomcat 7, since no matter what I tried connection pool would
not start.
Mark
>> mark
>>
>> Mark
>>>>
>>>> When I kill -3 <tomcat pid>
>>>>>> 2015-02-23 12:16:21
>>>>>> Full thread dump OpenJDK 64-Bit Server VM (23.25-b01 mixed mode):
>>>>>>
>>>>>> "http-8080-7" daemon prio=10 tid=0x00007f133c1b3000 nid=0x7134 in
>>>>>> Object.wait() [0x00007f1348f39000]
>>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000bae00240> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpo
>>>> int$Worker)
>>>>>> at java.lang.Object.wait(Object.java:502)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>>> 1511)
>>>>>> - locked <0x00000000bae00240> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$
>>>> Worker)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>>> 36)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "http-8080-6" daemon prio=10 tid=0x00007f135001b800 nid=0x712e in
>>>>>> Object.wait() [0x00007f134903a000]
>>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000bae002d8> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpo
>>>> int$Worker)
>>>>>> at java.lang.Object.wait(Object.java:502)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>>> 1511)
>>>>>> - locked <0x00000000bae002d8> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$
>>>> Worker)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>>> 36)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "http-8080-5" daemon prio=10 tid=0x00007f1350017800 nid=0x712d in
>>>>>> Object.wait() [0x00007f134913b000]
>>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000bae00370> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpo
>>>> int$Worker)
>>>>>> at java.lang.Object.wait(Object.java:502)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>>> 1511)
>>>>>> - locked <0x00000000bae00370> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$
>>>> Worker)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>>> 36)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "http-8080-4" daemon prio=10 tid=0x00007f1350014000 nid=0x712c in
>>>>>> Object.wait() [0x00007f134923c000]
>>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000bae00408> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpo
>>>> int$Worker)
>>>>>> at java.lang.Object.wait(Object.java:502)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>>> 1511)
>>>>>> - locked <0x00000000bae00408> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$
>>>> Worker)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>>> 36)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "http-8080-3" daemon prio=10 tid=0x00007f1350010800 nid=0x712b in
>>>>>> Object.wait() [0x00007f134933d000]
>>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000bae004a0> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpo
>>>> int$Worker)
>>>>>> at java.lang.Object.wait(Object.java:502)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>>> 1511)
>>>>>> - locked <0x00000000bae004a0> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$
>>>> Worker)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>>> 36)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "ajp-8009-Acceptor-0" daemon prio=10 tid=0x00007f136075c000 nid=0x7128
>>>>>> runnable [0x00007f1349a66000]
>>>>>> java.lang.Thread.State: RUNNABLE
>>>>>> at org.apache.tomcat.jni.Socket.accept(Native Method)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java:
>>>> 1156)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "ajp-8009-CometPoller-0" daemon prio=10 tid=0x00007f136074e000
>>>>>>
>>>>> nid=0x7127
>>>> in Obj ect.wait() [0x00007f1349b67000]
>>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000bae005b8> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpo
>>>> int$Poller)
>>>>>> at java.lang.Object.wait(Object.java:502)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>>> 13)
>>>>>> - locked <0x00000000bae005b8> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$
>>>> Poller)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "ajp-8009-Poller-0" daemon prio=10 tid=0x00007f1360653800 nid=0x7126 in
>>>>>> Object.w ait() [0x00007f1349c68000]
>>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000bae00660> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpo
>>>> int$Poller)
>>>>>> at java.lang.Object.wait(Object.java:502)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>>> 13)
>>>>>> - locked <0x00000000bae00660> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$
>>>> Poller)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "http-8080-2" daemon prio=10 tid=0x00007f135000c800 nid=0x7125 waiting
>>>>>>
>>>>> for
>>>> monit or entry [0x00007f1349d68000]
>>>>>> java.lang.Thread.State: BLOCKED (on object monitor)
>>>>>> at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:66)
>>>>>> - waiting to lock <0x00000000bae00708> (a java.lang.Class for
>>>>>> edu.unh.sr .cooa.DBPool)
>>>>>> at
>>>>>>
>>>>> org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java
>>>> :68)
>>>>>> at org.apache.jasper.runtime.HttpJspBase.service(
>>>>>> HttpJspBase.java:70)
>>>>>> at javax.servlet.http.HttpServlet.service(
>>>>>> HttpServlet.java:717)
>>>>>> at
>>>>>>
>>>>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>>> .java:377)
>>>>>> at
>>>>>>
>>>>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>>>> 13)
>>>>>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.
>>>>>> java:260)
>>>>>> at javax.servlet.http.HttpServlet.service(
>>>>>> HttpServlet.java:717)
>>>>>> at
>>>>>>
>>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>>> icationFilterChain.java:290)
>>>>>> at
>>>>>>
>>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>>> ilterChain.java:206)
>>>>>> at
>>>>>>
>>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
>>>> alve.java:233)
>>>>>> at
>>>>>>
>>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
>>>> alve.java:191)
>>>>>> at
>>>>>>
>>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
>>>> ava:127)
>>>>>> at
>>>>>>
>>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
>>>> ava:102)
>>>>>> at
>>>>>>
>>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
>>>> ve.java:109)
>>>>>> at
>>>>>>
>>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
>>>> a:298)
>>>>>> at
>>>>>>
>>>>> org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
>>>> r.java:865)
>>>>>> at
>>>>>>
>>>>> org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
>>>> ocess(Http11AprProtocol.java:579)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>>> 55)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "http-8080-1" daemon prio=10 tid=0x00007f1350008800 nid=0x7124 waiting
>>>>>>
>>>>> on
>>>> condit ion [0x00007f1349e68000]
>>>>>> java.lang.Thread.State: TIMED_WAITING (sleeping)
>>>>>> at java.lang.Thread.sleep(Native Method)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:88)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>>> at edu.unh.sr.cooa.DBPool.<init>(DBPool.java:55)
>>>>>> at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:67)
>>>>>> - locked <0x00000000bae00708> (a java.lang.Class for
>>>>>> edu.unh.sr.cooa.DBP ool)
>>>>>> at
>>>>>>
>>>>> org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java
>>>> :68)
>>>>>> at org.apache.jasper.runtime.HttpJspBase.service(
>>>>>> HttpJspBase.java:70)
>>>>>> at javax.servlet.http.HttpServlet.service(
>>>>>> HttpServlet.java:717)
>>>>>> at
>>>>>>
>>>>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>>> .java:377)
>>>>>> at
>>>>>>
>>>>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>>>> 13)
>>>>>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.
>>>>>> java:260)
>>>>>> at javax.servlet.http.HttpServlet.service(
>>>>>> HttpServlet.java:717)
>>>>>> at org.apache.catalina.core.ApplicationFilterChain.
>>>>>> internalDoFilter(ApplicationFilterChain.java:290)
>>>>>>
>>>>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>>>>>> ApplicationFilterChain.java:206)
>>>>>> at org.apache.catalina.core.StandardWrapperValve.invoke(
>>>>>> StandardWrapperValve.java:233)
>>>>>>
>>>>>> at org.apache.catalina.core.StandardContextValve.invoke(
>>>>>> StandardContextValve.java:191)
>>>>>> at org.apache.catalina.core.StandardHostValve.invoke(
>>>>>> StandardHostValve.java:127)
>>>>>>
>>>>>> at org.apache.catalina.valves.ErrorReportValve.invoke(
>>>>>> ErrorReportValve.java:102)
>>>>>> at org.apache.catalina.core.StandardEngineValve.invoke(
>>>>>> StandardEngineValve.java:109)
>>>>>>
>>>>>> at org.apache.catalina.connector.CoyoteAdapter.service(
>>>>>> CoyoteAdapter.java:298)
>>>>>> at org.apache.coyote.http11.Http11AprProcessor.process(
>>>>>> Http11AprProcessor.java:865)
>>>>>>
>>>>>> at org.apache.coyote.http11.Http11AprProtocol$
>>>>>> Http11ConnectionHandler.process(Http11AprProtocol.java:579)
>>>>>> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(
>>>>>> AprEndpoint.java:1555)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "http-8080-Acceptor-0" daemon prio=10 tid=0x00007f1360531800 nid=0x7123
>>>>>> runnable [0x00007f1349f6b000]
>>>>>> java.lang.Thread.State: RUNNABLE
>>>>>> at org.apache.tomcat.jni.Socket.accept(Native Method)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java:
>>>> 1156)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "http-8080-Sendfile-0" daemon prio=10 tid=0x00007f1360530000 nid=0x7122
>>>>>>
>>>>> in
>>>> Objec t.wait() [0x00007f134a06c000]
>>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000bae01410> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpo
>>>> int$Sendfile)
>>>>>> at java.lang.Object.wait(Object.java:502)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Sendfile.run(AprEndpoint.java:
>>>> 1773)
>>>>>> - locked <0x00000000bae01410> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$
>>>> Sendfile)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "http-8080-CometPoller-0" daemon prio=10 tid=0x00007f1360524800
>>>>>>
>>>>> nid=0x7121
>>>> in Object.wait() [0x00007f134a16d000]
>>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000bae014b0> (a
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpo
>>>> int$Poller)
>>>>>> at java.lang.Object.wait(Object.java:502)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>>> 13)
>>>>>> - locked <0x00000000bae014b0> (a org.apache.tomcat.util.net.
>>>>>> AprEndpoint$Poller)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "http-8080-Poller-0" daemon prio=10 tid=0x00007f1360544000 nid=0x7120
>>>>>> in
>>>>>> Object.wait() [0x00007f135c16c000]
>>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000bae01558> (a
>>>>>> org.apache.tomcat.util.net
>>>>>>
>>>>> .
>>>> AprEndpoint$Poller)
>>>>>> at java.lang.Object.wait(Object.java:502)
>>>>>> at
>>>>>>
>>>>> org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>>> 13)
>>>>>> - locked <0x00000000bae01558> (a org.apache.tomcat.util.net.
>>>>>> AprEndpoint$Poller)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "ContainerBackgroundProcessor[StandardEngine[Catalina]]" daemon
>>>>>> prio=10
>>>>>> tid=0x00 007f136053b800 nid=0x711f waiting on condition
>>>>>>
>>>>> [0x00007f135c26d000]
>>>> java.lang.Thread.State: TIMED_WAITING (sleeping)
>>>>>> at java.lang.Thread.sleep(Native Method)
>>>>>> at org.apache.catalina.core.ContainerBase$
>>>>>> ContainerBackgroundProcessor.run(ContainerBase.java:1579)
>>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>>
>>>>>> "GC Daemon" daemon prio=10 tid=0x00007f136043d800 nid=0x711e in
>>>>>> Object.wait() [0 x00007f1364123000]
>>>>>> java.lang.Thread.State: TIMED_WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
>>>>>> at sun.misc.GC$Daemon.run(GC.java:117)
>>>>>> - locked <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
>>>>>>
>>>>>> "Low Memory Detector" daemon prio=10 tid=0x00007f13600f5800 nid=0x711b
>>>>>> runnable [0x0000000000000000]
>>>>>> java.lang.Thread.State: RUNNABLE
>>>>>>
>>>>>> "C2 CompilerThread1" daemon prio=10 tid=0x00007f13600f3000 nid=0x711a
>>>>>> waiting on condition [0x0000000000000000]
>>>>>> java.lang.Thread.State: RUNNABLE
>>>>>>
>>>>>> "C2 CompilerThread0" daemon prio=10 tid=0x00007f13600f0800 nid=0x7119
>>>>>> waiting on condition [0x0000000000000000]
>>>>>> java.lang.Thread.State: RUNNABLE
>>>>>>
>>>>>> "Signal Dispatcher" daemon prio=10 tid=0x00007f13600ee800 nid=0x7118
>>>>>> waiting on condition [0x0000000000000000]
>>>>>> java.lang.Thread.State: RUNNABLE
>>>>>>
>>>>>> "Finalizer" daemon prio=10 tid=0x00007f136009b800 nid=0x7117 in
>>>>>> Object.wait() [0 x00007f1364bd1000]
>>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000cdb546f0> (a
>>>>>>
>>>>> java.lang.ref.ReferenceQueue$
>>>> Lock)
>>>>>> at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:
>>>>>> 133)
>>>>>> - locked <0x00000000cdb546f0> (a
>>>>>> java.lang.ref.ReferenceQueue$
>>>>>> Lock)
>>>>>> at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:
>>>>>> 149)
>>>>>> at
>>>>>>
>>>>> java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:189)
>>>> "Reference Handler" daemon prio=10 tid=0x00007f1360099800 nid=0x7116 in
>>>>>> Object.w ait() [0x00007f1364cd2000]
>>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>>> at java.lang.Object.wait(Native Method)
>>>>>> - waiting on <0x00000000cdb54480> (a
>>>>>>
>>>>> java.lang.ref.Reference$Lock)
>>>> at java.lang.Object.wait(Object.java:502)
>>>>>> at java.lang.ref.Reference$ReferenceHandler.run(
>>>>>> Reference.java:133)
>>>>>> - locked <0x00000000cdb54480> (a
>>>>>> java.lang.ref.Reference$Lock)
>>>>>>
>>>>>> "main" prio=10 tid=0x00007f1360009000 nid=0x7113 runnable
>>>>>> [0x00007f1365fb7000]
>>>>>> java.lang.Thread.State: RUNNABLE
>>>>>> at java.net.PlainSocketImpl.socketAccept(Native Method)
>>>>>> at
>>>>>>
>>>>> java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:
>>>> 375)
>>>>>> at java.net.ServerSocket.implAccept(ServerSocket.java:478)
>>>>>> at java.net.ServerSocket.accept(ServerSocket.java:446)
>>>>>> at
>>>>>>
>>>>> org.apache.catalina.core.StandardServer.await(StandardServer.java:389
>>>> )
>>>>>> at
>>>>>>
>>>>> org.apache.catalina.startup.Catalina.await(Catalina.java:657)
>>>> at
>>>>> org.apache.catalina.startup.Catalina.start(Catalina.java:617)
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>>> at
>>>>>>
>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
>>>> java:57)
>>>>>> at
>>>>>>
>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
>>>> sorImpl.java:43)
>>>>>> at java.lang.reflect.Method.invoke(Method.java:622)
>>>>>> at
>>>>>>
>>>>> org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
>>>> at
>>>>> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>>>> "VM Thread" prio=10 tid=0x00007f136008a800 nid=0x7115 runnable
>>>>>> "VM Periodic Task Thread" prio=10 tid=0x00007f1360100800 nid=0x711c
>>>>>> waiting on condition
>>>>>>
>>>>>> JNI global references: 253
>>>>>>
>>>>>> Heap
>>>>>> def new generation total 18432K, used 3571K [0x00000000b9c00000,
>>>>>> 0x00000000bb 000000, 0x00000000cdb50000)
>>>>>> eden space 16384K, 9% used [0x00000000b9c00000,
>>>>>> 0x00000000b9d7cff8,
>>>>>> 0x000000 00bac00000)
>>>>>> from space 2048K, 100% used [0x00000000bae00000,
>>>>>> 0x00000000bb000000,
>>>>>> 0x0000000 0bb000000)
>>>>>> to space 2048K, 0% used [0x00000000bac00000,
>>>>>> 0x00000000bac00000,
>>>>>> 0x0000000 0bae00000)
>>>>>> tenured generation total 40896K, used 4306K [0x00000000cdb50000,
>>>>>> 0x00000000d0 340000, 0x00000000f5a00000)
>>>>>> the space 40896K, 10% used [0x00000000cdb50000,
>>>>>> 0x00000000cdf849a0,
>>>>>> 0x000000 00cdf84a00, 0x00000000d0340000)
>>>>>> compacting perm gen total 21248K, used 13892K [0x00000000f5a00000,
>>>>>> 0x00000000f 6ec0000, 0x0000000100000000)
>>>>>> the space 21248K, 65% used [0x00000000f5a00000,
>>>>>> 0x00000000f6791378,
>>>>>> 0x000000 00f6791400, 0x00000000f6ec0000)
>>>>>> No shared spaces configured.
>>>>>>
>>>>>>
>>>>>>
>>>>>> What should be my next step in troubleshooting this issue?
>>>>>>
>>>>>> mark
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>> Mark Maciolek
>>>>>> Network Administrator
>>>>>> Morse Hall Room 339
>>>>>> 603-862-3050
>>>>>> https://www.unh.edu/research/support-units/research-computing-center
>>>>>>
>>>>>>
>>>>>> ---------------------------------------------------------------------
>>>>>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>>>>
>>>>>>
>>>>>> --
>>>> Mark Maciolek
>>>> Network Administrator
>>>> Morse Hall Room 339
>>>> 603-862-3050
>>>> https://www.unh.edu/research/support-units/research-computing-center
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>>
>>>>
>> --
>>
>> Mark Maciolek
>> Network Administrator
>> Morse Hall Room 339
>> 603-862-3050
>> https://www.unh.edu/research/support-units/research-computing-center
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
--
Mark Maciolek
Network Administrator
Morse Hall Room 339
603-862-3050
https://www.unh.edu/research/support-units/research-computing-center
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 6 database connection issue
Posted by Daniel Mikusa <dm...@pivotal.io>.
On Tue, Feb 24, 2015 at 10:08 AM, Mark Maciolek <ma...@unh.edu>
wrote:
>
> On 2/23/2015 2:46 PM, Daniel Mikusa wrote:
>
>> On Feb 23, 2015 12:49 PM, "Mark Maciolek" <ma...@unh.edu> wrote:
>>
>>>
>>> On 2/23/2015 12:37 PM, Daniel Mikusa wrote:
>>>
>>>> On Mon, Feb 23, 2015 at 12:25 PM, Mark Maciolek <ma...@unh.edu>
>>>> wrote:
>>>>
>>>> On 2/23/2015 9:55 AM, Daniel Mikusa wrote:
>>>>>
>>>>> On Mon, Feb 23, 2015 at 9:46 AM, Mark Maciolek <mark.maciolek@unh.edu
>>>>>> >
>>>>>> wrote:
>>>>>>
>>>>>> hi,
>>>>>>
>>>>>>> operating system:
>>>>>>> Scientific Linux release 6.6 (Carbon)
>>>>>>>
>>>>>>> postgres version
>>>>>>> postgresql-server-8.4.2
>>>>>>>
>>>>>>> tomcat version
>>>>>>> tomcat6-6.0.24
>>>>>>>
>>>>>>> Tomcat starts and I can reach page at the 8080 port on the server
>>>>>>> when I add the following xml file and restart tomcat I get this
>>>>>>> error:
>>>>>>>
>>>>>>> Feb 23, 2015 9:28:16 AM org.apache.catalina.startup.ContextConfig
>>>>>>> processContextConfig
>>>>>>> SEVERE: Parse error in context.xml for /cooa
>>>>>>> org.xml.sax.SAXParseException; systemId:
>>>>>>> file:///etc/tomcat6/Catalina/
>>>>>>> localhost/cooa.xml;
>>>>>>> lineNumber: 21; columnNumber: 12; Error at (21, 12: null
>>>>>>>
>>>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>>>>
>>>>>>> <Context>
>>>>>>> path="/web/opal/webapps"
>>>>>>> docBase="/web/opal/webapps/ROOT"
>>>>>>> debug="5"
>>>>>>> reloadable="true"
>>>>>>> allowLinking="true"
>>>>>>>
>>>>>>> <Resource>
>>>>>>> name="jdbc/postgres"
>>>>>>> auth="Container"
>>>>>>> type="javax.sql.DataSource"
>>>>>>> driverClassName="org.postgresql.Driver"
>>>>>>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>>>>>>> username="dbuser"
>>>>>>> password="*****"
>>>>>>> maxActive="20"
>>>>>>> maxIdle="10"
>>>>>>> maxWait="10000"
>>>>>>> </Resource>
>>>>>>>
>>>>>>> This could be the list or a copy / paste issue, but you should not
>>>>>>>
>>>>>> have
>>
>>> the
>>>>>> ">" on the opening resource tag. It should be after your last
>>>>>>
>>>>> attribute
>>
>>> (i.e. after maxWait. You also don't need the closing Resource tag.
>>>>>>
>>>>>> Ex:
>>>>>>
>>>>>> <Context
>>>>>> path="/web/opal/webapps"
>>>>>> docBase="/web/opal/webapps/ROOT"
>>>>>> debug="5"
>>>>>> reloadable="true"
>>>>>> allowLinking="true">
>>>>>> <Resource
>>>>>> name="jdbc/postgres"
>>>>>> auth="Container"
>>>>>> type="javax.sql.DataSource"
>>>>>> driverClassName="org.postgresql.Driver"
>>>>>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>>>>>> username="dbuser"
>>>>>> password="*****"
>>>>>> maxActive="20"
>>>>>> maxIdle="10"
>>>>>> maxWait="10000" />
>>>>>> </Context>
>>>>>>
>>>>>> Dan
>>>>>>
>>>>>> PS: Remove "path", it's not valid here. Remove "debug", I don't
>>>>>> think
>>>>>> that does anything. Also, you probably want to remove docBase because
>>>>>> you're pointing to something in the webapps folder (i.e. appBase), and
>>>>>>
>>>>> you
>>
>>> should only use docBase if your app is outside of the appBase folder.
>>>>>>
>>>>>>
>>>>>>
>>>>>> </Context>
>>>>>>>
>>>>>>> Line #21 is the </Resource> ran file past xml parse checker and
>>>>>>>
>>>>>> reports
>>
>>> everything okay.
>>>>>>>
>>>>>>> Been googling it for two days now and can not figure out what I have
>>>>>>>
>>>>>> done
>>
>>> wrong.
>>>>>>>
>>>>>>> Mark
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> Mark Maciolek
>>>>>>> Network Administrator
>>>>>>> Morse Hall Room 339
>>>>>>> 603-862-3050
>>>>>>> https://www.unh.edu/research/support-units/research-computing-center
>>>>>>>
>>>>>>>
>>>>>>> ------------------------------------------------------------
>>>>>>> ---------
>>>>>>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>>>>>
>>>>>>>
>>>>>>> hi,
>>>>>>>
>>>>>> Changing the xml file per your suggestions loads now and my jsp pages
>>>>>
>>>> now
>>
>>> load as long as they don't need a database connection.
>>>>>
>>>>> I expect to see new postgres processes similar to this from a working
>>>>> server:
>>>>>
>>>>> postgres 407 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>>>>> eosearthdata 127.0.0.1(60176) idle
>>>>> postgres 408 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>>>>> eosearthdata 127.0.0.1(60177) idle
>>>>> postgres 409 7734 0 Feb17 ? 00:01:01 postgres: dbuser
>>>>> eosearthdata 127.0.0.1(60178) idle
>>>>> postgres 410 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>>>>> eosearthdata 127.0.0.1(60179) idle
>>>>> postgres 411 7734 0 Feb17 ? 00:01:01 postgres: dbuser
>>>>> eosearthdata 127.0.0.1(60180) idle
>>>>>
>>>>> Starting tomcat does not start the additional postgres processes on my
>>>>> server.
>>>>> It is trying to though:
>>>>>
>>>>> Do you have Postgres running on the same machine as Tomcat? Looks
>>>> like
>>>> it's waiting trying to make a connection, although it's a little hard to
>>>> say because it looks like you're using a custom pool
>>>> (edu.unh.sr.cooa.DBPool?).
>>>>
>>>> Dan
>>>>
>>>> hi,
>>>
>>> yes, postgres and tomcat are on same server,
>>>
>> OK. It does seem like its hanging on connection. Have you actually tried
>> the connection details outside of Tomcat? Perhaps with a command line tool
>> or simple Java app?
>>
>> it is a custom pool because when moved to production server it will be
>>>
>> sharing tomcat and postgres resources with other web sites.
>>
>> I don't know your circumstances but as an fyi Tomcat can share connection
>> pools across multiple apps on one server.
>>
>> For testing purposes I would be willing to make it a standard pool.
>>>
>> If you could, that would be helpful.
>>
>> Thanks
>>
>> Dan
>>
> hi,
>
> added this line to my context xml and pool connections start
>
> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
>
For what it's worth, this is not the default pool used by Tomcat 6. Tomcat
6 is going to use a repackaged version of DBCP. If you simply remove the
"factory" attribute, Tomcat should create your with the default.
> had to get older tomcat-jdbc.jar
> now on to updating my web pages to use this
>
+1 to Chris' comment. You shouldn't need to change anything. You code
should be fetching a connection from the pool through JNDI. It shouldn't
know or care what pool you're using. Perhaps your code is creating / using
the pool directly?
http://tomcat.apache.org/tomcat-6.0-doc/jndi-resources-howto.html#Using_resources
Dan
>
> mark
>
> Mark
>>>
>>>
>>> When I kill -3 <tomcat pid>
>>>>>
>>>>> 2015-02-23 12:16:21
>>>>> Full thread dump OpenJDK 64-Bit Server VM (23.25-b01 mixed mode):
>>>>>
>>>>> "http-8080-7" daemon prio=10 tid=0x00007f133c1b3000 nid=0x7134 in
>>>>> Object.wait() [0x00007f1348f39000]
>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000bae00240> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpo
>>
>>> int$Worker)
>>>>> at java.lang.Object.wait(Object.java:502)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>
>>> 1511)
>>>>> - locked <0x00000000bae00240> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$
>>
>>> Worker)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>
>>> 36)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "http-8080-6" daemon prio=10 tid=0x00007f135001b800 nid=0x712e in
>>>>> Object.wait() [0x00007f134903a000]
>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000bae002d8> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpo
>>
>>> int$Worker)
>>>>> at java.lang.Object.wait(Object.java:502)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>
>>> 1511)
>>>>> - locked <0x00000000bae002d8> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$
>>
>>> Worker)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>
>>> 36)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "http-8080-5" daemon prio=10 tid=0x00007f1350017800 nid=0x712d in
>>>>> Object.wait() [0x00007f134913b000]
>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000bae00370> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpo
>>
>>> int$Worker)
>>>>> at java.lang.Object.wait(Object.java:502)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>
>>> 1511)
>>>>> - locked <0x00000000bae00370> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$
>>
>>> Worker)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>
>>> 36)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "http-8080-4" daemon prio=10 tid=0x00007f1350014000 nid=0x712c in
>>>>> Object.wait() [0x00007f134923c000]
>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000bae00408> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpo
>>
>>> int$Worker)
>>>>> at java.lang.Object.wait(Object.java:502)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>
>>> 1511)
>>>>> - locked <0x00000000bae00408> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$
>>
>>> Worker)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>
>>> 36)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "http-8080-3" daemon prio=10 tid=0x00007f1350010800 nid=0x712b in
>>>>> Object.wait() [0x00007f134933d000]
>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000bae004a0> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpo
>>
>>> int$Worker)
>>>>> at java.lang.Object.wait(Object.java:502)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>
>>> 1511)
>>>>> - locked <0x00000000bae004a0> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$
>>
>>> Worker)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>
>>> 36)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "ajp-8009-Acceptor-0" daemon prio=10 tid=0x00007f136075c000 nid=0x7128
>>>>> runnable [0x00007f1349a66000]
>>>>> java.lang.Thread.State: RUNNABLE
>>>>> at org.apache.tomcat.jni.Socket.accept(Native Method)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java:
>>
>>> 1156)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "ajp-8009-CometPoller-0" daemon prio=10 tid=0x00007f136074e000
>>>>>
>>>> nid=0x7127
>>
>>> in Obj ect.wait() [0x00007f1349b67000]
>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000bae005b8> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpo
>>
>>> int$Poller)
>>>>> at java.lang.Object.wait(Object.java:502)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>
>>> 13)
>>>>> - locked <0x00000000bae005b8> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$
>>
>>> Poller)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "ajp-8009-Poller-0" daemon prio=10 tid=0x00007f1360653800 nid=0x7126 in
>>>>> Object.w ait() [0x00007f1349c68000]
>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000bae00660> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpo
>>
>>> int$Poller)
>>>>> at java.lang.Object.wait(Object.java:502)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>
>>> 13)
>>>>> - locked <0x00000000bae00660> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$
>>
>>> Poller)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "http-8080-2" daemon prio=10 tid=0x00007f135000c800 nid=0x7125 waiting
>>>>>
>>>> for
>>
>>> monit or entry [0x00007f1349d68000]
>>>>> java.lang.Thread.State: BLOCKED (on object monitor)
>>>>> at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:66)
>>>>> - waiting to lock <0x00000000bae00708> (a java.lang.Class for
>>>>> edu.unh.sr .cooa.DBPool)
>>>>> at
>>>>>
>>>> org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java
>>
>>> :68)
>>>>> at org.apache.jasper.runtime.HttpJspBase.service(
>>>>> HttpJspBase.java:70)
>>>>> at javax.servlet.http.HttpServlet.service(
>>>>> HttpServlet.java:717)
>>>>> at
>>>>>
>>>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>
>>> .java:377)
>>>>> at
>>>>>
>>>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>>
>>> 13)
>>>>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.
>>>>> java:260)
>>>>> at javax.servlet.http.HttpServlet.service(
>>>>> HttpServlet.java:717)
>>>>> at
>>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>
>>> icationFilterChain.java:290)
>>>>> at
>>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>
>>> ilterChain.java:206)
>>>>> at
>>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
>>
>>> alve.java:233)
>>>>> at
>>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
>>
>>> alve.java:191)
>>>>> at
>>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
>>
>>> ava:127)
>>>>> at
>>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
>>
>>> ava:102)
>>>>> at
>>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
>>
>>> ve.java:109)
>>>>> at
>>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
>>
>>> a:298)
>>>>> at
>>>>>
>>>> org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
>>
>>> r.java:865)
>>>>> at
>>>>>
>>>> org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
>>
>>> ocess(Http11AprProtocol.java:579)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>
>>> 55)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "http-8080-1" daemon prio=10 tid=0x00007f1350008800 nid=0x7124 waiting
>>>>>
>>>> on
>>
>>> condit ion [0x00007f1349e68000]
>>>>> java.lang.Thread.State: TIMED_WAITING (sleeping)
>>>>> at java.lang.Thread.sleep(Native Method)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:88)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>>> at edu.unh.sr.cooa.DBPool.<init>(DBPool.java:55)
>>>>> at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:67)
>>>>> - locked <0x00000000bae00708> (a java.lang.Class for
>>>>> edu.unh.sr.cooa.DBP ool)
>>>>> at
>>>>>
>>>> org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java
>>
>>> :68)
>>>>> at org.apache.jasper.runtime.HttpJspBase.service(
>>>>> HttpJspBase.java:70)
>>>>> at javax.servlet.http.HttpServlet.service(
>>>>> HttpServlet.java:717)
>>>>> at
>>>>>
>>>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>
>>> .java:377)
>>>>> at
>>>>>
>>>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>>
>>> 13)
>>>>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.
>>>>> java:260)
>>>>> at javax.servlet.http.HttpServlet.service(
>>>>> HttpServlet.java:717)
>>>>> at org.apache.catalina.core.ApplicationFilterChain.
>>>>> internalDoFilter(ApplicationFilterChain.java:290)
>>>>>
>>>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>>>>> ApplicationFilterChain.java:206)
>>>>> at org.apache.catalina.core.StandardWrapperValve.invoke(
>>>>> StandardWrapperValve.java:233)
>>>>>
>>>>> at org.apache.catalina.core.StandardContextValve.invoke(
>>>>> StandardContextValve.java:191)
>>>>> at org.apache.catalina.core.StandardHostValve.invoke(
>>>>> StandardHostValve.java:127)
>>>>>
>>>>> at org.apache.catalina.valves.ErrorReportValve.invoke(
>>>>> ErrorReportValve.java:102)
>>>>> at org.apache.catalina.core.StandardEngineValve.invoke(
>>>>> StandardEngineValve.java:109)
>>>>>
>>>>> at org.apache.catalina.connector.CoyoteAdapter.service(
>>>>> CoyoteAdapter.java:298)
>>>>> at org.apache.coyote.http11.Http11AprProcessor.process(
>>>>> Http11AprProcessor.java:865)
>>>>>
>>>>> at org.apache.coyote.http11.Http11AprProtocol$
>>>>> Http11ConnectionHandler.process(Http11AprProtocol.java:579)
>>>>> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(
>>>>> AprEndpoint.java:1555)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "http-8080-Acceptor-0" daemon prio=10 tid=0x00007f1360531800 nid=0x7123
>>>>> runnable [0x00007f1349f6b000]
>>>>> java.lang.Thread.State: RUNNABLE
>>>>> at org.apache.tomcat.jni.Socket.accept(Native Method)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java:
>>
>>> 1156)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "http-8080-Sendfile-0" daemon prio=10 tid=0x00007f1360530000 nid=0x7122
>>>>>
>>>> in
>>
>>> Objec t.wait() [0x00007f134a06c000]
>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000bae01410> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpo
>>
>>> int$Sendfile)
>>>>> at java.lang.Object.wait(Object.java:502)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Sendfile.run(AprEndpoint.java:
>>
>>> 1773)
>>>>> - locked <0x00000000bae01410> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$
>>
>>> Sendfile)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "http-8080-CometPoller-0" daemon prio=10 tid=0x00007f1360524800
>>>>>
>>>> nid=0x7121
>>
>>> in Object.wait() [0x00007f134a16d000]
>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000bae014b0> (a
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpo
>>
>>> int$Poller)
>>>>> at java.lang.Object.wait(Object.java:502)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>
>>> 13)
>>>>> - locked <0x00000000bae014b0> (a org.apache.tomcat.util.net.
>>>>> AprEndpoint$Poller)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "http-8080-Poller-0" daemon prio=10 tid=0x00007f1360544000 nid=0x7120
>>>>> in
>>>>> Object.wait() [0x00007f135c16c000]
>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000bae01558> (a
>>>>> org.apache.tomcat.util.net
>>>>>
>>>> .
>>
>>> AprEndpoint$Poller)
>>>>> at java.lang.Object.wait(Object.java:502)
>>>>> at
>>>>>
>>>> org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>
>>> 13)
>>>>> - locked <0x00000000bae01558> (a org.apache.tomcat.util.net.
>>>>> AprEndpoint$Poller)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "ContainerBackgroundProcessor[StandardEngine[Catalina]]" daemon
>>>>> prio=10
>>>>> tid=0x00 007f136053b800 nid=0x711f waiting on condition
>>>>>
>>>> [0x00007f135c26d000]
>>
>>> java.lang.Thread.State: TIMED_WAITING (sleeping)
>>>>> at java.lang.Thread.sleep(Native Method)
>>>>> at org.apache.catalina.core.ContainerBase$
>>>>> ContainerBackgroundProcessor.run(ContainerBase.java:1579)
>>>>> at java.lang.Thread.run(Thread.java:701)
>>>>>
>>>>> "GC Daemon" daemon prio=10 tid=0x00007f136043d800 nid=0x711e in
>>>>> Object.wait() [0 x00007f1364123000]
>>>>> java.lang.Thread.State: TIMED_WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
>>>>> at sun.misc.GC$Daemon.run(GC.java:117)
>>>>> - locked <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
>>>>>
>>>>> "Low Memory Detector" daemon prio=10 tid=0x00007f13600f5800 nid=0x711b
>>>>> runnable [0x0000000000000000]
>>>>> java.lang.Thread.State: RUNNABLE
>>>>>
>>>>> "C2 CompilerThread1" daemon prio=10 tid=0x00007f13600f3000 nid=0x711a
>>>>> waiting on condition [0x0000000000000000]
>>>>> java.lang.Thread.State: RUNNABLE
>>>>>
>>>>> "C2 CompilerThread0" daemon prio=10 tid=0x00007f13600f0800 nid=0x7119
>>>>> waiting on condition [0x0000000000000000]
>>>>> java.lang.Thread.State: RUNNABLE
>>>>>
>>>>> "Signal Dispatcher" daemon prio=10 tid=0x00007f13600ee800 nid=0x7118
>>>>> waiting on condition [0x0000000000000000]
>>>>> java.lang.Thread.State: RUNNABLE
>>>>>
>>>>> "Finalizer" daemon prio=10 tid=0x00007f136009b800 nid=0x7117 in
>>>>> Object.wait() [0 x00007f1364bd1000]
>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000cdb546f0> (a
>>>>>
>>>> java.lang.ref.ReferenceQueue$
>>
>>> Lock)
>>>>> at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:
>>>>> 133)
>>>>> - locked <0x00000000cdb546f0> (a
>>>>> java.lang.ref.ReferenceQueue$
>>>>> Lock)
>>>>> at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:
>>>>> 149)
>>>>> at
>>>>>
>>>> java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:189)
>>
>>> "Reference Handler" daemon prio=10 tid=0x00007f1360099800 nid=0x7116 in
>>>>> Object.w ait() [0x00007f1364cd2000]
>>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>>> at java.lang.Object.wait(Native Method)
>>>>> - waiting on <0x00000000cdb54480> (a
>>>>>
>>>> java.lang.ref.Reference$Lock)
>>
>>> at java.lang.Object.wait(Object.java:502)
>>>>> at java.lang.ref.Reference$ReferenceHandler.run(
>>>>> Reference.java:133)
>>>>> - locked <0x00000000cdb54480> (a
>>>>> java.lang.ref.Reference$Lock)
>>>>>
>>>>> "main" prio=10 tid=0x00007f1360009000 nid=0x7113 runnable
>>>>> [0x00007f1365fb7000]
>>>>> java.lang.Thread.State: RUNNABLE
>>>>> at java.net.PlainSocketImpl.socketAccept(Native Method)
>>>>> at
>>>>>
>>>> java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:
>>
>>> 375)
>>>>> at java.net.ServerSocket.implAccept(ServerSocket.java:478)
>>>>> at java.net.ServerSocket.accept(ServerSocket.java:446)
>>>>> at
>>>>>
>>>> org.apache.catalina.core.StandardServer.await(StandardServer.java:389
>>
>>> )
>>>>> at
>>>>>
>>>> org.apache.catalina.startup.Catalina.await(Catalina.java:657)
>>
>>> at
>>>>>
>>>> org.apache.catalina.startup.Catalina.start(Catalina.java:617)
>>
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>> at
>>>>>
>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
>>
>>> java:57)
>>>>> at
>>>>>
>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
>>
>>> sorImpl.java:43)
>>>>> at java.lang.reflect.Method.invoke(Method.java:622)
>>>>> at
>>>>>
>>>> org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
>>
>>> at
>>>>>
>>>> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>>
>>> "VM Thread" prio=10 tid=0x00007f136008a800 nid=0x7115 runnable
>>>>>
>>>>> "VM Periodic Task Thread" prio=10 tid=0x00007f1360100800 nid=0x711c
>>>>> waiting on condition
>>>>>
>>>>> JNI global references: 253
>>>>>
>>>>> Heap
>>>>> def new generation total 18432K, used 3571K [0x00000000b9c00000,
>>>>> 0x00000000bb 000000, 0x00000000cdb50000)
>>>>> eden space 16384K, 9% used [0x00000000b9c00000,
>>>>> 0x00000000b9d7cff8,
>>>>> 0x000000 00bac00000)
>>>>> from space 2048K, 100% used [0x00000000bae00000,
>>>>> 0x00000000bb000000,
>>>>> 0x0000000 0bb000000)
>>>>> to space 2048K, 0% used [0x00000000bac00000,
>>>>> 0x00000000bac00000,
>>>>> 0x0000000 0bae00000)
>>>>> tenured generation total 40896K, used 4306K [0x00000000cdb50000,
>>>>> 0x00000000d0 340000, 0x00000000f5a00000)
>>>>> the space 40896K, 10% used [0x00000000cdb50000,
>>>>> 0x00000000cdf849a0,
>>>>> 0x000000 00cdf84a00, 0x00000000d0340000)
>>>>> compacting perm gen total 21248K, used 13892K [0x00000000f5a00000,
>>>>> 0x00000000f 6ec0000, 0x0000000100000000)
>>>>> the space 21248K, 65% used [0x00000000f5a00000,
>>>>> 0x00000000f6791378,
>>>>> 0x000000 00f6791400, 0x00000000f6ec0000)
>>>>> No shared spaces configured.
>>>>>
>>>>>
>>>>>
>>>>> What should be my next step in troubleshooting this issue?
>>>>>
>>>>> mark
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> Mark Maciolek
>>>>> Network Administrator
>>>>> Morse Hall Room 339
>>>>> 603-862-3050
>>>>> https://www.unh.edu/research/support-units/research-computing-center
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>>>
>>>>>
>>>>> --
>>>
>>> Mark Maciolek
>>> Network Administrator
>>> Morse Hall Room 339
>>> 603-862-3050
>>> https://www.unh.edu/research/support-units/research-computing-center
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>
>>>
> --
>
> Mark Maciolek
> Network Administrator
> Morse Hall Room 339
> 603-862-3050
> https://www.unh.edu/research/support-units/research-computing-center
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
Re: Tomcat 6 database connection issue
Posted by Mark Maciolek <ma...@unh.edu>.
On 2/23/2015 2:46 PM, Daniel Mikusa wrote:
> On Feb 23, 2015 12:49 PM, "Mark Maciolek" <ma...@unh.edu> wrote:
>>
>> On 2/23/2015 12:37 PM, Daniel Mikusa wrote:
>>> On Mon, Feb 23, 2015 at 12:25 PM, Mark Maciolek <ma...@unh.edu>
>>> wrote:
>>>
>>>> On 2/23/2015 9:55 AM, Daniel Mikusa wrote:
>>>>
>>>>> On Mon, Feb 23, 2015 at 9:46 AM, Mark Maciolek <ma...@unh.edu>
>>>>> wrote:
>>>>>
>>>>> hi,
>>>>>> operating system:
>>>>>> Scientific Linux release 6.6 (Carbon)
>>>>>>
>>>>>> postgres version
>>>>>> postgresql-server-8.4.2
>>>>>>
>>>>>> tomcat version
>>>>>> tomcat6-6.0.24
>>>>>>
>>>>>> Tomcat starts and I can reach page at the 8080 port on the server
>>>>>> when I add the following xml file and restart tomcat I get this error:
>>>>>>
>>>>>> Feb 23, 2015 9:28:16 AM org.apache.catalina.startup.ContextConfig
>>>>>> processContextConfig
>>>>>> SEVERE: Parse error in context.xml for /cooa
>>>>>> org.xml.sax.SAXParseException; systemId: file:///etc/tomcat6/Catalina/
>>>>>> localhost/cooa.xml;
>>>>>> lineNumber: 21; columnNumber: 12; Error at (21, 12: null
>>>>>>
>>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>>>
>>>>>> <Context>
>>>>>> path="/web/opal/webapps"
>>>>>> docBase="/web/opal/webapps/ROOT"
>>>>>> debug="5"
>>>>>> reloadable="true"
>>>>>> allowLinking="true"
>>>>>>
>>>>>> <Resource>
>>>>>> name="jdbc/postgres"
>>>>>> auth="Container"
>>>>>> type="javax.sql.DataSource"
>>>>>> driverClassName="org.postgresql.Driver"
>>>>>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>>>>>> username="dbuser"
>>>>>> password="*****"
>>>>>> maxActive="20"
>>>>>> maxIdle="10"
>>>>>> maxWait="10000"
>>>>>> </Resource>
>>>>>>
>>>>>> This could be the list or a copy / paste issue, but you should not
> have
>>>>> the
>>>>> ">" on the opening resource tag. It should be after your last
> attribute
>>>>> (i.e. after maxWait. You also don't need the closing Resource tag.
>>>>>
>>>>> Ex:
>>>>>
>>>>> <Context
>>>>> path="/web/opal/webapps"
>>>>> docBase="/web/opal/webapps/ROOT"
>>>>> debug="5"
>>>>> reloadable="true"
>>>>> allowLinking="true">
>>>>> <Resource
>>>>> name="jdbc/postgres"
>>>>> auth="Container"
>>>>> type="javax.sql.DataSource"
>>>>> driverClassName="org.postgresql.Driver"
>>>>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>>>>> username="dbuser"
>>>>> password="*****"
>>>>> maxActive="20"
>>>>> maxIdle="10"
>>>>> maxWait="10000" />
>>>>> </Context>
>>>>>
>>>>> Dan
>>>>>
>>>>> PS: Remove "path", it's not valid here. Remove "debug", I don't think
>>>>> that does anything. Also, you probably want to remove docBase because
>>>>> you're pointing to something in the webapps folder (i.e. appBase), and
> you
>>>>> should only use docBase if your app is outside of the appBase folder.
>>>>>
>>>>>
>>>>>
>>>>>> </Context>
>>>>>>
>>>>>> Line #21 is the </Resource> ran file past xml parse checker and
> reports
>>>>>> everything okay.
>>>>>>
>>>>>> Been googling it for two days now and can not figure out what I have
> done
>>>>>> wrong.
>>>>>>
>>>>>> Mark
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>> Mark Maciolek
>>>>>> Network Administrator
>>>>>> Morse Hall Room 339
>>>>>> 603-862-3050
>>>>>> https://www.unh.edu/research/support-units/research-computing-center
>>>>>>
>>>>>>
>>>>>> ---------------------------------------------------------------------
>>>>>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>>>>
>>>>>>
>>>>>> hi,
>>>> Changing the xml file per your suggestions loads now and my jsp pages
> now
>>>> load as long as they don't need a database connection.
>>>>
>>>> I expect to see new postgres processes similar to this from a working
>>>> server:
>>>>
>>>> postgres 407 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>>>> eosearthdata 127.0.0.1(60176) idle
>>>> postgres 408 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>>>> eosearthdata 127.0.0.1(60177) idle
>>>> postgres 409 7734 0 Feb17 ? 00:01:01 postgres: dbuser
>>>> eosearthdata 127.0.0.1(60178) idle
>>>> postgres 410 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>>>> eosearthdata 127.0.0.1(60179) idle
>>>> postgres 411 7734 0 Feb17 ? 00:01:01 postgres: dbuser
>>>> eosearthdata 127.0.0.1(60180) idle
>>>>
>>>> Starting tomcat does not start the additional postgres processes on my
>>>> server.
>>>> It is trying to though:
>>>>
>>> Do you have Postgres running on the same machine as Tomcat? Looks like
>>> it's waiting trying to make a connection, although it's a little hard to
>>> say because it looks like you're using a custom pool
>>> (edu.unh.sr.cooa.DBPool?).
>>>
>>> Dan
>>>
>> hi,
>>
>> yes, postgres and tomcat are on same server,
> OK. It does seem like its hanging on connection. Have you actually tried
> the connection details outside of Tomcat? Perhaps with a command line tool
> or simple Java app?
>
>> it is a custom pool because when moved to production server it will be
> sharing tomcat and postgres resources with other web sites.
>
> I don't know your circumstances but as an fyi Tomcat can share connection
> pools across multiple apps on one server.
>
>> For testing purposes I would be willing to make it a standard pool.
> If you could, that would be helpful.
>
> Thanks
>
> Dan
hi,
added this line to my context xml and pool connections start
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
had to get older tomcat-jdbc.jar
now on to updating my web pages to use this
mark
>> Mark
>>
>>
>>>> When I kill -3 <tomcat pid>
>>>>
>>>> 2015-02-23 12:16:21
>>>> Full thread dump OpenJDK 64-Bit Server VM (23.25-b01 mixed mode):
>>>>
>>>> "http-8080-7" daemon prio=10 tid=0x00007f133c1b3000 nid=0x7134 in
>>>> Object.wait() [0x00007f1348f39000]
>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000bae00240> (a
> org.apache.tomcat.util.net.AprEndpo
>>>> int$Worker)
>>>> at java.lang.Object.wait(Object.java:502)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>>> 1511)
>>>> - locked <0x00000000bae00240> (a
> org.apache.tomcat.util.net.AprEndpoint$
>>>> Worker)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>>> 36)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "http-8080-6" daemon prio=10 tid=0x00007f135001b800 nid=0x712e in
>>>> Object.wait() [0x00007f134903a000]
>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000bae002d8> (a
> org.apache.tomcat.util.net.AprEndpo
>>>> int$Worker)
>>>> at java.lang.Object.wait(Object.java:502)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>>> 1511)
>>>> - locked <0x00000000bae002d8> (a
> org.apache.tomcat.util.net.AprEndpoint$
>>>> Worker)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>>> 36)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "http-8080-5" daemon prio=10 tid=0x00007f1350017800 nid=0x712d in
>>>> Object.wait() [0x00007f134913b000]
>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000bae00370> (a
> org.apache.tomcat.util.net.AprEndpo
>>>> int$Worker)
>>>> at java.lang.Object.wait(Object.java:502)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>>> 1511)
>>>> - locked <0x00000000bae00370> (a
> org.apache.tomcat.util.net.AprEndpoint$
>>>> Worker)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>>> 36)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "http-8080-4" daemon prio=10 tid=0x00007f1350014000 nid=0x712c in
>>>> Object.wait() [0x00007f134923c000]
>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000bae00408> (a
> org.apache.tomcat.util.net.AprEndpo
>>>> int$Worker)
>>>> at java.lang.Object.wait(Object.java:502)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>>> 1511)
>>>> - locked <0x00000000bae00408> (a
> org.apache.tomcat.util.net.AprEndpoint$
>>>> Worker)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>>> 36)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "http-8080-3" daemon prio=10 tid=0x00007f1350010800 nid=0x712b in
>>>> Object.wait() [0x00007f134933d000]
>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000bae004a0> (a
> org.apache.tomcat.util.net.AprEndpo
>>>> int$Worker)
>>>> at java.lang.Object.wait(Object.java:502)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>>> 1511)
>>>> - locked <0x00000000bae004a0> (a
> org.apache.tomcat.util.net.AprEndpoint$
>>>> Worker)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>>> 36)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "ajp-8009-Acceptor-0" daemon prio=10 tid=0x00007f136075c000 nid=0x7128
>>>> runnable [0x00007f1349a66000]
>>>> java.lang.Thread.State: RUNNABLE
>>>> at org.apache.tomcat.jni.Socket.accept(Native Method)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java:
>>>> 1156)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "ajp-8009-CometPoller-0" daemon prio=10 tid=0x00007f136074e000
> nid=0x7127
>>>> in Obj ect.wait() [0x00007f1349b67000]
>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000bae005b8> (a
> org.apache.tomcat.util.net.AprEndpo
>>>> int$Poller)
>>>> at java.lang.Object.wait(Object.java:502)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>>> 13)
>>>> - locked <0x00000000bae005b8> (a
> org.apache.tomcat.util.net.AprEndpoint$
>>>> Poller)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "ajp-8009-Poller-0" daemon prio=10 tid=0x00007f1360653800 nid=0x7126 in
>>>> Object.w ait() [0x00007f1349c68000]
>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000bae00660> (a
> org.apache.tomcat.util.net.AprEndpo
>>>> int$Poller)
>>>> at java.lang.Object.wait(Object.java:502)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>>> 13)
>>>> - locked <0x00000000bae00660> (a
> org.apache.tomcat.util.net.AprEndpoint$
>>>> Poller)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "http-8080-2" daemon prio=10 tid=0x00007f135000c800 nid=0x7125 waiting
> for
>>>> monit or entry [0x00007f1349d68000]
>>>> java.lang.Thread.State: BLOCKED (on object monitor)
>>>> at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:66)
>>>> - waiting to lock <0x00000000bae00708> (a java.lang.Class for
>>>> edu.unh.sr .cooa.DBPool)
>>>> at
> org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java
>>>> :68)
>>>> at org.apache.jasper.runtime.HttpJspBase.service(
>>>> HttpJspBase.java:70)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>>>> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>>> .java:377)
>>>> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>>>> 13)
>>>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.
>>>> java:260)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>>>> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>>> icationFilterChain.java:290)
>>>> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>>> ilterChain.java:206)
>>>> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
>>>> alve.java:233)
>>>> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
>>>> alve.java:191)
>>>> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
>>>> ava:127)
>>>> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
>>>> ava:102)
>>>> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
>>>> ve.java:109)
>>>> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
>>>> a:298)
>>>> at
> org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
>>>> r.java:865)
>>>> at
> org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
>>>> ocess(Http11AprProtocol.java:579)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>>> 55)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "http-8080-1" daemon prio=10 tid=0x00007f1350008800 nid=0x7124 waiting
> on
>>>> condit ion [0x00007f1349e68000]
>>>> java.lang.Thread.State: TIMED_WAITING (sleeping)
>>>> at java.lang.Thread.sleep(Native Method)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:88)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>>> at edu.unh.sr.cooa.DBPool.<init>(DBPool.java:55)
>>>> at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:67)
>>>> - locked <0x00000000bae00708> (a java.lang.Class for
>>>> edu.unh.sr.cooa.DBP ool)
>>>> at
> org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java
>>>> :68)
>>>> at org.apache.jasper.runtime.HttpJspBase.service(
>>>> HttpJspBase.java:70)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>>>> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>>> .java:377)
>>>> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>>>> 13)
>>>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.
>>>> java:260)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>>>> at org.apache.catalina.core.ApplicationFilterChain.
>>>> internalDoFilter(ApplicationFilterChain.java:290)
>>>>
>>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>>>> ApplicationFilterChain.java:206)
>>>> at org.apache.catalina.core.StandardWrapperValve.invoke(
>>>> StandardWrapperValve.java:233)
>>>>
>>>> at org.apache.catalina.core.StandardContextValve.invoke(
>>>> StandardContextValve.java:191)
>>>> at org.apache.catalina.core.StandardHostValve.invoke(
>>>> StandardHostValve.java:127)
>>>>
>>>> at org.apache.catalina.valves.ErrorReportValve.invoke(
>>>> ErrorReportValve.java:102)
>>>> at org.apache.catalina.core.StandardEngineValve.invoke(
>>>> StandardEngineValve.java:109)
>>>>
>>>> at org.apache.catalina.connector.CoyoteAdapter.service(
>>>> CoyoteAdapter.java:298)
>>>> at org.apache.coyote.http11.Http11AprProcessor.process(
>>>> Http11AprProcessor.java:865)
>>>>
>>>> at org.apache.coyote.http11.Http11AprProtocol$
>>>> Http11ConnectionHandler.process(Http11AprProtocol.java:579)
>>>> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(
>>>> AprEndpoint.java:1555)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "http-8080-Acceptor-0" daemon prio=10 tid=0x00007f1360531800 nid=0x7123
>>>> runnable [0x00007f1349f6b000]
>>>> java.lang.Thread.State: RUNNABLE
>>>> at org.apache.tomcat.jni.Socket.accept(Native Method)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java:
>>>> 1156)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "http-8080-Sendfile-0" daemon prio=10 tid=0x00007f1360530000 nid=0x7122
> in
>>>> Objec t.wait() [0x00007f134a06c000]
>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000bae01410> (a
> org.apache.tomcat.util.net.AprEndpo
>>>> int$Sendfile)
>>>> at java.lang.Object.wait(Object.java:502)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Sendfile.run(AprEndpoint.java:
>>>> 1773)
>>>> - locked <0x00000000bae01410> (a
> org.apache.tomcat.util.net.AprEndpoint$
>>>> Sendfile)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "http-8080-CometPoller-0" daemon prio=10 tid=0x00007f1360524800
> nid=0x7121
>>>> in Object.wait() [0x00007f134a16d000]
>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000bae014b0> (a
> org.apache.tomcat.util.net.AprEndpo
>>>> int$Poller)
>>>> at java.lang.Object.wait(Object.java:502)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>>> 13)
>>>> - locked <0x00000000bae014b0> (a org.apache.tomcat.util.net.
>>>> AprEndpoint$Poller)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "http-8080-Poller-0" daemon prio=10 tid=0x00007f1360544000 nid=0x7120 in
>>>> Object.wait() [0x00007f135c16c000]
>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000bae01558> (a org.apache.tomcat.util.net
> .
>>>> AprEndpoint$Poller)
>>>> at java.lang.Object.wait(Object.java:502)
>>>> at
> org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>>> 13)
>>>> - locked <0x00000000bae01558> (a org.apache.tomcat.util.net.
>>>> AprEndpoint$Poller)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "ContainerBackgroundProcessor[StandardEngine[Catalina]]" daemon prio=10
>>>> tid=0x00 007f136053b800 nid=0x711f waiting on condition
> [0x00007f135c26d000]
>>>> java.lang.Thread.State: TIMED_WAITING (sleeping)
>>>> at java.lang.Thread.sleep(Native Method)
>>>> at org.apache.catalina.core.ContainerBase$
>>>> ContainerBackgroundProcessor.run(ContainerBase.java:1579)
>>>> at java.lang.Thread.run(Thread.java:701)
>>>>
>>>> "GC Daemon" daemon prio=10 tid=0x00007f136043d800 nid=0x711e in
>>>> Object.wait() [0 x00007f1364123000]
>>>> java.lang.Thread.State: TIMED_WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
>>>> at sun.misc.GC$Daemon.run(GC.java:117)
>>>> - locked <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
>>>>
>>>> "Low Memory Detector" daemon prio=10 tid=0x00007f13600f5800 nid=0x711b
>>>> runnable [0x0000000000000000]
>>>> java.lang.Thread.State: RUNNABLE
>>>>
>>>> "C2 CompilerThread1" daemon prio=10 tid=0x00007f13600f3000 nid=0x711a
>>>> waiting on condition [0x0000000000000000]
>>>> java.lang.Thread.State: RUNNABLE
>>>>
>>>> "C2 CompilerThread0" daemon prio=10 tid=0x00007f13600f0800 nid=0x7119
>>>> waiting on condition [0x0000000000000000]
>>>> java.lang.Thread.State: RUNNABLE
>>>>
>>>> "Signal Dispatcher" daemon prio=10 tid=0x00007f13600ee800 nid=0x7118
>>>> waiting on condition [0x0000000000000000]
>>>> java.lang.Thread.State: RUNNABLE
>>>>
>>>> "Finalizer" daemon prio=10 tid=0x00007f136009b800 nid=0x7117 in
>>>> Object.wait() [0 x00007f1364bd1000]
>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000cdb546f0> (a
> java.lang.ref.ReferenceQueue$
>>>> Lock)
>>>> at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:133)
>>>> - locked <0x00000000cdb546f0> (a java.lang.ref.ReferenceQueue$
>>>> Lock)
>>>> at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:149)
>>>> at
> java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:189)
>>>> "Reference Handler" daemon prio=10 tid=0x00007f1360099800 nid=0x7116 in
>>>> Object.w ait() [0x00007f1364cd2000]
>>>> java.lang.Thread.State: WAITING (on object monitor)
>>>> at java.lang.Object.wait(Native Method)
>>>> - waiting on <0x00000000cdb54480> (a
> java.lang.ref.Reference$Lock)
>>>> at java.lang.Object.wait(Object.java:502)
>>>> at java.lang.ref.Reference$ReferenceHandler.run(
>>>> Reference.java:133)
>>>> - locked <0x00000000cdb54480> (a java.lang.ref.Reference$Lock)
>>>>
>>>> "main" prio=10 tid=0x00007f1360009000 nid=0x7113 runnable
>>>> [0x00007f1365fb7000]
>>>> java.lang.Thread.State: RUNNABLE
>>>> at java.net.PlainSocketImpl.socketAccept(Native Method)
>>>> at
> java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:
>>>> 375)
>>>> at java.net.ServerSocket.implAccept(ServerSocket.java:478)
>>>> at java.net.ServerSocket.accept(ServerSocket.java:446)
>>>> at
> org.apache.catalina.core.StandardServer.await(StandardServer.java:389
>>>> )
>>>> at
> org.apache.catalina.startup.Catalina.await(Catalina.java:657)
>>>> at
> org.apache.catalina.startup.Catalina.start(Catalina.java:617)
>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
>>>> java:57)
>>>> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
>>>> sorImpl.java:43)
>>>> at java.lang.reflect.Method.invoke(Method.java:622)
>>>> at
> org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
>>>> at
> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>>>> "VM Thread" prio=10 tid=0x00007f136008a800 nid=0x7115 runnable
>>>>
>>>> "VM Periodic Task Thread" prio=10 tid=0x00007f1360100800 nid=0x711c
>>>> waiting on condition
>>>>
>>>> JNI global references: 253
>>>>
>>>> Heap
>>>> def new generation total 18432K, used 3571K [0x00000000b9c00000,
>>>> 0x00000000bb 000000, 0x00000000cdb50000)
>>>> eden space 16384K, 9% used [0x00000000b9c00000, 0x00000000b9d7cff8,
>>>> 0x000000 00bac00000)
>>>> from space 2048K, 100% used [0x00000000bae00000, 0x00000000bb000000,
>>>> 0x0000000 0bb000000)
>>>> to space 2048K, 0% used [0x00000000bac00000, 0x00000000bac00000,
>>>> 0x0000000 0bae00000)
>>>> tenured generation total 40896K, used 4306K [0x00000000cdb50000,
>>>> 0x00000000d0 340000, 0x00000000f5a00000)
>>>> the space 40896K, 10% used [0x00000000cdb50000, 0x00000000cdf849a0,
>>>> 0x000000 00cdf84a00, 0x00000000d0340000)
>>>> compacting perm gen total 21248K, used 13892K [0x00000000f5a00000,
>>>> 0x00000000f 6ec0000, 0x0000000100000000)
>>>> the space 21248K, 65% used [0x00000000f5a00000, 0x00000000f6791378,
>>>> 0x000000 00f6791400, 0x00000000f6ec0000)
>>>> No shared spaces configured.
>>>>
>>>>
>>>>
>>>> What should be my next step in troubleshooting this issue?
>>>>
>>>> mark
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Mark Maciolek
>>>> Network Administrator
>>>> Morse Hall Room 339
>>>> 603-862-3050
>>>> https://www.unh.edu/research/support-units/research-computing-center
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>>
>>>>
>> --
>>
>> Mark Maciolek
>> Network Administrator
>> Morse Hall Room 339
>> 603-862-3050
>> https://www.unh.edu/research/support-units/research-computing-center
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
--
Mark Maciolek
Network Administrator
Morse Hall Room 339
603-862-3050
https://www.unh.edu/research/support-units/research-computing-center
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 6 database connection issue
Posted by Daniel Mikusa <dm...@pivotal.io>.
On Feb 23, 2015 12:49 PM, "Mark Maciolek" <ma...@unh.edu> wrote:
>
>
> On 2/23/2015 12:37 PM, Daniel Mikusa wrote:
>>
>> On Mon, Feb 23, 2015 at 12:25 PM, Mark Maciolek <ma...@unh.edu>
>> wrote:
>>
>>> On 2/23/2015 9:55 AM, Daniel Mikusa wrote:
>>>
>>>> On Mon, Feb 23, 2015 at 9:46 AM, Mark Maciolek <ma...@unh.edu>
>>>> wrote:
>>>>
>>>> hi,
>>>>>
>>>>> operating system:
>>>>> Scientific Linux release 6.6 (Carbon)
>>>>>
>>>>> postgres version
>>>>> postgresql-server-8.4.2
>>>>>
>>>>> tomcat version
>>>>> tomcat6-6.0.24
>>>>>
>>>>> Tomcat starts and I can reach page at the 8080 port on the server
>>>>> when I add the following xml file and restart tomcat I get this error:
>>>>>
>>>>> Feb 23, 2015 9:28:16 AM org.apache.catalina.startup.ContextConfig
>>>>> processContextConfig
>>>>> SEVERE: Parse error in context.xml for /cooa
>>>>> org.xml.sax.SAXParseException; systemId: file:///etc/tomcat6/Catalina/
>>>>> localhost/cooa.xml;
>>>>> lineNumber: 21; columnNumber: 12; Error at (21, 12: null
>>>>>
>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>>
>>>>> <Context>
>>>>> path="/web/opal/webapps"
>>>>> docBase="/web/opal/webapps/ROOT"
>>>>> debug="5"
>>>>> reloadable="true"
>>>>> allowLinking="true"
>>>>>
>>>>> <Resource>
>>>>> name="jdbc/postgres"
>>>>> auth="Container"
>>>>> type="javax.sql.DataSource"
>>>>> driverClassName="org.postgresql.Driver"
>>>>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>>>>> username="dbuser"
>>>>> password="*****"
>>>>> maxActive="20"
>>>>> maxIdle="10"
>>>>> maxWait="10000"
>>>>> </Resource>
>>>>>
>>>>> This could be the list or a copy / paste issue, but you should not
have
>>>>
>>>> the
>>>> ">" on the opening resource tag. It should be after your last
attribute
>>>> (i.e. after maxWait. You also don't need the closing Resource tag.
>>>>
>>>> Ex:
>>>>
>>>> <Context
>>>> path="/web/opal/webapps"
>>>> docBase="/web/opal/webapps/ROOT"
>>>> debug="5"
>>>> reloadable="true"
>>>> allowLinking="true">
>>>> <Resource
>>>> name="jdbc/postgres"
>>>> auth="Container"
>>>> type="javax.sql.DataSource"
>>>> driverClassName="org.postgresql.Driver"
>>>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>>>> username="dbuser"
>>>> password="*****"
>>>> maxActive="20"
>>>> maxIdle="10"
>>>> maxWait="10000" />
>>>> </Context>
>>>>
>>>> Dan
>>>>
>>>> PS: Remove "path", it's not valid here. Remove "debug", I don't think
>>>> that does anything. Also, you probably want to remove docBase because
>>>> you're pointing to something in the webapps folder (i.e. appBase), and
you
>>>> should only use docBase if your app is outside of the appBase folder.
>>>>
>>>>
>>>>
>>>>> </Context>
>>>>>
>>>>> Line #21 is the </Resource> ran file past xml parse checker and
reports
>>>>> everything okay.
>>>>>
>>>>> Been googling it for two days now and can not figure out what I have
done
>>>>> wrong.
>>>>>
>>>>> Mark
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> Mark Maciolek
>>>>> Network Administrator
>>>>> Morse Hall Room 339
>>>>> 603-862-3050
>>>>> https://www.unh.edu/research/support-units/research-computing-center
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>>>
>>>>>
>>>>> hi,
>>>
>>> Changing the xml file per your suggestions loads now and my jsp pages
now
>>> load as long as they don't need a database connection.
>>>
>>> I expect to see new postgres processes similar to this from a working
>>> server:
>>>
>>> postgres 407 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>>> eosearthdata 127.0.0.1(60176) idle
>>> postgres 408 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>>> eosearthdata 127.0.0.1(60177) idle
>>> postgres 409 7734 0 Feb17 ? 00:01:01 postgres: dbuser
>>> eosearthdata 127.0.0.1(60178) idle
>>> postgres 410 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>>> eosearthdata 127.0.0.1(60179) idle
>>> postgres 411 7734 0 Feb17 ? 00:01:01 postgres: dbuser
>>> eosearthdata 127.0.0.1(60180) idle
>>>
>>> Starting tomcat does not start the additional postgres processes on my
>>> server.
>>> It is trying to though:
>>>
>> Do you have Postgres running on the same machine as Tomcat? Looks like
>> it's waiting trying to make a connection, although it's a little hard to
>> say because it looks like you're using a custom pool
>> (edu.unh.sr.cooa.DBPool?).
>>
>> Dan
>>
> hi,
>
> yes, postgres and tomcat are on same server,
OK. It does seem like its hanging on connection. Have you actually tried
the connection details outside of Tomcat? Perhaps with a command line tool
or simple Java app?
> it is a custom pool because when moved to production server it will be
sharing tomcat and postgres resources with other web sites.
I don't know your circumstances but as an fyi Tomcat can share connection
pools across multiple apps on one server.
>
> For testing purposes I would be willing to make it a standard pool.
If you could, that would be helpful.
Thanks
Dan
>
> Mark
>
>
>>>
>>> When I kill -3 <tomcat pid>
>>>
>>> 2015-02-23 12:16:21
>>> Full thread dump OpenJDK 64-Bit Server VM (23.25-b01 mixed mode):
>>>
>>> "http-8080-7" daemon prio=10 tid=0x00007f133c1b3000 nid=0x7134 in
>>> Object.wait() [0x00007f1348f39000]
>>> java.lang.Thread.State: WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000bae00240> (a
org.apache.tomcat.util.net.AprEndpo
>>> int$Worker)
>>> at java.lang.Object.wait(Object.java:502)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>> 1511)
>>> - locked <0x00000000bae00240> (a
org.apache.tomcat.util.net.AprEndpoint$
>>> Worker)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>> 36)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "http-8080-6" daemon prio=10 tid=0x00007f135001b800 nid=0x712e in
>>> Object.wait() [0x00007f134903a000]
>>> java.lang.Thread.State: WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000bae002d8> (a
org.apache.tomcat.util.net.AprEndpo
>>> int$Worker)
>>> at java.lang.Object.wait(Object.java:502)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>> 1511)
>>> - locked <0x00000000bae002d8> (a
org.apache.tomcat.util.net.AprEndpoint$
>>> Worker)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>> 36)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "http-8080-5" daemon prio=10 tid=0x00007f1350017800 nid=0x712d in
>>> Object.wait() [0x00007f134913b000]
>>> java.lang.Thread.State: WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000bae00370> (a
org.apache.tomcat.util.net.AprEndpo
>>> int$Worker)
>>> at java.lang.Object.wait(Object.java:502)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>> 1511)
>>> - locked <0x00000000bae00370> (a
org.apache.tomcat.util.net.AprEndpoint$
>>> Worker)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>> 36)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "http-8080-4" daemon prio=10 tid=0x00007f1350014000 nid=0x712c in
>>> Object.wait() [0x00007f134923c000]
>>> java.lang.Thread.State: WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000bae00408> (a
org.apache.tomcat.util.net.AprEndpo
>>> int$Worker)
>>> at java.lang.Object.wait(Object.java:502)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>> 1511)
>>> - locked <0x00000000bae00408> (a
org.apache.tomcat.util.net.AprEndpoint$
>>> Worker)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>> 36)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "http-8080-3" daemon prio=10 tid=0x00007f1350010800 nid=0x712b in
>>> Object.wait() [0x00007f134933d000]
>>> java.lang.Thread.State: WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000bae004a0> (a
org.apache.tomcat.util.net.AprEndpo
>>> int$Worker)
>>> at java.lang.Object.wait(Object.java:502)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>>> 1511)
>>> - locked <0x00000000bae004a0> (a
org.apache.tomcat.util.net.AprEndpoint$
>>> Worker)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>> 36)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "ajp-8009-Acceptor-0" daemon prio=10 tid=0x00007f136075c000 nid=0x7128
>>> runnable [0x00007f1349a66000]
>>> java.lang.Thread.State: RUNNABLE
>>> at org.apache.tomcat.jni.Socket.accept(Native Method)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java:
>>> 1156)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "ajp-8009-CometPoller-0" daemon prio=10 tid=0x00007f136074e000
nid=0x7127
>>> in Obj ect.wait() [0x00007f1349b67000]
>>> java.lang.Thread.State: WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000bae005b8> (a
org.apache.tomcat.util.net.AprEndpo
>>> int$Poller)
>>> at java.lang.Object.wait(Object.java:502)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>> 13)
>>> - locked <0x00000000bae005b8> (a
org.apache.tomcat.util.net.AprEndpoint$
>>> Poller)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "ajp-8009-Poller-0" daemon prio=10 tid=0x00007f1360653800 nid=0x7126 in
>>> Object.w ait() [0x00007f1349c68000]
>>> java.lang.Thread.State: WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000bae00660> (a
org.apache.tomcat.util.net.AprEndpo
>>> int$Poller)
>>> at java.lang.Object.wait(Object.java:502)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>> 13)
>>> - locked <0x00000000bae00660> (a
org.apache.tomcat.util.net.AprEndpoint$
>>> Poller)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "http-8080-2" daemon prio=10 tid=0x00007f135000c800 nid=0x7125 waiting
for
>>> monit or entry [0x00007f1349d68000]
>>> java.lang.Thread.State: BLOCKED (on object monitor)
>>> at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:66)
>>> - waiting to lock <0x00000000bae00708> (a java.lang.Class for
>>> edu.unh.sr .cooa.DBPool)
>>> at
org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java
>>> :68)
>>> at org.apache.jasper.runtime.HttpJspBase.service(
>>> HttpJspBase.java:70)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>>> at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>> .java:377)
>>> at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>>> 13)
>>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.
>>> java:260)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>>> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>> icationFilterChain.java:290)
>>> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>> ilterChain.java:206)
>>> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
>>> alve.java:233)
>>> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
>>> alve.java:191)
>>> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
>>> ava:127)
>>> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
>>> ava:102)
>>> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
>>> ve.java:109)
>>> at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
>>> a:298)
>>> at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
>>> r.java:865)
>>> at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
>>> ocess(Http11AprProtocol.java:579)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>>> 55)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "http-8080-1" daemon prio=10 tid=0x00007f1350008800 nid=0x7124 waiting
on
>>> condit ion [0x00007f1349e68000]
>>> java.lang.Thread.State: TIMED_WAITING (sleeping)
>>> at java.lang.Thread.sleep(Native Method)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:88)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>>> at edu.unh.sr.cooa.DBPool.<init>(DBPool.java:55)
>>> at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:67)
>>> - locked <0x00000000bae00708> (a java.lang.Class for
>>> edu.unh.sr.cooa.DBP ool)
>>> at
org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java
>>> :68)
>>> at org.apache.jasper.runtime.HttpJspBase.service(
>>> HttpJspBase.java:70)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>>> at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>> .java:377)
>>> at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>>> 13)
>>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.
>>> java:260)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>>> at org.apache.catalina.core.ApplicationFilterChain.
>>> internalDoFilter(ApplicationFilterChain.java:290)
>>>
>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>>> ApplicationFilterChain.java:206)
>>> at org.apache.catalina.core.StandardWrapperValve.invoke(
>>> StandardWrapperValve.java:233)
>>>
>>> at org.apache.catalina.core.StandardContextValve.invoke(
>>> StandardContextValve.java:191)
>>> at org.apache.catalina.core.StandardHostValve.invoke(
>>> StandardHostValve.java:127)
>>>
>>> at org.apache.catalina.valves.ErrorReportValve.invoke(
>>> ErrorReportValve.java:102)
>>> at org.apache.catalina.core.StandardEngineValve.invoke(
>>> StandardEngineValve.java:109)
>>>
>>> at org.apache.catalina.connector.CoyoteAdapter.service(
>>> CoyoteAdapter.java:298)
>>> at org.apache.coyote.http11.Http11AprProcessor.process(
>>> Http11AprProcessor.java:865)
>>>
>>> at org.apache.coyote.http11.Http11AprProtocol$
>>> Http11ConnectionHandler.process(Http11AprProtocol.java:579)
>>> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(
>>> AprEndpoint.java:1555)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "http-8080-Acceptor-0" daemon prio=10 tid=0x00007f1360531800 nid=0x7123
>>> runnable [0x00007f1349f6b000]
>>> java.lang.Thread.State: RUNNABLE
>>> at org.apache.tomcat.jni.Socket.accept(Native Method)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java:
>>> 1156)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "http-8080-Sendfile-0" daemon prio=10 tid=0x00007f1360530000 nid=0x7122
in
>>> Objec t.wait() [0x00007f134a06c000]
>>> java.lang.Thread.State: WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000bae01410> (a
org.apache.tomcat.util.net.AprEndpo
>>> int$Sendfile)
>>> at java.lang.Object.wait(Object.java:502)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Sendfile.run(AprEndpoint.java:
>>> 1773)
>>> - locked <0x00000000bae01410> (a
org.apache.tomcat.util.net.AprEndpoint$
>>> Sendfile)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "http-8080-CometPoller-0" daemon prio=10 tid=0x00007f1360524800
nid=0x7121
>>> in Object.wait() [0x00007f134a16d000]
>>> java.lang.Thread.State: WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000bae014b0> (a
org.apache.tomcat.util.net.AprEndpo
>>> int$Poller)
>>> at java.lang.Object.wait(Object.java:502)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>> 13)
>>> - locked <0x00000000bae014b0> (a org.apache.tomcat.util.net.
>>> AprEndpoint$Poller)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "http-8080-Poller-0" daemon prio=10 tid=0x00007f1360544000 nid=0x7120 in
>>> Object.wait() [0x00007f135c16c000]
>>> java.lang.Thread.State: WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000bae01558> (a org.apache.tomcat.util.net
.
>>> AprEndpoint$Poller)
>>> at java.lang.Object.wait(Object.java:502)
>>> at
org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>>> 13)
>>> - locked <0x00000000bae01558> (a org.apache.tomcat.util.net.
>>> AprEndpoint$Poller)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "ContainerBackgroundProcessor[StandardEngine[Catalina]]" daemon prio=10
>>> tid=0x00 007f136053b800 nid=0x711f waiting on condition
[0x00007f135c26d000]
>>> java.lang.Thread.State: TIMED_WAITING (sleeping)
>>> at java.lang.Thread.sleep(Native Method)
>>> at org.apache.catalina.core.ContainerBase$
>>> ContainerBackgroundProcessor.run(ContainerBase.java:1579)
>>> at java.lang.Thread.run(Thread.java:701)
>>>
>>> "GC Daemon" daemon prio=10 tid=0x00007f136043d800 nid=0x711e in
>>> Object.wait() [0 x00007f1364123000]
>>> java.lang.Thread.State: TIMED_WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
>>> at sun.misc.GC$Daemon.run(GC.java:117)
>>> - locked <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
>>>
>>> "Low Memory Detector" daemon prio=10 tid=0x00007f13600f5800 nid=0x711b
>>> runnable [0x0000000000000000]
>>> java.lang.Thread.State: RUNNABLE
>>>
>>> "C2 CompilerThread1" daemon prio=10 tid=0x00007f13600f3000 nid=0x711a
>>> waiting on condition [0x0000000000000000]
>>> java.lang.Thread.State: RUNNABLE
>>>
>>> "C2 CompilerThread0" daemon prio=10 tid=0x00007f13600f0800 nid=0x7119
>>> waiting on condition [0x0000000000000000]
>>> java.lang.Thread.State: RUNNABLE
>>>
>>> "Signal Dispatcher" daemon prio=10 tid=0x00007f13600ee800 nid=0x7118
>>> waiting on condition [0x0000000000000000]
>>> java.lang.Thread.State: RUNNABLE
>>>
>>> "Finalizer" daemon prio=10 tid=0x00007f136009b800 nid=0x7117 in
>>> Object.wait() [0 x00007f1364bd1000]
>>> java.lang.Thread.State: WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000cdb546f0> (a
java.lang.ref.ReferenceQueue$
>>> Lock)
>>> at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:133)
>>> - locked <0x00000000cdb546f0> (a java.lang.ref.ReferenceQueue$
>>> Lock)
>>> at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:149)
>>> at
java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:189)
>>>
>>> "Reference Handler" daemon prio=10 tid=0x00007f1360099800 nid=0x7116 in
>>> Object.w ait() [0x00007f1364cd2000]
>>> java.lang.Thread.State: WAITING (on object monitor)
>>> at java.lang.Object.wait(Native Method)
>>> - waiting on <0x00000000cdb54480> (a
java.lang.ref.Reference$Lock)
>>> at java.lang.Object.wait(Object.java:502)
>>> at java.lang.ref.Reference$ReferenceHandler.run(
>>> Reference.java:133)
>>> - locked <0x00000000cdb54480> (a java.lang.ref.Reference$Lock)
>>>
>>> "main" prio=10 tid=0x00007f1360009000 nid=0x7113 runnable
>>> [0x00007f1365fb7000]
>>> java.lang.Thread.State: RUNNABLE
>>> at java.net.PlainSocketImpl.socketAccept(Native Method)
>>> at
java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:
>>> 375)
>>> at java.net.ServerSocket.implAccept(ServerSocket.java:478)
>>> at java.net.ServerSocket.accept(ServerSocket.java:446)
>>> at
org.apache.catalina.core.StandardServer.await(StandardServer.java:389
>>> )
>>> at
org.apache.catalina.startup.Catalina.await(Catalina.java:657)
>>> at
org.apache.catalina.startup.Catalina.start(Catalina.java:617)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
>>> java:57)
>>> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
>>> sorImpl.java:43)
>>> at java.lang.reflect.Method.invoke(Method.java:622)
>>> at
org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
>>> at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>>>
>>> "VM Thread" prio=10 tid=0x00007f136008a800 nid=0x7115 runnable
>>>
>>> "VM Periodic Task Thread" prio=10 tid=0x00007f1360100800 nid=0x711c
>>> waiting on condition
>>>
>>> JNI global references: 253
>>>
>>> Heap
>>> def new generation total 18432K, used 3571K [0x00000000b9c00000,
>>> 0x00000000bb 000000, 0x00000000cdb50000)
>>> eden space 16384K, 9% used [0x00000000b9c00000, 0x00000000b9d7cff8,
>>> 0x000000 00bac00000)
>>> from space 2048K, 100% used [0x00000000bae00000, 0x00000000bb000000,
>>> 0x0000000 0bb000000)
>>> to space 2048K, 0% used [0x00000000bac00000, 0x00000000bac00000,
>>> 0x0000000 0bae00000)
>>> tenured generation total 40896K, used 4306K [0x00000000cdb50000,
>>> 0x00000000d0 340000, 0x00000000f5a00000)
>>> the space 40896K, 10% used [0x00000000cdb50000, 0x00000000cdf849a0,
>>> 0x000000 00cdf84a00, 0x00000000d0340000)
>>> compacting perm gen total 21248K, used 13892K [0x00000000f5a00000,
>>> 0x00000000f 6ec0000, 0x0000000100000000)
>>> the space 21248K, 65% used [0x00000000f5a00000, 0x00000000f6791378,
>>> 0x000000 00f6791400, 0x00000000f6ec0000)
>>> No shared spaces configured.
>>>
>>>
>>>
>>> What should be my next step in troubleshooting this issue?
>>>
>>> mark
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Mark Maciolek
>>> Network Administrator
>>> Morse Hall Room 339
>>> 603-862-3050
>>> https://www.unh.edu/research/support-units/research-computing-center
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>
>>>
>
> --
>
> Mark Maciolek
> Network Administrator
> Morse Hall Room 339
> 603-862-3050
> https://www.unh.edu/research/support-units/research-computing-center
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
Re: Tomcat 6 database connection issue
Posted by Mark Maciolek <ma...@unh.edu>.
On 2/23/2015 12:37 PM, Daniel Mikusa wrote:
> On Mon, Feb 23, 2015 at 12:25 PM, Mark Maciolek <ma...@unh.edu>
> wrote:
>
>> On 2/23/2015 9:55 AM, Daniel Mikusa wrote:
>>
>>> On Mon, Feb 23, 2015 at 9:46 AM, Mark Maciolek <ma...@unh.edu>
>>> wrote:
>>>
>>> hi,
>>>> operating system:
>>>> Scientific Linux release 6.6 (Carbon)
>>>>
>>>> postgres version
>>>> postgresql-server-8.4.2
>>>>
>>>> tomcat version
>>>> tomcat6-6.0.24
>>>>
>>>> Tomcat starts and I can reach page at the 8080 port on the server
>>>> when I add the following xml file and restart tomcat I get this error:
>>>>
>>>> Feb 23, 2015 9:28:16 AM org.apache.catalina.startup.ContextConfig
>>>> processContextConfig
>>>> SEVERE: Parse error in context.xml for /cooa
>>>> org.xml.sax.SAXParseException; systemId: file:///etc/tomcat6/Catalina/
>>>> localhost/cooa.xml;
>>>> lineNumber: 21; columnNumber: 12; Error at (21, 12: null
>>>>
>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>
>>>> <Context>
>>>> path="/web/opal/webapps"
>>>> docBase="/web/opal/webapps/ROOT"
>>>> debug="5"
>>>> reloadable="true"
>>>> allowLinking="true"
>>>>
>>>> <Resource>
>>>> name="jdbc/postgres"
>>>> auth="Container"
>>>> type="javax.sql.DataSource"
>>>> driverClassName="org.postgresql.Driver"
>>>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>>>> username="dbuser"
>>>> password="*****"
>>>> maxActive="20"
>>>> maxIdle="10"
>>>> maxWait="10000"
>>>> </Resource>
>>>>
>>>> This could be the list or a copy / paste issue, but you should not have
>>> the
>>> ">" on the opening resource tag. It should be after your last attribute
>>> (i.e. after maxWait. You also don't need the closing Resource tag.
>>>
>>> Ex:
>>>
>>> <Context
>>> path="/web/opal/webapps"
>>> docBase="/web/opal/webapps/ROOT"
>>> debug="5"
>>> reloadable="true"
>>> allowLinking="true">
>>> <Resource
>>> name="jdbc/postgres"
>>> auth="Container"
>>> type="javax.sql.DataSource"
>>> driverClassName="org.postgresql.Driver"
>>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>>> username="dbuser"
>>> password="*****"
>>> maxActive="20"
>>> maxIdle="10"
>>> maxWait="10000" />
>>> </Context>
>>>
>>> Dan
>>>
>>> PS: Remove "path", it's not valid here. Remove "debug", I don't think
>>> that does anything. Also, you probably want to remove docBase because
>>> you're pointing to something in the webapps folder (i.e. appBase), and you
>>> should only use docBase if your app is outside of the appBase folder.
>>>
>>>
>>>
>>>> </Context>
>>>>
>>>> Line #21 is the </Resource> ran file past xml parse checker and reports
>>>> everything okay.
>>>>
>>>> Been googling it for two days now and can not figure out what I have done
>>>> wrong.
>>>>
>>>> Mark
>>>>
>>>>
>>>> --
>>>>
>>>> Mark Maciolek
>>>> Network Administrator
>>>> Morse Hall Room 339
>>>> 603-862-3050
>>>> https://www.unh.edu/research/support-units/research-computing-center
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>>
>>>>
>>>> hi,
>> Changing the xml file per your suggestions loads now and my jsp pages now
>> load as long as they don't need a database connection.
>>
>> I expect to see new postgres processes similar to this from a working
>> server:
>>
>> postgres 407 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>> eosearthdata 127.0.0.1(60176) idle
>> postgres 408 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>> eosearthdata 127.0.0.1(60177) idle
>> postgres 409 7734 0 Feb17 ? 00:01:01 postgres: dbuser
>> eosearthdata 127.0.0.1(60178) idle
>> postgres 410 7734 0 Feb17 ? 00:01:00 postgres: dbuser
>> eosearthdata 127.0.0.1(60179) idle
>> postgres 411 7734 0 Feb17 ? 00:01:01 postgres: dbuser
>> eosearthdata 127.0.0.1(60180) idle
>>
>> Starting tomcat does not start the additional postgres processes on my
>> server.
>> It is trying to though:
>>
> Do you have Postgres running on the same machine as Tomcat? Looks like
> it's waiting trying to make a connection, although it's a little hard to
> say because it looks like you're using a custom pool
> (edu.unh.sr.cooa.DBPool?).
>
> Dan
>
hi,
yes, postgres and tomcat are on same server, it is a custom pool because
when moved to production server it will be sharing tomcat and postgres
resources with other web sites.
For testing purposes I would be willing to make it a standard pool.
Mark
>>
>> When I kill -3 <tomcat pid>
>>
>> 2015-02-23 12:16:21
>> Full thread dump OpenJDK 64-Bit Server VM (23.25-b01 mixed mode):
>>
>> "http-8080-7" daemon prio=10 tid=0x00007f133c1b3000 nid=0x7134 in
>> Object.wait() [0x00007f1348f39000]
>> java.lang.Thread.State: WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000bae00240> (a org.apache.tomcat.util.net.AprEndpo
>> int$Worker)
>> at java.lang.Object.wait(Object.java:502)
>> at org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>> 1511)
>> - locked <0x00000000bae00240> (a org.apache.tomcat.util.net.AprEndpoint$
>> Worker)
>> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>> 36)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "http-8080-6" daemon prio=10 tid=0x00007f135001b800 nid=0x712e in
>> Object.wait() [0x00007f134903a000]
>> java.lang.Thread.State: WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000bae002d8> (a org.apache.tomcat.util.net.AprEndpo
>> int$Worker)
>> at java.lang.Object.wait(Object.java:502)
>> at org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>> 1511)
>> - locked <0x00000000bae002d8> (a org.apache.tomcat.util.net.AprEndpoint$
>> Worker)
>> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>> 36)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "http-8080-5" daemon prio=10 tid=0x00007f1350017800 nid=0x712d in
>> Object.wait() [0x00007f134913b000]
>> java.lang.Thread.State: WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000bae00370> (a org.apache.tomcat.util.net.AprEndpo
>> int$Worker)
>> at java.lang.Object.wait(Object.java:502)
>> at org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>> 1511)
>> - locked <0x00000000bae00370> (a org.apache.tomcat.util.net.AprEndpoint$
>> Worker)
>> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>> 36)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "http-8080-4" daemon prio=10 tid=0x00007f1350014000 nid=0x712c in
>> Object.wait() [0x00007f134923c000]
>> java.lang.Thread.State: WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000bae00408> (a org.apache.tomcat.util.net.AprEndpo
>> int$Worker)
>> at java.lang.Object.wait(Object.java:502)
>> at org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>> 1511)
>> - locked <0x00000000bae00408> (a org.apache.tomcat.util.net.AprEndpoint$
>> Worker)
>> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>> 36)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "http-8080-3" daemon prio=10 tid=0x00007f1350010800 nid=0x712b in
>> Object.wait() [0x00007f134933d000]
>> java.lang.Thread.State: WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000bae004a0> (a org.apache.tomcat.util.net.AprEndpo
>> int$Worker)
>> at java.lang.Object.wait(Object.java:502)
>> at org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
>> 1511)
>> - locked <0x00000000bae004a0> (a org.apache.tomcat.util.net.AprEndpoint$
>> Worker)
>> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>> 36)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "ajp-8009-Acceptor-0" daemon prio=10 tid=0x00007f136075c000 nid=0x7128
>> runnable [0x00007f1349a66000]
>> java.lang.Thread.State: RUNNABLE
>> at org.apache.tomcat.jni.Socket.accept(Native Method)
>> at org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java:
>> 1156)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "ajp-8009-CometPoller-0" daemon prio=10 tid=0x00007f136074e000 nid=0x7127
>> in Obj ect.wait() [0x00007f1349b67000]
>> java.lang.Thread.State: WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000bae005b8> (a org.apache.tomcat.util.net.AprEndpo
>> int$Poller)
>> at java.lang.Object.wait(Object.java:502)
>> at org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>> 13)
>> - locked <0x00000000bae005b8> (a org.apache.tomcat.util.net.AprEndpoint$
>> Poller)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "ajp-8009-Poller-0" daemon prio=10 tid=0x00007f1360653800 nid=0x7126 in
>> Object.w ait() [0x00007f1349c68000]
>> java.lang.Thread.State: WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000bae00660> (a org.apache.tomcat.util.net.AprEndpo
>> int$Poller)
>> at java.lang.Object.wait(Object.java:502)
>> at org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>> 13)
>> - locked <0x00000000bae00660> (a org.apache.tomcat.util.net.AprEndpoint$
>> Poller)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "http-8080-2" daemon prio=10 tid=0x00007f135000c800 nid=0x7125 waiting for
>> monit or entry [0x00007f1349d68000]
>> java.lang.Thread.State: BLOCKED (on object monitor)
>> at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:66)
>> - waiting to lock <0x00000000bae00708> (a java.lang.Class for
>> edu.unh.sr .cooa.DBPool)
>> at org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java
>> :68)
>> at org.apache.jasper.runtime.HttpJspBase.service(
>> HttpJspBase.java:70)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>> .java:377)
>> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>> 13)
>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.
>> java:260)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>> icationFilterChain.java:290)
>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>> ilterChain.java:206)
>> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
>> alve.java:233)
>> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
>> alve.java:191)
>> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
>> ava:127)
>> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
>> ava:102)
>> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
>> ve.java:109)
>> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
>> a:298)
>> at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
>> r.java:865)
>> at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
>> ocess(Http11AprProtocol.java:579)
>> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
>> 55)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "http-8080-1" daemon prio=10 tid=0x00007f1350008800 nid=0x7124 waiting on
>> condit ion [0x00007f1349e68000]
>> java.lang.Thread.State: TIMED_WAITING (sleeping)
>> at java.lang.Thread.sleep(Native Method)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:88)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
>> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
>> at edu.unh.sr.cooa.DBPool.<init>(DBPool.java:55)
>> at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:67)
>> - locked <0x00000000bae00708> (a java.lang.Class for
>> edu.unh.sr.cooa.DBP ool)
>> at org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java
>> :68)
>> at org.apache.jasper.runtime.HttpJspBase.service(
>> HttpJspBase.java:70)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>> .java:377)
>> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
>> 13)
>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.
>> java:260)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>> at org.apache.catalina.core.ApplicationFilterChain.
>> internalDoFilter(ApplicationFilterChain.java:290)
>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>> ApplicationFilterChain.java:206)
>> at org.apache.catalina.core.StandardWrapperValve.invoke(
>> StandardWrapperValve.java:233)
>> at org.apache.catalina.core.StandardContextValve.invoke(
>> StandardContextValve.java:191)
>> at org.apache.catalina.core.StandardHostValve.invoke(
>> StandardHostValve.java:127)
>> at org.apache.catalina.valves.ErrorReportValve.invoke(
>> ErrorReportValve.java:102)
>> at org.apache.catalina.core.StandardEngineValve.invoke(
>> StandardEngineValve.java:109)
>> at org.apache.catalina.connector.CoyoteAdapter.service(
>> CoyoteAdapter.java:298)
>> at org.apache.coyote.http11.Http11AprProcessor.process(
>> Http11AprProcessor.java:865)
>> at org.apache.coyote.http11.Http11AprProtocol$
>> Http11ConnectionHandler.process(Http11AprProtocol.java:579)
>> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(
>> AprEndpoint.java:1555)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "http-8080-Acceptor-0" daemon prio=10 tid=0x00007f1360531800 nid=0x7123
>> runnable [0x00007f1349f6b000]
>> java.lang.Thread.State: RUNNABLE
>> at org.apache.tomcat.jni.Socket.accept(Native Method)
>> at org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java:
>> 1156)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "http-8080-Sendfile-0" daemon prio=10 tid=0x00007f1360530000 nid=0x7122 in
>> Objec t.wait() [0x00007f134a06c000]
>> java.lang.Thread.State: WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000bae01410> (a org.apache.tomcat.util.net.AprEndpo
>> int$Sendfile)
>> at java.lang.Object.wait(Object.java:502)
>> at org.apache.tomcat.util.net.AprEndpoint$Sendfile.run(AprEndpoint.java:
>> 1773)
>> - locked <0x00000000bae01410> (a org.apache.tomcat.util.net.AprEndpoint$
>> Sendfile)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "http-8080-CometPoller-0" daemon prio=10 tid=0x00007f1360524800 nid=0x7121
>> in Object.wait() [0x00007f134a16d000]
>> java.lang.Thread.State: WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000bae014b0> (a org.apache.tomcat.util.net.AprEndpo
>> int$Poller)
>> at java.lang.Object.wait(Object.java:502)
>> at org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>> 13)
>> - locked <0x00000000bae014b0> (a org.apache.tomcat.util.net.
>> AprEndpoint$Poller)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "http-8080-Poller-0" daemon prio=10 tid=0x00007f1360544000 nid=0x7120 in
>> Object.wait() [0x00007f135c16c000]
>> java.lang.Thread.State: WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000bae01558> (a org.apache.tomcat.util.net.
>> AprEndpoint$Poller)
>> at java.lang.Object.wait(Object.java:502)
>> at org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
>> 13)
>> - locked <0x00000000bae01558> (a org.apache.tomcat.util.net.
>> AprEndpoint$Poller)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "ContainerBackgroundProcessor[StandardEngine[Catalina]]" daemon prio=10
>> tid=0x00 007f136053b800 nid=0x711f waiting on condition [0x00007f135c26d000]
>> java.lang.Thread.State: TIMED_WAITING (sleeping)
>> at java.lang.Thread.sleep(Native Method)
>> at org.apache.catalina.core.ContainerBase$
>> ContainerBackgroundProcessor.run(ContainerBase.java:1579)
>> at java.lang.Thread.run(Thread.java:701)
>>
>> "GC Daemon" daemon prio=10 tid=0x00007f136043d800 nid=0x711e in
>> Object.wait() [0 x00007f1364123000]
>> java.lang.Thread.State: TIMED_WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
>> at sun.misc.GC$Daemon.run(GC.java:117)
>> - locked <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
>>
>> "Low Memory Detector" daemon prio=10 tid=0x00007f13600f5800 nid=0x711b
>> runnable [0x0000000000000000]
>> java.lang.Thread.State: RUNNABLE
>>
>> "C2 CompilerThread1" daemon prio=10 tid=0x00007f13600f3000 nid=0x711a
>> waiting on condition [0x0000000000000000]
>> java.lang.Thread.State: RUNNABLE
>>
>> "C2 CompilerThread0" daemon prio=10 tid=0x00007f13600f0800 nid=0x7119
>> waiting on condition [0x0000000000000000]
>> java.lang.Thread.State: RUNNABLE
>>
>> "Signal Dispatcher" daemon prio=10 tid=0x00007f13600ee800 nid=0x7118
>> waiting on condition [0x0000000000000000]
>> java.lang.Thread.State: RUNNABLE
>>
>> "Finalizer" daemon prio=10 tid=0x00007f136009b800 nid=0x7117 in
>> Object.wait() [0 x00007f1364bd1000]
>> java.lang.Thread.State: WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000cdb546f0> (a java.lang.ref.ReferenceQueue$
>> Lock)
>> at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:133)
>> - locked <0x00000000cdb546f0> (a java.lang.ref.ReferenceQueue$
>> Lock)
>> at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:149)
>> at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:189)
>>
>> "Reference Handler" daemon prio=10 tid=0x00007f1360099800 nid=0x7116 in
>> Object.w ait() [0x00007f1364cd2000]
>> java.lang.Thread.State: WAITING (on object monitor)
>> at java.lang.Object.wait(Native Method)
>> - waiting on <0x00000000cdb54480> (a java.lang.ref.Reference$Lock)
>> at java.lang.Object.wait(Object.java:502)
>> at java.lang.ref.Reference$ReferenceHandler.run(
>> Reference.java:133)
>> - locked <0x00000000cdb54480> (a java.lang.ref.Reference$Lock)
>>
>> "main" prio=10 tid=0x00007f1360009000 nid=0x7113 runnable
>> [0x00007f1365fb7000]
>> java.lang.Thread.State: RUNNABLE
>> at java.net.PlainSocketImpl.socketAccept(Native Method)
>> at java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:
>> 375)
>> at java.net.ServerSocket.implAccept(ServerSocket.java:478)
>> at java.net.ServerSocket.accept(ServerSocket.java:446)
>> at org.apache.catalina.core.StandardServer.await(StandardServer.java:389
>> )
>> at org.apache.catalina.startup.Catalina.await(Catalina.java:657)
>> at org.apache.catalina.startup.Catalina.start(Catalina.java:617)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
>> java:57)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
>> sorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:622)
>> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
>> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>>
>> "VM Thread" prio=10 tid=0x00007f136008a800 nid=0x7115 runnable
>>
>> "VM Periodic Task Thread" prio=10 tid=0x00007f1360100800 nid=0x711c
>> waiting on condition
>>
>> JNI global references: 253
>>
>> Heap
>> def new generation total 18432K, used 3571K [0x00000000b9c00000,
>> 0x00000000bb 000000, 0x00000000cdb50000)
>> eden space 16384K, 9% used [0x00000000b9c00000, 0x00000000b9d7cff8,
>> 0x000000 00bac00000)
>> from space 2048K, 100% used [0x00000000bae00000, 0x00000000bb000000,
>> 0x0000000 0bb000000)
>> to space 2048K, 0% used [0x00000000bac00000, 0x00000000bac00000,
>> 0x0000000 0bae00000)
>> tenured generation total 40896K, used 4306K [0x00000000cdb50000,
>> 0x00000000d0 340000, 0x00000000f5a00000)
>> the space 40896K, 10% used [0x00000000cdb50000, 0x00000000cdf849a0,
>> 0x000000 00cdf84a00, 0x00000000d0340000)
>> compacting perm gen total 21248K, used 13892K [0x00000000f5a00000,
>> 0x00000000f 6ec0000, 0x0000000100000000)
>> the space 21248K, 65% used [0x00000000f5a00000, 0x00000000f6791378,
>> 0x000000 00f6791400, 0x00000000f6ec0000)
>> No shared spaces configured.
>>
>>
>>
>> What should be my next step in troubleshooting this issue?
>>
>> mark
>>
>>
>>
>>
>> --
>>
>> Mark Maciolek
>> Network Administrator
>> Morse Hall Room 339
>> 603-862-3050
>> https://www.unh.edu/research/support-units/research-computing-center
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
--
Mark Maciolek
Network Administrator
Morse Hall Room 339
603-862-3050
https://www.unh.edu/research/support-units/research-computing-center
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 6 database connection issue
Posted by Daniel Mikusa <dm...@pivotal.io>.
On Mon, Feb 23, 2015 at 12:25 PM, Mark Maciolek <ma...@unh.edu>
wrote:
>
> On 2/23/2015 9:55 AM, Daniel Mikusa wrote:
>
>> On Mon, Feb 23, 2015 at 9:46 AM, Mark Maciolek <ma...@unh.edu>
>> wrote:
>>
>> hi,
>>>
>>> operating system:
>>> Scientific Linux release 6.6 (Carbon)
>>>
>>> postgres version
>>> postgresql-server-8.4.2
>>>
>>> tomcat version
>>> tomcat6-6.0.24
>>>
>>> Tomcat starts and I can reach page at the 8080 port on the server
>>> when I add the following xml file and restart tomcat I get this error:
>>>
>>> Feb 23, 2015 9:28:16 AM org.apache.catalina.startup.ContextConfig
>>> processContextConfig
>>> SEVERE: Parse error in context.xml for /cooa
>>> org.xml.sax.SAXParseException; systemId: file:///etc/tomcat6/Catalina/
>>> localhost/cooa.xml;
>>> lineNumber: 21; columnNumber: 12; Error at (21, 12: null
>>>
>>> <?xml version="1.0" encoding="UTF-8"?>
>>>
>>> <Context>
>>> path="/web/opal/webapps"
>>> docBase="/web/opal/webapps/ROOT"
>>> debug="5"
>>> reloadable="true"
>>> allowLinking="true"
>>>
>>> <Resource>
>>> name="jdbc/postgres"
>>> auth="Container"
>>> type="javax.sql.DataSource"
>>> driverClassName="org.postgresql.Driver"
>>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>>> username="dbuser"
>>> password="*****"
>>> maxActive="20"
>>> maxIdle="10"
>>> maxWait="10000"
>>> </Resource>
>>>
>>> This could be the list or a copy / paste issue, but you should not have
>> the
>> ">" on the opening resource tag. It should be after your last attribute
>> (i.e. after maxWait. You also don't need the closing Resource tag.
>>
>> Ex:
>>
>> <Context
>> path="/web/opal/webapps"
>> docBase="/web/opal/webapps/ROOT"
>> debug="5"
>> reloadable="true"
>> allowLinking="true">
>> <Resource
>> name="jdbc/postgres"
>> auth="Container"
>> type="javax.sql.DataSource"
>> driverClassName="org.postgresql.Driver"
>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>> username="dbuser"
>> password="*****"
>> maxActive="20"
>> maxIdle="10"
>> maxWait="10000" />
>> </Context>
>>
>> Dan
>>
>> PS: Remove "path", it's not valid here. Remove "debug", I don't think
>> that does anything. Also, you probably want to remove docBase because
>> you're pointing to something in the webapps folder (i.e. appBase), and you
>> should only use docBase if your app is outside of the appBase folder.
>>
>>
>>
>>> </Context>
>>>
>>> Line #21 is the </Resource> ran file past xml parse checker and reports
>>> everything okay.
>>>
>>> Been googling it for two days now and can not figure out what I have done
>>> wrong.
>>>
>>> Mark
>>>
>>>
>>> --
>>>
>>> Mark Maciolek
>>> Network Administrator
>>> Morse Hall Room 339
>>> 603-862-3050
>>> https://www.unh.edu/research/support-units/research-computing-center
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>
>>>
>>> hi,
>
> Changing the xml file per your suggestions loads now and my jsp pages now
> load as long as they don't need a database connection.
>
> I expect to see new postgres processes similar to this from a working
> server:
>
> postgres 407 7734 0 Feb17 ? 00:01:00 postgres: dbuser
> eosearthdata 127.0.0.1(60176) idle
> postgres 408 7734 0 Feb17 ? 00:01:00 postgres: dbuser
> eosearthdata 127.0.0.1(60177) idle
> postgres 409 7734 0 Feb17 ? 00:01:01 postgres: dbuser
> eosearthdata 127.0.0.1(60178) idle
> postgres 410 7734 0 Feb17 ? 00:01:00 postgres: dbuser
> eosearthdata 127.0.0.1(60179) idle
> postgres 411 7734 0 Feb17 ? 00:01:01 postgres: dbuser
> eosearthdata 127.0.0.1(60180) idle
>
> Starting tomcat does not start the additional postgres processes on my
> server.
> It is trying to though:
>
Do you have Postgres running on the same machine as Tomcat? Looks like
it's waiting trying to make a connection, although it's a little hard to
say because it looks like you're using a custom pool
(edu.unh.sr.cooa.DBPool?).
Dan
>
>
> When I kill -3 <tomcat pid>
>
> 2015-02-23 12:16:21
> Full thread dump OpenJDK 64-Bit Server VM (23.25-b01 mixed mode):
>
> "http-8080-7" daemon prio=10 tid=0x00007f133c1b3000 nid=0x7134 in
> Object.wait() [0x00007f1348f39000]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000bae00240> (a org.apache.tomcat.util.net.AprEndpo
> int$Worker)
> at java.lang.Object.wait(Object.java:502)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
> 1511)
> - locked <0x00000000bae00240> (a org.apache.tomcat.util.net.AprEndpoint$
> Worker)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
> 36)
> at java.lang.Thread.run(Thread.java:701)
>
> "http-8080-6" daemon prio=10 tid=0x00007f135001b800 nid=0x712e in
> Object.wait() [0x00007f134903a000]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000bae002d8> (a org.apache.tomcat.util.net.AprEndpo
> int$Worker)
> at java.lang.Object.wait(Object.java:502)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
> 1511)
> - locked <0x00000000bae002d8> (a org.apache.tomcat.util.net.AprEndpoint$
> Worker)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
> 36)
> at java.lang.Thread.run(Thread.java:701)
>
> "http-8080-5" daemon prio=10 tid=0x00007f1350017800 nid=0x712d in
> Object.wait() [0x00007f134913b000]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000bae00370> (a org.apache.tomcat.util.net.AprEndpo
> int$Worker)
> at java.lang.Object.wait(Object.java:502)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
> 1511)
> - locked <0x00000000bae00370> (a org.apache.tomcat.util.net.AprEndpoint$
> Worker)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
> 36)
> at java.lang.Thread.run(Thread.java:701)
>
> "http-8080-4" daemon prio=10 tid=0x00007f1350014000 nid=0x712c in
> Object.wait() [0x00007f134923c000]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000bae00408> (a org.apache.tomcat.util.net.AprEndpo
> int$Worker)
> at java.lang.Object.wait(Object.java:502)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
> 1511)
> - locked <0x00000000bae00408> (a org.apache.tomcat.util.net.AprEndpoint$
> Worker)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
> 36)
> at java.lang.Thread.run(Thread.java:701)
>
> "http-8080-3" daemon prio=10 tid=0x00007f1350010800 nid=0x712b in
> Object.wait() [0x00007f134933d000]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000bae004a0> (a org.apache.tomcat.util.net.AprEndpo
> int$Worker)
> at java.lang.Object.wait(Object.java:502)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java:
> 1511)
> - locked <0x00000000bae004a0> (a org.apache.tomcat.util.net.AprEndpoint$
> Worker)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
> 36)
> at java.lang.Thread.run(Thread.java:701)
>
> "ajp-8009-Acceptor-0" daemon prio=10 tid=0x00007f136075c000 nid=0x7128
> runnable [0x00007f1349a66000]
> java.lang.Thread.State: RUNNABLE
> at org.apache.tomcat.jni.Socket.accept(Native Method)
> at org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java:
> 1156)
> at java.lang.Thread.run(Thread.java:701)
>
> "ajp-8009-CometPoller-0" daemon prio=10 tid=0x00007f136074e000 nid=0x7127
> in Obj ect.wait() [0x00007f1349b67000]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000bae005b8> (a org.apache.tomcat.util.net.AprEndpo
> int$Poller)
> at java.lang.Object.wait(Object.java:502)
> at org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
> 13)
> - locked <0x00000000bae005b8> (a org.apache.tomcat.util.net.AprEndpoint$
> Poller)
> at java.lang.Thread.run(Thread.java:701)
>
> "ajp-8009-Poller-0" daemon prio=10 tid=0x00007f1360653800 nid=0x7126 in
> Object.w ait() [0x00007f1349c68000]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000bae00660> (a org.apache.tomcat.util.net.AprEndpo
> int$Poller)
> at java.lang.Object.wait(Object.java:502)
> at org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
> 13)
> - locked <0x00000000bae00660> (a org.apache.tomcat.util.net.AprEndpoint$
> Poller)
> at java.lang.Thread.run(Thread.java:701)
>
> "http-8080-2" daemon prio=10 tid=0x00007f135000c800 nid=0x7125 waiting for
> monit or entry [0x00007f1349d68000]
> java.lang.Thread.State: BLOCKED (on object monitor)
> at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:66)
> - waiting to lock <0x00000000bae00708> (a java.lang.Class for
> edu.unh.sr .cooa.DBPool)
> at org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java
> :68)
> at org.apache.jasper.runtime.HttpJspBase.service(
> HttpJspBase.java:70)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
> .java:377)
> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
> 13)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.
> java:260)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:290)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:206)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
> alve.java:233)
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
> alve.java:191)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
> ava:127)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
> ava:102)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
> ve.java:109)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
> a:298)
> at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
> r.java:865)
> at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
> ocess(Http11AprProtocol.java:579)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
> 55)
> at java.lang.Thread.run(Thread.java:701)
>
> "http-8080-1" daemon prio=10 tid=0x00007f1350008800 nid=0x7124 waiting on
> condit ion [0x00007f1349e68000]
> java.lang.Thread.State: TIMED_WAITING (sleeping)
> at java.lang.Thread.sleep(Native Method)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:88)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
> - locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
> at edu.unh.sr.cooa.DBPool.<init>(DBPool.java:55)
> at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:67)
> - locked <0x00000000bae00708> (a java.lang.Class for
> edu.unh.sr.cooa.DBP ool)
> at org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java
> :68)
> at org.apache.jasper.runtime.HttpJspBase.service(
> HttpJspBase.java:70)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
> .java:377)
> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
> 13)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.
> java:260)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:290)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:206)
> at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:233)
> at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:191)
> at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:127)
> at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:102)
> at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:109)
> at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:298)
> at org.apache.coyote.http11.Http11AprProcessor.process(
> Http11AprProcessor.java:865)
> at org.apache.coyote.http11.Http11AprProtocol$
> Http11ConnectionHandler.process(Http11AprProtocol.java:579)
> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(
> AprEndpoint.java:1555)
> at java.lang.Thread.run(Thread.java:701)
>
> "http-8080-Acceptor-0" daemon prio=10 tid=0x00007f1360531800 nid=0x7123
> runnable [0x00007f1349f6b000]
> java.lang.Thread.State: RUNNABLE
> at org.apache.tomcat.jni.Socket.accept(Native Method)
> at org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java:
> 1156)
> at java.lang.Thread.run(Thread.java:701)
>
> "http-8080-Sendfile-0" daemon prio=10 tid=0x00007f1360530000 nid=0x7122 in
> Objec t.wait() [0x00007f134a06c000]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000bae01410> (a org.apache.tomcat.util.net.AprEndpo
> int$Sendfile)
> at java.lang.Object.wait(Object.java:502)
> at org.apache.tomcat.util.net.AprEndpoint$Sendfile.run(AprEndpoint.java:
> 1773)
> - locked <0x00000000bae01410> (a org.apache.tomcat.util.net.AprEndpoint$
> Sendfile)
> at java.lang.Thread.run(Thread.java:701)
>
> "http-8080-CometPoller-0" daemon prio=10 tid=0x00007f1360524800 nid=0x7121
> in Object.wait() [0x00007f134a16d000]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000bae014b0> (a org.apache.tomcat.util.net.AprEndpo
> int$Poller)
> at java.lang.Object.wait(Object.java:502)
> at org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
> 13)
> - locked <0x00000000bae014b0> (a org.apache.tomcat.util.net.
> AprEndpoint$Poller)
> at java.lang.Thread.run(Thread.java:701)
>
> "http-8080-Poller-0" daemon prio=10 tid=0x00007f1360544000 nid=0x7120 in
> Object.wait() [0x00007f135c16c000]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000bae01558> (a org.apache.tomcat.util.net.
> AprEndpoint$Poller)
> at java.lang.Object.wait(Object.java:502)
> at org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13
> 13)
> - locked <0x00000000bae01558> (a org.apache.tomcat.util.net.
> AprEndpoint$Poller)
> at java.lang.Thread.run(Thread.java:701)
>
> "ContainerBackgroundProcessor[StandardEngine[Catalina]]" daemon prio=10
> tid=0x00 007f136053b800 nid=0x711f waiting on condition [0x00007f135c26d000]
> java.lang.Thread.State: TIMED_WAITING (sleeping)
> at java.lang.Thread.sleep(Native Method)
> at org.apache.catalina.core.ContainerBase$
> ContainerBackgroundProcessor.run(ContainerBase.java:1579)
> at java.lang.Thread.run(Thread.java:701)
>
> "GC Daemon" daemon prio=10 tid=0x00007f136043d800 nid=0x711e in
> Object.wait() [0 x00007f1364123000]
> java.lang.Thread.State: TIMED_WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
> at sun.misc.GC$Daemon.run(GC.java:117)
> - locked <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
>
> "Low Memory Detector" daemon prio=10 tid=0x00007f13600f5800 nid=0x711b
> runnable [0x0000000000000000]
> java.lang.Thread.State: RUNNABLE
>
> "C2 CompilerThread1" daemon prio=10 tid=0x00007f13600f3000 nid=0x711a
> waiting on condition [0x0000000000000000]
> java.lang.Thread.State: RUNNABLE
>
> "C2 CompilerThread0" daemon prio=10 tid=0x00007f13600f0800 nid=0x7119
> waiting on condition [0x0000000000000000]
> java.lang.Thread.State: RUNNABLE
>
> "Signal Dispatcher" daemon prio=10 tid=0x00007f13600ee800 nid=0x7118
> waiting on condition [0x0000000000000000]
> java.lang.Thread.State: RUNNABLE
>
> "Finalizer" daemon prio=10 tid=0x00007f136009b800 nid=0x7117 in
> Object.wait() [0 x00007f1364bd1000]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000cdb546f0> (a java.lang.ref.ReferenceQueue$
> Lock)
> at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:133)
> - locked <0x00000000cdb546f0> (a java.lang.ref.ReferenceQueue$
> Lock)
> at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:149)
> at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:189)
>
> "Reference Handler" daemon prio=10 tid=0x00007f1360099800 nid=0x7116 in
> Object.w ait() [0x00007f1364cd2000]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x00000000cdb54480> (a java.lang.ref.Reference$Lock)
> at java.lang.Object.wait(Object.java:502)
> at java.lang.ref.Reference$ReferenceHandler.run(
> Reference.java:133)
> - locked <0x00000000cdb54480> (a java.lang.ref.Reference$Lock)
>
> "main" prio=10 tid=0x00007f1360009000 nid=0x7113 runnable
> [0x00007f1365fb7000]
> java.lang.Thread.State: RUNNABLE
> at java.net.PlainSocketImpl.socketAccept(Native Method)
> at java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:
> 375)
> at java.net.ServerSocket.implAccept(ServerSocket.java:478)
> at java.net.ServerSocket.accept(ServerSocket.java:446)
> at org.apache.catalina.core.StandardServer.await(StandardServer.java:389
> )
> at org.apache.catalina.startup.Catalina.await(Catalina.java:657)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:617)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:622)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>
> "VM Thread" prio=10 tid=0x00007f136008a800 nid=0x7115 runnable
>
> "VM Periodic Task Thread" prio=10 tid=0x00007f1360100800 nid=0x711c
> waiting on condition
>
> JNI global references: 253
>
> Heap
> def new generation total 18432K, used 3571K [0x00000000b9c00000,
> 0x00000000bb 000000, 0x00000000cdb50000)
> eden space 16384K, 9% used [0x00000000b9c00000, 0x00000000b9d7cff8,
> 0x000000 00bac00000)
> from space 2048K, 100% used [0x00000000bae00000, 0x00000000bb000000,
> 0x0000000 0bb000000)
> to space 2048K, 0% used [0x00000000bac00000, 0x00000000bac00000,
> 0x0000000 0bae00000)
> tenured generation total 40896K, used 4306K [0x00000000cdb50000,
> 0x00000000d0 340000, 0x00000000f5a00000)
> the space 40896K, 10% used [0x00000000cdb50000, 0x00000000cdf849a0,
> 0x000000 00cdf84a00, 0x00000000d0340000)
> compacting perm gen total 21248K, used 13892K [0x00000000f5a00000,
> 0x00000000f 6ec0000, 0x0000000100000000)
> the space 21248K, 65% used [0x00000000f5a00000, 0x00000000f6791378,
> 0x000000 00f6791400, 0x00000000f6ec0000)
> No shared spaces configured.
>
>
>
> What should be my next step in troubleshooting this issue?
>
> mark
>
>
>
>
> --
>
> Mark Maciolek
> Network Administrator
> Morse Hall Room 339
> 603-862-3050
> https://www.unh.edu/research/support-units/research-computing-center
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
Re: Tomcat 6 database connection issue
Posted by Mark Maciolek <ma...@unh.edu>.
On 2/23/2015 9:55 AM, Daniel Mikusa wrote:
> On Mon, Feb 23, 2015 at 9:46 AM, Mark Maciolek <ma...@unh.edu>
> wrote:
>
>> hi,
>>
>> operating system:
>> Scientific Linux release 6.6 (Carbon)
>>
>> postgres version
>> postgresql-server-8.4.2
>>
>> tomcat version
>> tomcat6-6.0.24
>>
>> Tomcat starts and I can reach page at the 8080 port on the server
>> when I add the following xml file and restart tomcat I get this error:
>>
>> Feb 23, 2015 9:28:16 AM org.apache.catalina.startup.ContextConfig
>> processContextConfig
>> SEVERE: Parse error in context.xml for /cooa
>> org.xml.sax.SAXParseException; systemId: file:///etc/tomcat6/Catalina/localhost/cooa.xml;
>> lineNumber: 21; columnNumber: 12; Error at (21, 12: null
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>>
>> <Context>
>> path="/web/opal/webapps"
>> docBase="/web/opal/webapps/ROOT"
>> debug="5"
>> reloadable="true"
>> allowLinking="true"
>>
>> <Resource>
>> name="jdbc/postgres"
>> auth="Container"
>> type="javax.sql.DataSource"
>> driverClassName="org.postgresql.Driver"
>> url="jdbc:postgresql://127.0.0.1:5432/cooa"
>> username="dbuser"
>> password="*****"
>> maxActive="20"
>> maxIdle="10"
>> maxWait="10000"
>> </Resource>
>>
> This could be the list or a copy / paste issue, but you should not have the
> ">" on the opening resource tag. It should be after your last attribute
> (i.e. after maxWait. You also don't need the closing Resource tag.
>
> Ex:
>
> <Context
> path="/web/opal/webapps"
> docBase="/web/opal/webapps/ROOT"
> debug="5"
> reloadable="true"
> allowLinking="true">
> <Resource
> name="jdbc/postgres"
> auth="Container"
> type="javax.sql.DataSource"
> driverClassName="org.postgresql.Driver"
> url="jdbc:postgresql://127.0.0.1:5432/cooa"
> username="dbuser"
> password="*****"
> maxActive="20"
> maxIdle="10"
> maxWait="10000" />
> </Context>
>
> Dan
>
> PS: Remove "path", it's not valid here. Remove "debug", I don't think
> that does anything. Also, you probably want to remove docBase because
> you're pointing to something in the webapps folder (i.e. appBase), and you
> should only use docBase if your app is outside of the appBase folder.
>
>
>>
>> </Context>
>>
>> Line #21 is the </Resource> ran file past xml parse checker and reports
>> everything okay.
>>
>> Been googling it for two days now and can not figure out what I have done
>> wrong.
>>
>> Mark
>>
>>
>> --
>>
>> Mark Maciolek
>> Network Administrator
>> Morse Hall Room 339
>> 603-862-3050
>> https://www.unh.edu/research/support-units/research-computing-center
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
hi,
Changing the xml file per your suggestions loads now and my jsp pages
now load as long as they don't need a database connection.
I expect to see new postgres processes similar to this from a working
server:
postgres 407 7734 0 Feb17 ? 00:01:00 postgres: dbuser
eosearthdata 127.0.0.1(60176) idle
postgres 408 7734 0 Feb17 ? 00:01:00 postgres: dbuser
eosearthdata 127.0.0.1(60177) idle
postgres 409 7734 0 Feb17 ? 00:01:01 postgres: dbuser
eosearthdata 127.0.0.1(60178) idle
postgres 410 7734 0 Feb17 ? 00:01:00 postgres: dbuser
eosearthdata 127.0.0.1(60179) idle
postgres 411 7734 0 Feb17 ? 00:01:01 postgres: dbuser
eosearthdata 127.0.0.1(60180) idle
Starting tomcat does not start the additional postgres processes on my
server.
It is trying to though:
When I kill -3 <tomcat pid>
2015-02-23 12:16:21
Full thread dump OpenJDK 64-Bit Server VM (23.25-b01 mixed mode):
"http-8080-7" daemon prio=10 tid=0x00007f133c1b3000 nid=0x7134 in
Object.wait() [0x00007f1348f39000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000bae00240> (a
org.apache.tomcat.util.net.AprEndpo int$Worker)
at java.lang.Object.wait(Object.java:502)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java: 1511)
- locked <0x00000000bae00240> (a
org.apache.tomcat.util.net.AprEndpoint$ Worker)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15 36)
at java.lang.Thread.run(Thread.java:701)
"http-8080-6" daemon prio=10 tid=0x00007f135001b800 nid=0x712e in
Object.wait() [0x00007f134903a000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000bae002d8> (a
org.apache.tomcat.util.net.AprEndpo int$Worker)
at java.lang.Object.wait(Object.java:502)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java: 1511)
- locked <0x00000000bae002d8> (a
org.apache.tomcat.util.net.AprEndpoint$ Worker)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15 36)
at java.lang.Thread.run(Thread.java:701)
"http-8080-5" daemon prio=10 tid=0x00007f1350017800 nid=0x712d in
Object.wait() [0x00007f134913b000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000bae00370> (a
org.apache.tomcat.util.net.AprEndpo int$Worker)
at java.lang.Object.wait(Object.java:502)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java: 1511)
- locked <0x00000000bae00370> (a
org.apache.tomcat.util.net.AprEndpoint$ Worker)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15 36)
at java.lang.Thread.run(Thread.java:701)
"http-8080-4" daemon prio=10 tid=0x00007f1350014000 nid=0x712c in
Object.wait() [0x00007f134923c000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000bae00408> (a
org.apache.tomcat.util.net.AprEndpo int$Worker)
at java.lang.Object.wait(Object.java:502)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java: 1511)
- locked <0x00000000bae00408> (a
org.apache.tomcat.util.net.AprEndpoint$ Worker)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15 36)
at java.lang.Thread.run(Thread.java:701)
"http-8080-3" daemon prio=10 tid=0x00007f1350010800 nid=0x712b in
Object.wait() [0x00007f134933d000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000bae004a0> (a
org.apache.tomcat.util.net.AprEndpo int$Worker)
at java.lang.Object.wait(Object.java:502)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.await(AprEndpoint.java: 1511)
- locked <0x00000000bae004a0> (a
org.apache.tomcat.util.net.AprEndpoint$ Worker)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15 36)
at java.lang.Thread.run(Thread.java:701)
"ajp-8009-Acceptor-0" daemon prio=10 tid=0x00007f136075c000 nid=0x7128
runnable [0x00007f1349a66000]
java.lang.Thread.State: RUNNABLE
at org.apache.tomcat.jni.Socket.accept(Native Method)
at
org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java: 1156)
at java.lang.Thread.run(Thread.java:701)
"ajp-8009-CometPoller-0" daemon prio=10 tid=0x00007f136074e000
nid=0x7127 in Obj ect.wait() [0x00007f1349b67000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000bae005b8> (a
org.apache.tomcat.util.net.AprEndpo int$Poller)
at java.lang.Object.wait(Object.java:502)
at
org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13 13)
- locked <0x00000000bae005b8> (a
org.apache.tomcat.util.net.AprEndpoint$ Poller)
at java.lang.Thread.run(Thread.java:701)
"ajp-8009-Poller-0" daemon prio=10 tid=0x00007f1360653800 nid=0x7126 in
Object.w ait() [0x00007f1349c68000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000bae00660> (a
org.apache.tomcat.util.net.AprEndpo int$Poller)
at java.lang.Object.wait(Object.java:502)
at
org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13 13)
- locked <0x00000000bae00660> (a
org.apache.tomcat.util.net.AprEndpoint$ Poller)
at java.lang.Thread.run(Thread.java:701)
"http-8080-2" daemon prio=10 tid=0x00007f135000c800 nid=0x7125 waiting
for monit or entry [0x00007f1349d68000]
java.lang.Thread.State: BLOCKED (on object monitor)
at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:66)
- waiting to lock <0x00000000bae00708> (a java.lang.Class for
edu.unh.sr .cooa.DBPool)
at
org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java :68)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:377)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3 13)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav a:298)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:865)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:579)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15 55)
at java.lang.Thread.run(Thread.java:701)
"http-8080-1" daemon prio=10 tid=0x00007f1350008800 nid=0x7124 waiting
on condit ion [0x00007f1349e68000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:88)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.createDBConnection(DBPool.java:89)
- locked <0x00000000bae00c60> (a edu.unh.sr.cooa.DBPool)
at edu.unh.sr.cooa.DBPool.<init>(DBPool.java:55)
at edu.unh.sr.cooa.DBPool.getInstance(DBPool.java:67)
- locked <0x00000000bae00708> (a java.lang.Class for
edu.unh.sr.cooa.DBP ool)
at
org.apache.jsp.data.boats.bottle.index_jsp._jspService(index_jsp.java :68)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:377)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3 13)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:865)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
at java.lang.Thread.run(Thread.java:701)
"http-8080-Acceptor-0" daemon prio=10 tid=0x00007f1360531800 nid=0x7123
runnable [0x00007f1349f6b000]
java.lang.Thread.State: RUNNABLE
at org.apache.tomcat.jni.Socket.accept(Native Method)
at
org.apache.tomcat.util.net.AprEndpoint$Acceptor.run(AprEndpoint.java: 1156)
at java.lang.Thread.run(Thread.java:701)
"http-8080-Sendfile-0" daemon prio=10 tid=0x00007f1360530000 nid=0x7122
in Objec t.wait() [0x00007f134a06c000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000bae01410> (a
org.apache.tomcat.util.net.AprEndpo int$Sendfile)
at java.lang.Object.wait(Object.java:502)
at
org.apache.tomcat.util.net.AprEndpoint$Sendfile.run(AprEndpoint.java: 1773)
- locked <0x00000000bae01410> (a
org.apache.tomcat.util.net.AprEndpoint$ Sendfile)
at java.lang.Thread.run(Thread.java:701)
"http-8080-CometPoller-0" daemon prio=10 tid=0x00007f1360524800
nid=0x7121 in Object.wait() [0x00007f134a16d000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000bae014b0> (a
org.apache.tomcat.util.net.AprEndpo int$Poller)
at java.lang.Object.wait(Object.java:502)
at
org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13 13)
- locked <0x00000000bae014b0> (a
org.apache.tomcat.util.net.AprEndpoint$Poller)
at java.lang.Thread.run(Thread.java:701)
"http-8080-Poller-0" daemon prio=10 tid=0x00007f1360544000 nid=0x7120 in
Object.wait() [0x00007f135c16c000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000bae01558> (a
org.apache.tomcat.util.net.AprEndpoint$Poller)
at java.lang.Object.wait(Object.java:502)
at
org.apache.tomcat.util.net.AprEndpoint$Poller.run(AprEndpoint.java:13 13)
- locked <0x00000000bae01558> (a
org.apache.tomcat.util.net.AprEndpoint$Poller)
at java.lang.Thread.run(Thread.java:701)
"ContainerBackgroundProcessor[StandardEngine[Catalina]]" daemon prio=10
tid=0x00 007f136053b800 nid=0x711f waiting on condition [0x00007f135c26d000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1579)
at java.lang.Thread.run(Thread.java:701)
"GC Daemon" daemon prio=10 tid=0x00007f136043d800 nid=0x711e in
Object.wait() [0 x00007f1364123000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
at sun.misc.GC$Daemon.run(GC.java:117)
- locked <0x00000000cdd43778> (a sun.misc.GC$LatencyLock)
"Low Memory Detector" daemon prio=10 tid=0x00007f13600f5800 nid=0x711b
runnable [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
"C2 CompilerThread1" daemon prio=10 tid=0x00007f13600f3000 nid=0x711a
waiting on condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
"C2 CompilerThread0" daemon prio=10 tid=0x00007f13600f0800 nid=0x7119
waiting on condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
"Signal Dispatcher" daemon prio=10 tid=0x00007f13600ee800 nid=0x7118
waiting on condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE
"Finalizer" daemon prio=10 tid=0x00007f136009b800 nid=0x7117 in
Object.wait() [0 x00007f1364bd1000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000cdb546f0> (a
java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:133)
- locked <0x00000000cdb546f0> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:149)
at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:189)
"Reference Handler" daemon prio=10 tid=0x00007f1360099800 nid=0x7116 in
Object.w ait() [0x00007f1364cd2000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x00000000cdb54480> (a java.lang.ref.Reference$Lock)
at java.lang.Object.wait(Object.java:502)
at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:133)
- locked <0x00000000cdb54480> (a java.lang.ref.Reference$Lock)
"main" prio=10 tid=0x00007f1360009000 nid=0x7113 runnable
[0x00007f1365fb7000]
java.lang.Thread.State: RUNNABLE
at java.net.PlainSocketImpl.socketAccept(Native Method)
at
java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java: 375)
at java.net.ServerSocket.implAccept(ServerSocket.java:478)
at java.net.ServerSocket.accept(ServerSocket.java:446)
at
org.apache.catalina.core.StandardServer.await(StandardServer.java:389 )
at org.apache.catalina.startup.Catalina.await(Catalina.java:657)
at org.apache.catalina.startup.Catalina.start(Catalina.java:617)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:622)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
"VM Thread" prio=10 tid=0x00007f136008a800 nid=0x7115 runnable
"VM Periodic Task Thread" prio=10 tid=0x00007f1360100800 nid=0x711c
waiting on condition
JNI global references: 253
Heap
def new generation total 18432K, used 3571K [0x00000000b9c00000,
0x00000000bb 000000, 0x00000000cdb50000)
eden space 16384K, 9% used [0x00000000b9c00000, 0x00000000b9d7cff8,
0x000000 00bac00000)
from space 2048K, 100% used [0x00000000bae00000, 0x00000000bb000000,
0x0000000 0bb000000)
to space 2048K, 0% used [0x00000000bac00000, 0x00000000bac00000,
0x0000000 0bae00000)
tenured generation total 40896K, used 4306K [0x00000000cdb50000,
0x00000000d0 340000, 0x00000000f5a00000)
the space 40896K, 10% used [0x00000000cdb50000, 0x00000000cdf849a0,
0x000000 00cdf84a00, 0x00000000d0340000)
compacting perm gen total 21248K, used 13892K [0x00000000f5a00000,
0x00000000f 6ec0000, 0x0000000100000000)
the space 21248K, 65% used [0x00000000f5a00000, 0x00000000f6791378,
0x000000 00f6791400, 0x00000000f6ec0000)
No shared spaces configured.
What should be my next step in troubleshooting this issue?
mark
--
Mark Maciolek
Network Administrator
Morse Hall Room 339
603-862-3050
https://www.unh.edu/research/support-units/research-computing-center
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 6 database connection issue
Posted by Daniel Mikusa <dm...@pivotal.io>.
On Mon, Feb 23, 2015 at 9:46 AM, Mark Maciolek <ma...@unh.edu>
wrote:
> hi,
>
> operating system:
> Scientific Linux release 6.6 (Carbon)
>
> postgres version
> postgresql-server-8.4.2
>
> tomcat version
> tomcat6-6.0.24
>
> Tomcat starts and I can reach page at the 8080 port on the server
> when I add the following xml file and restart tomcat I get this error:
>
> Feb 23, 2015 9:28:16 AM org.apache.catalina.startup.ContextConfig
> processContextConfig
> SEVERE: Parse error in context.xml for /cooa
> org.xml.sax.SAXParseException; systemId: file:///etc/tomcat6/Catalina/localhost/cooa.xml;
> lineNumber: 21; columnNumber: 12; Error at (21, 12: null
>
> <?xml version="1.0" encoding="UTF-8"?>
>
> <Context>
> path="/web/opal/webapps"
> docBase="/web/opal/webapps/ROOT"
> debug="5"
> reloadable="true"
> allowLinking="true"
>
> <Resource>
> name="jdbc/postgres"
> auth="Container"
> type="javax.sql.DataSource"
> driverClassName="org.postgresql.Driver"
> url="jdbc:postgresql://127.0.0.1:5432/cooa"
> username="dbuser"
> password="*****"
> maxActive="20"
> maxIdle="10"
> maxWait="10000"
> </Resource>
>
This could be the list or a copy / paste issue, but you should not have the
">" on the opening resource tag. It should be after your last attribute
(i.e. after maxWait. You also don't need the closing Resource tag.
Ex:
<Context
path="/web/opal/webapps"
docBase="/web/opal/webapps/ROOT"
debug="5"
reloadable="true"
allowLinking="true">
<Resource
name="jdbc/postgres"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://127.0.0.1:5432/cooa"
username="dbuser"
password="*****"
maxActive="20"
maxIdle="10"
maxWait="10000" />
</Context>
Dan
PS: Remove "path", it's not valid here. Remove "debug", I don't think
that does anything. Also, you probably want to remove docBase because
you're pointing to something in the webapps folder (i.e. appBase), and you
should only use docBase if your app is outside of the appBase folder.
>
>
> </Context>
>
> Line #21 is the </Resource> ran file past xml parse checker and reports
> everything okay.
>
> Been googling it for two days now and can not figure out what I have done
> wrong.
>
> Mark
>
>
> --
>
> Mark Maciolek
> Network Administrator
> Morse Hall Room 339
> 603-862-3050
> https://www.unh.edu/research/support-units/research-computing-center
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>