I can't use Templated Queries

[firebabyIgnacio]

I'll follow the example(https://docs.space-cloud.io/storage/database/templated-queries/),But it didn't work out，

I took a look at the logs，
{"L":"INFO","T":"2023-02-17T15:18:56.512+0800","C":"server/middleware.go:28","M":"Request","requestId":"2Lr9Sql55gFGDCMKWNjiQzF7vfe","fields":{"body":"{"operationName":null,"variables":{"userId":"1","name":"Rock"},"query":"{\n changeName(userId: $userId, name: $name) @Profile {\n status\n error\n }\n}\n"}","method":"POST","queryVars":{},"url":"/v1/api/testapi/graphql"}}
{"L":"INFO","T":"2023-02-17T15:19:21.269+0800","C":"server/middleware.go:28","M":"Request","requestId":"2Lr9VvVGlxvR85q39wQD329wSRP","fields":{"body":"{"query":"mutation {\n update_users (where: { id: $userId }, set: { name: $name }) @mongo {\n status\n error\n }\n}","variables":null}","method":"POST","queryVars":{},"url":"/v1/api/testapi/graphql"}}
I found that the second time on internal call has no parameters
The deployment environment is deployed following the tutorial(https://docs.space-cloud.io/install/docker/)(mysql)

[YourTechBud]

Can you share the config of your templated query?

[firebabyIgnacio]

i found a problem when frequently building the same database，my database connection is full
step 1,no database


step 2 add a database,i choose mysql,two connections have been added and the time is refreshed every ten seconds


step 3 remove database,there is still a connection,when I create and remove databases multiple times, my database connection is full

[YourTechBud]

That's interesting. Let me check this once

[firebabyIgnacio]

excuse me, but i also have a question,1. is every time a new database is created, will two connections be maintained all the time? if so, then i have a little more database, so isn't the number of connections to the database consumed quickly? 2.won't it automatically disconnect because there has been no operation for a long time?
in response to question 1:i found that in gateway\modules\crud\crud.go:89, the c here seems to be leaked and cannot be managed, so two connections are created.
2:gateway\modules\crud\sql\sql.go:68,there's a Ticker set to 10s, and it looks like this will keep the connection open forever

this is just a guess on my part (i'm not a Go developer)

[YourTechBud]

Yes. Currently each database would have its own connection pool. You'll need to use a database proxy if you want to multiplex connections to the database

[firebabyIgnacio]

got it, will this connection always be maintained? even if it is not used for a long time?