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

Mariano Martinez Peck marianopeck at gmail.com
Sun Aug 1 18:20:57 UTC 2010


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

>
>
> On Sun, Aug 1, 2010 at 8:03 PM, Colin Doherty <colin.doherty at gmail.com>wrote:
>
>> Hi Again,
>>
>> Just tried Pharo 1.1 click image with Squeak 4.2.5beta1U VM and
>> opendbx-1.5.0 and got a different error:
>>
>> DBXFatalError: FATAL OpenDBX: Loading backend library failed
>>
>>
> Ok...at least this one is known :)
>
> The problem is that OpenDBX cannot load the Oracle libraries.
>
>
>> system.log:
>>
>> Aug  1 18:53:45 MacBook [0x0-0x85085].org.squeak.pharo[15272]: Loading
>> backend library oracle, liboraclebackend.so or
>> /usr/local/lib/opendbx/liboraclebackend.so failed
>> Aug  1 18:53:45 MacBook [0x0-0x85085].org.squeak.pharo[15272]:
>> dlopen(/usr/local/lib/opendbx/liboraclebackend.so, 1): Library not loaded:
>> /b/32_216/rdbms/lib/libclntsh.dylib.10.1
>> Aug  1 18:53:45 MacBook [0x0-0x85085].org.squeak.pharo[15272]:
>> Referenced from: /usr/local/lib/opendbx/liboraclebackend.so
>> Aug  1 18:53:45 MacBook [0x0-0x85085].org.squeak.pharo[15272]:   Reason:
>> image not found
>>
>> The directory /b/32_216/rdbms/lib  doesn't exist, not sure if it's a 32/64
>> bit issue on this OS. Everything compiled as 32 bit but this platform also
>> support 64 bit.
>>
>>
> read here
>
>
> http://blog.rayapps.com/2009/09/06/how-to-setup-ruby-and-oracle-instant-client-on-snow-leopard/
>
> search /b/32_216/rdbms/lib  and read what it says....
> maybe you shoud reinstall a 32 oracle client  ?
>
>
http://download.oracle.com/otn/mac/instantclient/10204/instantclient-sdk-10.2.0.4.0-macosx-x86.zip

http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/intel_macsoft.html

I am not sure at all :(




>
>
>>  Thanks
>> Colin
>>
>>
>>
>>
>> On Sun, Aug 1, 2010 at 6: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.
>>>
>>> This from Pharo debug log:
>>>
>>> THERE_BE_DRAGONS_HERE
>>> Error: A call to an external function failed
>>> 1 August 2010 6:16:57 pm
>>>
>>> VM: Mac OS - intel - 1064 - Squeak4.1 of 17 April 2010 [latest update:
>>> #9957] 19.0
>>> Image: Pharo-1.1-11411 [Latest update: #11411]
>>>
>>> SecurityManager state:
>>> Restricted: false
>>> FileAccess: true
>>> SocketAccess: true
>>> Working Dir /Users/Development/Smalltalk/Squeak64bit/Contents/Resources
>>> Trusted Dir /foobar/tooBar/forSqueak/bogus/
>>> Untrusted Dir /foobar/tooBar/forSqueak/bogus/
>>>
>>> OpenDBXMacOSX(Object)>>error:
>>> Receiver: an OpenDBXMacOSX
>>>  Arguments and temporary variables:
>>> aString: 'A call to an external function failed'
>>>  Receiver's instance variables:
>>> an OpenDBXMacOSX
>>>
>>> OpenDBXMacOSX(Object)>>externalCallFailed
>>> Receiver: an OpenDBXMacOSX
>>>  Arguments and temporary variables:
>>> errCode: 0
>>>  Receiver's instance variables:
>>> an OpenDBXMacOSX
>>>
>>> OpenDBXMacOSX(OpenDBXUnix)>>apiInitialize:backend:host:port:
>>>  Receiver: an OpenDBXMacOSX
>>> Arguments and temporary variables:
>>> handle: a WordArray(0)
>>>  backend: 'oracle'
>>> host: 'hostname.com'
>>>  port: '1521'
>>> Receiver's instance variables:
>>> an OpenDBXMacOSX
>>>
>>> DBXOraclePlatform(DBXPlatform)>>createConnection:
>>> Receiver: a DBXOraclePlatform
>>> Arguments and temporary variables:
>>>  aConnection: a DBXConnection
>>> err: nil
>>>  handleArray: a WordArray(0)
>>> handle: nil
>>>  Receiver's instance variables:
>>> a DBXOraclePlatform
>>>
>>> DBXConnection>>connect
>>> Receiver: a DBXConnection
>>>  Arguments and temporary variables:
>>>
>>> Receiver's instance variables:
>>>  platform: a DBXOraclePlatform
>>> settings: a DBXConnectionSettings
>>>  handle: nil
>>> open: a ValueHolder
>>>  connected: a ValueHolder
>>> result: nil
>>>
>>>
>>> UndefinedObject>>DoIt
>>> Receiver: nil
>>> Arguments and temporary variables:
>>>  conn: a DBXConnection
>>> connectionSettings: a DBXConnectionSettings
>>>  rs: nil
>>> Receiver's instance variables:
>>> nil
>>>
>>> Compiler>>evaluate:in:to:notifying:ifFail:logged:
>>> Receiver: a Compiler
>>> Arguments and temporary variables:
>>>  textOrStream: '|conn connectionSettings rs |
>>>
>>> connectionSettings:= DBXConnectio...etc...
>>>  aContext: nil
>>> receiver: nil
>>>  aRequestor: a TextMorphForShoutEditor
>>> failBlock: [FakeClassPool adopt: nil.
>>>  ^ #failedDoit]
>>> logFlag: true
>>>  methodNode: DoIt
>>> | conn connectionSettings rs |
>>>  connectionSettings := DBXConn...etc...
>>> method: (UndefinedObject>>#DoIt "a CompiledMethod(570949632)")
>>>  value: nil
>>> toLog: nil
>>>  itsSelection: nil
>>> itsSelectionString: nil
>>>  Receiver's instance variables:
>>> sourceStream: a ReadStream '|conn connectionSettings rs |
>>>
>>> connectionSettings:=...etc...
>>> requestor: a TextMorphForShoutEditor
>>>  class: UndefinedObject
>>> category: nil
>>>  context: nil
>>> parser: a Parser
>>>
>>>
>>>
>>> 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.
>>>
>>> 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
>>>
>>> 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
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20100801/56a23a84/attachment.htm


More information about the SqueakDBX mailing list