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

[Robert Kennedy]

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|




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141217/eb111bd2/attachment.html>