One follow-up: Do you think 2.1.4 is stable in this regard? Thanks!
- Matt -----Original Message----- From: Jan Wieck [mailto:[email protected]] Sent: Friday, January 24, 2014 11:36 AM To: Hanselman, Matthew; Steve Singer Cc: [email protected] Subject: Re: [Slony1-general] Sync stopped with slony-2.2.1 on data type mismatch On 01/24/14 10:03, Hanselman, Matthew wrote: > This looks very similar. I'll leave a comment to this effect on the bug. > Thanks! > > For what it's worth, I tried restarting the slon daemon on both the master & > slave. I got a very similar error, but this time it was complaining that > "Lost Angeles" wasn't an integer. That does indeed look like memory corruption. I will take a very close look at the apply trigger code. In the meantime it may mask this error to increase the size of the apply query cache in the slon conf. Thanks, Jan > > - Matt > > > -----Original Message----- > From: Steve Singer [mailto:[email protected]] > Sent: Friday, January 24, 2014 9:59 AM > To: Jan Wieck > Cc: Hanselman, Matthew; [email protected] > Subject: Re: [Slony1-general] Sync stopped with slony-2.2.1 on data > type mismatch > > On 01/23/2014 03:42 PM, Jan Wieck wrote: >> On 01/23/14 15:31, Hanselman, Matthew wrote: >>> Running Slony 2.2.1 with Postgres 9.2.6. The slave is getting errors >>> trying to apply a change with this error: >>> >>> >>> >>> 2014-01-23 14:55:58 EST ERROR remoteWorkerThread_1_1: error at end >>> of COPY IN: ERROR: invalid input syntax for integer: "33.7726910000000018" >>> > > > Could this be the same thing as that is causing > http://bugs.slony.info/bugzilla/show_bug.cgi?id=327 > > (We suspect memory corruption in the apply trigger) > > > > >>> >>> >>> The column in question is a "double precision" on both master & slave. >>> No schema change has happened since Slony was deployed. >> >> What did happen between slony was deployed and this breakage? >> >> >> Jan >> >> >> >>> >>> >>> >>> Is this a bug in Slony, or is there something else I can do to troubleshoot? >>> >>> >>> >>> - Matt >>> >>> >>> >>> >>> >>> _______________________________________________ >>> Slony1-general mailing list >>> [email protected] >>> http://lists.slony.info/mailman/listinfo/slony1-general >>> >> >> > -- Anyone who trades liberty for security deserves neither liberty nor security. -- Benjamin Franklin _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
