Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 83147 invoked from network); 8 Apr 2008 19:17:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 8 Apr 2008 19:17:57 -0000 Received: (qmail 14985 invoked by uid 500); 8 Apr 2008 19:17:52 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 14975 invoked by uid 500); 8 Apr 2008 19:17:52 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 14955 invoked by uid 99); 8 Apr 2008 19:17:51 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Apr 2008 12:17:51 -0700 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=DATE_IN_PAST_06_12,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [200.251.3.184] (HELO uipa01m02.usiminas.com.br) (200.251.3.184) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Apr 2008 19:17:09 +0000 Received: by uipa01m02 with Internet Mail Service (5.5.2656.59) id <2RRWA2Q0>; Tue, 8 Apr 2008 16:17:08 -0300 Message-ID: <1DA4730D9FDF93498D628B93820EEC0F0826F2CB@cos01m56.cosipa.su.net> From: Fernando Simonetti To: "'user-java@ibatis.apache.org'" Subject: groupby x out of memory Date: Tue, 8 Apr 2008 09:51:26 -0300 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Checked: Checked by ClamAV on apache.org Eventually my aplication server is going down by "Out of Memory". Analizing de heap dumping, it's point for the same class allocating 600 Mb. This event can occur 3 hours or 3 days after I restart my server. This class is used thounsands times in the period. Monitoring the memory of the server, I could see 300MB to 700MB of memory been allocated in 3 minutes. It hapens eventualy but not in a determined period. The unique diference for this class for others, is the groupby clause in Ibatis. First I thouth it could be a cartesian product, but I ran the query without parameters and found nothing. I going to implement this class without groupby clause, but first I would like to see if there are other options. thanks, Fernando