Date: Wed, 8 Aug 2012 11:43:14 -0400
From: Wayne Cuddy <lists-pgsql@useunix.net>
To: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: can this be done with a check expression?
Message-ID: <20120808154314.GD16371@slacker.ja10629.home>
Mail-Followup-To: PostgreSQL <pgsql-sql@postgresql.org>
References: <20120802231043.GA16173@slacker.ja10629.home>
	<88520F99-849D-438C-9CCD-F80700636A2A@excoventures.com>
	<20120803195053.GA16371@slacker.ja10629.home>
	<20120808154101.GC16371@slacker.ja10629.home>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20120808154101.GC16371@slacker.ja10629.home>
User-Agent: Mutt/1.4.2.3i

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