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 <[email protected]> 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 <[email protected]> > > > > > > > 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 <[email protected]> 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 <[email protected]> > > > > > 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 <[email protected]> > > > > >> 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 > > ... > > Erfahren Sie mehr »- Zitierten Text ausblenden - > > - Zitierten Text anzeigen - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "OpenMeetings User" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/openmeetings-user?hl=en -~----------~----~----~----~------~----~------~--~---
