Skip to Main Content

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Perl & "Lock table is out of available lock entries"

724757Oct 21 2009 — edited Oct 21 2009
Hi,

i use to retrieve about ten thousand results with ./dbxml,
but when i use the same query within a perl script,
i get the error:

"""
Lock table is out of available lock entries
Query collection("frwiki_10_0.dbxml")/DOCUMENT/Sentence failed (1)
Error: Could not fetch next DOM element for doc id: 2, nid: 8CB6 in /Users/francois/Desktop/INRIA/EasyRef2_DBXML/script/../lib/session.pm, line 175
Database handles still open at environment close
Open database handle: frwiki_10_0.dbxml/structural_stats
Open database handle: frwiki_10_0.dbxml/secondary_document_statistics_double
Open database handle: frwiki_10_0.dbxml/secondary_document_index_double
Open database handle: frwiki_10_0.dbxml/secondary_document_statistics_string
Open database handle: frwiki_10_0.dbxml/secondary_document_index_string
Open database handle: frwiki_10_0.dbxml/node_nodestorage
Open database handle: frwiki_10_0.dbxml/secondary_document
Open database handle: frwiki_10_0.dbxml/secondary_dictionary
Open database handle: frwiki_10_0.dbxml/primary_dictionary
Open database handle: frwiki_10_0.dbxml/secondary_sequence
Open database handle: frwiki_10_0.dbxml/secondary_configuration
Segmentation fault
"""

Somewhere on other forums, one's talking about Configuring locking: sizing the system & DB_ENV->set_lk_max_locks(),
but how can I my environment the same way with a perl script?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2009
Added on Oct 21 2009
6 comments
2,079 views