pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Stats getting corrupted 2+ messages / 2 participants [nested] [flat]
* Stats getting corrupted @ 2018-12-20 03:09 Devendra Yadav <devendraydba@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Devendra Yadav @ 2018-12-20 03:09 UTC (permalink / raw) To: pgsql-admin@lists.postgresql.org 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".* 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 ? Has anybody faced such issue or can guide me what can be done and how it can be avoided in near future ? Thanks and Regards, Devendra Yadav ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Stats getting corrupted @ 2018-12-20 15:37 Alvaro Herrera <alvherre@2ndquadrant.com> parent: Devendra Yadav <devendraydba@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Alvaro Herrera @ 2018-12-20 15:37 UTC (permalink / raw) To: Devendra Yadav <devendraydba@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-12-20 15:37 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-12-20 03:09 Stats getting corrupted Devendra Yadav <devendraydba@gmail.com> 2018-12-20 15:37 ` Alvaro Herrera <alvherre@2ndquadrant.com>
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