From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: aliakbar.pinjari@gmail.com
Subject: BUG #17078: Timeout issue in getting large amount data in Dot Net application using cursors
Date: Wed, 30 Jun 2021 11:26:50 +0000
Message-ID: <17078-5e5b1bb6a3f1a8c5@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17078
Logged by: Ali Pinjari
Email address: aliakbar.pinjari@gmail.com
PostgreSQL version: 10.14
Operating system: AWS Postgres RDS
Description:
Hi Team,
Facing timeout issue in getting large amount data in Dot Net application
using cursors. We are using Npgsql dll of 4.0.10 version.
More details:- We are using a postgress function which returns three cursors
i.e. three table data. When getting data using cursor from the application
taking more time and sometimes getting timeout or connection issues. Where
as same executed in the DB, getting results in seconds.
Exact error:- A connection attempt failed because the connected party did
not properly respond after a period of time, or established connection
failed because connected host has failed to respond at
System.Net.Sockets.Socket.Receive
Do we have any alternative in returning more than one table data from a
function without using ref cursor?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, aliakbar.pinjari@gmail.com
Subject: Re: BUG #17078: Timeout issue in getting large amount data in Dot Net application using cursors
In-Reply-To: <17078-5e5b1bb6a3f1a8c5@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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