[pgpool-general: 2419] Re: pgpool error

[Gray, David W]

Here's the postgresql.conf file (attached). Also, for brevity, here is the file with all comments and blank lines filtered out:
listen_addresses = '*'                  # what IP address(es) to listen on;
port = 5430
max_connections = 100
shared_buffers = 1000                   # min 16 or max_connections*2, 8KB each
checkpoint_segments = 16                # in logfile segments, min 1, 16MB each
archive_command = 'test ! -f /mnt/dsk/1/xactdump/%f && cp %p /mnt/dsk/1/xactdump/%f'
log_destination = 'syslog'              # Valid values are combinations of
redirect_stderr = on                    # Enable capturing of stderr into log
log_directory = 'pg_log'                # Directory where log files are written
log_filename = 'postgresql-%a.log'      # Log file name pattern.
log_truncate_on_rotation = on   # If on, any existing log file of the same
log_rotation_age = 1440                 # Automatic rotation of logfiles will
log_rotation_size = 0                   # Automatic rotation of logfiles will
log_error_verbosity = verbose           # terse, default, or verbose messages
log_min_duration_statement = 0          # -1 is disabled, 0 logs all statements
log_connections = on
log_statement = 'all'                   # none, mod, ddl, all
lc_messages = 'en_US.UTF-8'                     # locale for system error message
lc_monetary = 'en_US.UTF-8'                     # locale for monetary formatting
lc_numeric = 'en_US.UTF-8'                      # locale for number formatting
lc_time = 'en_US.UTF-8'                         # locale for time formatting
max_locks_per_transaction = 65536       # min 10

(Anything not here is defaulted, such as log_min_messages.)

-----Original Message-----
From: Tatsuo Ishii [mailto:ishii at postgresql.org] 
Sent: Wednesday, January 15, 2014 1:03 AM
To: Gray, David W
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 2410] Re: pgpool error

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgresql.conf
Type: application/octet-stream
Size: 13895 bytes
Desc: postgresql.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140115/a80b79e1/attachment-0001.obj>