Hi,
Here is the section of configuration.yml relevant for the database (access
data excluded):
database:
driverClass: org.postgresql.Driver
# the username
# the password
# the JDBC URL
properties:
charSet: UTF-8
maxWaitForConnection: 1s
# validationQuery: "/* MyService Health Check */ SELECT 1"
validationQueryTimeout: 3s
minSize: 8
maxSize: 32
checkConnectionWhileIdle: false
evictionInterval: 10s
minIdleTime: 1 minute
I have commented the validationQuery property, so the default value is used.
Small correction from my side: the validation query runs *8 *(not 10 as I
mistakenly said before) times, which equals to *minSize* property. These
connections are created on application start, but also then every time a
new HTTP request comes in which uses some of the generated JDBI DAOs. All
validation queries are switch state quickly to idle but are not cleaned up.
I am tempted to set up Hikari connection pool, but seeing that other
queries seem to be closed properly and only the validation query is an
issue, I would rather resolve that first before inserting an additional
component to the system.
I appreciate the feedback.
Regards, R.
On Sat, Jun 8, 2019 at 4:26 PM Oscar Nalin <[email protected]>
wrote:
> How is your connection pool configured? Can you post the configuration
> values you are using?
>
> The validation query that you are seeing is the default one. Look at the
> java docs to see all default values:
> https://www.dropwizard.io/1.3.12/dropwizard-db/apidocs/index.html
>
> Is the validation query running 10 times when the connection is created or
> when you are requesting a connection from the connection pool?
>
> Den lördag 8 juni 2019 kl. 02:45:34 UTC+2 skrev Radomir Djurdjevic:
>>
>> Is there a way to get this default liveness check under control somehow?
>> It is taking up space from regular clients trying to connect...
>>
>> On Saturday, June 8, 2019 at 2:35:29 AM UTC+2, Ryan Kennedy wrote:
>>>
>>> I believe this is the default liveness check for the connection pool to
>>> determine if a connection in the pool is still “good” or not.
>>>
>>> On Fri, Jun 7, 2019 at 5:30 PM Radomir Djurdjevic <[email protected]>
>>> wrote:
>>>
>>>> Hi guys,
>>>>
>>>> I have an issue with a health check query that appears approximately 10
>>>> times each time connection is established, although I've never set this
>>>> check explicitly. It's the validation query:
>>>>
>>>> /* Health Check */ SELECT 1
>>>>
>>>> In the *config.yml* I use for running the service there is no
>>>> *valiidationQuery* property set, which makes me wonder where is this
>>>> health check coming from. I do not have any other health checks put in
>>>> place, so it can't be coming from the *health* module.
>>>> Does anyone have an idea what could be making the health check?
>>>>
>>>> I am using:
>>>>
>>>> - Java 8
>>>> - PostgreSQL 11
>>>> - DropWizard 1.3.5
>>>> - JDBI3
>>>>
>>>>
>>>> Thanks a lot,
>>>> Rasha
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "dropwizard-user" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to [email protected].
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/dropwizard-user/237a3003-1430-4468-a4e3-5bcbdaa4cd74%40googlegroups.com
>>>> <https://groups.google.com/d/msgid/dropwizard-user/237a3003-1430-4468-a4e3-5bcbdaa4cd74%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>> --
> You received this message because you are subscribed to the Google Groups
> "dropwizard-user" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/dropwizard-user/8f16d874-8335-441a-9638-4eee74382057%40googlegroups.com
> <https://groups.google.com/d/msgid/dropwizard-user/8f16d874-8335-441a-9638-4eee74382057%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"dropwizard-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/dropwizard-user/CAHq0KsbM-pG7jG%3Dsj06wjwWmzUJGJCgOjxmLpyVOVTSt%2B6KkTA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
