Opened 18 years ago

Closed 18 years ago

Last modified 18 years ago

#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 Nicklas Nordborg, 18 years ago

Status: newassigned

comment:2 by Nicklas Nordborg, 18 years ago

(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

comment:3 by Nicklas Nordborg, 18 years ago

(In [2967]) References #440: Update to latest versions of 3rd-party software

Updated to Hibernate 3.2.1. Remains to verify that updating works for both Postgres and MySQL.

comment:4 by Nicklas Nordborg, 18 years ago

Resolution: fixed
Status: assignedclosed

(In [2970]) Fixes #440: Update to latest versions of 3rd-party software

Verified that upgrading Postgres and MySQL works.

comment:5 by Nicklas Nordborg, 18 years ago

Priority: majorcritical
Resolution: fixed
Status: closedreopened

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:

  1. Change the 'max connections' setting for the database to 1000 (well 300 may work, but it's better to be on the safe side)
  2. 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 Nicklas Nordborg, 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 Nicklas Nordborg, 18 years ago

(In [3050]) References #440: Update to latest versions of 3rd-party software

Built Hibernate from subversion source (revision #11018), updated to latest C3P0. Fixed one issue with JOIN ... WITH syntax.

comment:8 by Nicklas Nordborg, 18 years ago

Resolution: fixed
Status: reopenedclosed

(In [3085]) Fixes #440: Update to latest versions of 3rd-party software

comment:9 by Nicklas Nordborg, 18 years ago

(In [3090]) References #440: Update to latest versions of 3rd-party software

Updated documentation about 3rd-party components

Note: See TracTickets for help on using tickets.