X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9F0B2568CE for ; Wed, 16 Mar 2005 05:01:12 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32218-01 for ; Wed, 16 Mar 2005 05:00:50 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 00CE3568FB for ; Wed, 16 Mar 2005 05:00:46 +0000 (GMT) Received: from [192.168.1.20] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j2G4wakh023713; Tue, 15 Mar 2005 20:58:37 -0800 Message-ID: <4237BDC6.9070107@commandprompt.com> Date: Tue, 15 Mar 2005 21:01:58 -0800 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Yulius Tjahjadi Cc: pgsql-php@postgresql.org Subject: Re: pg_pconnect causing References: <08F5636B48FE8F4D856E209D0E6C0637A83BC3@hq01.ultimatearena.com> In-Reply-To: <08F5636B48FE8F4D856E209D0E6C0637A83BC3@hq01.ultimatearena.com> Content-Type: multipart/mixed; boundary="------------090109030905050100090800" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.04 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/40 X-Sequence-Number: 3055 This is a multi-part message in MIME format. --------------090109030905050100090800 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Yulius Tjahjadi wrote: >Hi, > >When I use pg_pconnect() and the apache process exits for reaping, >I get these errors. I'm using Postgres 8.0.1 on Ferdora Core 2. > >LOG: unexpected EOF on client connection >LOG: unexpected EOF on client connection >LOG: unexpected EOF on client connection > >I think I know what's going on. Since there is a persistent >connection, when the apache process dies postgres thinks >the connection was abruptly disconnected w/o a proper >close function. It's not causing me any problems, but I >would like to remove any bad messages from the log file. >I was wondering if this is just a bug that needs to be >fixed. > > You are correct in your assumption but it is not a bug. PostgreSQL is doing exactly what it should. The bug (if it was considered to be a bug) would be in the communication between PHP and Apache and PHP not closing the connection before Apache drops its process. Sincerely, Joshua D. Drake >Thanks. > >yulius > >---------------------------(end of broadcast)--------------------------- >TIP 8: explain analyze is your friend > > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL --------------090109030905050100090800 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard --------------090109030905050100090800--