Re: [Sqlrelay-discussion] Cannot fetch from bind cursor....
Brought to you by:
mused
Menu
▾
▴
Re: [Sqlrelay-discussion] Cannot fetch from bind cursor....
|
From: Andrew L <akl...@ya...> - 2011-07-28 22:17:34
|
additional info... After seeing: Debugging to: /my/path/to/SQLRELAY/var/sqlrelay/debug/sqlr-listener.24999 I took a look at /my/path/to/SQLRELAY/var/sqlrelay/debug/sqlr-listener.24999 but saw no errors: 07/28/2011 14:06:28 PDT listener [24999] : getting authentication... 07/28/2011 14:06:28 PDT listener [24999] : listener-based authentication succeeded 07/28/2011 14:06:28 PDT listener [24999] : incrementing session count... 07/28/2011 14:06:28 PDT listener [24999] : waiting for exclusive access... 07/28/2011 14:06:28 PDT listener [24999] : done waiting for exclusive access... 1 07/28/2011 14:06:28 PDT listener [24999] : waiting for the scaler... 07/28/2011 14:06:28 PDT listener [24999] : done waiting for the scaler... 07/28/2011 14:06:28 PDT listener [24999] : done incrementing session count 07/28/2011 14:06:28 PDT listener [24999] : getting a connection... 07/28/2011 14:06:28 PDT listener [24999] : acquiring exclusive shm access 07/28/2011 14:06:28 PDT listener [24999] : done acquiring exclusive shm access 07/28/2011 14:06:28 PDT listener [24999] : waiting for an available connection 07/28/2011 14:06:28 PDT listener [24999] : done waiting for an available connection 07/28/2011 14:06:28 PDT listener [24999] : handoff=pass 07/28/2011 14:06:28 PDT listener [24999] : signalling connection that we've read 07/28/2011 14:06:28 PDT listener [24999] : done signalling connection that we've read 07/28/2011 14:06:28 PDT listener [24999] : releasing exclusive shm access 07/28/2011 14:06:28 PDT listener [24999] : done releasing exclusive shm access 07/28/2011 14:06:28 PDT listener [24999] : done getting a connection 07/28/2011 14:06:28 PDT listener [24999] : passing descriptor... 07/28/2011 14:06:28 PDT listener [24999] : done passing descriptor 07/28/2011 14:06:28 PDT listener [24999] : decrementing busy listeners 07/28/2011 14:06:28 PDT listener [24999] : done decrementing busy listeners ________________________________ From: Andrew L <akl...@ya...> To: "sql...@li..." <sql...@li...> Sent: Thursday, July 28, 2011 2:47 PM Subject: [Sqlrelay-discussion] Cannot fetch from bind cursor.... 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 ------------------------------------------------------------------------------ Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion |
