[pgpool-general: 2405] pgpool error

Gray, David W David.W.Gray at nielsen.com
Wed Jan 15 00:18:56 JST 2014


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