#440 closed task (fixed)
Update to latest versions of 3rd-party software
| Reported by: | Nicklas Nordborg | Owned by: | Nicklas Nordborg |
|---|---|---|---|
| Priority: | critical | Milestone: | BASE 2.2 |
| Component: | core | Version: | |
| Keywords: | Cc: |
Description
Hibernate 3.2.1 contains a fix for the update bug affecting postgres. See UpgradePostgres for more info. There might also be updates to other software.
Change History (9)
comment:1 by , 18 years ago
| Status: | new → assigned |
|---|
comment:2 by , 18 years ago
comment:3 by , 18 years ago
comment:4 by , 18 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
comment:5 by , 18 years ago
| Priority: | major → critical |
|---|---|
| Resolution: | fixed |
| Status: | closed → reopened |
It turns out that there is a connection leak in the c3p0 connection pool. Together with a new bug in Hibernate this affects the updatedb.sh script. What happens is that the update opens a lot of connections but doesn't close them. If the database has a 'max connections' setting that is too low the update will fail. There are two workarounds:
- Change the 'max connections' setting for the database to 1000 (well 300 may work, but it's better to be on the safe side)
- Comment out all settings in hibernate.cfg.xml having to do with c3p0.
In both cases, you should revert back to the old settings once the update has finished. The bug has been fixed in Hibernate and will be released in 3.2.2. For more information see: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2032
comment:6 by , 18 years ago
The second option turned out to be a bit unsafe, since the loss of the connection pool made other things unstable. Those things has been corrected in the trunk. If you get into problems when using the (2) workaround, try (1) as well. Please send the error messages you get with (2) to us since they may indicate a potential problem in our code.
comment:7 by , 18 years ago
comment:8 by , 18 years ago
| Resolution: | → fixed |
|---|---|
| Status: | reopened → closed |
(In [2966]) References #440: Update to latest versions of 3rd-party software
Updated Log4j to 1.2.14, Xerces to 2.9.0, MySQL Connector to 5.0.4, JFreeChart to 1.0.3