Exceptions after idle for several hours

[Wayne]

OS: CentOS v5
OpenMeeting v0.7rc1 and previous
Red5: r3200 snapshot

Here is a description of our problem...

- OpenMeetings sits idle for several hours.
- Scenario 1: Crash when navigating between OpenMeeting pages--never
while in a meeting room.
- Scenario 2: Unable to make an initial connection--OpenMeeting
already crashed.
- Red5 is still up and running (can access demo applications).
- Red5 error log indicates (I think) that OpenMeeting was unable to
communicate with MySQL.
- MySQL database appears to be operating normally (access from console
is OK).
- Restarting Red5 restores access to OpenMeeting.

I've included excerpts from the Red5 error log file for Scenario 1 and
Scenario 2. Can anyone confirm my guess that this is a communications
problem with MySQL?

Any suggestions? Thanks for your help.


Scenario 1 ==========================================
2009-01-30 00:00:17,589 [pool-4-thread-13] ERROR
o.o.app.remote.ConferenceService - ConferenceService.java 23315726 88
org.openmeetings.app.remote.ConferenceService [pool-4-thread-13] -
getRoomsPublic user_level: 1
2009-01-30 00:00:17,590 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23315727 277
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- getPublicRooms: roomtypes_id 1
2009-01-30 00:00:17,590 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23315727 279
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: create Query 1
2009-01-30 00:00:17,594 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23315731 302
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: size Room List 3
2009-01-30 00:01:14,526 [pool-4-thread-13] ERROR
o.o.app.data.user.Usermanagement - LdapLoginManagement.java 23372663
80 org.openmeetings.app.data.user.Usermanagement [pool-4-thread-13] -
Error retrieving ConfigKey ldap_config_path!
2009-01-30 00:01:17,250 [pool-4-thread-13] ERROR
o.o.app.data.basic.Navimanagement - Navimanagement.java 23375387 75
org.openmeetings.app.data.basic.Navimanagement [pool-4-thread-13] -
getMainMenu 5
2009-01-30 00:01:44,978 [pool-4-thread-13] ERROR
o.o.app.remote.ConferenceService - ConferenceService.java 23403115 88
org.openmeetings.app.remote.ConferenceService [pool-4-thread-13] -
getRoomsPublic user_level: 3
2009-01-30 00:01:44,979 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23403116 277
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- getPublicRooms: roomtypes_id 1
2009-01-30 00:01:44,979 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23403116 279
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: create Query 1
2009-01-30 00:01:44,983 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23403120 302
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: size Room List 3
2009-01-30 00:01:47,646 [pool-4-thread-13] ERROR
o.o.app.remote.ConferenceService - ConferenceService.java 23405783 88
org.openmeetings.app.remote.ConferenceService [pool-4-thread-13] -
getRoomsPublic user_level: 3
2009-01-30 00:01:47,647 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23405784 277
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- getPublicRooms: roomtypes_id 2
2009-01-30 00:01:47,648 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23405785 279
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: create Query 2
2009-01-30 00:01:47,651 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23405788 302
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: size Room List 1
2009-01-30 00:02:14,754 [pool-4-thread-13] ERROR
o.o.app.remote.ConferenceService - ConferenceService.java 23432891 88
org.openmeetings.app.remote.ConferenceService [pool-4-thread-13] -
getRoomsPublic user_level: 3
2009-01-30 00:02:14,755 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23432892 277
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- getPublicRooms: roomtypes_id 1
2009-01-30 00:02:14,756 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23432893 279
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: create Query 1
2009-01-30 00:02:14,759 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23432896 302
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: size Room List 3
2009-01-30 00:03:05,467 [pool-4-thread-13] ERROR
o.o.app.remote.ConferenceService - ConferenceService.java 23483604 88
org.openmeetings.app.remote.ConferenceService [pool-4-thread-13] -
getRoomsPublic user_level: 3
2009-01-30 00:03:05,468 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23483605 277
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- getPublicRooms: roomtypes_id 1
2009-01-30 00:03:05,468 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23483605 279
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: create Query 1
2009-01-30 00:03:05,473 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23483610 302
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: size Room List 3
2009-01-30 00:03:48,868 [pool-4-thread-13] ERROR
o.o.app.remote.ConferenceService - ConferenceService.java 23527005 88
org.openmeetings.app.remote.ConferenceService [pool-4-thread-13] -
getRoomsPublic user_level: 3
2009-01-30 00:03:48,869 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23527006 277
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- getPublicRooms: roomtypes_id 1
2009-01-30 00:03:48,870 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23527007 279
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: create Query 1
2009-01-30 00:03:48,874 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23527011 302
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: size Room List 3
2009-01-30 00:05:57,201 [pool-4-thread-13] ERROR
o.o.app.remote.ConferenceService - ConferenceService.java 23655338 88
org.openmeetings.app.remote.ConferenceService [pool-4-thread-13] -
getRoomsPublic user_level: 3
2009-01-30 00:05:57,202 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23655339 277
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- getPublicRooms: roomtypes_id 1
2009-01-30 00:05:57,202 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23655339 279
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: create Query 1
2009-01-30 00:05:57,207 [pool-4-thread-13] ERROR
o.o.a.d.conference.Roommanagement - Roommanagement.java 23655344 302
org.openmeetings.app.data.conference.Roommanagement [pool-4-thread-13]
- ### getPublicRooms: size Room List 3
2009-01-30 00:08:39,891 [pool-4-thread-13] ERROR
o.o.app.data.user.Usermanagement - LdapLoginManagement.java 23818028
80 org.openmeetings.app.data.user.Usermanagement [pool-4-thread-13] -
Error retrieving ConfigKey ldap_config_path!
2009-01-30 00:08:42,708 [pool-4-thread-13] ERROR
o.o.app.data.basic.Navimanagement - Navimanagement.java 23820845 75
org.openmeetings.app.data.basic.Navimanagement [pool-4-thread-13] -
getMainMenu 5
2009-01-30 00:09:45,742 [pool-4-thread-13] ERROR
o.o.app.remote.UserService - UserService.java 23883879 268
org.openmeetings.app.remote.UserService [pool-4-thread-13] -
saveOrUpdateUser7: 300
2009-01-30 00:09:45,744 [pool-4-thread-13] ERROR
o.o.app.data.user.Emailmanagement - Emailmanagement.java 23883881 388
org.openmeetings.app.data.user.Emailmanagement [pool-4-thread-13] -
checkUserMail: and...@tbd.com
2009-01-30 00:09:45,746 [pool-4-thread-13] ERROR
o.o.app.data.user.Emailmanagement - Emailmanagement.java 23883883 396
org.openmeetings.app.data.user.Emailmanagement [pool-4-thread-13] -
size: 0
2009-01-30 00:09:45,762 [pool-4-thread-13] ERROR
o.o.a.d.user.Organisationmanagement - Organisationmanagement.java
23883899 446 org.openmeetings.app.data.user.Organisationmanagement
[pool-4-thread-13] - getOrganisation_UserByUserAndOrganisation 9 1
2009-01-30 00:09:45,765 [pool-4-thread-13] ERROR
o.o.a.d.user.Organisationmanagement - Organisationmanagement.java
23883902 459 org.openmeetings.app.data.user.Organisationmanagement
[pool-4-thread-13] - getOrganisation_UserByUserAndOrganisation: 0
2009-01-30 00:09:45,768 [pool-4-thread-13] ERROR
o.o.a.d.user.Organisationmanagement - Organisationmanagement.java
23883905 415 org.openmeetings.app.data.user.Organisationmanagement
[pool-4-thread-13] - org: CAI
2009-01-30 09:18:00,025 [pool-4-thread-15] ERROR
o.h.util.JDBCExceptionReporter - JDBCExceptionReporter.java 56778162
101 org.hibernate.util.JDBCExceptionReporter [pool-4-thread-15] -
Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Broken pipe

