From: Wayne Cuddy <lists-pgsql@useunix.net>
To: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: can this be done with a check expression?
Date: Wed, 8 Aug 2012 11:43:14 -0400
Message-ID: <20120808154314.GD16371@slacker.ja10629.home> (raw)
In-Reply-To: <20120808154101.GC16371@slacker.ja10629.home>
References: <20120802231043.GA16173@slacker.ja10629.home>
<88520F99-849D-438C-9CCD-F80700636A2A@excoventures.com>
<20120803195053.GA16371@slacker.ja10629.home>
<20120808154101.GC16371@slacker.ja10629.home>
This was posted under the wrong subject.. Please ignore, will repost.
On Wed, Aug 08, 2012 at 11:41:01AM -0400, Wayne Cuddy wrote:
> 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.
>
> Thanks,
> Wayne
>
> ----------------------------------------------------------------------
> 2012-07-19 21:05:42.840 GMT 8966 4fd07ba5.2306 @: DEBUG: could not
> fsync
> file "base/16711/45365979_fsm" but retrying: No such file or directory
> 2012-07-20 06:25:43.899 GMT 8966 4fd07ba5.2306 @: DEBUG: could not
> fsync
> file "base/16711/45413298_fsm" but retrying: No such file or directory
> 2012-07-20 11:20:44.755 GMT 8966 4fd07ba5.2306 @: DEBUG: could not
> fsync
> file "base/16711/45438221_fsm" but retrying: No such file or directory
> 2012-07-20 15:40:45.974 GMT 8966 4fd07ba5.2306 @: DEBUG: could not
> fsync
> file "base/16711/45460199_fsm" but retrying: No such file or directory
> 2012-07-22 12:35:43.882 GMT 8966 4fd07ba5.2306 @: DEBUG: could not
> fsync
> file "base/16711/45687933_fsm" but retrying: No such file or directory
> 2012-07-25 03:35:42.933 GMT 8966 4fd07ba5.2306 @: DEBUG: could not
> fsync
> file "base/16711/46007387_fsm" but retrying: No such file or directory
> 2012-07-25 06:30:45.354 GMT 8966 4fd07ba5.2306 @: DEBUG: could not
> fsync
> file "base/16711/46022167_fsm" but retrying: No such file or directory
> 2012-07-26 06:48:13.595 GMT 8966 4fd07ba5.2306 @: DEBUG: could not
> fsync
> file "base/16711/46145719_fsm" but retrying: No such file or directory
> 2012-07-28 17:58:40.774 GMT 8966 4fd07ba5.2306 @: DEBUG: could not
> fsync
> file "base/16711/46445945_fsm" but retrying: No such file or directory
> 2012-08-01 09:38:42.234 GMT 8966 4fd07ba5.2306 @: DEBUG: could not
> fsync
> file "base/16711/46890581_fsm" but retrying: No such file or directory
> 2012-08-05 01:07:43.659 GMT 8966 4fd07ba5.2306 @: DEBUG: could not
> fsync
> file "base/16711/47334522_fsm" but retrying: No such file or directory
> 2012-08-07 01:27:43.605 GMT 8966 4fd07ba5.2306 @: DEBUG: could not
> fsync
> file "base/16711/47579627_fsm" but retrying: No such file or directory
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
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-sql@postgresql.org
Cc: lists-pgsql@useunix.net
Subject: Re: can this be done with a check expression?
In-Reply-To: <20120808154314.GD16371@slacker.ja10629.home>
* 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