The Read method cannot be called

Robert Riley 21 Reputation points
2021-01-20T14:45:15.307+00:00

Hello,
I am having an issue with the npgsql connector to postgres. Error message below:

'Type=Npgsql.NpgsqlException,Message=Exception while reading from stream,Source=Npgsql,''Type=System.NotSupportedException,Message=The Read method cannot be called when another read operation is pending.,Source=System,'

This is coming from a look up query to a managed postgres instance, the query is a simple nested query like:

SELECT * FROM table1 t1 WHERE t1.id IN (SELECT t2.id from Table2 t2)

I am unable to find anything from npgsql or adf in regards to this error.

Please advise!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,689 questions
Azure Database for PostgreSQL
{count} votes