pq: unexpected describe rows response: 'D'

[dajohi]

Hello -

I created a prepared select statement. When I run it within a transaction, I get the follow error:

pq: unexpected describe rows response: 'D'

I believe lib/pq needs to support 'D'

libpq does it like so: http://doxygen.postgresql.org/fe-protocol3_8c_source.html#l00318

[RangelReale]

This is the same error as this:

#81

You can't run another query on the same connection without finishing the previous one. See the discussion on that thread.

[dajohi]

Ahh, yes, that was it. Thanks for the pointer!

[otiai10]

I faced the same error message.
You helped me a lot.
Thank you very much! 👍

[rubens21]

Just a heads-up:
I was not starting two transactions, but I was getting the same error.
In my case, the problem was a *sql.Row that I was not closing.

returnedRow, err := myTransaction.Query(...)

fix:

returnedRow, err := myTransaction.Query(...)
// do you job
returnedRow.Close()

[aashishAil]

I was running to goroutines to update a different table with the same transaction, which was introducing a race condition that sometimes the 1st update query had not finished when the 2nd query started and giving me the error.
Fix: Make the go routines trigger after completion