[Sqlrelay-discussion] Cannot fetch from bind cursor....
Brought to you by:
mused
|
From: Andrew L <akl...@ya...> - 2011-07-28 21:48:03
|
hi I just installed sqlrelay-0.42 and rudiments-0.33 on my Linux system and ran: $SQLRELAYHOME/bin/sqlr-start -id ire -config $SQLRELAYHOME/etc/sqlrelay.conf Everything starts up successfully: Starting listener: sqlr-listener -id ire -config /my/path/to/SQLRELAY/etc/sqlrelay.conf -debug Debugging to: /my/path/to/SQLRELAY/var/sqlrelay/debug/sqlr-listener.30342 Starting 1 connections to ire : sqlr-connection-oracle8 -id ire -connectionid ire -config /my/path/to/SQLRELAY/etc/sqlrelay.conf -debug Debugging to: /my/path/to/SQLRELAY/var/sqlrelay/debug/sqlr-connection.30346 Starting scaler: sqlr-scaler -id ire -debug -config /my/path/to/SQLRELAY/etc/sqlrelay.conf Starting cache manager: sqlr-cachemanager Warning: using default id. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. Thanks to FeedLounge for sponsoring: Query routing and filtering. However, when I try to run the following Perl code: 1 ..... 2 $stmt = 'begin :cursor := my_function; end;'; 3 $curs->prepareQuery ($stmt); 4 $curs->defineOutputBindCursor("cursor"); 5 $curs->executeQuery() || 6 die "Can't retrieve data from database: " . $curs->errorMessage(); 7 my $bindcur=$curs->getOutputBindCursor("cursor") || die "getOutputBindCursor() failed: " . $curs->errorMessage(); 8 $bindcur->fetchFromBindCursor() || die "Can't fetch from bind cursor: " . $bindcur->errorMessage(); 9 ..... my Perl script dies while trying to invoke fetchFromBindCursor at line 8. The window where I ran sqlr-start command immediately shows: Debugging to: /my/path/to/SQLRELAY/var/sqlrelay/debug/sqlr-listener.24999 (pid=24781) Abnormal termination: signal 11 received Couldn't open debug file: (null) Couldn't open debug file: (null) Couldn't open debug file: (null) Couldn't open debug file: (null) Couldn't open debug file: (null) Couldn't open debug file: (null) Couldn't open debug file: (null) Couldn't open debug file: (null) I could NOT find sqlr-listener.24781 or sqlr-connection.24781 in the /my/path/to/SQLRELAY/var/sqlrelay/debug directory. Also, the output from the "ps" does not show the sqlr-connection-oracle8 process. It looks like sqlr-connection-oracle8 died when 'Abnormal termination: signal 11 received' message appeared. Is this a known issue and how do I resolve the problem? My Perl script runs without any problems when I use rudiments-0.32 and sqlrelay-0.39.4 version. Thanks --Andrew |