From dev-return-55017-archive-asf-public=cust-asf.ponee.io@jackrabbit.apache.org Tue Dec 1 10:38:35 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mxout1-he-de.apache.org (mxout1-he-de.apache.org [95.216.194.37]) by mx-eu-01.ponee.io (Postfix) with ESMTPS id 6AE79180648 for ; Tue, 1 Dec 2020 11:38:35 +0100 (CET) Received: from mail.apache.org (mailroute1-lw-us.apache.org [207.244.88.153]) by mxout1-he-de.apache.org (ASF Mail Server at mxout1-he-de.apache.org) with SMTP id EBE0E660C4 for ; Tue, 1 Dec 2020 10:38:31 +0000 (UTC) Received: (qmail 88159 invoked by uid 500); 1 Dec 2020 10:38:31 -0000 Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@jackrabbit.apache.org Delivered-To: mailing list dev@jackrabbit.apache.org Received: (qmail 88137 invoked by uid 99); 1 Dec 2020 10:38:31 -0000 Received: from ec2-52-204-25-47.compute-1.amazonaws.com (HELO mailrelay1-ec2-va.apache.org) (52.204.25.47) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Dec 2020 10:38:31 +0000 Received: from jira2-he-de.apache.org (jira2-he-de.apache.org [168.119.33.54]) by mailrelay1-ec2-va.apache.org (ASF Mail Server at mailrelay1-ec2-va.apache.org) with ESMTPS id E43173E8F5 for ; Tue, 1 Dec 2020 10:38:30 +0000 (UTC) Received: from jira2-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira2-he-de.apache.org (ASF Mail Server at jira2-he-de.apache.org) with ESMTP id 3B619C803EE for ; Tue, 1 Dec 2020 10:38:00 +0000 (UTC) Date: Tue, 1 Dec 2020 10:38:00 +0000 (UTC) From: "Julian Reschke (Jira)" To: dev@jackrabbit.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (JCR-4579) jackrabbit-data: allow to disable statement pooling through system property MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/JCR-4579?page=3Dcom.atlassian.= jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Reschke updated JCR-4579: -------------------------------- Fix Version/s: 2.16.7 > jackrabbit-data: allow to disable statement pooling through system proper= ty > -------------------------------------------------------------------------= -- > > Key: JCR-4579 > URL: https://issues.apache.org/jira/browse/JCR-4579 > Project: Jackrabbit Content Repository > Issue Type: Bug > Components: jackrabbit-data > Reporter: Claus K=C3=B6ll > Assignee: Claus K=C3=B6ll > Priority: Major > Labels: candidate_jcr_2_16 > Fix For: 2.22, 2.16.7, 2.21.2, 2.20.2 > > > We are using a DriverDataSource and in really rare situations we see foll= owing exception > {code:java} > Closed Statement; nested exception is java.sql.SQLException: Closed State= ment {code} > The DriverDataSource uses the commons-dbcp library to create a BasicDataS= ource. > The old commons-dbcp is also using a fairly old version of commons-pool. > After researching a valid fix can be is to disable the pooling of Prepare= dStatements. > As a quick fix i would define a SystemProperty to disable the pooling. We= have a really high load and we see no performance impacts. > As a future fix we can update to a actual dbcp2 version. -- This message was sent by Atlassian Jira (v8.3.4#803005)