Re: ERROR: could not serialize access due to concurrent update

Ron <ronljohnsonjr@xxxxxxxxx> · Tue, 16 May 2023 08:44:00 -0500



    Scan, you say?  Add an index to support the FK lookup.

    
    On 5/16/23 08:09, ROHIT SACHDEVA wrote:

    
      Also foreign table scan is there on query.
      

        On Tue, May 16, 2023 at
          6:08 PM ROHIT SACHDEVA <sachdeva.rohit648@xxxxxxxxx>
          wrote:

        
           Hi All,

            I am getting this error in the application logs, and this
            error is frequently coming. Could someone suggest what would
            be the best solution to overcome these types of errors.

            Isolation of the database is read committed. Should I change
            the isolation?  

            
              -- 

              Have a Good day !!!

                
                Regards

                Rohit Sachdeva
            
          
      -- 

      Have a Good day !!!

        
        Regards

        Rohit Sachdeva
    
    
    -- 

      Born in Arizona, moved to Babylonia.