I'm getting the following (derby_persistence.xml is used):
org.springframework.transaction.CannotCreateTransactionException:
Could not open JPA EntityManager for transaction; nested exception is
<openjpa-2.2.1-r422266:1396819 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: ALTER TABLE
statement cannot add an IDENTITY column to a table. {stmnt 1208085072
ALTER TABLE adresses ADD id BIGINT GENERATED BY DEFAULT AS IDENTITY}
[code=30000, state=42601]
at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransact
ionManager.java:427) ~[org.springframework.orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEA
SE]
at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.getTransaction(AbstractPlatformTransactionManager.java:371) ~[org.springfr
amework.transaction-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
No successful interaction with a database is performed.
--
With best regards / с наилучшими пожеланиями,
Alexei Fedotov / Алексей Федотов,
http://dataved.ru/
+7 916 562 8095
On Mon, Dec 10, 2012 at 7:24 PM, Mikael Kurula <[email protected]> wrote:
> Thanks, Solomax! I'm very grateful for your speedy and constant help! I
> created an issue in JIRA about the MySQL timeouts.
>
> I now tried switching back to Derby by renaming derby_persistence to
> persistence and restarting the OM server. Fine. Then I tried connecting with
> the web browser and I got the attached error message. In the log I got the
> curses below.
>
> Friendly greetings,
> Mikael
>
>
>
>
>
>
> WARN 12-10 17:19:02.610 Configurationmanagement.java 94426 104
> org.openmeetings.app.data.basic.Configurationmanagement [http-0.0.0.0-5080-1]
> - Could not find key in configuration CONF_KEY: application.name
> DEBUG 12-10 17:19:13.241 ScopeApplicationAdapter.java 105057 181
> org.openmeetings.app.remote.red5.ScopeApplicationAdapter [NioProcessor-2] -
> roomConnect :
> DEBUG 12-10 17:19:13.241 ScopeApplicationAdapter.java 105057 193
> org.openmeetings.app.remote.red5.ScopeApplicationAdapter [NioProcessor-2] -
> ### Client connected to OpenMeetings, register Client StreamId: 0 scope
> hibernate isAVClient false
> DEBUG 12-10 17:19:13.242 ScopeApplicationAdapter.java 105058 195
> org.openmeetings.app.remote.red5.ScopeApplicationAdapter [NioProcessor-2] -
> params [Ljava.lang.Object;@7aee513
> DEBUG 12-10 17:19:13.245 ManageCryptStyle.java 105061 41
> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] -
> getInstanceOfCrypt: org.openmeetings.utils.crypt.ManageCryptStyle@6a5d5a2c
> DEBUG 12-10 17:19:13.247 ManageCryptStyle.java 105063 43
> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] -
> getInstanceOfCrypt:
> org.openmeetings.app.data.basic.Configurationmanagement@77158bbe
> DEBUG 12-10 17:19:13.249 ManageCryptStyle.java 105065 50
> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] -
> configKeyCryptClassName: null
> ERROR 12-10 17:19:13.253 ManageCryptStyle.java 105069 58
> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] -
> [getInstanceOfCrypt]
> java.lang.NullPointerException: null
> at java.lang.Class.forName0(Native Method) ~[na:1.6.0_37]
> at java.lang.Class.forName(Unknown Source) ~[na:1.6.0_37]
> at
> org.openmeetings.utils.crypt.ManageCryptStyle.getInstanceOfCrypt(ManageCryptStyle.java:52)
> ~[openmeetings-2.0.0-RELEASE.jar:na]
> at
> org.openmeetings.app.remote.red5.ClientListManager.addClientListItem(ClientListManager.java:88)
> [openmeetings-2.0.0-RELEASE.jar:na]
> at
> org.openmeetings.app.remote.red5.ScopeApplicationAdapter.roomConnect(ScopeApplicationAdapter.java:205)
> [openmeetings-2.0.0-RELEASE.jar:na]
> at
> org.red5.server.adapter.MultiThreadedApplicationAdapter.connect(MultiThreadedApplicationAdapter.java:326)
> [red5.jar:na]
> at
> org.red5.server.adapter.ApplicationAdapter.connect(ApplicationAdapter.java:42)
> [red5.jar:na]
> at org.red5.server.scope.Scope.connect(Scope.java:256) [red5.jar:na]
> at org.red5.server.BaseConnection.connect(BaseConnection.java:326)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPConnection.connect(RTMPConnection.java:278)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPMinaConnection.connect(RTMPMinaConnection.java:87)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:268)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164)
> [red5.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124)
> [red5.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
> [mina-core-2.0.4.jar:na]
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> Source) [na:1.6.0_37]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> [na:1.6.0_37]
> at java.lang.Thread.run(Unknown Source) [na:1.6.0_37]
> ERROR 12-10 17:19:13.254 ClientListManager.java 105070 109
> org.openmeetings.app.remote.red5.ClientListManager [NioProcessor-2] -
> [addClientListItem]
> java.lang.NullPointerException: null
> at
> org.openmeetings.app.remote.red5.ClientListManager.addClientListItem(ClientListManager.java:88)
> ~[openmeetings-2.0.0-RELEASE.jar:na]
> at
> org.openmeetings.app.remote.red5.ScopeApplicationAdapter.roomConnect(ScopeApplicationAdapter.java:205)
> [openmeetings-2.0.0-RELEASE.jar:na]
> at
> org.red5.server.adapter.MultiThreadedApplicationAdapter.connect(MultiThreadedApplicationAdapter.java:326)
> [red5.jar:na]
> at
> org.red5.server.adapter.ApplicationAdapter.connect(ApplicationAdapter.java:42)
> [red5.jar:na]
> at org.red5.server.scope.Scope.connect(Scope.java:256) [red5.jar:na]
> at org.red5.server.BaseConnection.connect(BaseConnection.java:326)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPConnection.connect(RTMPConnection.java:278)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPMinaConnection.connect(RTMPMinaConnection.java:87)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:268)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164)
> [red5.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124)
> [red5.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
> [mina-core-2.0.4.jar:na]
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> Source) [na:1.6.0_37]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> [na:1.6.0_37]
> at java.lang.Thread.run(Unknown Source) [na:1.6.0_37]
> ERROR 12-10 17:19:13.256 ScopeApplicationAdapter.java 105072 217
> org.openmeetings.app.remote.red5.ScopeApplicationAdapter [NioProcessor-2] -
> roomJoin
> java.lang.NullPointerException: null
> at
> org.openmeetings.app.remote.red5.ScopeApplicationAdapter.roomConnect(ScopeApplicationAdapter.java:210)
> ~[na:na]
> at
> org.red5.server.adapter.MultiThreadedApplicationAdapter.connect(MultiThreadedApplicationAdapter.java:326)
> [red5.jar:na]
> at
> org.red5.server.adapter.ApplicationAdapter.connect(ApplicationAdapter.java:42)
> [red5.jar:na]
> at org.red5.server.scope.Scope.connect(Scope.java:256) [red5.jar:na]
> at org.red5.server.BaseConnection.connect(BaseConnection.java:326)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPConnection.connect(RTMPConnection.java:278)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPMinaConnection.connect(RTMPMinaConnection.java:87)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:268)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164)
> [red5.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124)
> [red5.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
> [mina-core-2.0.4.jar:na]
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> Source) [na:1.6.0_37]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> [na:1.6.0_37]
> at java.lang.Thread.run(Unknown Source) [na:1.6.0_37]
> DEBUG 12-10 17:19:13.335 Sessionmanagement.java 105151 73
> org.openmeetings.app.data.basic.Sessionmanagement [NioProcessor-2] -
> startsession :: startsession
> DEBUG 12-10 17:19:13.335 ManageCryptStyle.java 105151 41
> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] -
> getInstanceOfCrypt: org.openmeetings.utils.crypt.ManageCryptStyle@6a5d5a2c
> DEBUG 12-10 17:19:13.336 ManageCryptStyle.java 105152 43
> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] -
> getInstanceOfCrypt:
> org.openmeetings.app.data.basic.Configurationmanagement@77158bbe
> DEBUG 12-10 17:19:13.336 ManageCryptStyle.java 105152 50
> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] -
> configKeyCryptClassName: null
> ERROR 12-10 17:19:13.337 ManageCryptStyle.java 105153 58
> org.openmeetings.utils.crypt.ManageCryptStyle [NioProcessor-2] -
> [getInstanceOfCrypt]
> java.lang.NullPointerException: null
> at java.lang.Class.forName0(Native Method) ~[na:1.6.0_37]
> at java.lang.Class.forName(Unknown Source) ~[na:1.6.0_37]
> at
> org.openmeetings.utils.crypt.ManageCryptStyle.getInstanceOfCrypt(ManageCryptStyle.java:52)
> ~[openmeetings-2.0.0-RELEASE.jar:na]
> at
> org.openmeetings.app.data.basic.Sessionmanagement.startsession(Sessionmanagement.java:77)
> [openmeetings-2.0.0-RELEASE.jar:na]
> at
> org.openmeetings.app.data.basic.Sessionmanagement$$FastClassByCGLIB$$3de5b4e4.invoke(<generated>)
> [cglib-jar-2.2.2.jar:na]
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
> [cglib-jar-2.2.2.jar:na]
> at
> org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
> [org.springframework.transaction-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
> org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
> org.openmeetings.app.data.basic.Sessionmanagement$$EnhancerByCGLIB$$b669a81.startsession(<generated>)
> [cglib-jar-2.2.2.jar:na]
> at
> org.openmeetings.app.remote.MainService.getsessiondata(MainService.java:205)
> [openmeetings-2.0.0-RELEASE.jar:na]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.6.0_37]
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> ~[na:1.6.0_37]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> ~[na:1.6.0_37]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_37]
> at
> org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:196)
> [red5.jar:na]
> at
> org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:115)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:157)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:399)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164)
> [red5.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124)
> [red5.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
> [mina-core-2.0.4.jar:na]
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> Source) [na:1.6.0_37]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> [na:1.6.0_37]
> at java.lang.Thread.run(Unknown Source) [na:1.6.0_37]
> ERROR 12-10 17:19:13.339 Sessionmanagement.java 105155 87
> org.openmeetings.app.data.basic.Sessionmanagement [NioProcessor-2] -
> [startsession]:
> java.lang.NullPointerException: null
> at
> org.openmeetings.app.data.basic.Sessionmanagement.startsession(Sessionmanagement.java:77)
> ~[openmeetings-2.0.0-RELEASE.jar:na]
> at
> org.openmeetings.app.data.basic.Sessionmanagement$$FastClassByCGLIB$$3de5b4e4.invoke(<generated>)
> [cglib-jar-2.2.2.jar:na]
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
> [cglib-jar-2.2.2.jar:na]
> at
> org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
> [org.springframework.transaction-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
> org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at
> org.openmeetings.app.data.basic.Sessionmanagement$$EnhancerByCGLIB$$b669a81.startsession(<generated>)
> [cglib-jar-2.2.2.jar:na]
> at
> org.openmeetings.app.remote.MainService.getsessiondata(MainService.java:205)
> [openmeetings-2.0.0-RELEASE.jar:na]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.6.0_37]
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> ~[na:1.6.0_37]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> ~[na:1.6.0_37]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_37]
> at
> org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:196)
> [red5.jar:na]
> at
> org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:115)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:157)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:399)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130)
> [red5.jar:na]
> at
> org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164)
> [red5.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124)
> [red5.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141)
> [mina-core-2.0.4.jar:na]
> at
> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
> [mina-core-2.0.4.jar:na]
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> Source) [na:1.6.0_37]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> [na:1.6.0_37]
> at java.lang.Thread.run(Unknown Source) [na:1.6.0_37]
> DEBUG 12-10 17:19:13.517 ClientListManager.java 105333 121
> org.openmeetings.app.remote.red5.ClientListManager [NioProcessor-2] - Tried
> to get a non existing Client 0
> DEBUG 12-10 17:19:14.399 ScopeApplicationAdapter.java 106215 519
> org.openmeetings.app.remote.red5.ScopeApplicationAdapter [NioProcessor-2] -
> roomLeave 0 0 /openmeetings/hibernate hibernate
> DEBUG 12-10 17:19:14.400 ClientListManager.java 106216 121
> org.openmeetings.app.remote.red5.ClientListManager [NioProcessor-2] - Tried
> to get a non existing Client 0
> DEBUG 12-10 17:19:26.687 MeetingReminderJob.java 118503 34
> org.openmeetings.app.quartz.scheduler.MeetingReminderJob
> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] -
> MeetingReminderJob.execute
> WARN 12-10 17:19:26.688 Configurationmanagement.java 118504 104
> org.openmeetings.app.data.basic.Configurationmanagement
> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] -
> Could not find key in configuration CONF_KEY: number.minutes.reminder.send
> DEBUG 12-10 17:19:26.690 AppointmentDaoImpl.java 118506 931
> org.openmeetings.app.data.calendar.daos.AppointmentDaoImpl
> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] -
> startStamp 2012-12-10 17:19:26.689
> DEBUG 12-10 17:19:26.690 AppointmentDaoImpl.java 118506 932
> org.openmeetings.app.data.calendar.daos.AppointmentDaoImpl
> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] -
> stopStamp 2012-12-10 17:34:26.689
> DEBUG 12-10 17:19:26.694 AppointmentLogic.java 118510 408
> org.openmeetings.app.data.calendar.management.AppointmentLogic
> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] -
> doScheduledMeetingReminder : no Appointments in range
>
>
>
>
>
>
> On 2012.10.12, at 15:31, Maxim Solodovnik wrote:
>
>> Hello Mikael,
>>
>> I can point to the 2 MySQL advantages:
>> 1 it performs faster
>> 2 you can query it while OM is running :)
>>
>> If you don't like MySQL you can use postgres or oracle, or write
>> persistence.xml to the DB of your choice :)
>>
>> I never saw timeout issues with MySQL. But feel free to file JIRA issue if
>> you feel you found a bug :)
>>
>> On Dec 10, 2012 7:57 PM, "Mikael Kurula" <[email protected]> wrote:
>> Hi again!
>>
>> Now I had no problems with recordings and mysql timeouts, even if I don't
>> think the OM server has been used for days.
>>
>> Anyway, since poor reliability was the only reason for me to switch away
>> from the previous web conference software I was using, I'm not happy with
>> the prospect of losing OM-recordings because of mysql timeouts. Therefore I
>> now ask: why is mysql recommended? What are the drawbacks of using the
>> default derby persistence?
>>
>> Another question: I find it a bit difficult to follow the discussions here
>> in the mailing list. Besides, this seems to be a clear bug, not an issue
>> about how to use OM. Should I file a bug report in the issue tracker? Also,
>> after some testing I might have a few other bugs and feature requests to
>> report.
>>
>> Friendly greetings,
>> Mikael
>>
>>
>> On 2012.4.12, at 10:44, Mikael Kurula wrote:
>>
>> > That's unfortunate... If it's of any help, then I'm using a CentOS 6
>> > server with the following version of mysql:
>> >
>> > mysql Ver 14.14 Distrib 5.1.66, for redhat-linux-gnu (x86_64) using
>> > readline 5.1
>> >
>> > My version of openmeetings is this:
>> > apache-openmeetings-incubating-2.0.0.r1361497-14-07-2012_1108.tar.gz
>> >
>> > and the version of the J connector is mysql-connector-java-5.1.22.tar.gz
>> >
>> > Mikael
>> >
>> >
>> > On 4 December 2012 10:16, Maxim Solodovnik <[email protected]> wrote:
>> > We are using OpenJPA (not Hibernate)
>> > and already have "TestOnBorrow=true" and DB connection pool :(
>> > not sure what else can be done ... Never saw such exception on my machines
>> > :(
>> >
>> >
>> > On Tue, Dec 4, 2012 at 3:03 PM, Mikael Kurula <[email protected]> wrote:
>> > Good morning!
>> >
>> > Very nice to see that this issue generates interest. By googling I found
>> > these discussions:
>> >
>> > http://wiki.pentaho.com/display/ServerDoc2x/Configuring+for+MySQL
>> > http://www.coderanch.com/t/564390/Tomcat/CommunicationsException-tomcat-mysql
>> >
>> > I would assume this is the problem. Can the solution outlined in the first
>> > link solve the problem for OM as well?
>> >
>> > Friendly greetings,
>> > Mikael
>> >
>> >
>> >
>> > On 3 December 2012 20:08, Mahmut TEKER <[email protected]> wrote:
>> > Hi,
>> >
>> > There is a connection between this error (or info) and recording and
>> > sharing of the OM (or I guess like that). I have the same problem on
>> > recordings and I am taking same response about com.mysql.jdbc... kind of
>> > reports from the system. I have also checked that "autoReconnect=true"
>> > option is already given on the connection string and also checked the
>> > permission or the connection of mysql server but could not find a proper
>> > solution. Is there a bit more specific information about error message?
>> >
>> > Thanks,
>> >
>> > _Mahmut
>> >
>> >
>> > On 12/3/2012 2:25 PM, Mikael Kurula wrote:
>> > Hi again!
>> >
>> >
>> > Today I have another question. As I understand, it is recommended to
>> > integrate OpenMeetings with MySQL. This I did, but it seems I run into
>> > problems with MySQL timeouts because of inactivity overnight, getting the
>> > following error message in the openmeetings.log:
>> >
>> > Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The
>> > last packet successfully received from the server was 90,881,924
>> > milliseconds ago. The last packet sent successfully to the server was
>> > 90,881,924 milliseconds ago. is longer than the server configured value of
>> > 'wait_timeout'. You should consider either expiring and/or testing
>> > connection validity before use in your application, increasing the server
>> > configured values for client timeouts, or using the Connector/J connection
>> > property 'autoReconnect=true' to avoid this problem.
>> >
>> > I found rather conflicting information on the appropriateness of setting
>> > autoReconnect=true when I googled. What is the recommended way of dealing
>> > with this in OpenMeetings?
>> >
>> >
>> > I don't know if it is related or not, but these errors showed up when I
>> > finished a test recording. Then when I tried to go and watch the
>> > recording, I only get "The recording is not yet ready for watching" and it
>> > seems the recording didn't consume any disk space.
>> >
>> >
>> > Id' be most grateful for any help!
>> >
>> > Mikael
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > --
>> > WBR
>> > Maxim aka solomax
>> >
>>
>
>
