<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:"Lucida Console";
panose-1:2 11 6 9 4 5 4 2 2 4;}
@font-face
{font-family:"Edwardian Script ITC";
panose-1:3 3 3 2 4 7 7 13 8 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hey folks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Using pgpool 3.4.3 with streaming replication (yes, I’m in the process of moving to 3.5). I’m seeing this error – an SQL query attempts to create a table (which already exists) and the PostgreSQL server returns the proper error message.
However, pgpool raises this fatal message:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">FATAL: unable to process backend response<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">DETAIL: invalid message kind sent by backend connection<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">DEBUG: shmem_exit(2): 0 callbacks to make<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">DEBUG: proc_exit(2): 0 callbacks to make<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">DEBUG: exit(2)<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">DEBUG: shmem_exit(-1): 0 callbacks to make<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">DEBUG: proc_exit(-1): 0 callbacks to make<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I tried executing the same SQL statement from pgAdmin, but could not generate the above error in the pgpool log. So I’m not sure what the original client is doing differently. Any ideas about how to avoid this error? This is only a fatal
error with pgpool – the PostgreSQL server doesn’t appear to have any issues. I’ll try pgpool 3.5 to see if I see the same results.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The detailed pgpool.log follows: <o:p></o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console""><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: LOG: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 30876 statement: "create
table if not exists EAM_ENCRYPTION_KEYS (encryption_key varchar(2000) not null, creation_date timestamp primary key default now()) " message: "NOTICE: relation "eam_encryption_keys" already exists, skipping<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console""> "<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: detect error: kind: N<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: detect error: kind: N<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: detect error: kind: N<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: detect error: kind: N<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: reading backend data packet kind<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DETAIL: backend:0 kind:'N'<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: reading backend data packet kind<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DETAIL: backend:0 of 2 kind = 'N'<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: processing backend response<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DETAIL: received kind 'N'(4e) from backend<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: reading string data<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DETAIL: read all from pending data. po:2 len:80<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: reading backend data packet kind<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DETAIL: backend:0 kind:'<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: reading backend data packet kind<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DETAIL: backend:0 of 2 kind = '<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: FATAL: unable to process backend response<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DETAIL: invalid message kind sent by backend connection<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: shmem_exit(2): 0 callbacks to make<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: proc_exit(2): 0 callbacks to make<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: exit(2)<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: shmem_exit(-1): 0 callbacks to make<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30584: DEBUG: proc_exit(-1): 0 callbacks to make<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30335: DEBUG: reaper handler<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30335: LOG: child process with pid: 30584 exits with status 512<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console"">2016-10-17 23:00:08: pid 30335: LOG: fork a new child process with pid: 30877<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Lucida Console""><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:22.0pt;font-family:"Edwardian Script ITC"">Ken Young</span><span style="font-family:"Edwardian Script ITC""><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif">Ken.Young@sas.com</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif">
<br>
</span><b><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif">Data Management R&D</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif">
<br>
</span><b><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif">SAS Institute, Inc.</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif">
<br>
</span><b><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif">919-531-9319
</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><a href="http://www.sas.com/"><span style="color:blue">http://www.sas.com</span></a></span><span style="font-size:12.0pt;font-family:"Times New Roman",serif">
<o:p></o:p></span></p>
<p class="MsoNormal"><b><i><span style="font-size:13.5pt;font-family:"Helvetica",sans-serif">SAS...</span> The Power to Know</i></b>
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>