Ran into a strange problem that seems to appear randomly, and I haven't been able to pin down the conditions under which it appears.
I have 2 functions that I use to access my database. These functions are called from multiple locations. In one of the functions, I have the following code:
Dim sql as string = "select ..... "
Dim conn As New Npgsql.NpgsqlConnection(ConnectionString)
Dim command = New Npgsql.NpgsqlCommand(sql, conn)
Dim dr As Npgsql.NpgsqlDataReader = command.ExecuteReader()
' perform processing
catch ex As Exception
For some reason, an exception "Stream does not support Writing" is being thrown on the ExecuteReader command. However, it does not occur all the time (nor does it always appear when the same function is calling it.
Did a quick search and didn't find any reference to this error with Postgres. Any idea what the cause could be?