[Sqlrelay-discussion] Question about cursor in sqlrelay

[Huve L. <l....@fo...>]

Hello David ,

I have another question about the cursors.
Is it a max value about the number of cursor used by connexion (I cant
use more 35).=20
When we load some web page with oracle procedure we get Listeners fork
and time out,  however I have a lot of available connexions but there
are not used and the listener fork and I must restart my pool.

Is it possible we use to many sqlrelay cursor (In oracle  no probleme).

exemple of what append :
3 Forks but when I do a sqlr-status I see X connexion not use. Each time
I want use the connexion a new fork appear and nothing occur. so I must
reload my configuration.

    0:04 sqlr-listener -id CRON_COMMANDE
-config /usr/local/sqlrelay/etc/sqlrelay.conf
    0:00  \_ sqlr-listener -id CRON_COMMANDE
-config /usr/local/sqlrelay/etc/sqlrelay.conf
    0:00  \_ sqlr-listener -id CRON_COMMANDE
-config /usr/local/sqlrelay/etc/sqlrelay.conf
    0:00  \_ sqlr-listener -id CRON_COMMANDE
-config /usr/local/sqlrelay/etc/sqlrelay.conf=20
    0:00 sqlr-connection-oracle8 -id CRON_COMMANDE -connectionid
CRON_COMMANDE -config /usr/local
217:47 sqlr-connection-oracle8 -id CRON_COMMANDE -connectionid
CRON_COMMANDE -config /usr/local
   0:00 sqlr-connection-oracle8 -id CRON_COMMANDE -connectionid
CRON_COMMANDE -config /usr/local
   0:00 sqlr-connection-oracle8 -id CRON_COMMANDE -connectionid
CRON_COMMANDE -config /usr/local


Open   Server Connections:  9
Opened Server Connections:  2986152
Open   Client Connections:  3
Opened Client Connections:  579
Open   Server Cursors:      150
Opened Server Cursors:      729
Times  New Cursor Used:     0
Times  Cursor Reused:       1135

Total  Queries:             2987347
Total  Errors:              2986155

Forked Listeners:           3

---------------------------------------------------------------------------=
--------

This part is about my last mail :=20

This is the display when I launch the procedure with php and my
connexion die (my last mail)
at one time I get a "(null)=3DErreur de segmentation" maybe it's at this
moment the connexion is kill.


randd:/var/www/PixPlace# php -e relay4loic.php
<hr><hr>SQL RELAY<hr><hr>Connecting to listener...
Inet socket: 192.168.1.69:9200
Authenticating with listener : devpixplace:pixplacedev
Waiting for auth success/failure...
No authentication error.
Must Not Reconnect.
Authenticating with connection : devpixplace:pixplacedev
Waiting for auth success/failure...
No authentication error.
Sending Query:
begin
PCK_COUNTRIES.P_GET_COUNTRY_LANGUAGE_TEST(:LANGUAGE,:ERROR,:CURSOR);
end;
Length: 79
Requesting a new cursor.
Sending 1 Input Bind Variables:
LANGUAGE(8:STRING)=3Dfr(2)
Sending Output Bind Variables:
ERROR
CURSOR
Send Column Info: yes
Skipping and Fetching
Skipping 0 rows
Fetching 0 rows
Checking For An Error... error!!!
Getting Error From Server
ORA-00942: Table ou vue inexistante
ORA-06512: =C3=A0 "DEVPIXPLACE.PCK_COUNTRIES", ligne 101
ORA-06512: =C3=A0 ligne 1
Getting Cursor ID...
Cursor ID: 0
Send Column Info: yes
Skipping and Fetching
Skipping 0 rows
Fetching 0 rows
Checking For An Error... none.
Getting Cursor ID...
Cursor ID: 0
Previous result set was not suspended.
Parsing Column Info
Actual row count: unknown
Affected row count: 0
Column count: 0
Receiving Output Bind Values:
        getting type...
        done getting type: 5
        INTEGER output bind
                done fetching
(null)=3D(null)
        getting type...
        done getting type: 4
        CURSOR output bind
                done fetching
(null)=3DErreur de segmentation


Thanks a lot.
Loic