Hi Paul, I don't think that it is a database issue. It is rather the question where the application places the large amounts of data and how it is cleaned up.
I interprete your statements that it is placed in the session object assuming that the memory is freed at session timeout. Unfortunately that is not the case. The session timeout is a security feature to force a new login if the same user comes back after a longish idle time. There is no guarantee that the container will actually delete the session object at the session timeout. As long as there is a reference to the session object GC cannot free the attached memory. You will have to find a way that the application keeps the data only for the duration of a request, or use another mechanism to limit the memory requirements. HTH, Alfred. -----Original Message----- From: Paul Joseph [mailto:[email protected]] Sent: Montag, 24. Oktober 2011 17:16 To: [email protected] Subject: thought I had fixe it Hi there, I thought I had fixed this memory issue but... I am using Tomcat 6 in a Windows 32 bit environment (Windows 2003) with Cocoon 2.1.11 and Java 1.6, agains Postgresql 8.4 with the latest Postgres 9.1, JDBC 4 driver. The behavior is this: The user fires of a LARGE query that returns 25,000 large objects. The user repeats this 20 times within 5 minutes to show me he can freeze the app. On the 20th time, it says out of memory (heap space). The JVM indicates that it is maxed to the limit specified in Xms and that there is only about 2MB of memory free. I then ask her to log off. The session time out is set to 20 minutes. But even after an hour, the memory is not reclaimed by the JVM--it still reports that only about 2MB is still free. Is the fact that it is not reclaiming memory an indication of a memory leak? I am using the following settings in my repository.database: <jdbc-connection-descriptor jcd-alias="WebApp" default-connection="true" platform="PostgreSQL" jdbc-level="4.0" driver="org.postgresql.Driver" protocol="jdbc" subprotocol="postgresql" dbalias="//localhost:5432/WebApp" username="******" password="******" eager-release="false" batch-mode="false"> <connection-pool maxActive="200" validationQuery="" /> <sequence-manager className="org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl" /> </jdbc-connection-descriptor> Thanks much! Paul --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] The content of this e-mail is intended only for the confidential use of the person addressed. If you are not the intended recipient, please notify the sender and delete this e-mail immediately. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
