BUG #12071: Stat collector went crasy (50MB/s constant writes)

From: maxim(dot)boguk(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12071: Stat collector went crasy (50MB/s constant writes)
Date: 2014-11-26 13:08:10
Message-ID: 20141126130810.15507.39189@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

The following bug has been logged on the website:

Bug reference: 12071
Logged by: Maxim Boguk
Email address: maxim(dot)boguk(at)gmail(dot)com
PostgreSQL version: 9.2.9
Operating system: Linux
Description:

Hi,

On one of my servers stat collector went crasy on idle system.
It constantly write around 50MB/s on idle database (no activity at all).

What I tried:
1)stop/start the database - no effect
2)update to 9.2.9 from 9.2.7 - no effect

Size of the pgstat.stat file: 5270114 bytes (reasonable small).

strace look like:

open("pg_stat_tmp/pgstat.tmp", O_WRONLY|O_CREAT|O_TRUNC, 0666) = 7
fstat(7, {st_mode=S_IFREG|0600, st_size=0, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x7f90455b5000
write(7,
"\232\274\245\1fCWw\301\253\1\0\370\27\1\0\0\0\0\0\242\7\0\0\0\0\0\0\211\2569\270"...,
4096) = 4096
write(7,
"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096)
= 4096
write(7,
"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0T(at)\340N"..., 4096)
= 4096
write(7,
"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096)
= 4096
write(7,
"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096)
= 4096
write(7,
"\0\0\0\0\0\2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096)
= 4096
write(7,
"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096)
= 4096

I see nothing real weird in strace output.

It's test server with full access so I can try a lot of things but at this
moment I out of ideas.

Kind Regards,
Maksym

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2014-11-26 13:15:26 Re: BUG #12071: Stat collector went crasy (50MB/s constant writes)
Previous Message bouda 2014-11-26 08:10:59 BUG #12070: hstore extension: hstore_to_json_loose produces invalid JSON

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2014-11-26 13:15:26 Re: BUG #12071: Stat collector went crasy (50MB/s constant writes)
Previous Message Palle Girgensohn 2014-11-26 13:06:36 Re: [pgsql-packagers] Palle Girgensohn's ICU patch