Re: shutdown Postgres (standby) host causing timeout on other servers in replication

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 3 Nov 2022 20:46:48 -0500



    On 11/3/22 15:55, Joanna Xu wrote:

    
        Hi All, 
         
        We have PostgreSQL master-slave replication
          configuration with 4 servers. 
          
        After shutting down one standby server, we
          found below errors on all other 3 servers and the applications
          couldn’t access the database due to the timeout.
        DAO-00002
            datasource connection failure:Time out waiting for a
            DefaultDataSource
        ERROR
            SQLException code: 0 SQLState: null
            
         
        What could be the cause of the errors? 
          Would anyting be helpful to prevent it from happening?
      
    
    Synchronous or asynchronous replication?

    
    Go to the database server and look in it's logs.

    
    -- 

      Angular momentum makes the world go 'round.