http://www.slony.info/bugzilla/show_bug.cgi?id=327

--- Comment #2 from Matt <matthewh at telenav.com> 2014-01-24 08:24:22 PST ---
I think I may have hit this same bug. My symptoms:

Set up a cluster with Postgres 9.2.6 and Slony 2.2.1. Cascading replication set
up with Master -> Intermediate Slave -> 4 Slaves

After 2 days of uptime and no DDL changes, the intermediate slave's slon daemon
stated saying messages like:

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"

The column in question is a “double precision” on both master & slave.

I tried restarting the slon daemon on both master and intermediate slave. The
error message changed slightly:

COPY IN: ERROR:  invalid input syntax for integer: "Los Angeles"

Unfortunately I have to tear down this cluster since we need the machinery, but
I'll keep my eye out for it again

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.