Re: rebellious pg stats collector (reopened case) - Mailing list pgsql-admin

From Laszlo Nagy
Subject Re: rebellious pg stats collector (reopened case)
Date
Msg-id 494F9D23.1040601@shopzeus.com
Whole thread Raw
In response to Re: rebellious pg stats collector (reopened case)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
> 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.




pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: rebellious pg stats collector (reopened case)
Next
From: Carol Walter
Date:
Subject: Psql errors