From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Devendra Yadav <devendraydba@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Stats getting corrupted
Date: Thu, 20 Dec 2018 12:37:43 -0300
Message-ID: <20181220153743.slaxsk4vjcvwwe6h@alvherre.pgsql> (raw)
In-Reply-To: <CAGQOD0mu3u-k3oRJdrhrJJwBNK0An7nG02jUypgqiMxoRvZ5Ug@mail.gmail.com>
On 2018-Dec-20, Devendra Yadav wrote:
> Dear All,
>
> The stats file in *pg_stat_tmp *are getting corrupted. Even earlier the
> files in *pg_stat* got corrupted. They show ?? ?? when you list the files
> in folder. Also we can see them in the error log.
> it says " *could not open statistics file 'pg_stat_tml/db_0.tmp': to
> 'pg_stat_tmp/db_0.stat': Input/output error".*
You have problems related to the disk or operating system. This is not
PostgreSQL's fault. See `dmesg` or whatever OS diagnostics you have.
I suggest never to transcribe error messages manually. Copy & paste instead.
When transcribing you're likely to make mistakes that obscure important
details.
> After doing e2fsck (file system scan ) it is fixed but that needs downtime
> and also it removes the file. What is the impact if the file is being
> removed ?
Deleting those files will lose some statistical counters, but it's not
critical data; you're advised to run ANALYZE on all databases after
making the disk work properly again.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
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-admin@postgresql.org
Cc: alvherre@2ndquadrant.com, devendraydba@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Stats getting corrupted
In-Reply-To: <20181220153743.slaxsk4vjcvwwe6h@alvherre.pgsql>
* 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