Re: Tomcat mysteriously stops responding...
When creating your mySQL connection do you have autoReconnect=true in your connection string? If you don't mySQL will close inactive connections after a time and the driver won't reconnect. That time to live seems to vary from installation to installation. Ours died after eight hours inactivity. Other people on this list have seen dead connections after, say, 3hrs. Some connection pools have 'ping' functionality for connections, some don't. Depends on the pool you are using ;) I think DBCP has this option but we're not using it so I can't be sure... HTH, Jon Sonny Sukumar wrote: Interesting observation. I think you might be onto something, but let's explore it a bit further. I'm using DBCP with a MySQL backend database. I don't really get why Tomcat would stop responding though after several hours of idle time though. You think it's because after all those hours of idle time the # of db connections is 0? I thought the connection pool could handle that and create a new connection when needed. I think I'm not understanding though...do enlighten me. :-) Thanks for your help, Sonny --- mike jackson [EMAIL PROTECTED] wrote: When this has happened to me it's usually been the database connection pool that I'm using. Or was using. If it looks like you had a bunch of connections prior to the restart and very few after then you've found your culprit. You database should be able to give you a connection count, but the way to get it depends on the database so I can't help you there. --mikej -=-- mike jackson [EMAIL PROTECTED] -Original Message- From: Sonny Sukumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 3:25 PM To: [EMAIL PROTECTED] Subject: Tomcat mysteriously stops responding... Hey guys, I've had the persistent problem with Tomcat (using Cocoon) over some months now where when I go to bed at night my Tomcat/Cocoon server is functioning just fine and I can access all web pages, both static and dynamically generated (from a backend db). But when I wake up and try to access the pages the connection just times out and I get a totally blank response. This doesn't happen every single day, but often enough to be annoying. We're soon going live with the site, so this happening **at all** is a scary thought. I can't seem to figure out what the problem could be. I'm fairly sure it's Tomcat because restarting Tomcat almost always solves the problem. I've had this problem through all my Tomcat upgrades (4.1.12 all the way to 4.1.27 now) and my Cocoon upgrades (from 2.0.x all the way until latest 2.1.2). Has anybody else experienced this? Any idea what it could be? Thanks! Sonny __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat mysteriously stops responding...
If you are using Red-Hat 9, you may have run into the problem I had. Check the thread Re: tomcat jitters, then hangs - please help Noam - Original Message - From: Sonny Sukumar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 1:25 AM Subject: Tomcat mysteriously stops responding... Hey guys, I've had the persistent problem with Tomcat (using Cocoon) over some months now where when I go to bed at night my Tomcat/Cocoon server is functioning just fine and I can access all web pages, both static and dynamically generated (from a backend db). But when I wake up and try to access the pages the connection just times out and I get a totally blank response. This doesn't happen every single day, but often enough to be annoying. We're soon going live with the site, so this happening **at all** is a scary thought. I can't seem to figure out what the problem could be. I'm fairly sure it's Tomcat because restarting Tomcat almost always solves the problem. I've had this problem through all my Tomcat upgrades (4.1.12 all the way to 4.1.27 now) and my Cocoon upgrades (from 2.0.x all the way until latest 2.1.2). Has anybody else experienced this? Any idea what it could be? Thanks! Sonny __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat mysteriously stops responding...
I've had a similar problem and can't figure it out. I suspect I have a servlet which isn't closing connections correctly or isn't shutting down properly and ties up resources. I havn't found it yet, but someone suggested poor programming practices from us newbies/unknowledgeables could be the problem. Good luck and I hope you find it. robyne -Original Message- From: Sonny Sukumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 5:25 PM To: [EMAIL PROTECTED] Subject: Tomcat mysteriously stops responding... Hey guys, I've had the persistent problem with Tomcat (using Cocoon) over some months now where when I go to bed at night my Tomcat/Cocoon server is functioning just fine and I can access all web pages, both static and dynamically generated (from a backend db). But when I wake up and try to access the pages the connection just times out and I get a totally blank response. This doesn't happen every single day, but often enough to be annoying. We're soon going live with the site, so this happening **at all** is a scary thought. I can't seem to figure out what the problem could be. I'm fairly sure it's Tomcat because restarting Tomcat almost always solves the problem. I've had this problem through all my Tomcat upgrades (4.1.12 all the way to 4.1.27 now) and my Cocoon upgrades (from 2.0.x all the way until latest 2.1.2). Has anybody else experienced this? Any idea what it could be? Thanks! Sonny __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE : Tomcat mysteriously stops responding...
Same problem, maybe poor programming practices -Message d'origine- De : Robyne Vaughn [mailto:[EMAIL PROTECTED] Envoyé : jeudi 23 octobre 2003 14:56 À : Tomcat Users List; [EMAIL PROTECTED] Objet : RE: Tomcat mysteriously stops responding... I've had a similar problem and can't figure it out. I suspect I have a servlet which isn't closing connections correctly or isn't shutting down properly and ties up resources. I havn't found it yet, but someone suggested poor programming practices from us newbies/unknowledgeables could be the problem. Good luck and I hope you find it. robyne -Original Message- From: Sonny Sukumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 5:25 PM To: [EMAIL PROTECTED] Subject: Tomcat mysteriously stops responding... Hey guys, I've had the persistent problem with Tomcat (using Cocoon) over some months now where when I go to bed at night my Tomcat/Cocoon server is functioning just fine and I can access all web pages, both static and dynamically generated (from a backend db). But when I wake up and try to access the pages the connection just times out and I get a totally blank response. This doesn't happen every single day, but often enough to be annoying. We're soon going live with the site, so this happening **at all** is a scary thought. I can't seem to figure out what the problem could be. I'm fairly sure it's Tomcat because restarting Tomcat almost always solves the problem. I've had this problem through all my Tomcat upgrades (4.1.12 all the way to 4.1.27 now) and my Cocoon upgrades (from 2.0.x all the way until latest 2.1.2). Has anybody else experienced this? Any idea what it could be? Thanks! Sonny __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat mysteriously stops responding...
Many thanks for these suggestions, Justin. I'll refer to them the next time I encounter this problem. --- Justin Ruthenbeck [EMAIL PROTECTED] wrote: Figure out the answers to the following and you'll probably figure out what's causing the problem: (1) When Tomcat is frozen, can you interact with the Admin/Manager apps? (2) When it's frozen, do any non-database requests succeed (such as an image served through Tomcat's default servlet)? (3) Do you have any custom threads that could be getting locked up under certain cases? (4) If you get a thread dump when it's frozen, what do you see? Spinning threads? Deadlocks? Nothing interesting? (5) Bump you logging levels up. When your app gets frozen, does any logging appear at all? (6) If it looks like it's a db thing, are you able to connect to your database through a different app when your webApp is frozen? (7) Is anyone using the app between the time you go to bed and wake up? Some action (either user or system) is causing the hang -- what is it? Just something to get you started. Since you've seen this on various versions of Tomcat and Cocoon (and there's no accepted issues with this happening, to the best of my knowledge), I'd put my money on your app/deployment/network as the culprit. Let us know what you find... justin At 05:26 PM 10/22/2003, you wrote: Interesting observation. I think you might be onto something, but let's explore it a bit further. I'm using DBCP with a MySQL backend database. I don't really get why Tomcat would stop responding though after several hours of idle time though. You think it's because after all those hours of idle time the # of db connections is 0? I thought the connection pool could handle that and create a new connection when needed. I think I'm not understanding though...do enlighten me. :-) Thanks for your help, Sonny --- mike jackson [EMAIL PROTECTED] wrote: When this has happened to me it's usually been the database connection pool that I'm using. Or was using. If it looks like you had a bunch of connections prior to the restart and very few after then you've found your culprit. You database should be able to give you a connection count, but the way to get it depends on the database so I can't help you there. --mikej -=-- mike jackson [EMAIL PROTECTED] -Original Message- From: Sonny Sukumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 3:25 PM To: [EMAIL PROTECTED] Subject: Tomcat mysteriously stops responding... Hey guys, I've had the persistent problem with Tomcat (using Cocoon) over some months now where when I go to bed at night my Tomcat/Cocoon server is functioning just fine and I can access all web pages, both static and dynamically generated (from a backend db). But when I wake up and try to access the pages the connection just times out and I get a totally blank response. This doesn't happen every single day, but often enough to be annoying. We're soon going live with the site, so this happening **at all** is a scary thought. I can't seem to figure out what the problem could be. I'm fairly sure it's Tomcat because restarting Tomcat almost always solves the problem. I've had this problem through all my Tomcat upgrades (4.1.12 all the way to 4.1.27 now) and my Cocoon upgrades (from 2.0.x all the way until latest 2.1.2). Has anybody else experienced this? Any idea what it could be? Thanks! Sonny __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Justin Ruthenbeck Software Engineer, NextEngine Inc. justinr - AT - nextengine DOT com Confidential See http://www.nextengine.com/confidentiality.php - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat mysteriously stops responding...
When this has happened to me it's usually been the database connection pool that I'm using. Or was using. If it looks like you had a bunch of connections prior to the restart and very few after then you've found your culprit. You database should be able to give you a connection count, but the way to get it depends on the database so I can't help you there. --mikej -=-- mike jackson [EMAIL PROTECTED] -Original Message- From: Sonny Sukumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 3:25 PM To: [EMAIL PROTECTED] Subject: Tomcat mysteriously stops responding... Hey guys, I've had the persistent problem with Tomcat (using Cocoon) over some months now where when I go to bed at night my Tomcat/Cocoon server is functioning just fine and I can access all web pages, both static and dynamically generated (from a backend db). But when I wake up and try to access the pages the connection just times out and I get a totally blank response. This doesn't happen every single day, but often enough to be annoying. We're soon going live with the site, so this happening **at all** is a scary thought. I can't seem to figure out what the problem could be. I'm fairly sure it's Tomcat because restarting Tomcat almost always solves the problem. I've had this problem through all my Tomcat upgrades (4.1.12 all the way to 4.1.27 now) and my Cocoon upgrades (from 2.0.x all the way until latest 2.1.2). Has anybody else experienced this? Any idea what it could be? Thanks! Sonny __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat mysteriously stops responding...
Interesting observation. I think you might be onto something, but let's explore it a bit further. I'm using DBCP with a MySQL backend database. I don't really get why Tomcat would stop responding though after several hours of idle time though. You think it's because after all those hours of idle time the # of db connections is 0? I thought the connection pool could handle that and create a new connection when needed. I think I'm not understanding though...do enlighten me. :-) Thanks for your help, Sonny --- mike jackson [EMAIL PROTECTED] wrote: When this has happened to me it's usually been the database connection pool that I'm using. Or was using. If it looks like you had a bunch of connections prior to the restart and very few after then you've found your culprit. You database should be able to give you a connection count, but the way to get it depends on the database so I can't help you there. --mikej -=-- mike jackson [EMAIL PROTECTED] -Original Message- From: Sonny Sukumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 3:25 PM To: [EMAIL PROTECTED] Subject: Tomcat mysteriously stops responding... Hey guys, I've had the persistent problem with Tomcat (using Cocoon) over some months now where when I go to bed at night my Tomcat/Cocoon server is functioning just fine and I can access all web pages, both static and dynamically generated (from a backend db). But when I wake up and try to access the pages the connection just times out and I get a totally blank response. This doesn't happen every single day, but often enough to be annoying. We're soon going live with the site, so this happening **at all** is a scary thought. I can't seem to figure out what the problem could be. I'm fairly sure it's Tomcat because restarting Tomcat almost always solves the problem. I've had this problem through all my Tomcat upgrades (4.1.12 all the way to 4.1.27 now) and my Cocoon upgrades (from 2.0.x all the way until latest 2.1.2). Has anybody else experienced this? Any idea what it could be? Thanks! Sonny __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat mysteriously stops responding...
Figure out the answers to the following and you'll probably figure out what's causing the problem: (1) When Tomcat is frozen, can you interact with the Admin/Manager apps? (2) When it's frozen, do any non-database requests succeed (such as an image served through Tomcat's default servlet)? (3) Do you have any custom threads that could be getting locked up under certain cases? (4) If you get a thread dump when it's frozen, what do you see? Spinning threads? Deadlocks? Nothing interesting? (5) Bump you logging levels up. When your app gets frozen, does any logging appear at all? (6) If it looks like it's a db thing, are you able to connect to your database through a different app when your webApp is frozen? (7) Is anyone using the app between the time you go to bed and wake up? Some action (either user or system) is causing the hang -- what is it? Just something to get you started. Since you've seen this on various versions of Tomcat and Cocoon (and there's no accepted issues with this happening, to the best of my knowledge), I'd put my money on your app/deployment/network as the culprit. Let us know what you find... justin At 05:26 PM 10/22/2003, you wrote: Interesting observation. I think you might be onto something, but let's explore it a bit further. I'm using DBCP with a MySQL backend database. I don't really get why Tomcat would stop responding though after several hours of idle time though. You think it's because after all those hours of idle time the # of db connections is 0? I thought the connection pool could handle that and create a new connection when needed. I think I'm not understanding though...do enlighten me. :-) Thanks for your help, Sonny --- mike jackson [EMAIL PROTECTED] wrote: When this has happened to me it's usually been the database connection pool that I'm using. Or was using. If it looks like you had a bunch of connections prior to the restart and very few after then you've found your culprit. You database should be able to give you a connection count, but the way to get it depends on the database so I can't help you there. --mikej -=-- mike jackson [EMAIL PROTECTED] -Original Message- From: Sonny Sukumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 3:25 PM To: [EMAIL PROTECTED] Subject: Tomcat mysteriously stops responding... Hey guys, I've had the persistent problem with Tomcat (using Cocoon) over some months now where when I go to bed at night my Tomcat/Cocoon server is functioning just fine and I can access all web pages, both static and dynamically generated (from a backend db). But when I wake up and try to access the pages the connection just times out and I get a totally blank response. This doesn't happen every single day, but often enough to be annoying. We're soon going live with the site, so this happening **at all** is a scary thought. I can't seem to figure out what the problem could be. I'm fairly sure it's Tomcat because restarting Tomcat almost always solves the problem. I've had this problem through all my Tomcat upgrades (4.1.12 all the way to 4.1.27 now) and my Cocoon upgrades (from 2.0.x all the way until latest 2.1.2). Has anybody else experienced this? Any idea what it could be? Thanks! Sonny __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Justin Ruthenbeck Software Engineer, NextEngine Inc. justinr - AT - nextengine DOT com Confidential See http://www.nextengine.com/confidentiality.php - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]