[pgpool-general: 2406] Re: pgpool error

[Gray, David W]

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?


-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 30731 bytes
Desc: pgpool.conf
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20140114/34a77da2/attachment.obj>