Frequent Crashing

jim_frey · Post by **jim_frey** » Mon Dec 04, 2006 4:32 pm

I have OpenEMM installed on a CentOS machine. When OpenEMM is working, it's awesome, but it seems to crash every couple days. I have to then log into the machine, stop and start OpenEMM, and then it seems fine again.

It's not always the same error that comes up (I'll have to start posting the errors now.)

Is anyone else having problems with the application being stable? This is an awesome application, it's just I can't quite trust it to be stable yet.

jim_frey · Post by **jim_frey** » Sat Dec 09, 2006 10:54 pm

Here's the error I see today ---

Ein Fehler ist aufgetreten
Ursache: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot get a connection, pool exhausted; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted

I rebooted it and everything seems fine again.

jim_frey · Post by **jim_frey** » Tue Dec 12, 2006 6:39 pm

Maybe someone should look into...
http://news.yahoo.com/s/pcworld/2006121 ... rld/128129

jim_frey · Post by **jim_frey** » Sun Dec 17, 2006 3:22 pm

It crashed again, here's the error message ---

Ein Fehler ist aufgetreten
Ursache: javax.servlet.ServletException: javax.servlet.jsp.JspTagException: Error: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted

Post by **maschoff** » Mon Dec 18, 2006 9:42 am

Every once in a while there seems to be a problem with Hibernate under load. We are aware of this problem and are checking the Hibernate configuration right now. We will provide you with either a change of the configuration or revised code in the next release of OpenEMM.

jim_frey · Post by **jim_frey** » Sat Dec 23, 2006 4:57 pm

Here's the error I got today. The crashing seems to happen when I check the recipient statistics.

Ein Fehler ist aufgetreten
Ursache: javax.servlet.ServletException: javax.servlet.jsp.JspTagException: Error: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted

Post by **maschoff** » Sat Dec 23, 2006 7:29 pm

The only workaround right now is a periodic restart of OpenEMM - once per day for instance.

We will fix the problem in the next version of OpenEMM.

jim_frey · Post by **jim_frey** » Tue Dec 26, 2006 8:16 pm

Alright, I'll just write a shell script for now. It's a really cool application, thanks for the help.

jim_frey · Post by **jim_frey** » Fri Jan 26, 2007 3:20 pm

Ever since I started sending 17K emails a day to my regular mailing list, the problem went away.

danieljones2006 · Post by **danieljones2006** » Sun Aug 29, 2010 6:24 am

I think the flaw of being unstable has been solved lang back. One doesn't have to worry anymore.

jihuang · Post by **jihuang** » Tue Dec 21, 2010 9:34 pm

i am seeing this problem at version 6.1, can anyone tell me what do i need to do in order to fix it?

An error occurred
Cause: javax.servlet.ServletException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot get a connection, pool exhausted; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted

SoBeverly · Post by **SoBeverly** » Wed Jun 15, 2011 9:18 am

jihuang wrote:i am seeing this problem at version 6.1, can anyone tell me what do i need to do in order to fix it?

An error occurred
Cause: javax.servlet.ServletException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot get a connection, pool exhausted; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted

Same here! Are there any suggestions?

change wav to mp3
wav to mp3 converter

Post by **maschoff** » Wed Jun 15, 2011 9:26 am

Please describe the version you use and the situation that leads to this error message.

bit-factory · Post by **bit-factory** » Sun Jul 03, 2011 9:43 am

SoBeverly wrote:
jihuang wrote:i am seeing this problem at version 6.1, can anyone tell me what do i need to do in order to fix it?

An error occurred
Cause: javax.servlet.ServletException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot get a connection, pool exhausted; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
Same here! Are there any suggestions?

change wav to mp3
wav to mp3 converter

We are also encountering a similar problem with 6.2.

OpenEMMVersion: 6.2
System: Ubuntu Server 2.6.38-8-server

While sending out a mailing with ~8k recipients yesterday we noticed that the statistics page was not accessible any more. It just does not stop loading and blocks any other action so the only way to be able to do something else in the interface is to close the tab and relogin.
Also the unsubscribe and change profile links in the mailing lead to the page where Openemm recognizes the klick and should forward the user to the related form. Also no further action here, it just keeps loading and terminates with a timeout.
In our test runs before sending the mailing every function described above was tested and running properly.
On the other hand normal links inside the mailing which are also routed over Openemm seem to work fine.

After 2-3 hours while sending, openemm started crashing. The result is the same error as stated in the previous posts:

Cause: javax.servlet.ServletException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot get a connection, pool exhausted; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted

After stopping and starting Openemm the mailing continued sending and the interface was accessible again except of statistics and forms. It also continued crashing at about 2-3 hours.
We only send 200 mails per 20 minutes so there should not be any "heavy load" on hibernate i guess.

Probably interesting at this point is the fact that also statistics of previous mailings are also not available any more. They also were fine before sending the mailing.
The mailing is sent now but the problem is still present.

Our next step is to turn up Tomcat's log level as we could not find anything in /home/openemm/var/log or /var/log/tomcat6/catalina.out. But we also wanted to ask here if this error is already known.

Thank you very much

Ps:
Before the error occoured we already sent a mailing to the same recipients a month ago without any problems. What has happend since then is that we once deleted all recipients from the database and reimported them (nearly the same dataset with some minor changes). We also set up Bounce Filters for the mailings.

Post by **maschoff** » Sun Jul 03, 2011 10:18 am

OpenEMM was never tested with Tomcat. You should either use Resin (provided with the binary tarball) or switch to OpenEMM 2011 (which does run with Tomcat).

The error message simply indicates that OpenEMM can not access MySQL any longer because the connection pool ran out of connections. See section 5.7 of the OpenEMM Install Guide on how to increase the pool size. And to understand the reason behind you should have a look at the log files.

OpenEMM Technical Support Forum

Frequent Crashing

Frequent Crashing

Hibernate problems

Cannot get a connection, pool exhausted

Re:

Re: Frequent Crashing

Re: Re:

Re: Frequent Crashing