Assertion failure using LDAP

[cthielen]

My development machine uses ruby-oci8 against the Oracle Instant Client (OS X) just fine. When I move to production (Ubuntu 64-bit), I encounter some errors.

ruby-oci8 actually continues to work fine under a simple 'irb' but when I switch to using 'bundle exec rake my_oracle_task', the OCI8.new line fails with the following:

user@host:~$ bundle exec rake banner:import
ruby: getentry.c:35: ldap_first_entry: Assertion `( (ld)->ldc->ldc_options.ldo_valid == 0x2 )' failed.

From reading around the Internet, it appears this problem may be related to another library using the system LDAP (openldap?) instead of the Oracle functions. I have no idea what that other library would be.

I think this is related: http://stackoverflow.com/a/15322554/98647

Do you have any idea what's going on here and how I can go about debugging? I've wasted a few hours trying various things like following his suggestions in modifying ruby-oci8 to adjusting the order of gems loaded in Bundler, etc.

[cthielen]

I do have some backtrace information on this, specifically:

-- C level backtrace information -------------------------------------------
/home/deployer/.rbenv/versions/2.0.0-p247/bin/ruby(+0x152865) [0x7fd99837a865]
/home/deployer/.rbenv/versions/2.0.0-p247/bin/ruby(+0x1a727c) [0x7fd9983cf27c]
/home/deployer/.rbenv/versions/2.0.0-p247/bin/ruby(rb_bug+0xb7) [0x7fd9983d0c27]
/home/deployer/.rbenv/versions/2.0.0-p247/bin/ruby(+0xdc61e) [0x7fd99830461e]
/lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0) [0x7fd997df5cb0] ocihandle.c:599
/usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2(ldap_first_entry+0xc) [0x7fd992ee913c] oranumber_util.c:315
/opt/oracle/instantclient_12_1/libclntsh.so.12.1(nnflgne+0x11b0) [0x7fd98c4ae8a0]
/opt/oracle/instantclient_12_1/libclntsh.so.12.1(+0x1666bb2) [0x7fd98c4a0bb2]
/opt/oracle/instantclient_12_1/libclntsh.so.12.1(+0x1675e7c) [0x7fd98c4afe7c]
/opt/oracle/instantclient_12_1/libclntsh.so.12.1(nnfgrne+0x289) [0x7fd98b3f35d9]
/opt/oracle/instantclient_12_1/libclntsh.so.12.1(nlolgobj+0x151) [0x7fd98b56a151]

That ldap_first_entry() seems to be the libldap coming from the GNU system though I think oranumber_util.c is supposed to use the one from Instant Client?

[cthielen]

I was able to work around this by loading 'oci8' before 'pg' as Ubuntu's standard libpg is linked against libldap which has the conflicting symbol name.

Is it possible for ruby-oci8 to explicitly use the functions in Oracle Instant Client's libclntsh.so to avoid this workaround?

[kubo]

Is it possible for ruby-oci8 to explicitly use the functions in Oracle Instant Client's libclntsh.so to avoid this workaround?

Impossible.

I think that Oracle Corporation can fix the symbol conflict issue if Oracle Instant Client libclntsh.so is linked with the following version scripts not to export LDAP functions.

{
global:
    OCI*; /* export symbols which start OCI. */
local:
    *;  /* All others are hidden. */
};