Re: can this be done with a check expression?

From: Wayne Cuddy <lists-pgsql(at)useunix(dot)net>
To: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: can this be done with a check expression?
Date: 2012-08-08 15:43:14
Message-ID: 20120808154314.GD16371@slacker.ja10629.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Wayne Cuddy 2012-08-08 15:44:16 fsync debug messages in pgsql logs
Previous Message Wayne Cuddy 2012-08-08 15:41:01 Re: can this be done with a check expression?