[SqueakDBX] MAC OSX 10.6 + squeakDBX + Oracle 10.2 issues

Colin Doherty colin.doherty at gmail.com
Sun Aug 1 18:18:20 UTC 2010


Just tried a make clean, same result:

1. Run:
  Conn::Conn()
Loading backend library oracle, liboraclebackend.so or
/usr/local/lib/opendbx/liboraclebackend.so failed

dlopen(/usr/local/lib/opendbx/liboraclebackend.so, 1): Library not loaded:
/b/32_216/rdbms/lib/libclntsh.dylib.10.1
  Referenced from: /usr/local/lib/opendbx/liboraclebackend.so
  Reason: image not found
Caught exception: Loading backend library failed


On Sun, Aug 1, 2010 at 7:11 PM, Mariano Martinez Peck <marianopeck at gmail.com
> wrote:

> can you try a 'make clean' before configure and recompiling ?  istill the
> same problem ?
>
>
> On Sun, Aug 1, 2010 at 8:10 PM, Mariano Martinez Peck <
> marianopeck at gmail.com> wrote:
>
>>
>>
>> On Sun, Aug 1, 2010 at 8:08 PM, Colin Doherty <colin.doherty at gmail.com>wrote:
>>
>>> Hi,
>>>
>>> Here's the output of  ./odbxplustest -b oracle -p 1521 -d 'mysid' -u
>>> 'user' -w 'password' -v
>>>
>>
>> the error with odbxtest (not plus, as that is c++) is the same?
>>
>> ok...the problem is with OpenDBX then, and it cannot loads the
>> liboraclebackend
>>
>>
>>
>>
>>>
>>> 1. Run:
>>>   Conn::Conn()
>>> Loading backend library oracle, liboraclebackend.so or
>>> /usr/local/lib/opendbx/liboraclebackend.so failed
>>>
>>> dlopen(/usr/local/lib/opendbx/liboraclebackend.so, 1): Library not
>>> loaded: /b/32_216/rdbms/lib/libclntsh.dylib.10.1
>>>   Referenced from: /usr/local/lib/opendbx/liboraclebackend.so
>>>   Reason: image not found
>>> Caught exception: Loading backend library failed
>>>
>>> Cheers
>>> Colin
>>>
>>> On Sun, Aug 1, 2010 at 7:00 PM, Mariano Martinez Peck <
>>> marianopeck at gmail.com> wrote:
>>>
>>>>
>>>>
>>>> On Sun, Aug 1, 2010 at 7:38 PM, Colin Doherty <colin.doherty at gmail.com>wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> Ok I've tried using the Squeak5.7b1 64-32 VM with the Pharo 1.1 image
>>>>> and opendbx-1.5.0 with debug-log option, the error is:
>>>>>
>>>>> Error: call to an external function failed.
>>>>>
>>>>>
>>>> Grrrrr okok.  It is failing in the apiInitialize:backend:host:port:
>>>> but I don't know why.
>>>>
>>>>
>>>>
>>>>>
>>>>> No error messages were produced in /var/log/system.log when this
>>>>> occurred and no additional opendbx debug log was produced that I could see.
>>>>>
>>>>
>>>> Check the created files in the directory where you have the image or
>>>> where you have the VM.  They are something like this 'opendbx-0x9af4610.dbg'
>>>> where 0x9af4610 is the connection handle.
>>>>
>>>>
>>>>> I've run the FFIPlugin tests, these two failed in the standard
>>>>> Pharo-1.1 with  Squeak 4.2.5beta1U VM:
>>>>>
>>>>> FFIPluginTests>>#testLongLongs
>>>>> FFIPluginTests>>#testPoint2
>>>>>
>>>>
>>>> Ok, that's correct. The problem seems to be in OpenDBX.
>>>>
>>>> Now, can you do another test?
>>>>
>>>> When you configure and compile OpenDBX, you can see there is /test
>>>> inside the folder of OpenDBX.
>>>>
>>>> in /test you have an executable to run tests. YOu can do:
>>>>
>>>>  ./odbxplustest -b oracle -p 1521 -d 'mysid' -u 'user' -w 'password' -v
>>>>
>>>> -v is verbose
>>>>
>>>> run that from command line and see if it works or if there is a problem.
>>>> In such case, please paste console.
>>>>
>>>>
>>>> Cheers
>>>>
>>>> Mariano
>>>>
>>>>
>>>>
>>>>> With the  Squeak 64-32 5.7b1 VM all the FFIPluginTests produced an
>>>>> error/failed, it is an experimental 64bit VM though so I guess that's
>>>>> expected ?
>>>>>
>>>>> Thanks
>>>>> Colin
>>>>>
>>>>>
>>>>> On Sun, Aug 1, 2010 at 5:24 PM, Mariano Martinez Peck <
>>>>> marianopeck at gmail.com> wrote:
>>>>>
>>>>>>
>>>>>>
>>>>>> On Sun, Aug 1, 2010 at 5:04 PM, Colin Doherty <
>>>>>> colin.doherty at gmail.com> wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> I've tried using the Pharo 1.1 OneClick image (not sure what the VM
>>>>>>> version is for this) and have tried Squeak Seaside 3.0 image,  Squeak/VM
>>>>>>> version 4.1 I think ?. I installed it using Metacello. This is the version
>>>>>>> of OpenDBX: OpenDBX-Core-MarianoMartinezPeck.246 and
>>>>>>> SqueakDBX-Smalltalk-Dialect-MarianoMartinezPeck.3 from what I can see in
>>>>>>> ConfigurationOfSqueakDBX>>version11.
>>>>>>>
>>>>>>>
>>>>>> Ok, this is perfect. Now...could you test the same image of Pharo 1.1
>>>>>> but using another VM than the one that it is in the one click.
>>>>>>
>>>>>> The one click VM is Squeak 4.2.5beta1U
>>>>>> Can you try with Squeak 64-32 5.7b1 ??
>>>>>> ftp://ftp.smalltalkconsulting.com/Squeak%2064-32%205.7b1.app.zip
>>>>>>
>>>>>> In addition (to see if we have more logs) can you enable the debug
>>>>>> mode in those VMs ?
>>>>>>
>>>>>> to do that, you need to open the .app (show package contents) and
>>>>>> then, in the file Info.plist  you have to enable debug mode:
>>>>>>
>>>>>>     <key>SqueakDebug</key>
>>>>>>     <integer>1</integer>
>>>>>>
>>>>>> or...from the mac os tool to edit .plist
>>>>>>
>>>>>> then...open first the Mac OS Console, and luckily we will have more
>>>>>> information.
>>>>>>
>>>>>>
>>>>>>
>>>>>>> I've just tried a simple connect example:
>>>>>>>
>>>>>>> |conn connectionSettings rs |
>>>>>>>
>>>>>>> connectionSettings:= DBXConnectionSettings
>>>>>>> host:'hostname.com'
>>>>>>> port:'1521'
>>>>>>> database:'mysid'
>>>>>>> userName:'username'
>>>>>>> userPassword: 'pw'.
>>>>>>>
>>>>>>> conn := DBXConnection platform: DBXOraclePlatform new settings:
>>>>>>> connectionSettings.
>>>>>>> conn connect.
>>>>>>> conn open.
>>>>>>> rs := conn execute: 'select job from emp'.
>>>>>>>
>>>>>>>
>>>>>> Ok...what happens if you do all that but not the conn execute ?  (i
>>>>>> mean, jut connect and open).  Try this:
>>>>>>
>>>>>> |conn connectionSettings rs |
>>>>>>
>>>>>> connectionSettings:= DBXConnectionSettings
>>>>>> host:'hostname.com'
>>>>>> port:'1521'
>>>>>> database:'mysid'
>>>>>> userName:'username'
>>>>>> userPassword: 'pw'.
>>>>>>
>>>>>> conn := DBXConnection platform: DBXOraclePlatform new settings:
>>>>>> connectionSettings.
>>>>>> conn connect.
>>>>>> conn open.
>>>>>> conn disconnect.
>>>>>>
>>>>>> does it work?
>>>>>>
>>>>>>
>>>>>>
>>>>>>> I've done no tests of FFI but it installed ok as far as I could see.
>>>>>>>
>>>>>>>
>>>>>> No, but they came with FFI. Check in the category FFI-Tests  there are
>>>>>> tests like FFIPluginTests
>>>>>>
>>>>>>
>>>>>>
>>>>>>> I'm using opendbx-1.4.5.
>>>>>>>
>>>>>>
>>>>>> Ok...can you please recompile using the debug mode enabled?
>>>>>>   To do that  ./configure --enable-debug-log   and then a .log file
>>>>>> per connection is generated in the directory where you are calling opendbx
>>>>>>
>>>>>> However, if I remember correctly, this was added in opendbx-1.5.0, not
>>>>>> in 1.4.5.
>>>>>>
>>>>>> You can download it from:
>>>>>> http://linuxnetworks.de/opendbx/download/libopendbx-1.5.0.tar.gz
>>>>>>
>>>>>> So...compile like that, and run your test again. Then, please send the
>>>>>> generated log.
>>>>>>
>>>>>> Let's do all these tests, and then we can contact someone to help us.
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> Mariano
>>>>>>
>>>>>>
>>>>>>>
>>>>>>> Thanks
>>>>>>> Colin
>>>>>>>
>>>>>>>
>>>>>>> On Sun, Aug 1, 2010 at 3:17 PM, Mariano Martinez Peck <
>>>>>>> marianopeck at gmail.com> wrote:
>>>>>>>
>>>>>>>> HI. wow...never saw this problem.
>>>>>>>>
>>>>>>>> Which Squeak VM are you using?
>>>>>>>>
>>>>>>>> What is exactly what you are running in the image side that brings
>>>>>>>> that error ?
>>>>>>>>
>>>>>>>> thanks
>>>>>>>>
>>>>>>>> mariano
>>>>>>>>
>>>>>>>> On Sun, Aug 1, 2010 at 4:04 PM, Colin Doherty <
>>>>>>>> colin.doherty at gmail.com> wrote:
>>>>>>>>
>>>>>>>>> Hi,
>>>>>>>>>
>>>>>>>>> I've tried installing squeakDBX and got it installed using the 32
>>>>>>>>> bit Oracle 10.2.0.4 instant client using this config:
>>>>>>>>>
>>>>>>>>> CFLAGS="-m32" CPPFLAGS="-m32
>>>>>>>>> -I/usr/local/instantclient10_2/sdk/include" LDFLAGS="-arch i386
>>>>>>>>> -L/usr/local/instantclient10_2" ./configure --disable-utils
>>>>>>>>> --with-backends="oracle"
>>>>>>>>>
>>>>>>>>> However, I'm getting the following error when I try to use it in
>>>>>>>>> either squeak 4.1 or pharo 1.1:
>>>>>>>>>
>>>>>>>>> Out of memory error
>>>>>>>>>
>>>>>>>>> This is from the log:
>>>>>>>>>
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading /Users/DevelopmentSmalltalk/Pharo/Plugins/opendbx.so
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading /Users/Development/Smalltalk/Pharo/Plugins/opendbx.dylib
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading /Users/Development/Smalltalk/Pharo/Plugins/libopendbx
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading /Users/Development/Smalltalk/Pharo/Plugins/libopendbx.so
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading /Users/Development/Smalltalk/Pharo/Plugins/libopendbx.dylib
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading ./opendbx.bundle/Contents/MacOS/opendbx
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading ./opendbx
>>>>>>>>> Jul 31 20:57:47: --- last message repeated 1 time ---
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading ./opendbx.so
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading ./opendbx.dylib
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading ./libopendbx
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading ./libopendbx.so
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading ./libopendbx.dylib
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading
>>>>>>>>> /Users/Development/Smalltalk/Pharo/Pharo-1.1-OneClick.app/Contents/Resources/opendbx.bundle/Contents/MacOS/opendbx
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> tryLoading
>>>>>>>>> /Users/Development/Smalltalk/Pharo/Pharo-1.1-OneClick.app/Contents/Resources/opendbx
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> ioFindExternalFunctionIn(odbx_init, 2155408)
>>>>>>>>> Jul 31 20:57:47 MacBook Squeak VM Opt[22081]: Squeak VM
>>>>>>>>> Opt(22081,0xa0bf2500) malloc: *** error for object 0xf1f2f3f4: pointer being
>>>>>>>>> freed was not allocated\n*** set a breakpoint in malloc_error_break to debug
>>>>>>>>>  Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> Squeak VM Opt(22081,0xa0bf2500) malloc: *** error for object 0xf1f2f3f4:
>>>>>>>>> pointer being freed was not allocated
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]: ***
>>>>>>>>> set a breakpoint in malloc_error_break to debug
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> ioFindExternalFunctionIn(odbx_error, 2155408)
>>>>>>>>> Jul 31 20:57:47 MacBook [0x0-0x39039].org.squeak.pharo[22081]:
>>>>>>>>> ioFindExternalFunctionIn(odbx_error_type, 2155408)
>>>>>>>>> Jul 31 21:01:49 MacBook Safari[8492]: INSERT-HANG-DETECTED: Tx
>>>>>>>>> time:18.496361, # of Inserts: 0, # of bytes written: 0, Did shrink: YES
>>>>>>>>> Jul 31 21:05:31 MacBook [0x0-0x39039].org.squeak.pharo[22081]: VM:
>>>>>>>>> MouseModifierStateCarbon buttonStateBits 1 modifier
>>>>>>>>>
>>>>>>>>> I've also tried compiling a 64 bit version which worked and used
>>>>>>>>> the experimental 64 bit squeak vm, this doesn't work but generates no
>>>>>>>>> errors. Any ideas on how to fix the 32 bit out of memory issue ?
>>>>>>>>>
>>>>>>>>> Thanks
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> SqueakDBX mailing list
>>>>>>>>> SqueakDBX at lists.squeakfoundation.org
>>>>>>>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> SqueakDBX mailing list
>>>>>>>> SqueakDBX at lists.squeakfoundation.org
>>>>>>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> SqueakDBX mailing list
>>>>>>> SqueakDBX at lists.squeakfoundation.org
>>>>>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> SqueakDBX mailing list
>>>>>> SqueakDBX at lists.squeakfoundation.org
>>>>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>>>>
>>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> SqueakDBX mailing list
>>>>> SqueakDBX at lists.squeakfoundation.org
>>>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> SqueakDBX mailing list
>>>> SqueakDBX at lists.squeakfoundation.org
>>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>>
>>>>
>>>
>>> _______________________________________________
>>> SqueakDBX mailing list
>>> SqueakDBX at lists.squeakfoundation.org
>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>
>>>
>>
>
> _______________________________________________
> SqueakDBX mailing list
> SqueakDBX at lists.squeakfoundation.org
> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20100801/4248703e/attachment-0001.htm


More information about the SqueakDBX mailing list