[pgpool-general: 2410] Re: pgpool error

Tatsuo Ishii ishii at postgresql.org
Wed Jan 15 11:35:06 JST 2014


Hi,

This seems really strange because in the PostgreSQL log, PREPARE and
BIND succeeded then suddenly EXECUTE complains "there's no such that
portal". Do you have any self contained test case for this?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Adding pgpool.conf 
> 
> -----Original Message-----
> From: Gray, David W 
> Sent: Tuesday, January 14, 2014 10:19 AM
> To: 'pgpool-general at pgpool.net'
> Subject: pgpool error 
> 
> I am trying to set up a test system, looking to get pgpool running in load balancing and replication modes. We have an extensive grid processing system that the database serves as a backend for. I am getting a consistent error, that has proved to be a show-stopper:
> 
>>From pgpool:
> Jan 14 10:04:57 dayrheocrq003 pgpool[19528]: DB node id: 0 backend pid: 25223
> statement: COMMIT
> Jan 14 10:04:57 dayrheocrq003 pgpool[19528]: DB node id: 0 backend pid: 25223
> statement: SELECT count(*) from (SELECT has_function_privilege('measure',
> 'pgpool_regclass(cstring)', 'execute') WHERE EXISTS(SELECT * FROM
> pg_catalog.pg_proc AS p WHERE p.proname = 'pgpool_regclass')) AS s
> Jan 14 10:04:57 dayrheocrq003 pgpool[19528]: do_query: error message from
> backend: portal "pgpool19528" does not exist. Exit this session.
> 
>>From postgres DB:
> 
> Jan 14 10:04:57 dayrhegrdp005 postgres[25223]: [4559-1] LOG:  00000: statement: PREPARE pgpool19528 AS SELECT count(*) from (SELECT has_function_privilege('measure',
> Jan 14 10:04:57 dayrhegrdp005 postgres[25223]: [4559-2]  'pgpool_regclass(cstring)', 'execute') WHERE EXISTS(SELECT * FROM pg_catalog.pg_proc AS p WHERE p.proname = 'pgpool_regclass'))
> Jan 14 10:04:57 dayrhegrdp005 postgres[25223]: [4559-3]  AS s
> Jan 14 10:04:57 dayrhegrdp005 postgres[25223]: [4559-4] LOCATION:  exec_parse_message, postgres.c:1159
> Jan 14 10:04:57 dayrhegrdp005 postgres[25223]: [4560-1] LOG:  00000: statement: <BIND> pgpool19528
> Jan 14 10:04:57 dayrhegrdp005 postgres[25223]: [4560-2] LOCATION:  exec_bind_message, postgres.c:1460
> Jan 14 10:04:57 dayrhegrdp005 postgres[25223]: [4561-1] ERROR:  34000: portal "pgpool19528" does not exist
> Jan 14 10:04:57 dayrhegrdp005 postgres[25223]: [4561-2] LOCATION:  exec_execute_message, postgres.c:1669
> 
> The versions:
> pgpool v3.3.2  compiled 1/10/2014
> 
> PostgreSQL 8.1.23 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51)
> 
> I had found similar errors via google, but nothing quite exactly like this.
> 
> Please let me know what other information I can provide?
> 
> 


More information about the pgpool-general mailing list