Random empty results from PostgreSQL

[p-mitana]

Sometimes it seems like the DB returned the empty result set (PostgreSQL). No error or log seems to be yielded, so I don't have any more information to supply.

It always looks like when user refreshes the app's page, the first query an application tries returns an empty result - and the subsequent ones return properly. If user refreshes page a few times more, eventually the first query returns proper result as well, but some time later the error will appear again.

[p-mitana]

I forgot to mention: I experience this error in 1.1.4 version as well.

[gaoxincheng]

I will check this later. If possible, please provide your test code.

[p-mitana]

I actually do not have any compact test case to supply. Anyway I'll list you a bit more information:

• DMD 2.085
• hunt-database 1.1.4
• Release build
• PostgreSQL 11
• PostgreSQL and my application are run as two containers in the same docker stack.

Problem appeared as well when I tried running application locally and connect to remote database. Still in the same manner - randomly.

I found a temporary workaround: for every client request, before I start to query database for data I actually need, I query for some dummy data that should be in database. I attempt to query it until it something is returned (up to 5 times). This way seems to neutralize the error - if the first attempt fails, the query returns properly on the second or third one.