(FunctionClauseError) no function clause matching in Postgrex.Protocol.handle_msg/3 about postgrex HOT 4 CLOSED

Hi @benonymus,

Thank you for reporting. I never heard of https://www.polyscale.ai/, is it basically a database that accepts the Postgres wire protocol?

The issue is happening because the function here: close_parse_describe_flush is first sending a close message and then the parse/describe messages.

By the Postgres protocol we are supposed to receive a CloseComplete message or an error if it is not closed properly. But it is not coming back and skipping right ahead to the parse response.

Is this something you could report upstream?

from postgrex.

Awesome @benjamg, thanks for reporting back! We are glad we helped in a small way. ❤️

from postgrex.

Hey @greg-rychlewski,

Thanks a lot for checking this!

I am in contact with the team at Polyscale and I will let them know!

from postgrex.

Thanks for taking the time in finding this.
PolyScale is a caching frontend that accepts the PostgreSQL wire protocol rather than a database in it's own right and this was indeed a bug in my code due to the way I was trying to avoid a round-trip to the database wherever possible, knowing it was a missing CloseComplete helped me hunt down the flaw :)

from postgrex.