<div dir="ltr">I *think* the problem is that Amazon rebooted our instance and it was not a clean restart. In my mind, it's possible memory got corrupted. <div><br></div><div>The postgresql.log file shows this:</div><div><br></div><div><div>2015-08-24 06:48:31 UTC ERROR: invalid memory alloc request size 1970234207</div><div>2015-08-24 06:48:31 UTC CONTEXT: COPY sl_log_1, line 97033: "1 310825709 20 120889769 public customers U 11 {first_name,ABE,last_name,VIGODA,address_1,"1313 MO..."</div><div>2015-08-24 06:48:31 UTC STATEMENT: COPY "_clients_cluster"."sl_log_1" ( log_origin, log_txid,log_tableid,log_actionseq,log_tablenspname, log_tablerelname, log_cmdtype, log_cmdupdncols,log_cmdargs) FROM STDIN</div></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><table border="0" cellspacing="0" cellpadding="0" style="font-family:Times"><tbody><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;border-bottom-width:1px;border-bottom-color:rgb(200,200,200);border-bottom-style:solid"> </td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;height:5px"> </td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;height:5px"><table width="100%" border="0" cellpadding="0" cellspacing="0"><tbody><tr><td rowspan="2" style="font-family:'Gill Sans',Helvetica,sans-serif;line-height:20px;padding-right:10px;padding-left:10px;border-right-width:1px;border-right-color:rgb(200,200,200);border-right-style:solid"><a href="http://www.clutch.com" target="_blank"><img src="https://s3.amazonaws.com/assets.clutchwallet.com/clutchLogo.png" alt="Clutch Holdings, LLC" name="UNIQUE_ID_SafeHtmlFilter_Clutch" width="140" height="76" border="0"></a></td><td rowspan="2" style="font-family:'Gill Sans',Helvetica,sans-serif;line-height:24px;border-left-width:1px;border-left-color:rgb(200,200,200);border-left-style:solid;margin-right:10px;padding-right:20px"> </td><td style="font-family:'Gill Sans',Helvetica,sans-serif;font-size:18px;line-height:24px;border-bottom-width:1px;border-bottom-color:rgb(200,200,200);border-bottom-style:solid;padding-bottom:5px"><font color="#f16528">Mike James</font> | Manager of Infrastructure<br><span style="font-size:13px">267.419.6400, ext 204 | <a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a></span></td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;font-size:13px;line-height:20px;padding-top:5px">201 S Maple St. | Suite 250 | Ambler, PA 19002 <br><a href="http://www.clutch.com" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">Clutch.com</a> | <a href="https://twitter.com/clutchsuccess" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">Twitter</a> | <a href="https://www.linkedin.com/company/2837209" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">LinkedIn</a> | <a href="https://www.youtube.com/user/clutchsuccess" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">YouTube</a> | <a href="http://clientsupport.clutch.com/" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">Clutch Support Center</a></td></tr></tbody></table></td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;height:5px"> </td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:12px;font-style:italic;line-height:20px;padding-right:30px;border-top-width:1px;border-top-color:rgb(200,200,200);border-top-style:solid;border-bottom-width:1px;border-bottom-color:rgb(200,200,200);border-bottom-style:solid;height:30px">The only end to end consumer management platform that empowers consumer-focused businesses to identify, target, message, and engage their best customers.</td></tr></tbody></table></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Mon, Aug 24, 2015 at 10:26 AM, Steve Singer <span dir="ltr"><<a href="mailto:ssinger@ca.afilias.info" target="_blank">ssinger@ca.afilias.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 08/24/2015 09:19 AM, Mike James wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
We have a slony slave in AWS. During an Amazon maintenance, the instance<br>
was rebooted and now the daemon won't start. The log file has this error<br>
message:<br>
<br>
<br>
2015-08-24 06:50:03 UTC INFO remoteWorkerThread_1: syncing set 1 with<br>
102 table(s) from provider 1<br>
2015-08-24 06:50:33 UTC ERROR remoteWorkerThread_1_1: error at end of<br>
COPY IN: ERROR: invalid memory alloc request size 1970234207<br>
CONTEXT: COPY sl_log_1, line 97033:<br>
<br>
I'm not sure whether this is a Postgres error or a slony error. We're<br>
running Postgres 9.3.5 and slony 2.2.1. Any help much appreciated.<br>
</blockquote>
<br>
<br></span>
Try upgrading to slony 2.2.4<br>
<br>
This MIGHT be bug <a href="http://www.slony.info/bugzilla/show_bug.cgi?id=327" rel="noreferrer" target="_blank">http://www.slony.info/bugzilla/show_bug.cgi?id=327</a><br>
<br>
Memory corruption bugs sometimes manifest themselves with slightly different symptoms.<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Mike<br>
Clutch Holdings, LLC <<a href="http://www.clutch.com" rel="noreferrer" target="_blank">http://www.clutch.com</a>> Mike James | Manager of<br>
Infrastructure<br>
<a href="tel:267.419.6400%2C%20ext%20204" value="+12674196400" target="_blank">267.419.6400, ext 204</a> | <a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a> <mailto:<a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a>><span class=""><br>
201 S Maple St. | Suite 250 | Ambler, PA 19002<br></span>
Clutch.com <<a href="http://www.clutch.com" rel="noreferrer" target="_blank">http://www.clutch.com</a>> | Twitter<br>
<<a href="https://twitter.com/clutchsuccess" rel="noreferrer" target="_blank">https://twitter.com/clutchsuccess</a>> | LinkedIn<br>
<<a href="https://www.linkedin.com/company/2837209" rel="noreferrer" target="_blank">https://www.linkedin.com/company/2837209</a>> | YouTube<br>
<<a href="https://www.youtube.com/user/clutchsuccess" rel="noreferrer" target="_blank">https://www.youtube.com/user/clutchsuccess</a>> | Clutch Support Center<br>
<<a href="http://clientsupport.clutch.com/" rel="noreferrer" target="_blank">http://clientsupport.clutch.com/</a>><span class=""><br>
<br>
The only end to end consumer management platform that empowers<br>
consumer-focused businesses to identify, target, message, and engage<br>
their best customers.<br>
<br>
<br>
<br></span>
_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info" target="_blank">Slony1-general@lists.slony.info</a><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" rel="noreferrer" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
<br>
</blockquote>
<br>
</blockquote></div><br></div>