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 - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
