Re: What is the tuplestore?

Ron <ronljohnsonjr@xxxxxxxxx> · Mon, 10 Dec 2018 17:33:03 -0600



    Which file system (specifically, which directory)?  Is it
    data/base/pgsql_tmp?  There's 96GB free, which is 74% of the volume.

    
    On 12/10/2018 04:50 PM, Rene Romero
      Benavides wrote:

    
        Maybe the temp space got released right after the
          failure?
          https://grokbase.com/t/postgresql/pgsql-general/02ag7k8gcr/tuplestore-write-failed

          
          do you have space usage charts for that partition?
            doesn't it show a spike during that time?
        
      
        Am Mo., 10. Dez. 2018 um 15:54 Uhr schrieb Ron
          <ronljohnsonjr@xxxxxxxxx>:

        
           There's certainly a problem with the
            application, but the error is in the pg_log, not the
            application log.

            
            On
              12/10/2018 03:21 PM, Rene Romero Benavides wrote:

            
              What if this error message pertains to
                something happening on the application side? 
              

                Am Mo., 10. Dez. 2018 um 09:56 Uhr
                  schrieb Ron <ronljohnsonjr@xxxxxxxxx>:

                
                Hi,

                  
                  v9.6.6

                  
                  2018-12-07 06:21:55.504 EST 10.140.181.89(35868) CDS
                  CDSLBXW 13748 SELECT 

                  PostgreSQL JDBC Driver 53100 ERROR:  could not write
                  to tuplestore temporary 

                  file: No space left on device

                  
                  I see this in the pg_log file, but #1 can't figure out
                  what "tuplestore" is 

                  (Google doesn't help), and #2 there's lots of space on
                  all my file systems.  

                  data/base, where pgsql_tmp lives, has 96GB free.)

                  
                  Thanks

                  
    -- 

      Angular momentum makes the world go 'round.