The master is a 7.3.3 box and the slave is a 7.3.8 box. Note, all
attempts have been with slony 1.0.5.

When I try to replicate to a freshly installed 7.4.6 box I get the
following errors on the slave:

CONFIG main: slon version 1.0.5 starting up
CONFIG main: local node id = 2
CONFIG main: loading current cluster configuration
CONFIG storeNode: no_id=1 no_comment='Master Node'
CONFIG storePath: pa_server=1 pa_client=2 pa_conninfo="dbname=sam
host=pgsql.geotivity.net port=5432 user=postgres" pa_connretry=10
CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1
CONFIG main: configuration complete - starting threads
CONFIG enableNode: no_id=1
CONFIG storeSet: set_id=1 set_origin=1 set_comment='First Set'
CONFIG storeSubscribe: sub_set=1 sub_provider=1 sub_forward='t'
WARN   remoteWorkerThread_1: transactions earlier than XID 2498386219
are still in progress
WARN   remoteWorkerThread_1: data copy for set 1 failed - sleep 15
seconds
ERROR  remoteWorkerThread_1: copy from stdin on local node -
PGRES_FATAL_ERROR ERROR:  invalid input syntax for integer: ""
CONTEXT:  COPY project, line 1, column wet_warning: ""
WARN   remoteWorkerThread_1: data copy for set 1 failed - sleep 30
seconds
ERROR  remoteWorkerThread_1: copy from stdin on local node -
PGRES_FATAL_ERROR ERROR:  invalid input syntax for integer: ""
CONTEXT:  COPY project, line 1, column wet_warning: ""
WARN   remoteWorkerThread_1: data copy for set 1 failed - sleep 60
seconds
ERROR  remoteWorkerThread_1: copy from stdin on local node -
PGRES_FATAL_ERROR ERROR:  invalid input syntax for integer: ""
CONTEXT:  COPY project, line 1, column wet_warning: ""
WARN   remoteWorkerThread_1: data copy for set 1 failed - sleep 60
seconds
INFO   remoteListenThread_1: disconnecting from 'dbname=sam
host=pgsql.geotivity.net port=5432 user=postgres'
WARNING:  there is no transaction in progress
[postgres at pgsql2.geotivity.net ~]$ pg_ctl --version
pg_ctl (PostgreSQL) 7.4.6


And in the server log:

ERROR:  invalid input syntax for integer: ""
CONTEXT:  COPY project, line 1, column wet_warning: ""
ERROR:  invalid input syntax for integer: ""
CONTEXT:  COPY project, line 1, column wet_warning: ""
ERROR:  invalid input syntax for integer: ""
CONTEXT:  COPY project, line 1, column wet_warning: ""
WARNING:  there is no transaction in progress

Dan Hrabarchuk

On Fri, 2004-12-24 at 09:03, Dan Hrabarchuk wrote:
> Also I have this in my PostgreSQL server log repeating:
> 
> WARNING:  ROLLBACK: no transaction in progress
> FATAL:  Socket command type 6 unknown
> LOG:  pq_flush: send() failed: Broken pipe
> 
> Dan Hrabarchuk
> 
> On Fri, 2004-12-24 at 08:57, Dan Hrabarchuk wrote:
> > I successfully set up replication using a couple of test databases as
> > described by the README.
> > 
> > When I go to replicate my production machine I get the following output
> > on the slave:
> > 
> > CONFIG main: slon version 1.0.5 starting up
> > CONFIG main: local node id = 2
> > CONFIG main: loading current cluster configuration
> > CONFIG storeNode: no_id=1 no_comment='Master Node'
> > CONFIG storePath: pa_server=1 pa_client=2 pa_conninfo="dbname=sam
> > host=pgsql.geotivity.net port=5432 user=postgres" pa_connretry=10
> > CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1
> > CONFIG storeSet: set_id=1 set_origin=1 set_comment='First Set'
> > WARN   remoteWorker_wakeup: node 1 - no worker thread
> > CONFIG storeSubscribe: sub_set=1 sub_provider=1 sub_forward='t'
> > WARN   remoteWorker_wakeup: node 1 - no worker thread
> > CONFIG main: configuration complete - starting threads
> > CONFIG enableNode: no_id=1
> > ERROR:  copy: line 1, pg_atoi: zero-length string
> > lost synchronization with server, resetting connection
> > ERROR  remoteWorkerThread_1: PGendcopy() on local DBWARNING:  ROLLBACK:
> > no transaction in progress
> > WARN   remoteWorkerThread_1: data copy for set 1 failed - sleep 15
> > seconds
> > <repeat>
> > ERROR:  copy: line 1, Slony-I: Table unit is replicated and cannot be
> > modified on a subscriber node
> > lost synchronization with server, resetting connection
> > </repeat>
> > 
> > First off, why the zero-length string? Also why is the replication
> > daemon unable to replicate the unit table? Is there any way is increase
> > the verbosity of slon? When I do a COPY or a \COPY of any of the tables
> > I get a full and proper result. It seems as if it is trying to copy the
> > data but a local constraint is preventing the copy from happening.
> > 
> > Here is my installation script:
> > 
> > cluster name = geo;
> > node 1 admin conninfo = 'dbname=sam host=pgsql.geotivity.net port=5432
> > user=postgres';
> > node 2 admin conninfo = 'dbname=sam host=pgsql2.geotivity.net port=5432
> > user=postgres';
> > echo 'Cluster defined.';
> >  
> > init cluster (id=1, comment='Master Node');
> > store node (id=2, comment='Backup Node');
> > echo 'Nodes defined.';
> >  
> > store path (server=1, client=2, conninfo='dbname=sam
> > host=pgsql.geotivity.net port=5432 user=postgres');
> > store path (server=2, client=1, conninfo='dbname=sam
> > host=pgsql2.geotivity.net port=5432 user=postgres');
> > echo 'Paths stored.';
> >  
> > store listen (origin=1, receiver=2, provider=1);
> > store listen (origin=2, receiver=1, provider=2);
> > echo 'Listening.';
> > create set (id=1, origin=1, comment='First Set');
> > echo 'Set 1 created.';
> >  
> > set add table (set id=1, origin=1, id=1, fully qualified
> > name='public.unit', comment='Unit');
> > set add table (set id=1, origin=1, id=2, fully qualified
> > name='public.timezones', comment='Timezones');
> > set add table (set id=1, origin=1, id=3, fully qualified
> > name='public.timezone_rotations', comment='timezone_rotations');
> > set add table (set id=1, origin=1, id=4, fully qualified
> > name='public.client', comment='client');
> > set add table (set id=1, origin=1, id=5, fully qualified
> > name='public.project', comment='project');
> > echo 'Set 1 defined.';
> >  
> > subscribe set (id=1, provider=1, receiver=2, forward=yes);
> > echo 'Set 1 subscribed.';
> > 
> > Thank you very much for any help.
> > 
> > Dan Hrabarchuk
> > 
> > _______________________________________________
> > Slony1-general mailing list
> > Slony1-general at gborg.postgresql.org
> > http://gborg.postgresql.org/mailman/listinfo/slony1-general
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general