1 Reply Latest reply on Oct 25, 2011 5:01 PM by "Andrei Costache, Oracle-Oracle"

    Best way to resolve "Database handles still open at environment close" ?

    862294
      Hello:

      We're using DB XML 2.5.16 by way of a server application (Fedora Commons Repository); we're not coding directly to DB XML. Yesterday we hit the DB XML 'out of memory' error. The team member looking at the server ran './db_recover -h /opt/repository/fedora/pdp/database/' which got the system back up, but we are now seeing the following in the logs:

      Database handles still open at environment close
      Open database handle: policies.dbxml/structural_stats
      Open database handle: policies.dbxml/secondary_document_statistics_double
      Open database handle: policies.dbxml/secondary_document_index_double
      Open database handle: policies.dbxml/secondary_document_statistics_string
      Open database handle: policies.dbxml/secondary_document_index_string
      Open database handle: policies.dbxml/secondary_document_statistics_none
      Open database handle: policies.dbxml/secondary_document_index_none
      Open database handle: policies.dbxml/node_nodestorage
      Open database handle: policies.dbxml/secondary_document
      Open database handle: policies.dbxml/secondary_dictionary
      Open database handle: policies.dbxml/primary_dictionary
      Open database handle: policies.dbxml/secondary_sequence
      Open database handle: policies.dbxml/secondary_configuration

      Is there a way to fix this? I've searched the forums, but the advice seems to be for changing code, not for fixing the database when the code hasn't changed.

      Thanks!

      Edited by: diannao on Oct 13, 2011 6:45 AM