From users-return-267776-archive-asf-public=cust-asf.ponee.io@tomcat.apache.org Tue Jun 25 11:58:29 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 3898318062F for ; Tue, 25 Jun 2019 13:58:29 +0200 (CEST) Received: (qmail 20524 invoked by uid 500); 25 Jun 2019 11:58:26 -0000 Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Tomcat Users List" Delivered-To: mailing list users@tomcat.apache.org Received: (qmail 20513 invoked by uid 99); 25 Jun 2019 11:58:26 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 25 Jun 2019 11:58:26 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 972B8180D47 for ; Tue, 25 Jun 2019 11:58:25 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.09 X-Spam-Level: X-Spam-Status: No, score=0.09 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, NO_DNS_FOR_FROM=0.379, RCVD_IN_DNSWL_MED=-2.3, SPF_HELO_NONE=0.001, T_SPF_TEMPERROR=0.01] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id APjLt817kaRL for ; Tue, 25 Jun 2019 11:58:21 +0000 (UTC) Received: from smtp2.uni-freiburg.de (smtp2.uni-freiburg.de [132.230.2.212]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 0153260D1D for ; Tue, 25 Jun 2019 11:58:20 +0000 (UTC) Delivery-date: Tue, 25 Jun 2019 13:58:21 +0200 Received: from fe1.uni-freiburg.de ([132.230.2.221] helo=uni-freiburg.de) port 45594 by smtp2.uni-freiburg.de with esmtp ( Exim ) id 1hfk5W-0000lx-0x for users@tomcat.apache.org; Tue, 25 Jun 2019 13:58:14 +0200 Received: from [10.122.6.48] (account christoph.hanke@imtek.uni-freiburg.de [10.122.6.48] verified) by mail.uni-freiburg.de (CommuniGate Pro SMTP 6.2.12) with ESMTPSA id 12554759 for users@tomcat.apache.org; Tue, 25 Jun 2019 13:58:13 +0200 From: Christoph Hanke Subject: Memory problems due to org.apache.tomcat.dbcp.dbcp.AbandonedTrace? To: users@tomcat.apache.org Message-ID: <87a91026-9752-eb89-9ad5-a260584330e3@imtek.uni-freiburg.de> Date: Tue, 25 Jun 2019 13:58:09 +0200 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:60.0) Gecko/20100101 Thunderbird/60.7.1 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------465EEB706E6EEF106D432705" --------------465EEB706E6EEF106D432705 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Hi, I have got a jspx Page which gets reloaded every 30 seconds to show some status information. Consequently there are database requests every 30 seconds. Before switching from glassfish to tomcat (7.0.94) there were no issues with that, but now the memory consumption is bloating over time. Looking at the heapdump I recognized that the the traceLists of the used preparedStatements and the resultSets are the cause of the memory consumption.  I already tried to use***removeAbandoned*=true and setting*removeAbandonedTimeout=5 *seconds, as well as turning off my jspx-database-requests over night,  thinking this could provide the necessary "timeout" for the connection / AbandonedTrace objects ( https://tomcat.apache.org/tomcat-7.0-doc/api/org/apache/tomcat/dbcp/dbcp/AbandonedTrace.html ) to get cleaned up. Unfortuneatly it did not. I'm now thinking to turn of the tracking (by using |*clearTrace *()| ) but it seems a little bit hackish to me. Has someone eventually an idea where to look at or what to do? Kind regards Chris --------------465EEB706E6EEF106D432705--