Hi all: I recentlty installed OM 3.0.3 and everything seems to work perfectly. But after starting the application, the logs begins to be populated with messages like this one:
*ERROR 03-02 13:32:15.233 o.a.o.d.d.b.ConfigurationDao:144 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-7] - cannot be cast to return type, you have misconfigured your configuration CONF_KEY: smtp_server* *org.apache.openjpa.persistence.PersistenceException: Communications link failure* *The last packet successfully received from the server was 34.928 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.* * at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4974) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4934) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:108) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:60) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connect(JDBCStoreManager.java:968) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getConnection(JDBCStoreManager.java:242) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:415) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:393) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:275) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:291) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:99) ~[openmeetings-db-3.0.3-RELEASE.jar:na]* * at org.apache.openmeetings.db.dao.basic.ConfigurationDao.getConfValue(ConfigurationDao.java:120) ~[openmeetings-db-3.0.3-RELEASE.jar:na]* * at org.apache.openmeetings.db.dao.basic.ConfigurationDao$$FastClassBySpringCGLIB$$2f9526f2.invoke(<generated>) [spring-core-4.0.6.RELEASE.jar:na]* * at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [spring-core-4.0.6.RELEASE.jar:4.0.6.RELEASE]* * at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708) [spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE]* * at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE]* * at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) [spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]* * at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262) [spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]* * at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) [spring-tx-jar-4.0.6.RELEASE.jar:4.0.6.RELEASE]* * at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE]* * at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) [spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE]* * at org.apache.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerBySpringCGLIB$$a14e5412.getConfValue(<generated>) [spring-core-4.0.6.RELEASE.jar:na]* * at org.apache.openmeetings.mail.MailHandler.init(MailHandler.java:88) [openmeetings-core-3.0.3-RELEASE.jar:na]* * at org.apache.openmeetings.mail.MailHandler.sendMails(MailHandler.java:257) [openmeetings-core-3.0.3-RELEASE.jar:na]* * at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_13]* * at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_13]* * at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_13]* * at java.lang.reflect.Method.invoke(Method.java:601) ~[na:1.7.0_13]* * at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:269) [spring-core-4.0.6.RELEASE.jar:4.0.6.RELEASE]* * at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:322) [spring-context-support-4.0.6.RELEASE.jar:4.0.6.RELEASE]* * at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:112) [spring-context-support-4.0.6.RELEASE.jar:4.0.6.RELEASE]* * at org.quartz.core.JobRunShell.run(JobRunShell.java:213) [quartz-2.1.7.jar:na]* * at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) [quartz-2.1.7.jar:na]* *Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure* *The last packet successfully received from the server was 34.928 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.* * at sun.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source) ~[na:na]* * at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_13]* * at java.lang.reflect.Constructor.newInstance(Constructor.java:525) ~[na:1.7.0_13]* * at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java.jar:na]* * at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) ~[mysql-connector-java.jar:na]* * at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090) ~[mysql-connector-java.jar:na]* * at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979) ~[mysql-connector-java.jar:na]* * at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520) ~[mysql-connector-java.jar:na]* * at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) ~[mysql-connector-java.jar:na]* * at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) ~[mysql-connector-java.jar:na]* * at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619) ~[mysql-connector-java.jar:na]* * at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4997) ~[mysql-connector-java.jar:na]* * at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371) ~[commons-dbcp-jar-1.4.jar:1.4]* * at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371) ~[commons-dbcp-jar-1.4.jar:1.4]* * at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328) ~[commons-dbcp-jar-1.4.jar:1.4]* * at org.apache.openjpa.lib.jdbc.DelegatingConnection.setAutoCommit(DelegatingConnection.java:167) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.lib.jdbc.DelegatingConnection.setAutoCommit(DelegatingConnection.java:167) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.setAutoCommit(ConfiguringConnectionDecorator.java:117) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.<init>(ConfiguringConnectionDecorator.java:111) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator.decorate(ConfiguringConnectionDecorator.java:93) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.lib.jdbc.DecoratingDataSource.decorate(DecoratingDataSource.java:99) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:88) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connectInternal(JDBCStoreManager.java:979) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connect(JDBCStoreManager.java:964) ~[openjpa-bundle-2.3.0.jar:2.3.0]* * ... 38 common frames omitted* *Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.* * at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540) ~[mysql-connector-java.jar:na]* * at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990) ~[mysql-connector-java.jar:na]* After a couple of hours later, OM can't get a connection from the database and the application remains out of service until I reboot it... It should not be a problem of too many database connections as it is a testing installation with hardly no users yet... Thank's and regards.
