Re: [Sqlrelay-discussion] ORA Error : ORA-04030

[David M. <dav...@fi...>]

I believe that error means that either all of the system's memory has
been used, or the "max memory size" of a process has gotten too large.
This could be on the database server or the server running sqlrelay.

Run "ulimit -m" on the sqlrelay server and check to see if there are any
sqlr-connection-oracle8 processes that are close to consuming that
amount of memory.  If so, that could be the problem; there could be a
memory leak.  If not, then check on the database server and see if there
are any processes which are getting close to whatever "ulimit -m"
returns on that server.

sqlrelay 0.38 doesn't have any known memory leaks, but I've encountered
a few leaks in Oracle's client libraries.  There is one leak, for sure
on the client-side in 10g that occurs when a client logs in.  It causes
problems if the database is unavailable for a while and sqlrelay has to
attempt to log in over and over until it becomes available again.

Take a look and let me know what you find.

David Muse
dav...@fi...

On Thu, 2007-07-12 at 11:00 +0200, Huve Loic wrote:
> 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émoire de traitement manquante lors
> d'affectation de 123404 octets (QERGH hash-agg,kllcqas:kllsltba) 
> 
> 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). Do you have an idea of what it occurs.
> 
> Thanks a lot.
> Loic 
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion