pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPrepared statement issue in Pgpool-II
6+ messages / 2 participants
[nested] [flat]
* Prepared statement issue in Pgpool-II
@ 2010-06-28 21:32 raghu ram <raghuchennuru@gmail.com>
2010-06-28 22:14 ` Prepared statement issue in Pgpool-II raghu ram <raghuchennuru@gmail.com>
2010-06-29 09:55 ` Re: [NOVICE] Prepared statement issue in Pgpool-II Vibhor Kumar <vibhor.kumar@enterprisedb.com>
0 siblings, 2 replies; 6+ messages in thread
From: raghu ram @ 2010-06-28 21:32 UTC (permalink / raw)
To: pgsql-admin; pgsql-novice@postgresql.org; +Cc: abbas.dba@gmail.com
Hi,
We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and
facing the below error while running the select queries in the application
side::
ERROR: prepared statement
"mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
STATEMENT: DEALLOCATE PREPARE
mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e
WARNING: archive_mode enabled, yet archive_command is not set
In the pgpool.conf file set the "reset_query_list" ='ABORT; RESET ALL; SET
SESSION AUTHORIZATION DEFAULT'
We also tested on pgpool-II version 2.3.3, result will be same.
Please help us to resolve the issue.
Regards
Raghu
^ permalink raw reply [nested|flat] 6+ messages in thread
* Prepared statement issue in Pgpool-II
2010-06-28 21:32 Prepared statement issue in Pgpool-II raghu ram <raghuchennuru@gmail.com>
@ 2010-06-28 22:14 ` raghu ram <raghuchennuru@gmail.com>
2010-06-29 09:53 ` Re: Prepared statement issue in Pgpool-II Vibhor Kumar <vibhor.kumar@enterprisedb.com>
1 sibling, 1 reply; 6+ messages in thread
From: raghu ram @ 2010-06-28 22:14 UTC (permalink / raw)
To: pgsql-general@postgresql.org
Hi,
We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and
facing the below error while running the select queries in the application
side::
ERROR: prepared statement
"mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
STATEMENT: DEALLOCATE PREPARE
mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e
WARNING: archive_mode enabled, yet archive_command is not set
In the pgpool.conf file set the "reset_query_list" ='ABORT; RESET ALL; SET
SESSION AUTHORIZATION DEFAULT'
We also tested on pgpool-II version 2.3.3, result will be same.
Please help us to resolve the issue.
Regards
Raghu
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Prepared statement issue in Pgpool-II
2010-06-28 21:32 Prepared statement issue in Pgpool-II raghu ram <raghuchennuru@gmail.com>
2010-06-28 22:14 ` Prepared statement issue in Pgpool-II raghu ram <raghuchennuru@gmail.com>
@ 2010-06-29 09:53 ` Vibhor Kumar <vibhor.kumar@enterprisedb.com>
2010-06-29 07:49 ` Re: Prepared statement issue in Pgpool-II raghu ram <raghuchennuru@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Vibhor Kumar @ 2010-06-29 09:53 UTC (permalink / raw)
To: raghu ram <raghuchennuru@gmail.com>; +Cc: pgsql-general@postgresql.org
On 28/06/10 11:14 PM, raghu ram wrote:
>
> Hi,
>
>
>
> We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9
> and facing the below error while running the select queries in the
> application side::
>
>
> ERROR: prepared statement
> "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
>
Try with reset_query_list= 'ABORT; DISCARD ALL'
--
Thanks& Regards,
Vibhor Kumar.
EnterpriseDB Corporation
The Enterprise Postgres Company
Office: 732-331-1300 Ext-2022
Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Prepared statement issue in Pgpool-II
2010-06-28 21:32 Prepared statement issue in Pgpool-II raghu ram <raghuchennuru@gmail.com>
2010-06-28 22:14 ` Prepared statement issue in Pgpool-II raghu ram <raghuchennuru@gmail.com>
2010-06-29 09:53 ` Re: Prepared statement issue in Pgpool-II Vibhor Kumar <vibhor.kumar@enterprisedb.com>
@ 2010-06-29 07:49 ` raghu ram <raghuchennuru@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: raghu ram @ 2010-06-29 07:49 UTC (permalink / raw)
To: Vibhor Kumar <vibhor.kumar@enterprisedb.com>; +Cc: pgsql-general@postgresql.org
On Tue, Jun 29, 2010 at 3:23 PM, Vibhor Kumar <vibhor.kumar@enterprisedb.com
> wrote:
> On 28/06/10 11:14 PM, raghu ram wrote:
>
>>
>> Hi,
>>
>>
>>
>> We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and
>> facing the below error while running the select queries in the application
>> side::
>>
>>
>> ERROR: prepared statement
>> "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
>>
>>
> Try with reset_query_list= 'ABORT; DISCARD ALL'
>
>
Thanks Vibhor...
If you set the reset_query_list = 'ABORT; DISCARD ALL'
(or) reset_query_list = 'ABORT; DISCARD TEMPORARY' also getting the same
error again for both version of the Pgpool-II.
Thanks&Regards
Raghu
> --
> Thanks& Regards,
> Vibhor Kumar.
> EnterpriseDB Corporation
> The Enterprise Postgres Company
>
> Office: 732-331-1300 Ext-2022
>
> Website: www.enterprisedb.com
> EnterpriseDB Blog: http://blogs.enterprisedb.com
> Follow us on Twitter: http://www.twitter.com/enterprisedb
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [NOVICE] Prepared statement issue in Pgpool-II
2010-06-28 21:32 Prepared statement issue in Pgpool-II raghu ram <raghuchennuru@gmail.com>
@ 2010-06-29 09:55 ` Vibhor Kumar <vibhor.kumar@enterprisedb.com>
2010-06-29 07:48 ` Re: [NOVICE] Prepared statement issue in Pgpool-II raghu ram <raghuchennuru@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Vibhor Kumar @ 2010-06-29 09:55 UTC (permalink / raw)
To: raghu ram <raghuchennuru@gmail.com>; +Cc: pgsql-admin; pgsql-novice@postgresql.org; abbas.dba@gmail.com
On 28/06/10 10:32 PM, raghu ram wrote:
>
> ERROR: prepared statement
> "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
>
> STATEMENT: DEALLOCATE PREPARE
> mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e
>
> WARNING: archive_mode enabled, yet archive_command is not set
>
>
> In the pgpool.conf file set the "reset_query_list" ='ABORT; RESET
> ALL; SET SESSION AUTHORIZATION DEFAULT'
>
Change the parameter setting reset_query_list = 'ABORT; DISCARD ALL'
--
Thanks& Regards,
Vibhor Kumar.
Senior System Engineer.
EnterpriseDB Corporation
The Enterprise Postgres Company
Office: 732-331-1300 Ext-2022
Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [NOVICE] Prepared statement issue in Pgpool-II
2010-06-28 21:32 Prepared statement issue in Pgpool-II raghu ram <raghuchennuru@gmail.com>
2010-06-29 09:55 ` Re: [NOVICE] Prepared statement issue in Pgpool-II Vibhor Kumar <vibhor.kumar@enterprisedb.com>
@ 2010-06-29 07:48 ` raghu ram <raghuchennuru@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: raghu ram @ 2010-06-29 07:48 UTC (permalink / raw)
To: Vibhor Kumar <vibhor.kumar@enterprisedb.com>; +Cc: pgsql-admin; pgsql-novice@postgresql.org; abbas.dba@gmail.com
On Tue, Jun 29, 2010 at 3:25 PM, Vibhor Kumar <vibhor.kumar@enterprisedb.com
> wrote:
> On 28/06/10 10:32 PM, raghu ram wrote:
>
>>
>> ERROR: prepared statement
>> "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
>>
>> STATEMENT: DEALLOCATE PREPARE
>> mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e
>>
>> WARNING: archive_mode enabled, yet archive_command is not set
>>
>>
>> In the pgpool.conf file set the "reset_query_list" ='ABORT; RESET ALL;
>> SET SESSION AUTHORIZATION DEFAULT'
>>
>>
> Change the parameter setting reset_query_list = 'ABORT; DISCARD ALL'
>
>
Thanks Vibhor...
If you set the reset_query_list = 'ABORT; DISCARD ALL'
(or) reset_query_list = 'ABORT; DISCARD TEMPORARY' also getting the same
error again for both version of the Pgpool-II.
Thanks&Regards
Raghu
--
> Thanks& Regards,
> Vibhor Kumar.
> Senior System Engineer.
>
> EnterpriseDB Corporation
> The Enterprise Postgres Company
>
> Office: 732-331-1300 Ext-2022
>
> Website: www.enterprisedb.com
> EnterpriseDB Blog: http://blogs.enterprisedb.com
> Follow us on Twitter: http://www.twitter.com/enterprisedb
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2010-06-29 09:55 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-28 21:32 Prepared statement issue in Pgpool-II raghu ram <raghuchennuru@gmail.com>
2010-06-28 22:14 ` raghu ram <raghuchennuru@gmail.com>
2010-06-29 09:53 ` Vibhor Kumar <vibhor.kumar@enterprisedb.com>
2010-06-29 07:49 ` raghu ram <raghuchennuru@gmail.com>
2010-06-29 09:55 ` Vibhor Kumar <vibhor.kumar@enterprisedb.com>
2010-06-29 07:48 ` raghu ram <raghuchennuru@gmail.com>
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