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.beche...@medint.de> > > 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> > > > > > > > > > > > > > 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> > > > > > > > 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 > > > > ... > > > > 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 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 -~----------~----~----~----~------~----~------~--~---