[pgpool-general: 2447] Re: pgpool error

Gray, David W David.W.Gray at nielsen.com
Sat Jan 18 00:39:06 JST 2014


I've turned up the logging in postgresql, which hasn't revealed much extra. 

I have noticed that *every time* this fails, the log shows that we had just ran:
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 0 backend pid: 18650 statement: Parse: SELECT NEXTVAL( 'be_workflow_history_seq' )
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 1 backend pid: 20011 statement: Parse: SELECT NEXTVAL( 'be_workflow_history_seq' )
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 0 backend pid: 18650 statement: B message
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 1 backend pid: 20011 statement: B message
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 0 backend pid: 18650 statement: D message
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 1 backend pid: 20011 statement: D message
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 0 backend pid: 18650 statement: Execute: SELECT NEXTVAL( 'be_workflow_history_seq' )
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 1 backend pid: 20011 statement: Execute: SELECT NEXTVAL( 'be_workflow_history_seq' )
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 0 backend pid: 18650 statement: BEGIN
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 1 backend pid: 20011 statement: BEGIN
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 0 backend pid: 18650 statement: DEALLOCATE dbdpg_p29257_726
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 1 backend pid: 20011 statement: DEALLOCATE dbdpg_p29257_726
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 1 backend pid: 20011 statement: COMMIT
Jan 17 10:35:25 dayrheocrq003 pgpool[31305]: DB node id: 0 backend pid: 18650 statement: COMMIT

Every time.

What is the trigger that causes the permission check (that fails)?

-----Original Message-----
From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Gray, David W
Sent: Wednesday, January 15, 2014 10:18 AM
To: Tatsuo Ishii
Cc: pgpool-general at pgpool.net
Subject: [pgpool-general: 2421] Re: pgpool error

You assume correctly.

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

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

Ok. So I can assume log_min_messages = NOTICE.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
_______________________________________________
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