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 <[email protected]> > > 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 - > > > -- Sebastian Wagner http://www.webbase-design.de http://openmeetings.googlecode.com http://www.laszlo-forum.de [email protected] --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
