Skip to main content
kondia0001
kondia0001
October 31, 2022
Question

Database connection Cannot open

  • October 31, 2022
  • 3 replies
  • 0 views

Hi,

Recently we deployed a new application to Production environment. It's working fine.

The screenshot


But facing DB connectivity issue every 37 minutes we are getting this error.

Can anyone please help me regarding this DB connectivity issue?

    3 replies

    D
    deepakg681722
    October 31, 2022

    It is regarding your queryEntity. some of the queryEntity is taking a lot of time to execute.

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    October 31, 2022

    Did you check the tomcat-stdout.log for any details? How do you know that this issue comes up in a interval of 37 minutes?

    csteward
    csteward
    October 31, 2022

    Also curious on the "37 minutes", is this exact?  If so I would look to things like, events occurring on the database side on schedule which are causing it to overload and reject connections?  Or events within your environment causing higher load on this schedule creating it difficult to initiate the connection?  This should be more seamless but I am also troubleshooting a similar, sporadic issue in our environment as well which has started occurring after having an external database moved to a different (cloud) server.

    This should not be related to the time of the query execution as the error indicates the connection has not even been opened yet to start executing the query.

    Terms & ConditionsAccessibility statement