STACKTRACE:

java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:
92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:
65)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal
(PreparedStatement.java:1313)
at com.mysql.jdbc.PreparedStatement.executeQuery
(PreparedStatement.java:1448)
at org.hibernate.jdbc.AbstractBatcher.getResultSet
(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections
(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list
(QueryTranslatorImpl.java:361)
at org.hibernate.engine.query.HQLQueryPlan.performList
(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at
org.openmeetings.app.data.basic.Fieldmanagment.getAllFieldsByLanguage
(Fieldmanagment.java:178)
at org.openmeetings.app.remote.LanguageService.getLanguageByIdAndMax
(LanguageService.java:57)
at sun.reflect.GeneratedMethodAccessor769.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:
201)
at org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:
119)
at org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:
158)
at org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:
410)
at org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived
(BaseRTMPHandler.java:146)
at org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived
(RTMPMinaIoHandler.java:126)
at org.apache.mina.common.support.AbstractIoFilterChain
$TailFilter.messageReceived(AbstractIoFilterChain.java:570)
at
org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived
(AbstractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterChain.access$1100
(AbstractIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl
$1.messageReceived(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.executor.ExecutorFilter.processEvent
(ExecutorFilter.java:220)
at org.apache.mina.filter.executor.ExecutorFilter
$ProcessEventsRunnable.run(ExecutorFilter.java:264)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask
(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run
(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)


** END NESTED EXCEPTION **



Last packet sent to the server was 3 ms ago.
2009-01-30 09:18:00,039 [pool-4-thread-15] ERROR
o.o.app.data.basic.Fieldmanagment - Fieldmanagment.java 56778176 224
org.openmeetings.app.data.basic.Fieldmanagment [pool-4-thread-15] -
[getConfKey]:
org.hibernate.exception.JDBCConnectionException: could not execute
query
at org.hibernate.exception.SQLStateConverter.convert
(SQLStateConverter.java:97)
at org.hibernate.exception.JDBCExceptionHelper.convert
(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2231)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list
(QueryTranslatorImpl.java:361)
at org.hibernate.engine.query.HQLQueryPlan.performList
(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at
org.openmeetings.app.data.basic.Fieldmanagment.getAllFieldsByLanguage
(Fieldmanagment.java:178)
at org.openmeetings.app.remote.LanguageService.getLanguageByIdAndMax
(LanguageService.java:57)
at sun.reflect.GeneratedMethodAccessor769.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:
201)
at org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:
119)
at org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:
158)
at org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:
410)
at org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived
(BaseRTMPHandler.java:146)
at org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived
(RTMPMinaIoHandler.java:126)
at org.apache.mina.common.support.AbstractIoFilterChain
$TailFilter.messageReceived(AbstractIoFilterChain.java:570)
at
org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived
(AbstractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterChain.access$1100
(AbstractIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl
$1.messageReceived(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.executor.ExecutorFilter.processEvent
(ExecutorFilter.java:220)
at org.apache.mina.filter.executor.ExecutorFilter
$ProcessEventsRunnable.run(ExecutorFilter.java:264)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask
(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run
(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link
failure due to underlying exception:


Scenario 2 ==========================================
2009-01-30 12:39:02,627 [pool-4-thread-15] ERROR
o.h.util.JDBCExceptionReporter - JDBCExceptionReporter.java 68840764
101 org.hibernate.util.JDBCExceptionReporter [pool-4-thread-15] -
Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Broken pipe

STACKTRACE:

java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:
92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:
65)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal
(PreparedStatement.java:1313)
at com.mysql.jdbc.PreparedStatement.executeQuery
(PreparedStatement.java:1448)
at org.hibernate.jdbc.AbstractBatcher.getResultSet
(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:427)
at org.hibernate.hql.ast.QueryTranslatorImpl.iterate
(QueryTranslatorImpl.java:403)
at org.hibernate.engine.query.HQLQueryPlan.performIterate
(HQLQueryPlan.java:248)
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1219)
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:69)
at org.openmeetings.app.data.basic.Configurationmanagement.getConfKey
(Configurationmanagement.java:55)
at org.openmeetings.utils.crypt.ManageCryptStyle.getInstanceOfCrypt
(ManageCryptStyle.java:30)
at
org.openmeetings.app.remote.red5.ClientListManager.addClientListItem
(ClientListManager.java:43)
at org.openmeetings.app.remote.red5.ScopeApplicationAdapter.roomJoin
(ScopeApplicationAdapter.java:132)
at org.red5.server.adapter.MultiThreadedApplicationAdapter.join
(MultiThreadedApplicationAdapter.java:405)
at org.red5.server.adapter.ApplicationAdapter.join
(ApplicationAdapter.java:72)
at org.red5.server.Scope.connect(Scope.java:427)
at org.red5.server.BaseConnection.connect(BaseConnection.java:268)
at org.red5.server.net.rtmp.RTMPConnection.connect
(RTMPConnection.java:269)
at org.red5.server.net.rtmp.RTMPMinaConnection.connect
(RTMPMinaConnection.java:74)
at org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:
299)
at org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived
(BaseRTMPHandler.java:146)
at org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived
(RTMPMinaIoHandler.java:126)
at org.apache.mina.common.support.AbstractIoFilterChain
$TailFilter.messageReceived(AbstractIoFilterChain.java:570)
at
org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived
(AbstractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterChain.access$1100
(AbstractIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl
$1.messageReceived(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.executor.ExecutorFilter.processEvent
(ExecutorFilter.java:220)
at org.apache.mina.filter.executor.ExecutorFilter
$ProcessEventsRunnable.run(ExecutorFilter.java:264)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask
(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run
(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)


** END NESTED EXCEPTION **



Last packet sent to the server was 1 ms ago.
2009-01-30 12:39:02,629 [pool-4-thread-15] ERROR
o.o.a.d.b.Configurationmanagement - Configurationmanagement.java
68840766 65 org.openmeetings.app.data.basic.Configurationmanagement
[pool-4-thread-15] - [getConfKey]:
org.hibernate.exception.JDBCConnectionException: could not execute
query using iterate
at org.hibernate.exception.SQLStateConverter.convert
(SQLStateConverter.java:97)
at org.hibernate.exception.JDBCExceptionHelper.convert
(JDBCExceptionHelper.java:66)
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:450)
at org.hibernate.hql.ast.QueryTranslatorImpl.iterate
(QueryTranslatorImpl.java:403)
at org.hibernate.engine.query.HQLQueryPlan.performIterate
(HQLQueryPlan.java:248)
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1219)
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:69)
at org.openmeetings.app.data.basic.Configurationmanagement.getConfKey
(Configurationmanagement.java:55)
at org.openmeetings.utils.crypt.ManageCryptStyle.getInstanceOfCrypt
(ManageCryptStyle.java:30)
at
org.openmeetings.app.remote.red5.ClientListManager.addClientListItem
(ClientListManager.java:43)
at org.openmeetings.app.remote.red5.ScopeApplicationAdapter.roomJoin
(ScopeApplicationAdapter.java:132)
at org.red5.server.adapter.MultiThreadedApplicationAdapter.join
(MultiThreadedApplicationAdapter.java:405)
at org.red5.server.adapter.ApplicationAdapter.join
(ApplicationAdapter.java:72)
at org.red5.server.Scope.connect(Scope.java:427)
at org.red5.server.BaseConnection.connect(BaseConnection.java:268)
at org.red5.server.net.rtmp.RTMPConnection.connect
(RTMPConnection.java:269)
at org.red5.server.net.rtmp.RTMPMinaConnection.connect
(RTMPMinaConnection.java:74)
at org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:
299)
at org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived
(BaseRTMPHandler.java:146)
at org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived
(RTMPMinaIoHandler.java:126)
at org.apache.mina.common.support.AbstractIoFilterChain
$TailFilter.messageReceived(AbstractIoFilterChain.java:570)
at
org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived
(AbstractIoFilterChain.java:299)
at org.apache.mina.common.support.AbstractIoFilterChain.access$1100
(AbstractIoFilterChain.java:53)
at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl
$1.messageReceived(AbstractIoFilterChain.java:648)
at org.apache.mina.filter.executor.ExecutorFilter.processEvent
(ExecutorFilter.java:220)
at org.apache.mina.filter.executor.ExecutorFilter
$ProcessEventsRunnable.run(ExecutorFilter.java:264)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask
(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run
(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link
failure due to underlying exception:

[Sebastian Wagner]

I've seen that. The latest package should have different values in the hibernate.cfg.xml

http://openmeetings.googlecode.com/svn/trunk/webapp/webapp/openmeetings/conf/mysql_hibernate.cfg.xml

see the line with the new ....

autoReconnect=true&

....:

<property name="connection.url">jdbc:mysql://localhost/openmeetings?autoReconnect=true&amp;useUnicode=true&amp;createDatabaseIfNotExist=true&amp;characterEncoding=utf-8</property>	

		

param and the new values + properties for c3p0:

		<property name="c3p0.max_size">20</property>
		<property name="c3p0.min_size">2</property>
        <property name="c3p0.idle_test_period">100</property>

		<property name="c3p0.max_statements">100</property>
		<property name="c3p0.timeout">100</property>

That should fix it.


sebastian

2009/1/30 Wayne <w.f....@gmail.com>

--
Sebastian Wagner
http://www.webbase-design.de
http://openmeetings.googlecode.com
http://www.laszlo-forum.de
seba....@gmail.com

[Sebastian Wagner]

... but i think its still not solved.
I know did update to the latest JDBC driver and test that
you have to replace the old one from WEB-INF/lib and restart
http://dev.mysql.com/downloads/connector/j/5.1.html

... and then wait for another 24/36 hours to see if this is the solution.

sebastian wagner

2009/1/31 Sebastian Wagner <seba....@gmail.com>

[Wayne]

Sebastian --

I am mostly concerned about our installation of v0.7rc1. The values
in the hibernate.cfg.xml of that installation were as you outlined in
your post. I have left those alone.

I updated to v5.1.7 of the JDBC driver.

I'll wait 36 hours and let you know what happens.

Out of curiosity--we had OpenMeeting v0.52 running under Windows 2003
and XAMPP v1.67. It ran for many days without problems. Is there
something different about that environment?

Thanks for your responses.

-- Wayne

On Jan 31, 2:36 am, Sebastian Wagner <seba.wag...@gmail.com> wrote:
> ... but i think its still not solved.
> I know did update to the latest JDBC driver and test that

> you have to replace the old one from WEB-INF/lib and restarthttp://dev.mysql.com/downloads/connector/j/5.1.html

>
> ... and then wait for another 24/36 hours to see if this is the solution.
>
> sebastian wagner
>

> 2009/1/31 Sebastian Wagner <seba.wag...@gmail.com>

>
> > I've seen that. The latest package should have different values in the
> > hibernate.cfg.xml
>

> >http://openmeetings.googlecode.com/svn/trunk/webapp/webapp/openmeetin...

>
> > see the line with the new ....
>
> > autoReconnect=true&amp;
>
> > ....:
>
> > <property name="connection.url">jdbc:mysql://localhost/openmeetings?autoReconnect=true&amp;useUnicode=true&amp;createDatabaseIfNotExist=true&amp;characterEncoding=utf-8</property>    
>
> >            param and the new values + properties for c3p0:
>
> >            <property name="c3p0.max_size">20</property>
> >            <property name="c3p0.min_size">2</property>
> >         <property name="c3p0.idle_test_period">100</property>
>
> >            <property name="c3p0.max_statements">100</property>
> >            <property name="c3p0.timeout">100</property>
>
> > That should fix it.
>
> > sebastian
>

> > 2009/1/30 Wayne <w.f.wa...@gmail.com>

> ...
>
> read more »

[Sebastian Wagner]

OpenMeeting v0.52 had another Database-Engine (InnoDB) now we use MyISAM which is much faster (but has not referential integrity).

It seems to me like that did do the trick almost. I have no problems now for the last 24 hours.

sebastian

2009/1/31 Wayne <w.f....@gmail.com>

[smoeker]

hola,

the hibernate problems in combination with the mysql are mostly
dependent on the wait_timeout parameter in the mysql server.

-> the default in the mysqlserver is a wait_timeout of 8 hours until
the mysqld cuts all non used connections.
-> its easier to test, setting down that startparam in the server, so
u dont have to wait until it happens after some hours....

see ya

Smoeker

On 1 Feb., 11:22, Sebastian Wagner <seba.wag...@gmail.com> wrote:
>  OpenMeeting v0.52 had another Database-Engine (InnoDB) now we use MyISAM
> which is much faster (but has not referential integrity).
>
> It seems to me like that did do the trick almost. I have no problems now for
> the last 24 hours.
>
> sebastian
>

> 2009/1/31 Wayne <w.f.wa...@gmail.com>

> > name="connection.url">jdbc:mysql://localhost/openmeetings?autoReconnect=tru­e&amp;useUnicode=true&amp;createDatabaseIfNotExist=true&amp;characterEncodi­ng=utf-8</property>

> ...
>
> Erfahren Sie mehr »- Zitierten Text ausblenden -
>
> - Zitierten Text anzeigen -

[Sebastian Wagner]

I do not completely understand that as the QuartzSessionClear-Class will query the db every 30 minutes for session-data that is timed-out. How can the DB Connection be timed-out because of in-activity if there is a Query every 15 minutes?


sebastian

2009/2/2 smoeker <o.bec...@medint.de>

[smoeker]

hi,

i was facing the same problem with a reporting tool, that executes
queries periodically via cron4j - i think its about the pooling - the
mysqld doesnt care about the hibernate pooling, but controls every
single connection
( so it could be possible, that some connections in the pool got
invalid out of the servers view, while others still were alive...)

there are lots of threads concerning that topic, e.g.
http://forum.hibernate.org/viewtopic.php?t=943079&highlight=c3p0+connection+timeout

-> the posted errormessage

java.net.SocketException
MESSAGE: Broken pipe


seems familiar....

see ya

Smoeker

On 2 Feb., 13:17, Sebastian Wagner <seba.wag...@gmail.com> wrote:
> I do not completely understand that as the QuartzSessionClear-Class will
> query the db every 30 minutes for session-data that is timed-out. How can
> the DB Connection be timed-out because of in-activity if there is a Query
> every 15 minutes?
>
> sebastian
>

> 2009/2/2 smoeker <o.beche...@medint.de>

> > name="connection.url">jdbc:mysql://localhost/openmeetings?autoReconnect=tru­­e&amp;useUnicode=true&amp;createDatabaseIfNotExist=true&amp;characterEncod­i­ng=utf-8</property>

[Sebastian Wagner]

but I think with the latest SNV up + the new Mysql-Driver => I have no such problems anymore
(actually we never had these problems as long as we did use InnoDB which is kind of a mistery why the change to another db-engine can cause connection timeouts .. but anyway I think with the Conector/J 5.1.7 we solved it now)

sebastian

2009/2/2 smoeker <o.bec...@medint.de>

[Wayne]

Good morning --

We now have two installations of v0.7rc1 up and running for over 47
hours. Both are using Connector/J 5.1.7. Both have had at least
three idle periods (no user log-in) that were longer than eight hours.

Let's hope this problem is solved.

Thanks for your help.

-- Wayne

[Sebastian Wagner]

I think so.
I ll update the SVN version with the new Driver and include that in a 0.7 Final Updated Package


sebastian

2009/2/2 Wayne <w.f....@gmail.com>

[Wayne]

Both our installations of OpenMeeting are still up and running. All
user activities appear to be successful. The only viewable problem is
that the blue default user image icon sometimes is not displayed on
the home page.

And, I am now getting the error shown below when users return to the
home page from the conference room list page. See the "Caused by:"
explanation in the 39th line below. I have verified that
autoReconnect is set to true in the connection.url property in
hibernate.cfg.xml and that I am using Connector/J 5.1.7.

2009-02-03 00:19:19,073 [http-5080-1] ERROR
o.o.a.data.basic.Sessionmanagement - Sessionmanagement.java 210153814
143 org.openmeetings.app.data.basic.Sessionmanagement [http-5080-1] -
[checkSession]:

org.hibernate.exception.JDBCConnectionException: could not execute
query
at org.hibernate.exception.SQLStateConverter.convert
(SQLStateConverter.java:97)
at org.hibernate.exception.JDBCExceptionHelper.convert
(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2231)
at org.hibernate.loader.Loader.listIgnoreQueryCache

(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)

at org.hibernate.loader.criteria.CriteriaLoader.list
(CriteriaLoader.java:118)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at
org.openmeetings.app.data.basic.Sessionmanagement.checkSession
(Sessionmanagement.java:123)
at
org.openmeetings.servlet.outputhandler.DownloadHandler.service
(DownloadHandler.java:49)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
820)
at sun.reflect.GeneratedMethodAccessor365.invoke(Unknown

Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.security.SecurityUtil$1.run
(SecurityUtil.java:244)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:
517)
at org.apache.catalina.security.SecurityUtil.execute
(SecurityUtil.java:276)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege
(SecurityUtil.java:162)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:283)
at org.apache.catalina.core.ApplicationFilterChain.access$000
(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run
(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:185)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke
(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke
(AccessLogValve.java:568)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service
(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run
(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
The last packet successfully received from the server was84254
milliseconds ago.The last packet sent successfully to the server was
84254 milliseconds ago, which 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.
at sun.reflect.GeneratedConstructorAccessor63.newInstance
(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance
(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:
513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException
(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3270)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1932)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:
2554)
at com.mysql.jdbc.PreparedStatement.executeInternal
(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.executeQuery
(PreparedStatement.java:1912)

at org.hibernate.jdbc.AbstractBatcher.getResultSet
(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections
(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)

... 33 common frames omitted
Caused by: java.net.SocketException: Broken pipe

at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite

(SocketOutputStream.java:92)

at java.net.SocketOutputStream.write(SocketOutputStream.java:
136)
at java.io.BufferedOutputStream.flushBuffer
(BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.flush
(BufferedOutputStream.java:123)

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3251)
... 43 common frames omitted

[Sebastian Wagner]

you could try add or replace:

 <property name="connection.provider_class ">org.hibernate.connection.C3P0ConnectionProvider</property>

with:

<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
 <property name="connection.provider_class ">org.hibernate.connection.C3P0ConnectionProvider</property>

sebastian

2009/2/3 Wayne <w.f....@gmail.com>

[Wayne]

This property
<property
name="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</
property>
was already present in the hibernate.cfg.xml file.

I added...
<property
name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</
property>

I want to confirm that you want BOTH properties in the
hibernate.cfg.xml file with the SAME values and in the order shown--
with hibernate.connection.provider_class FIRST and
connection.provider_class SECOND.

On Feb 3, 12:52 am, Sebastian Wagner <seba.wag...@gmail.com> wrote:
> you could try add or replace:
>
>  <property name="connection.provider_class
> ">org.hibernate.connection.C3P0ConnectionProvider</property>
>
> with:
>
> <property
> name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
>  <property name="connection.provider_class
> ">org.hibernate.connection.C3P0ConnectionProvider</property>
>
> sebastian
>

> 2009/2/3 Wayne <w.f.wa...@gmail.com>

> seba.wag...@gmail.com

[Sebastian Wagner]

nono I meant to replace the former value named *connection.provider_class* with *hibernate.connection.

provider_class* and same value. Seems like since hibernate 3.3 you have to name that param different.

sebastian

2009/2/3 Wayne <w.f....@gmail.com>

[Wayne]

As of this morning our v0.7rc1 installation has been running for 48-
hours with multiple idle periods of greater than eight hours.

There are now NO MySQL driver-related errors!