Re: 12.2: Howto check memory-leak in worker?

On 5/4/20 4:56 AM, Peter wrote:
> Hi all,
> I have something that looks a bit insane:
>
> # ps axl | grep 6145
> UID PID PPID CPU PRI NI VSZ RSS MWCHAN STAT TT TIME COMMAND
> 770 6145 1 0 20 0 241756 868 select SsJ - 0:24.62 /usr/local/bin/postgres -D
> 770 6147 6145 0 23 0 243804 109784 select IsJ - 3:18.52 postgres: checkpointer (
> 770 6148 6145 0 20 0 241756 21348 select SsJ - 2:02.83 postgres: background writer
> 770 6149 6145 0 20 0 241756 7240 select SsJ - 16:36.80 postgres: walwriter (pos
> 770 6150 6145 0 20 0 21980 876 select SsJ - 0:13.92 postgres: archiver last w
> 770 6151 6145 0 20 0 21980 980 select SsJ - 0:58.45 postgres: stats collector
> 770 6152 6145 0 20 0 241756 1268 select IsJ - 0:02.07 postgres: logical replicati
> 770 43315 6145 0 21 0 251844 7520 select IsJ - 1:07.74 postgres: admin postgres 19
> 770 43317 6145 0 25 0 251764 8684 select IsJ - 1:28.89 postgres: admin bareos 192.
> 770 43596 6145 0 20 0 245620 4476 select IsJ - 0:00.12 postgres: admin bareos 192.
> 770 43761 6145 0 20 0 245620 4476 select IsJ - 0:00.15 postgres: admin bareos 192.
> 770 90206 6145 0 52 0 1331256 219720 racct DsJ - 563:45.41 postgres: bareos bareos 192
>
> The 90206 is continuously growing. It is the unspecific, all-purpose
> worker for the www.bareos.com backup tool, so it is a bit difficult to
> figure what precisely it does - but it tends to be rather simple
> straight-forward queries, so it is unlikely to have dozens of "internal sort
> operations and hash tables".
>

Is there any relevant information in the bareos or Postgres logs?

>
> OS is FreeBSD 11.3-RELEASE-p8 r360175M i386
> PostgreSQL 12.2 on i386-portbld-freebsd11.3, compiled by gcc9 (FreeBSD Ports Collection) 9.3.0, 32-bit
>
> autovacuum is Disabled.

Any particular reason for above?

> cheerio,
> PMc
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com