postgres-wire icon indicating copy to clipboard operation
postgres-wire copied to clipboard
verified publisher icon postgres-haskell

IncorrectUsage error when batching update statements.

Open naushadh opened this issue 6 years ago • 2 comments

Issue

  • Under high load (upto 512 concurrent requests) in a web app, postgres-wire keeps running into IncorrectUsage: "Expected DataRow message, but got ReadyForQuery" error for a batch of update statements.

  • Issue does NOT manifest when the number of concurrent requests is low.

  • Related project and workaround I had to apply: https://github.com/TechEmpower/FrameworkBenchmarks/pull/4571/commits/a707305805e6085ed486072232998756e8d789a4#diff-18e221ebfc6aeb9c7554015904f0c042

Is this expected? Am I doing something wrong?

naushadh avatar Mar 29 '19 23:03 naushadh

Thank you for the report! I will investigate this. Also, it will be really helpful if you have a code example that reproduces this issue.

NCrashed avatar Apr 03 '19 07:04 NCrashed

@NCrashed Created a sample project that focuses and reproduces this issue: https://github.com/naushadh/postgres-wire-issue25

See out.log for test reproduction output.

naushadh avatar Apr 07 '19 19:04 naushadh