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> > > 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& > > > > > ....: > > > > > <property > name="connection.url">jdbc:mysql://localhost/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&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> > > > > >> 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 > > > > ... > > > > read more ยป > > > -- Sebastian Wagner http://www.webbase-design.de http://openmeetings.googlecode.com http://www.laszlo-forum.de seba.wag...@gmail.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "OpenMeetings User" group. To post to this group, send email to openmeetings-user@googlegroups.com To unsubscribe from this group, send email to openmeetings-user+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/openmeetings-user?hl=en -~----------~----~----~----~------~----~------~--~---
