FusionAuth
    • Home
    • Categories
    • Recent
    • Popular
    • Pricing
    • Contact us
    • Docs
    • Login

    Hakari CP DB Settings?

    Scheduled Pinned Locked Moved
    General Discussion
    2
    7
    822
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      matt 1
      last edited by

      Hi, I found a post where an official linked to the Hikari "Knobs" page and said that most of those should be able to be set in the fusionauth.properties file. I have set several of them while trying to troubleshoot a managed Postgres DB timeout issue, but I am unsure if they are being utilized.

      1. Can someone confirm if I have set the following values correctly in the .properties file?
      # settings necessary to avoid AWS RDS timeouts
      database.initializationFailTimeout=5000
      database.minimumIdle=5
      database.maximumPoolSize=10
      database.maxLifetime=300000
      database.keepaliveTime=30000
      
      1. Is there a logging mode or some way for me to determine if FusionAuth is picking up and honoring the settings I have specified?
      M 1 Reply Last reply Reply Quote 0
      • M
        matt 1 @matt 1
        last edited by

        Can anyone help?

        joshuaJ 1 Reply Last reply Reply Quote 0
        • joshuaJ
          joshua @matt 1
          last edited by

          @matt-1

          Some of this might be covered in a related thread.

          https://fusionauth.io/community/forum/topic/1178/connection-closed-errors-with-managed-postgresql-on-digitalocean/12?_=1644539462639

          HTH!

          Josh

          M 1 Reply Last reply Reply Quote 0
          • M
            matt 1 @joshua
            last edited by

            @joshua Hi, that is the thread where I got the links to the settings from. However, I don't see any indication that FusionAuth is honoring them, although I think it is because we've gone 5 days now with no DB timeout errors.

            Is there a dev at FusionAuth who can comment as to whether the settings, as I have specified them, are the correct way to have them honored in the fusionauth.properties file?

            joshuaJ 1 Reply Last reply Reply Quote 0
            • joshuaJ
              joshua @matt 1
              last edited by joshua

              @matt-1 said in Hakari CP DB Settings?:

              However, I don't see any indication that FusionAuth is honoring them, although I think it is because we've gone 5 days now with no DB timeout errors.

              It is not necessarily about FusionAuth honoring timeouts as much as it is about the managed database properly informing the connection pool when it intends to remove or modify a database connection.

              As probably evidenced from the related thread - tuning a managed database so that it properly integrates with a connection pool is a task unto itself. I would recommend reviewing Hikari docs, and. the documentation. that comes with the DB that you are working with.

              Also to note, FusionAuth has a few folks that are using managed databases. They may yet be able to provide input if they see this thread.

              Thanks,
              Josh

              M 1 Reply Last reply Reply Quote 0
              • M
                matt 1 @joshua
                last edited by

                @joshua said in Hakari CP DB Settings?:

                It is not necessarily about FusionAuth honoring timeouts as much as it is about the managed database properly informing the connection pool when it intends to remove or modify a database connection. [...] As probably evidenced from the related thread - tuning a managed database so that it properly integrates with a connection pool is a task unto itself. I would recommend reviewing Hikari docs, and. the documentation. that comes with the DB that you are working with.

                I believe you're missing the point. I'm simply asking you to let me know if I have put the settings into your application configuration file to that they are passed to Hakari properly. I'm not asking you to solve the managed DB problem for me.

                That said, it seems they are because we haven't seen the DB timeouts in 6 FusionAuth environments in over 2 weeks now.

                joshuaJ 1 Reply Last reply Reply Quote 0
                • joshuaJ
                  joshua @matt 1
                  last edited by

                  @matt-1 said in Hakari CP DB Settings?:

                  That said, it seems they are because we haven't seen the DB timeouts in 6 FusionAuth environments in over 2 weeks now.

                  Hi @matt-1 Yes, I believe that I misunderstood your question. I believe that you are correct.

                  Josh

                  1 Reply Last reply Reply Quote 0
                  • First post
                    Last post