To: (The User)
cc: petar@imapserver2.fnal.gov,cdfdb-support@fnal.gov
Subject: Long-term inactive database connections

Hello,

Monitoring of database connections today shows that your jobs 
appear to be holding onto connections longer than is needed 
typically to obtain information in an efficient manner.  It is
therefore likely that your jobs have one or more of the
following known problems, for which our presently known fixes
are listed below.  We would like to ask that you check your
code for the indicated problems and send e-mail to 
cdfdb-support@fnal.gov if you have further questions.

Generally speaking, we recommend using version 5.3.3 or
higher of the CDF software.

For versions of CDF code 4.11.1 and later, only routines that use
TriggerMap (for example, Level3Mods and Prereq) are affected.  To fix
these, please apply the following recipe:

problem:
    idle connection while waiting for staged data
solution:

    uncomment line 217 of TriggerMap.cc :

    217     //handle->disconnect();

and move it outside the '}' on line 218


For versions of code between 4.10.0int3 and 4.11.x, (not including
4.11.x), you also need to apply the following fix to the
CalibrationManager.  This change is already in 4.11.x and higher.

For 4.10.0int3 or greater, one needs to build FrameMods locally:

      addpkg FrameMods
      cvs co -r 1.33 FrameMods/src/CalibrationManager.cc
      gmake FrameMods.nobin



For earlier versions, between 4.9.1 and 4.10.4, in addition to the
above,

addpkg FrameMods

edit
        CalibrationManager.cc

by adding line:

 tryDiscon();

        just before 'return AppResult::OK' in the 'beginJob()' method

        gmake FrameMods.nobin
        gmake yourstuff.bin


Please send e-mail to cdfdb-support@fnal.gov if you have any further
questions.