Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id EAA1C64FFEC
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 22 Dec 2008 09:57:46 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 19336-02
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 22 Dec 2008 09:57:44 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from shopzeus.com (135-shost.hostoffice.hu [195.228.74.135])
	by mail.postgresql.org (Postfix) with ESMTP id 8E9BB64FF86
	for <pgsql-performance@postgresql.org>;
	Mon, 22 Dec 2008 09:57:44 -0400 (AST)
Received: from [192.168.1.104] (localhost [127.0.0.1])
	by shopzeus.com (Postfix) with ESMTP id 902C2392435
	for <pgsql-performance@postgresql.org>;
	Mon, 22 Dec 2008 08:54:02 -0500 (EST)
Message-ID: <494F9CCD.5090002@shopzeus.com>
Date: Mon, 22 Dec 2008 14:57:33 +0100
From: Laszlo Nagy <gandalf@shopzeus.com>
User-Agent: Thunderbird 2.0.0.18 (X11/20081125)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: [ADMIN] rebellious pg stats collector (reopened case)
References: <49479876.8040607@shopzeus.com>
	<20081216134542.GH4741@alvh.no-ip.org>
	<494B614C.5060808@shopzeus.com>
	<20081219130446.GC4278@alvh.no-ip.org>
	<494F67D2.3090406@shopzeus.com> <6938.1229952228@sss.pgh.pa.us>
	<20081222132721.GC10220@alvh.no-ip.org>
	<7117.1229952970@sss.pgh.pa.us>
In-Reply-To: <7117.1229952970@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.125 tagged_above=0 required=5
	tests=DNS_FROM_RFC_BOGUSMX=2.125
X-Spam-Level: **
X-Archive-Number: 200812/191
X-Sequence-Number: 32227


> and see if its output changes when you start to trace it.
>   
%cat test.c
#include <stdio.h>

int main() {
    while(1) {
        sleep(5);
        printf("ppid = %d\n", getppid());
    }
}

%gcc -o test test.c
%./test
ppid = 47653
ppid = 47653
ppid = 47653 # Started "truss -p 48864" here!
ppid = 49073
ppid = 49073
ppid = 49073

> Agreed, but we need to understand what the tools being used to
> investigate the problem are doing ...
>   
Unfortunately, I'm not able to install strace:

# pwd
/usr/ports/devel/strace
# make
===>  strace-4.5.7 is only for i386, while you are running amd64.
*** Error code 1

Stop in /usr/ports/devel/strace.

I'll happily install any trace tool, but have no clue which one would help.