From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Sebastian Tennant Newsgroups: gmane.lisp.guile.user Subject: Broken pipe errors using guile-pg with guile 1.8 Date: Mon, 23 Feb 2009 16:57:21 +0000 Message-ID: NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" X-Trace: ger.gmane.org 1235408250 1827 80.91.229.12 (23 Feb 2009 16:57:30 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Mon, 23 Feb 2009 16:57:30 +0000 (UTC) To: guile-user@gnu.org Original-X-From: guile-user-bounces+guile-user=m.gmane.org@gnu.org Mon Feb 23 17:58:45 2009 Return-path: Envelope-to: guile-user@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1Lbe8Y-0005i7-7e for guile-user@m.gmane.org; Mon, 23 Feb 2009 17:58:36 +0100 Original-Received: from localhost ([127.0.0.1]:37714 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Lbe7D-0004Lb-GD for guile-user@m.gmane.org; Mon, 23 Feb 2009 11:57:11 -0500 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1Lbe6v-0004LM-Ob for guile-user@gnu.org; Mon, 23 Feb 2009 11:56:53 -0500 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1Lbe6u-0004L8-GV for guile-user@gnu.org; Mon, 23 Feb 2009 11:56:53 -0500 Original-Received: from [199.232.76.173] (port=48432 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Lbe6u-0004L5-B0 for guile-user@gnu.org; Mon, 23 Feb 2009 11:56:52 -0500 Original-Received: from mx20.gnu.org ([199.232.41.8]:25788) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1Lbe6t-0001Z7-Mz for guile-user@gnu.org; Mon, 23 Feb 2009 11:56:51 -0500 Original-Received: from main.gmane.org ([80.91.229.2] helo=ciao.gmane.org) by mx20.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1Lbe6p-000414-U1 for guile-user@gnu.org; Mon, 23 Feb 2009 11:56:48 -0500 Original-Received: from list by ciao.gmane.org with local (Exim 4.43) id 1Lbe6j-0004g9-T9 for guile-user@gnu.org; Mon, 23 Feb 2009 16:56:41 +0000 Original-Received: from vps203.linuxvps.org ([91.186.7.203]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 23 Feb 2009 16:56:41 +0000 Original-Received: from sebyte by vps203.linuxvps.org with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 23 Feb 2009 16:56:41 +0000 X-Injected-Via-Gmane: http://gmane.org/ Original-Lines: 221 Original-X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: vps203.linuxvps.org X-Composed-In: Gnus User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/22.2 (gnu/linux) Cancel-Lock: sha1:6EbBLCqY9CPUpMmTMnuRIN/DE0Y= X-detected-kernel: by mx20.gnu.org: Linux 2.6, seldom 2.4 (older, 4) X-detected-operating-system: by monty-python.gnu.org: GNU/Linux 2.6, seldom 2.4 (older, 4) X-BeenThere: guile-user@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: General Guile related discussions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: guile-user-bounces+guile-user=m.gmane.org@gnu.org Errors-To: guile-user-bounces+guile-user=m.gmane.org@gnu.org Xref: news.gmane.org gmane.lisp.guile.user:7151 Archived-At: --=-=-= Hi Guilers, Is anyone familiar with the internals of guile-pg (version 0.16, author Ian Grant) which wraps PostgreSQL's libpq? I'm getting a lot of 'broken pipe' errors of the sort: Feb 23 11:32:13 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:32:13 stderr: ERROR: could not send startup packet: Broken pipe It's especially bad at times of light load (rather than no load) and I never once noticed this error whilst the webapp was in development (i.e., I was the only person using it) which suggests to me that it's happening whenever two or more page requests call scripts that attempt to open database connections more or less at the same time. All my calls to pg-connectdb are let bound so database connections are (supposed to be) closed after every query. Any advice very much appreciated. I've attached a log extract to give you an idea of the frequency of failures. I need to find a solution to this problem fast! Seb P.S. Perhaps upgrading guile-pg is the first thing I should try? IIRC there's a more recent pkgsrc version (which is guile 1.8 comaptible) somewhere... hunting for it now. --=-=-= Content-Disposition: inline; filename=broken_pipes.txt Feb 23 11:32:12 session.scm: Called... Feb 23 11:32:12 session.scm: Called... Feb 23 11:32:13 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:32:13 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:32:13 home: home.scm: EXITED WITH CODE 1 Feb 23 11:32:13 listing-view: listing-view.scm: exited cleanly Feb 23 11:32:13 listing-view: # -- Feb 23 11:43:27 home: calling home.scm... Feb 23 11:43:27 session.scm: Called... Feb 23 11:43:27 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:43:27 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:43:27 home: home.scm: EXITED WITH CODE 1 Feb 23 11:43:27 home: # Feb 23 11:43:40 listing-view: calling listing-view.scm... Feb 23 11:43:40 session.scm: Called... Feb 23 11:43:40 session.scm: User peteksirin has just logged in. Feb 23 11:43:40 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:43:40 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:43:40 listing-view: listing-view.scm: EXITED WITH CODE 1 Feb 23 11:43:40 listing-view: # Feb 23 11:43:44 listing-view: calling listing-view.scm... -- Feb 23 11:44:13 session.scm: Called... Feb 23 11:44:13 session.scm: User peteksirin has just logged in. Feb 23 11:44:13 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:44:13 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:44:13 listing-view: listing-view.scm: EXITED WITH CODE 1 Feb 23 11:44:14 listing-view: # Feb 23 11:44:16 listing-view: calling listing-view.scm... -- Feb 23 11:44:30 account-remind-form-handler.scm: Called... Feb 23 11:44:30 account-remind-form-handler.scm: Form checks passed. Feb 23 11:44:30 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:44:30 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:44:30 account-remind: account-remind.scm: EXITED WITH CODE 1 Feb 23 11:44:30 account-remind-form-handler.scm: Address is in use, account details exist. Sending reminder... Feb 23 11:44:30 account-remind: # -- Feb 23 11:45:37 account-remind: calling account-remind.scm... Feb 23 11:45:37 session.scm: Called... Feb 23 11:45:37 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:45:37 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:45:37 account-remind-form-handler.scm: Called... Feb 23 11:45:37 account-remind-form-handler.scm: Form checks passed. Feb 23 11:45:37 account-remind-form-handler.scm: Address is in use, account details exist. Sending reminder... -- Feb 23 11:46:10 home: calling home.scm... Feb 23 11:46:10 session.scm: Called... Feb 23 11:46:10 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:46:10 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:46:10 home: home.scm: EXITED WITH CODE 1 Feb 23 11:46:10 home: # Feb 23 11:46:12 listing-view: calling listing-view.scm... -- Feb 23 11:46:19 home: calling home.scm... Feb 23 11:46:19 session.scm: Called... Feb 23 11:46:19 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:46:19 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:46:19 home: home.scm: EXITED WITH CODE 1 Feb 23 11:46:19 home: # Feb 23 11:46:25 listing-view: calling listing-view.scm... -- Feb 23 11:47:22 session.scm: User peteksirin is logged in. Feb 23 11:47:22 session.scm: Called... Feb 23 11:47:22 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:47:22 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:47:22 listing-browse: listing-browse.scm: EXITED WITH CODE 1 Feb 23 11:47:23 listing-view: listing-view.scm: exited cleanly Feb 23 11:47:23 listing-view: # -- Feb 23 11:47:45 session.scm: Called... Feb 23 11:47:45 session.scm: User peteksirin is logged in. Feb 23 11:47:45 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:47:45 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:47:45 home: home.scm: EXITED WITH CODE 1 Feb 23 11:47:45 rates-rationale: rates-rationale.scm: exited cleanly Feb 23 11:47:45 rates-rationale: # -- Feb 23 11:48:40 home: calling home.scm... Feb 23 11:48:40 session.scm: Called... Feb 23 11:48:40 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:48:40 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:48:40 home: home.scm: EXITED WITH CODE 1 Feb 23 11:48:40 home: # Feb 23 11:48:52 listing-browse: calling listing-browse.scm... -- Feb 23 11:49:52 home: calling home.scm... Feb 23 11:49:52 session.scm: Called... Feb 23 11:49:52 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:49:52 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:49:52 home: home.scm: EXITED WITH CODE 1 Feb 23 11:49:52 home: # Feb 23 11:50:11 home: calling home.scm... Feb 23 11:50:11 session.scm: Called... Feb 23 11:50:11 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:50:11 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:50:11 home: home.scm: EXITED WITH CODE 1 Feb 23 11:50:11 home: # Feb 23 11:50:29 listing-browse: calling listing-browse.scm... Feb 23 11:50:29 session.scm: Called... Feb 23 11:50:30 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:50:30 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:50:30 listing-browse: listing-browse.scm: EXITED WITH CODE 1 Feb 23 11:50:30 listing-browse: # Feb 23 11:50:46 listing-view: calling listing-view.scm... -- Feb 23 11:51:13 home: calling home.scm... Feb 23 11:51:14 session.scm: Called... Feb 23 11:51:14 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:51:14 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:51:14 home: home.scm: EXITED WITH CODE 1 Feb 23 11:51:14 home: # Feb 23 11:51:26 listing-view: calling listing-view.scm... -- Feb 23 11:52:20 home: calling home.scm... Feb 23 11:52:20 session.scm: Called... Feb 23 11:52:20 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:52:20 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:52:20 home: home.scm: EXITED WITH CODE 1 Feb 23 11:52:21 home: # Feb 23 11:53:08 home: calling home.scm... Feb 23 11:53:08 session.scm: Called... Feb 23 11:53:08 stderr: ERROR: In procedure pg-connectdb: Feb 23 11:53:08 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 11:53:08 home: home.scm: EXITED WITH CODE 1 Feb 23 11:53:08 home: # Feb 23 11:54:23 listing-view: calling listing-view.scm... -- Feb 23 11:57:50 stderr: 35: 3* [pg-connectdb "dbname=itidb"] Feb 23 11:57:50 stderr: Feb 23 11:57:50 stderr: zlib/listing-pgutils.scm:35:18: In procedure pg-connectdb in expression (pg-connectdb "dbname=itidb"): Feb 23 11:57:50 stderr: zlib/listing-pgutils.scm:35:18: could not send startup packet: Broken pipe Feb 23 11:57:50 stderr: ABORT: (misc-error) Feb 23 11:58:21 stderr: Feb 23 11:58:21 stderr: In standard input: -- Feb 23 12:09:16 account-create-submission-handler.scm: Empty value checks passed and chosen username not in use. Feb 23 12:09:16 account-create-submission-handler.scm: Email address xxx@xxx.xxx in use, but without a username. Performing sql UPDATE... Feb 23 12:09:16 stderr: ERROR: In procedure pg-connectdb: Feb 23 12:09:16 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 12:09:16 account-create: account-create.scm: EXITED WITH CODE 1 Feb 23 12:09:16 account-create-submission-handler.scm: Done. Feb 23 12:09:17 account-create: # -- Feb 23 12:13:07 account-create-submission-handler.scm: Called... Feb 23 12:13:07 account-create-submission-handler.scm: Empty value checks passed and chosen username not in use. Feb 23 12:13:07 stderr: ERROR: In procedure pg-connectdb: Feb 23 12:13:07 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 12:13:07 account-create: account-create.scm: EXITED WITH CODE 1 Feb 23 12:13:07 account-create-submission-handler.scm: Email address xxx@xxx.xxx not in use. Performing sql INSERT... Feb 23 12:13:08 account-create: # -- Feb 23 15:52:26 home: calling home.scm... Feb 23 15:52:26 session.scm: Called... Feb 23 15:52:26 stderr: ERROR: In procedure pg-connectdb: Feb 23 15:52:26 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 15:52:26 home: home.scm: EXITED WITH CODE 1 Feb 23 15:52:26 home: # Feb 23 15:53:33 listing-view: calling listing-view.scm... -- Feb 23 16:09:35 session.scm: Called... Feb 23 16:09:35 account-create-submission-handler.scm: Called... Feb 23 16:09:35 stderr: ERROR: In procedure pg-connectdb: Feb 23 16:09:35 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 16:09:35 account-create: account-create.scm: EXITED WITH CODE 1 Feb 23 16:09:35 account-create-submission-handler.scm: Empty value checks passed and chosen username not in use. Feb 23 16:09:35 account-create-submission-handler.scm: Email address xxx@xxx.xxx in use, but without a username. Performing sql UPDATE... -- Feb 23 16:11:49 account-create-submission-handler.scm: Called... Feb 23 16:11:49 account-create-submission-handler.scm: Empty value checks passed and chosen username not in use. Feb 23 16:11:49 stderr: ERROR: In procedure pg-connectdb: Feb 23 16:11:49 stderr: ERROR: could not send startup packet: Broken pipe Feb 23 16:11:49 account-create: account-create.scm: EXITED WITH CODE 1 Feb 23 16:11:49 account-create-submission-handler.scm: Email address xxx@xxx.xxx in use, but without a username. Performing sql UPDATE... Feb 23 16:11:50 account-create: # --=-=-= -- Emacs' AlsaPlayer - Music Without Jolts Lightweight, full-featured and mindful of your idyllic happiness. http://home.gna.org/eap --=-=-=--