Re: pg_basebackup - Stale file handle for file under gprof

Korry Douglas <korry.douglas@xxxxxxxxxxxxxxxx> · Fri, 26 Feb 2016 10:51:49 -0500



      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@xxxxxxxxx
          513.803.5370
           
        
            From: Korry Douglas
                [mailto:korry.douglas@xxxxxxxxxxxxxxxx]
                

                Sent: Friday, February 26, 2016 9:38 AM

                To: Reno, Natalie <Natalie.Reno@xxxxxxxxx>

                Cc: pgsql-admin@xxxxxxxxxxxxxx

                Subject: Re:  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@xxxxxxxxx
          513.803.5370