[Sqlrelay-discussion] Question about cursor in sqlrelay
Brought to you by:
mused
|
From: Huve L. <l....@fo...> - 2007-10-01 08:58:27
|
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
|