X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 6C0959FB43F for ; Thu, 31 Aug 2006 23:03:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 74195-03-3 for ; Fri, 1 Sep 2006 02:02:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 338D09FB475 for ; Thu, 31 Aug 2006 23:01:44 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k8121aO9027237; Thu, 31 Aug 2006 22:01:37 -0400 (EDT) To: "Donald Fraser" cc: "[ADMIN]" Subject: Re: Strange message followed by server crash In-reply-to: <008c01c6c855$35f6cd20$7d64a8c0@demolish1> References: <003401c6c837$8dc6cb90$7d64a8c0@demolish1> <23160.1156513462@sss.pgh.pa.us> <008c01c6c855$35f6cd20$7d64a8c0@demolish1> Comments: In-reply-to "Donald Fraser" message dated "Fri, 25 Aug 2006 15:46:11 +0100" Date: Thu, 31 Aug 2006 22:01:36 -0400 Message-ID: <27236.1157076096@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/371 X-Sequence-Number: 22914 "Donald Fraser" writes: > Log messages: > <1Tmenteshvili 10709 2006-08-24 17:48:19 BST 0> ERROR: invalid = > message format > < 3670 2006-08-24 17:48:19 BST > LOG: server process (PID 10709) was = > terminated by signal 11 > At the same time, an engineer, who thought nobody was in the = > building, was working on the network and changing a network switch. I tried to reproduce this by using gdb to force the "invalid message format" failure --- that is, deliberately changing one of the values pq_getmsgend compares. No luck, the backend issued the error and continued just as it should. My best guess now that the crash was not directly related to that error, but was caused by insufficiently robust processing of whatever garbage was received following that. However, with no clue what that garbage might have looked like, there's too many possible code paths to try to chase through with no leads. Anyone care to do some random-data stress testing, ie, connect to a backend and squirt random data at it to see if you can make it crash rather than just complain and disconnect? Be prepared to show a backend stack trace and the exact data sent if you succeed. regards, tom lane