Re: fsync debug messages in pgsql logs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wayne Cuddy <lists-pgsql(at)useunix(dot)net>
Cc: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: fsync debug messages in pgsql logs
Date: 2012-08-08 16:23:22
Message-ID: 12758.1344443002@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Wayne Cuddy <lists-pgsql(at)useunix(dot)net> writes:
> I'm seeing this in my PGSQL logs, is this something to be concerned
> about? I know the file system it sits on is reliable and the DB appears
> to run with fine, additionally the log indicates it's a debug message. I
> did some google searches and didn't find much.
> When I examine the file system file by these names to not exist.

If it only complains once per file name, this is expected behavior when
somebody drops a table just before the checkpoint mechanism tries to
fsync it. (If the failure were to repeat, then it might be something
more interesting.) It does seem a bit odd that only fsm files are being
complained of, though.

What PG version is that exactly?

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Wayne Cuddy 2012-08-08 16:53:04 Re: fsync debug messages in pgsql logs
Previous Message Wayne Cuddy 2012-08-08 15:44:16 fsync debug messages in pgsql logs