[pgpool-general: 2411] Re: pgpool error

Tatsuo Ishii ishii at postgresql.org
Wed Jan 15 15:02:43 JST 2014


Since this is really strange, I posted to pgsql-hackers list as well.
And I got an question regarding postgresql.conf settings, especially
log_min_messages. Can I take a look at postgresql.conf?

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

> 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?
>> 
>> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


More information about the pgpool-general mailing list