go icon indicating copy to clipboard operation
go copied to clipboard

services/horizon: pq: unexpected message `E`

Open paulbellamy opened this issue 4 years ago • 2 comments

What version are you using?

2.8.1

What did you do?

Noticed a (new?) error in the horizon logs:

[...] horizon_msg:select failed: pq: unexpected message 'E'; expected ReadyForQuery @version:1 message:time="2021-08-31T09:58:31.742Z" level=error msg="select failed: pq: unexpected message 'E'; expected ReadyForQuery" pid=2972576 stack="[main.go:43 session.go:352 session.go:320 metrics.go:374 operation.go:266 operation.go:124 handler.go:199 handler.go:270 middleware.go:259 server.go:2049 chain.go:31 mux.go:425 server.go:2049 server.go:2049 middleware.go:429 server.go:2049 http.go:73 server.go:2049 cors.go:190 server.go:2049 compress.go:190 server.go:2049

What did you expect to see?

No errors.

What did you see instead?

This error.

paulbellamy avatar Aug 31 '21 10:08 paulbellamy

Might be related to the issue here: https://github.com/lib/pq/issues/478

paulbellamy avatar Aug 31 '21 10:08 paulbellamy

Usually it's a sign that connection (likely in a DB transaction) is reused by two or more go routines. We need to check the logs to understand when it's happening.

bartekn avatar Aug 31 '21 22:08 bartekn