From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: nehemadhuri@gmail.com
Subject: BUG #18534: ERROR: portal "C_n" does not exist type of error getting thrown.
Date: Fri, 12 Jul 2024 09:31:48 +0000
Message-ID: <18534-911bd7dcafa8afca@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18534
Logged by: madhuri nehe
Email address: nehemadhuri@gmail.com
PostgreSQL version: 15.3
Operating system: Linux
Description:
1. This issue occurs in multithreaded application.
2. We retrieve records from a single table and store them in the ResultSet
object of JDBC.
3. To read the records sequentially from the ResultSet object, we employ the
rSet.next() method for iteration.
4. We are encountering a sporadic portal exception triggered by the
rSet.next() method call.
5. We have examined all potential causes, such as verifying the executed
query, checking if the ResultSet cursor is open or closed, ensuring the
database connection object is active, and confirming the prepared statement
cursor’s status. No issues have been detected. Also, ResultSet is not being
accessed by multiple threads simultaneously.
We've been thorough in our search for the cause of the issue but haven't
found anything yet.
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, nehemadhuri@gmail.com
Subject: Re: BUG #18534: ERROR: portal "C_n" does not exist type of error getting thrown.
In-Reply-To: <18534-911bd7dcafa8afca@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