pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedReporting query failing
2+ messages / 2 participants
[nested] [flat]
* Reporting query failing
@ 2013-05-25 13:46 aup20 <aup20.devi@gmail.com>
2013-05-25 21:00 ` Re: Reporting query failing Tomas Vondra <tv@fuzzy.cz>
0 siblings, 1 reply; 2+ messages in thread
From: aup20 @ 2013-05-25 13:46 UTC (permalink / raw)
To: pgsql-performance
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.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Reporting query failing
2013-05-25 13:46 Reporting query failing aup20 <aup20.devi@gmail.com>
@ 2013-05-25 21:00 ` Tomas Vondra <tv@fuzzy.cz>
0 siblings, 0 replies; 2+ messages in thread
From: Tomas Vondra @ 2013-05-25 21:00 UTC (permalink / raw)
To: pgsql-performance
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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2013-05-25 21:00 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-05-25 13:46 Reporting query failing aup20 <aup20.devi@gmail.com>
2013-05-25 21:00 ` Tomas Vondra <tv@fuzzy.cz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox