[Sqlrelay-discussion] ORA Error : ORA-04030

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

Hello,

We use since a short time sqlrelay with oracle RAC 10 g on a debian etch
and sqlrelay 0.38.
We use it for php pooling.
We have a strange probleme, all work fine during 15-16 hours and at one
moment we received  this type of errors :

ORA Error : ORA-04030: m=C3=A9moire de traitement manquante lors
d'affectation de 123404 octets (QERGH hash-agg,kllcqas:kllsltba)=20

In the same time sqlr-status detect errors :

root@sqlrelay:/usr/local/sqlrelay/bin# sqlr-status -id USER_BRAIN_A
Warning: using default connectionid.
  Open   Server Connections:  20
  Opened Server Connections:  20
  Open   Client Connections:  1
  Opened Client Connections:  23324
  Open   Server Cursors:      300
  Opened Server Cursors:      23623
  Times  New Cursor Used:     0
  Times  Cursor Reused:       4469369
  Total  Queries:             2463745

  Total  Errors:              66

  Forked Listeners:           0


We just restart instance and all work fine again (errors stop until 15
or 16 hours).=20
Do you have an idea of what it occurs.

Thanks a lot.
Loic