Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ch0cw-0000lt-9X for pgsql-admin@arkaria.postgresql.org; Thu, 23 Feb 2017 21:08:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ch0cu-00042f-Qf for pgsql-admin@arkaria.postgresql.org; Thu, 23 Feb 2017 21:08:36 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ch0cu-00042Z-Ah for pgsql-admin@postgresql.org; Thu, 23 Feb 2017 21:08:36 +0000 Received: from mail-qk0-x244.google.com ([2607:f8b0:400d:c09::244]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1ch0cr-0007zk-Ib for pgsql-admin@postgresql.org; Thu, 23 Feb 2017 21:08:34 +0000 Received: by mail-qk0-x244.google.com with SMTP id s186so487521qkb.1 for ; Thu, 23 Feb 2017 13:08:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:date:message-id:mime-version:thread-index :content-language; bh=16bFfLas78kDvlmw28hz7s28Bl92rIPBNPKpNACVo1E=; b=czqPs1ycLhc+boDuxDrYFzPFBX8rOeQjpHjTIdT6X8twg+rmA024nnji6BWtotH9Ub 1PaNDQa1sbQeY2QTncVxLO0Z5YVjBXw4xVR4Nx8lKa3/mH3YpBcbAJyGo5K1Gi15Qw/G fS/mOKLYQR773fZjCT18IGeQv0JJ2DbPgoQIzyp1V2Th6qJ/tQly7btL9yw0l4UOyZRH 0kTPo22aBZDwvhOQsn1XffS9pJVeoSo+/YMCfkjBPAw2ijtJSp+JbE8QHGASsnItFWwm /ppOtsu/rJhbko0yrHAaqgpiIbDw2/VGqev9EclwuiN6iUnVuQ4w2iYReV+vKg6K1bcg vB4Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:date:message-id:mime-version :thread-index:content-language; bh=16bFfLas78kDvlmw28hz7s28Bl92rIPBNPKpNACVo1E=; b=EdBeUqRzxM5wDDLjIOZA8fUcb72z6/GD2BpkxXLgEBNeTy2TAL3qtZ0BY2Sxf6FUQz uML0+AfH9f8A+uBdVkOgg0W1ctD4yOa6U2cD6Q1mWo0WWsKcOOJsegjrjabHwN55PIII 3z4tOFc2BZ50Fv8SdWziujQcCUPsDzyi/nDX/m3UaM72wJLY3tCmaUxnl65mcLVB8BV2 PL+dZIeNzC+YNMu8UK6DstCxeojz7dS78w/g0mVJlNmiWjFDAtpPmICgylN4QJpl0Ao2 zlTp5YXM5Ppn4fcBiNQc2CjAViXeaT0jFnWl5cVcukTWVA5jKcR7AC8lpjio6RY5j/sD l1BQ== X-Gm-Message-State: AMke39mFozt2kHjPAkV6F7u+JgzZyxQ6KNReUE2OvFKUEyIRpZSHmBC9PKH9qeucWiD/qg== X-Received: by 10.55.111.2 with SMTP id k2mr42601161qkc.138.1487884112017; Thu, 23 Feb 2017 13:08:32 -0800 (PST) Received: from irylachi ([200.55.161.75]) by smtp.gmail.com with ESMTPSA id i51sm3419485qtc.67.2017.02.23.13.08.26 (version=TLS1_2 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Thu, 23 Feb 2017 13:08:31 -0800 (PST) From: "Lazaro Garcia" To: , Subject: Failover but master is running Date: Thu, 23 Feb 2017 16:08:20 -0500 Message-ID: <001a01d28e18$fbf76720$f3e63560$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001B_01D28DEF.1323D020" X-Mailer: Microsoft Outlook 15.0 Thread-Index: AdKOGDurR6mC9ER+R0axkARkFdPNGw== Content-Language: es-mx X-Pg-Spam-Score: -1.7 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_001B_01D28DEF.1323D020 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello everyone in the list, testing pgpool a failover is triggered but the master is running. The pgpool version is 3.5.5. This is the log reported by pgpool. Could anybody help me to clarify this error? The reason could be postgresql server has reached max_connections? Regards. 2017-02-23 14:18:58: pid 5303: ERROR: unable to read data 2017-02-23 14:18:58: pid 5303: DETAIL: child connection forced to terminate due to client_idle_limit:300 is reached 2017-02-23 14:25:31: pid 5479: LOG: pool_read_kind: error message from 1 th backend:sorry, too many clients already 2017-02-23 14:25:31: pid 5479: ERROR: unable to read message kind 2017-02-23 14:25:31: pid 5479: DETAIL: kind does not match between master(52) slot[1] (45) 2017-02-23 14:25:36: pid 5287: ERROR: failed to authenticate 2017-02-23 14:25:36: pid 5287: DETAIL: invalid authentication message response type, Expecting 'R' and received 'E' 2017-02-23 14:25:41: pid 55651: ERROR: failed to authenticate 2017-02-23 14:25:41: pid 55651: DETAIL: invalid authentication message response type, Expecting 'R' and received 'E' 2017-02-23 14:25:41: pid 55651: ERROR: failed to authenticate 2017-02-23 14:25:41: pid 55651: DETAIL: invalid authentication message response type, Expecting 'R' and received 'E' 2017-02-23 14:25:41: pid 55651: LOG: setting backend node 1 status to NODE DOWN 2017-02-23 14:25:41: pid 55651: LOG: received degenerate backend request for node_id: 1 from pid [55651] 2017-02-23 14:25:41: pid 55651: LOG: starting degeneration. shutdown host 192.168.5.19(5432) ------=_NextPart_000_001B_01D28DEF.1323D020 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello everyone in the list, testing = pgpool a failover is triggered but the master is running. The pgpool = version is 3.5.5. This is the log reported by = pgpool.

 

Could anybody help me to clarify this = error?

 

The reason could be postgresql server has reached = max_connections?

 

Regards.

2017-02-23 14:18:58: pid 5303: ERROR:  unable to read = data

2017-02-23 14:18:58: pid 5303: DETAIL:  child = connection forced to terminate due to client_idle_limit:300 is = reached

2017-02-23 14:25:31: pid 5479: LOG:  pool_read_kind: = error message from 1 th backend:sorry, too many clients = already

2017-02-23 14:25:31: pid 5479: ERROR:  unable to read = message kind

2017-02-23 14:25:31: pid 5479: = DETAIL:  kind does not match between master(52) slot[1] = (45)

2017-02-23 14:25:36: pid 5287: ERROR:  failed to = authenticate

2017-02-23 14:25:36: pid 5287: DETAIL:  invalid = authentication message response type, Expecting 'R' and received = 'E'

2017-02-23 14:25:41: pid 55651: ERROR:  failed to = authenticate

2017-02-23 14:25:41: pid 55651: DETAIL:  invalid = authentication message response type, Expecting 'R' and received = 'E'

2017-02-23 14:25:41: pid 55651: ERROR:  failed to = authenticate

2017-02-23 14:25:41: pid 55651: DETAIL:  invalid = authentication message response type, Expecting 'R' and received = 'E'

2017-02-23 14:25:41: pid 55651: LOG:  setting backend = node 1 status to NODE DOWN

2017-02-23 14:25:41: pid 55651: = LOG:  received degenerate backend request for node_id: 1 from pid = [55651]

2017-02-23 14:25:41: pid 55651: LOG:  starting = degeneration. shutdown host = 192.168.5.19(5432)

------=_NextPart_000_001B_01D28DEF.1323D020--