[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
openldap-2.4.19 backsql with oracle and slap_sl_malloc of 56 bytes failed, using ch_malloc error
- To: openldap-software@openldap.org
- Subject: openldap-2.4.19 backsql with oracle and slap_sl_malloc of 56 bytes failed, using ch_malloc error
- From: Nikethan Raja <nikethan@gmail.com>
- Date: Tue, 5 Jan 2010 00:36:47 -0800
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=kP1V7MsUe7l5IwicSYXm3XI0h6sxA/cIyninLeCVSBI=; b=xqj+bLHCnlxj9jp4Rcu126nzuDjFAAvoCd2M8WhRXDIScTS3kvmhLcktiLYvQRMEFl i1NAY1YZX8OfnQdt63egjaVV7DaoPPC5y/0N9a7gBVTAnOurZvUCje5jx2WQST4Ps0fK BosTFxuVV5OSxSPbTJEzFmyLhMQ1uj8Rcww/k=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=b9sxO5reaUKapPIg8tGWcUWJDDBiwBiUd0bQBJJay5dCTrWSbJQNPvZHRaoApy3lYt iZEvVfuAoOpSbo/MUTptqB3U8w1hs0gZv/SA1Hd0sSYog04MRkEHq5Y6u9J4G2BOlaoD e4icjl2q6xjMOa+mCgO7BRNpoGbPcfX9wuUpM=
We have installed openldap-2.4.19 backsql and oracle as RDMS.
Everthing works fine when I search for a specific entry.
But If I open a LDAP beowser and expand the tree. It tries to run
the following query to load all the entries for ObjectClass
NetAcadPerson .
Unfortunately this query (this Objectclass has) returns almost one
million records.
SELECT DISTINCT
ldap_entries.id,NetacadPersons.NetAcadUserID,'NetAcadPerson'
objectClass,ldap_entries.dn dn FROM ldap_entries,NetacadPersons WHERE
NetacadPersons.NetAcadUserID=ldap_entries.keyval AND
ldap_entries.oc_map_id=? AND ldap_entries.parent=? AND 3=3
It was able to load 1000+ records with the following info in the logs ....
backsql_oc_get_candidates(): added entry id=471024, keyval=470924
dn="uid=xxxxx,ou=people,dc=netacad,dc=net"
>>> dnPrettyNormal: <uid=xxxxx,ou=people,dc=netacad,dc=net>
<<< dnPrettyNormal: <uid=xxxxx,ou=people,dc=netacad,dc=net>,
<uid=xxxxxx,ou=people,dc=netacad,dc=net>
backsql_oc_get_candidates(): added entry id=471024, keyval=470924
dn="uid=xxxxx,ou=people,dc=netacad,dc=net"
>>> dnPrettyNormal: <uid=xxxxx,ou=people,dc=netacad,dc=net>
<<< dnPrettyNormal: <uid=xxxxx,ou=people,dc=netacad,dc=net>,
<uid=xxxxxx,ou=people,dc=netacad,dc=net>
But after loaading some of them I get the following error ...telling
me that the memory allocation falied....
slap_sl_malloc of 16 bytes failed, using ch_malloc
slap_sl_malloc of 32 bytes failed, using ch_malloc
slap_sl_malloc of 56 bytes failed, using ch_malloc
My questions is - is it possible to restrict number of rows by using
"rownum" special ORACLE feature.
By appending some thing like below to the query above.
"AND rownum < 100 "
If it is possible to configure above query, please let me know what
slapd configuration I should use. I read all the options in the
following man page - http://linux.die.net/man/5/slapd-sql
Let me know if I have any other options to prevent this from happening.
Thanks a lot in advance.
-Nikethan