From users-return-19128-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org Fri Sep 7 05:31:45 2012 Return-Path: X-Original-To: apmail-jackrabbit-users-archive@minotaur.apache.org Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DED34D646 for ; Fri, 7 Sep 2012 05:31:45 +0000 (UTC) Received: (qmail 54717 invoked by uid 500); 7 Sep 2012 05:31:45 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 54171 invoked by uid 500); 7 Sep 2012 05:31:40 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Delivered-To: moderator for users@jackrabbit.apache.org Received: (qmail 47416 invoked by uid 99); 7 Sep 2012 00:50:57 -0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of twcrone@gmail.com designates 209.85.210.170 as permitted sender) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=b9o2bjCsp6pHBfQXvjI4yTynd5hAKA5xEjV/eDljDC8=; b=f0fBBgx/XqdZchEdTCQkcEfXHvZCwo+6a1LsCvYt1rmavXCdB6a0PvG6EQHbbcPyXQ zUuhulzLi67yCeF19u2ZlQvwd47QdO/2puAW8Cwnmzsiv2fSVqIe6WJeIAgqVRtud7qJ UB+PGd9QGPo25R+sKGyAZPT9xpP9kPzHvWMLFY/UyZQbqFsDOW1yvrfaNEkiAQVhh0Gx b+7jU6DNSAgd3iD2h+EKHCo0lzWK3xvpGDE7k+YMkgkXj0bsZbNHyJCXMJWqWFYBwjYC YttqKIaoTBbXCvvUFg+mKLHx1Wi9jWFQbU+98YRnxfdgWqwwb5tQvfkvsZbZsPuyDBq2 H/Eg== MIME-Version: 1.0 Date: Thu, 6 Sep 2012 20:50:28 -0400 Message-ID: Subject: Jackrabbit with Postgres From: Todd Crone To: users@jackrabbit.apache.org Content-Type: multipart/alternative; boundary=14dae9340539894fe804c911fea2 --14dae9340539894fe804c911fea2 Content-Type: text/plain; charset=ISO-8859-1 We had an issue with JCR integration with PostgreSQL under load where it looked like a transaction would hang. The same scenario would stop with MySQL but would timeout on its own. The JCR code seemed to depend on this behavior that MySQL provides by default. PostgreSQL by default apparently won't timeout a statement. So we updated the statement_timeout in postgresql.conf from -1 (no timeout) to something (10000 or more perhaps) and this seems to solve the problem. I just thought this might be useful in the Jackrabbit documentation but I'm not active in the community currently. Can someone add this note somewhere or direct me to the proper location? Todd Crone --14dae9340539894fe804c911fea2--