Return-Path: Delivered-To: apmail-httpd-modules-dev-archive@locus.apache.org Received: (qmail 36978 invoked from network); 7 Jul 2007 10:50:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 7 Jul 2007 10:50:29 -0000 Received: (qmail 14448 invoked by uid 500); 7 Jul 2007 10:50:32 -0000 Delivered-To: apmail-httpd-modules-dev-archive@httpd.apache.org Received: (qmail 14105 invoked by uid 500); 7 Jul 2007 10:50:31 -0000 Mailing-List: contact modules-dev-help@httpd.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: modules-dev@httpd.apache.org Delivered-To: mailing list modules-dev@httpd.apache.org Received: (qmail 14094 invoked by uid 99); 7 Jul 2007 10:50:30 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Jul 2007 03:50:30 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of bnoordhuis@gmail.com designates 66.249.82.233 as permitted sender) Received: from [66.249.82.233] (HELO wx-out-0506.google.com) (66.249.82.233) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Jul 2007 03:50:26 -0700 Received: by wx-out-0506.google.com with SMTP id h27so381697wxd for ; Sat, 07 Jul 2007 03:50:06 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=WEUvV44+VBpx14zy7An+XvKle/nktcHQrTO9nnZPwmsPLeE4YpT2ctZ+DDf6aNC0QLSutp7RLdruJ1lp3pS0ElsXLx77OyJgJaZ/c2SDZfKr/iguBK0Qorbdf9PhnpuMJbGQJpHDylHoHW+oRWjwHqhR8GEBRByRISLlHw1o0zE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=NEscOaXZX+UpIZPIogYWqmc92WK4YjYYG0yeqX6a4fnNgwCvzS3hFfsOD6bTHOH1WIHW+0QjSY/7bvGtizklPWgxeX6b1zyYoJXZvkrhi7ozkRGD0gCWAol9vqJ6L/HAaepUJluy1ou1NOF4itGN+m9P3dg7r3as6hj+JgDkb40= Received: by 10.90.69.8 with SMTP id r8mr954566aga.1183805405364; Sat, 07 Jul 2007 03:50:05 -0700 (PDT) Received: by 10.90.66.17 with HTTP; Sat, 7 Jul 2007 03:50:05 -0700 (PDT) Message-ID: <54885e060707070350qde50245r319be1e4b726d177@mail.gmail.com> Date: Sat, 7 Jul 2007 12:50:05 +0200 From: "Ben Noordhuis" To: modules-dev@httpd.apache.org Subject: Re: mod_authn_dbd - internal server error after certain idle time In-Reply-To: <54885e060707070313u1fd93f84te299ae184483f7d3@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <00b701c7c000$f2f71300$66d482d8@CORP.LOCAL> <1183749481.5095.44.camel@fuego> <00d501c7c007$700c0b10$66d482d8@CORP.LOCAL> <1183752783.5095.56.camel@fuego> <20070706230429.34edfd4a@grimnir> <1183772227.5095.70.camel@fuego> <20070707093828.618637f7@grimnir> <468F607B.8020407@bellatlantic.net> <20070707105147.7b2e8e43@grimnir> <54885e060707070313u1fd93f84te299ae184483f7d3@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org On 7/7/07, Ben Noordhuis wrote: > I'm not aware of a reliable workaround for earlier versions of > MySQL, unfortunately. Allow me to reply to myself. If you can live with a slight performance impact, the code snippet below should help you to reconnect in a controlled fashion. Hope this helps. switch (mysql_query(&mysql, "SELECT 1")) { case 0: mysql_free_result(mysql_use_result(&mysql)); break; case CR_SERVER_GONE_ERROR: /* reinitialize */ break; default: /* handle error */ }