[Sqlrelay-discussion] Cannot fetch from bind cursor....

[Andrew L <akl...@ya...>]

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