can you check the system log regarding any kernel messages regarding killing processes etc. ?
On Mon, Mar 2, 2015 at 7:27 PM, Manu <[email protected]> wrote: > Hi Maxim: > > Thanks for your quick reply. Yes, I have installed it after unpacking and > I am able to login to OM, manage users, rooms, config etc... I can access > db via command-line with no problem too... It is really strange... > > Thanks. > > On 2 March 2015 at 14:10, Maxim Solodovnik <[email protected]> wrote: > >> What do you mean by "installed OM 3.0.3 and everything seems to work >> perfectly" >> Were you able to login to OM? Have you installed it after unpacking? >> >> can you check your values from persistence.xml using command-line mysql >> client: >> >> mysql -u*user* --host *host* -p *database* >> (please replace everything in bold with your values from persistence.xml) >> >> >> On Mon, Mar 2, 2015 at 6:53 PM, Manu <[email protected]> wrote: >> >>> 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. >>> >>> >>> >> >> >> -- >> WBR >> Maxim aka solomax >> > > -- WBR Maxim aka solomax
