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.
The postgresql.log file shows this:
2015-08-24 06:48:31 UTC ERROR: invalid memory alloc request size 1970234207
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..."
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
[image: Clutch Holdings, LLC] <http://www.clutch.com> Mike James |
Manager of Infrastructure
267.419.6400, ext 204 | mike.james@clutch.com201 S Maple St. | Suite 250 |
Ambler, PA 19002
Clutch.com <http://www.clutch.com> | Twitter
<https://twitter.com/clutchsuccess> | LinkedIn
<https://www.linkedin.com/company/2837209> | YouTube
<https://www.youtube.com/user/clutchsuccess> | Clutch Support Center
<http://clientsupport.clutch.com/> The only end to end consumer management
platform that empowers consumer-focused businesses to identify, target,
message, and engage their best customers.
On Mon, Aug 24, 2015 at 10:26 AM, Steve Singer <ssin...@ca.afilias.info>
wrote:
> On 08/24/2015 09:19 AM, Mike James wrote:
>
>> We have a slony slave in AWS. During an Amazon maintenance, the instance
>> was rebooted and now the daemon won't start. The log file has this error
>> message:
>>
>>
>> 2015-08-24 06:50:03 UTC INFO remoteWorkerThread_1: syncing set 1 with
>> 102 table(s) from provider 1
>> 2015-08-24 06:50:33 UTC ERROR remoteWorkerThread_1_1: error at end of
>> COPY IN: ERROR: invalid memory alloc request size 1970234207
>> CONTEXT: COPY sl_log_1, line 97033:
>>
>> I'm not sure whether this is a Postgres error or a slony error. We're
>> running Postgres 9.3.5 and slony 2.2.1. Any help much appreciated.
>>
>
>
> Try upgrading to slony 2.2.4
>
> This MIGHT be bug http://www.slony.info/bugzilla/show_bug.cgi?id=327
>
> Memory corruption bugs sometimes manifest themselves with slightly
> different symptoms.
>
>
>
>> Mike
>> Clutch Holdings, LLC <http://www.clutch.com> Mike James |
>> Manager of
>> Infrastructure
>> 267.419.6400, ext 204 | mike.ja...@clutch.com <mailto:
>> mike.ja...@clutch.com>
>> 201 S Maple St. | Suite 250 | Ambler, PA 19002
>> Clutch.com <http://www.clutch.com> | Twitter
>> <https://twitter.com/clutchsuccess> | LinkedIn
>> <https://www.linkedin.com/company/2837209> | YouTube
>> <https://www.youtube.com/user/clutchsuccess> | Clutch Support Center
>> <http://clientsupport.clutch.com/>
>>
>> The only end to end consumer management platform that empowers
>> consumer-focused businesses to identify, target, message, and engage
>> their best customers.
>>
>>
>>
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general@lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-general
>>
>>
>
_______________________________________________
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
