From: Laszlo Nagy <gandalf@shopzeus.com>
To: pgsql-admin@postgresql.org
Subject: Re: rebellious pg stats collector (reopened case)
Date: Mon, 22 Dec 2008 14:58:59 +0100
Message-ID: <494F9D23.1040601@shopzeus.com> (raw)
In-Reply-To: <7117.1229952970@sss.pgh.pa.us>
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>
> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gandalf@shopzeus.com, pgsql-admin@postgresql.org
Subject: Re: rebellious pg stats collector (reopened case)
In-Reply-To: <494F9D23.1040601@shopzeus.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox