Обсуждение: Reporting query failing

I am using postgresql  9.2, and we are getting error like -
System.Data.EntityException: The underlying provider failed on Open. --->
Devart.Data.PostgreSql.PgSqlException: Stream already closed!!!.   I have
turned the autovacuum on but my reporting query is failing.  When the manual
full autovacuum is performed along with analyse the reporting query works.
Please let me know how to deal with this situation.

Thank you
A.



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Reporting-query-failing-tp5756840.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

Hi!

On 25.5.2013 15:46, aup20 wrote:
> I am using postgresql  9.2, and we are getting error like -
> System.Data.EntityException: The underlying provider failed on Open.
> ---> Devart.Data.PostgreSql.PgSqlException: Stream already closed!!!.
> I have turned the autovacuum on but my reporting query is failing.
> When the manual full autovacuum is performed along with analyse the
> reporting query works. Please let me know how to deal with this
> situation.

We need substantially more info to be able to help you.

1) What does the PostgreSQL log say?

2) What query are you running? Post the SQL query, please.

3) Was this happening since the beginning, or did that start recently?

4) Are you able to reproduce the issues when running the query using
   psql (or other client, i.e. not through dotconnect)?

5) I don't understand how is this related to autovacuum (or vacuum in
   general). Why have you disabled the autovacuum in the first place?

6) I assume all this is on Windows (as you're using dotconnect). Is
   that correct? Please describe the environment a bit (versions etc.)
   It the application running on the same system as the database?

kind regards
Tomas