Re: [Sqlrelay-discussion] ORA Error : ORA-04030
Brought to you by:
mused
|
From: David M. <dav...@fi...> - 2007-07-12 13:09:10
|
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 |