pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_basebackup - Stale file handle for file under gprof
4+ messages / 2 participants
[nested] [flat]
* pg_basebackup - Stale file handle for file under gprof
@ 2016-02-26 14:29 Reno, Natalie <Natalie.Reno@cchmc.org>
0 siblings, 1 reply; 4+ messages in thread
From: Reno, Natalie @ 2016-02-26 14:29 UTC (permalink / raw)
To: pgsql-admin
I have just implemented pg_basebackup on my 9.5 PostgreSQL database. I received the following notification:
pg_basebackup: could not create file "<base_directory>/fullbckp_20160225/gprof/2540/gmon.out": Stale file handle
Is this an issue or can this be ignored since these are tracing files?
Natalie Reno
Sr. Database Administrator
Database Infrastructure Team Lead
BioMedical Informatics
Cincinnati Children's Hospital
natalie.reno@cchmc.org<mailto:natalie.reno@cchmc.org>
513.803.5370
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_basebackup - Stale file handle for file under gprof
@ 2016-02-26 14:38 Korry Douglas <korry.douglas@enterprisedb.com>
parent: Reno, Natalie <Natalie.Reno@cchmc.org>
0 siblings, 1 reply; 4+ messages in thread
From: Korry Douglas @ 2016-02-26 14:38 UTC (permalink / raw)
To: Reno, Natalie <Natalie.Reno@cchmc.org>; +Cc: pgsql-admin
Did you compile your copy of PostgreSQL 9.5 yourself, and if so, did you
enable profiling? If not, which installer did you use?
-- Korry
> I have just implemented pg_basebackup on my 9.5 PostgreSQL database. I
> received the following notification:
>
> pg_basebackup: could not create file
> "<base_directory>/fullbckp_20160225/gprof/2540/gmon.out": Stale file
> handle
>
> Is this an issue or can this be ignored since these are tracing files?
>
> */Natalie Reno/*
>
> Sr. Database Administrator
>
> Database Infrastructure Team Lead
>
> /BioMedical Informatics/
>
> /Cincinnati Children's Hospital/
>
> natalie.reno@cchmc.org <mailto:natalie.reno@cchmc.org>
>
> 513.803.5370
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_basebackup - Stale file handle for file under gprof
@ 2016-02-26 15:24 Reno, Natalie <Natalie.Reno@cchmc.org>
parent: Korry Douglas <korry.douglas@enterprisedb.com>
0 siblings, 1 reply; 4+ messages in thread
From: Reno, Natalie @ 2016-02-26 15:24 UTC (permalink / raw)
To: Korry Douglas <korry.douglas@enterprisedb.com>; +Cc: pgsql-admin
I am guilty of compiling the code myself and enabling the profiling. I am new to Postgres and was following the previous DBAs work. I now realize this needs to be off and will look to be recompiling the code again. I am thinking I will create a new software home and point the database there.
Natalie Reno
Sr. Database Administrator
Database Infrastructure Team Lead
BioMedical Informatics
Cincinnati Children's Hospital
natalie.reno@cchmc.org<mailto:natalie.reno@cchmc.org>
513.803.5370
From: Korry Douglas [mailto:korry.douglas@enterprisedb.com]
Sent: Friday, February 26, 2016 9:38 AM
To: Reno, Natalie <Natalie.Reno@cchmc.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_basebackup - Stale file handle for file under gprof
Did you compile your copy of PostgreSQL 9.5 yourself, and if so, did you enable profiling? If not, which installer did you use?
-- Korry
I have just implemented pg_basebackup on my 9.5 PostgreSQL database. I received the following notification:
pg_basebackup: could not create file "<base_directory>/fullbckp_20160225/gprof/2540/gmon.out": Stale file handle
Is this an issue or can this be ignored since these are tracing files?
Natalie Reno
Sr. Database Administrator
Database Infrastructure Team Lead
BioMedical Informatics
Cincinnati Children's Hospital
natalie.reno@cchmc.org<mailto:natalie.reno@cchmc.org>
513.803.5370
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_basebackup - Stale file handle for file under gprof
@ 2016-02-26 15:51 Korry Douglas <korry.douglas@enterprisedb.com>
parent: Reno, Natalie <Natalie.Reno@cchmc.org>
0 siblings, 0 replies; 4+ messages in thread
From: Korry Douglas @ 2016-02-26 15:51 UTC (permalink / raw)
To: Reno, Natalie <Natalie.Reno@cchmc.org>; +Cc: pgsql-admin
Nothing wrong with building your own version, but you'll want to disable
profiling in most cases (the profiling code will noticeably hurt
performance). The files in the gprof subdirectory are produced by the
profiler.
The error message you see (Stale file handle) suggests that you are
using an NFS-mounted filesystem and that someone may have deleted a
directory while you were running the backup. That may be ok, but I
personally would not trust a backup that reported an error (especially
if you can't explain the error, which I can't).
-- Korry
> I am guilty of compiling the code myself and enabling the profiling. I
> am new to Postgres and was following the previous DBAs work. I now
> realize this needs to be off and will look to be recompiling the code
> again. I am thinking I will create a new software home and point the
> database there.
>
> */Natalie Reno/*
>
> Sr. Database Administrator
>
> Database Infrastructure Team Lead
>
> /BioMedical Informatics/
>
> /Cincinnati Children's Hospital/
>
> natalie.reno@cchmc.org <mailto:natalie.reno@cchmc.org>
>
> 513.803.5370
>
> *From:*Korry Douglas [mailto:korry.douglas@enterprisedb.com]
> *Sent:* Friday, February 26, 2016 9:38 AM
> *To:* Reno, Natalie <Natalie.Reno@cchmc.org>
> *Cc:* pgsql-admin@postgresql.org
> *Subject:* Re: [ADMIN] pg_basebackup - Stale file handle for file
> under gprof
>
> Did you compile your copy of PostgreSQL 9.5 yourself, and if so, did
> you enable profiling? If not, which installer did you use?
>
>
> -- Korry
>
> I have just implemented pg_basebackup on my 9.5 PostgreSQL
> database. I received the following notification:
>
> pg_basebackup: could not create file
> "<base_directory>/fullbckp_20160225/gprof/2540/gmon.out": Stale
> file handle
>
> Is this an issue or can this be ignored since these are tracing files?
>
> */Natalie Reno/*
>
> Sr. Database Administrator
>
> Database Infrastructure Team Lead
>
> /BioMedical Informatics/
>
> /Cincinnati Children's Hospital/
>
> natalie.reno@cchmc.org <mailto:natalie.reno@cchmc.org>
>
> 513.803.5370
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2016-02-26 15:51 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-02-26 14:29 pg_basebackup - Stale file handle for file under gprof Reno, Natalie <Natalie.Reno@cchmc.org>
2016-02-26 14:38 ` Korry Douglas <korry.douglas@enterprisedb.com>
2016-02-26 15:24 ` Reno, Natalie <Natalie.Reno@cchmc.org>
2016-02-26 15:51 ` Korry Douglas <korry.douglas@enterprisedb.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