[pgpool-general: 3373] Re: Why is the log so busy

[Tatsuo Ishii]

Regarding "DETAIL: received message kind 'X' from frontend", it has
been already fixed in the repository.

I will work on "WARNING: failed to execute regex matching, pattern is
NULL" meesages.

Both are harmles and should be treated as DEBUG message.

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

> Hey Guys
> 
> I keep getting these message repeating over and over in the log. Beginning to get concerned what's causing it. I've looked around and cant see anything obvious. Also any idea whats causing the line : WARNING:  failed to execute regex matching, pattern is NULL
> 
> 
> DETAIL:  received message kind 'X' from frontend
> LOG:  statement:  DISCARD ALL
> LOG:  DB node id: 0 backend pid: 15594 statement:  DISCARD ALL
> LOG:  DB node id: 2 backend pid: 5248 statement:  DISCARD ALL
> WARNING:  failed to execute regex matching, pattern is NULL
> LOG:  statement: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
> LOG:  DB node id: 0 backend pid: 15594 statement: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
> LOG:  Frontend terminated
> DETAIL:  received message kind 'X' from frontend
> LOG:  statement:  DISCARD ALL
> LOG:  DB node id: 0 backend pid: 15594 statement:  DISCARD ALL
> LOG:  DB node id: 2 backend pid: 5248 statement:  DISCARD ALL
> WARNING:  failed to execute regex matching, pattern is NULL
> LOG:  statement: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
> LOG:  DB node id: 0 backend pid: 15594 statement: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
> LOG:  Frontend terminated
> DETAIL:  received message kind 'X' from frontend
> LOG:  statement:  DISCARD ALL
> LOG:  DB node id: 0 backend pid: 15594 statement:  DISCARD ALL
> LOG:  DB node id: 1 backend pid: 26917 statement:  DISCARD ALL
> WARNING:  failed to execute regex matching, pattern is NULL
> LOG:  statement: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
> LOG:  DB node id: 0 backend pid: 15594 statement: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
> LOG:  Frontend terminated
> DETAIL:  received message kind 'X' from frontend
> LOG:  statement:  DISCARD ALL
> LOG:  DB node id: 0 backend pid: 15594 statement:  DISCARD ALL
> LOG:  DB node id: 2 backend pid: 5248 statement:  DISCARD ALL
> WARNING:  failed to execute regex matching, pattern is NULL
> LOG:  statement: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
> LOG:  DB node id: 0 backend pid: 15594 statement: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
> LOG:  Frontend terminated
> DETAIL:  received message kind 'X' from frontend
> LOG:  statement:  DISCARD ALL
> LOG:  DB node id: 0 backend pid: 15594 statement:  DISCARD ALL
> WARNING:  failed to execute regex matching, pattern is NULL
> LOG:  statement: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
> LOG:  DB node id: 0 backend pid: 13686 statement: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
> LOG:  Frontend terminated
> DETAIL:  received message kind 'X' from frontend
> LOG:  statement:  DISCARD ALL
> LOG:  DB node id: 0 backend pid: 13686 statement:  DISCARD ALL
> 
> Current setup 2 pgool servers, connecting to 3 postgres servers.
> 
> 
> 
> Robert Kennedy| Software & Systems Developer|
> 
> 
> 
>