[Pgcluster-general] Problems with pgreplicator

[Agustín López]

Hello!

I am testing pgcluster. The last problem I got is the next.
Replicator have a segfault with a  repeating message in
the syslog. Firstly go Ok, but in one moment the replicator
hang up when COPY TO data with pg_restore. I think of
it is by binary bytes (see ERROR msg below).
I have created the DB with LATIN9 and pg_dump in the same
way.

Any pointer to help me?

Regards,
Agustin

Using:
Debian
Linux 2.6.18-xen #1 SMP Mon Dec 10 14:47:51 CET 2007 x86_64 GNU/Linux
pgcluster-1.7.0rc12, compiled by me.
2 nodes, 2 replicators, not load balancing

------------------------------------------------------------
NODE_1
LOG:  statement: COPY acs_attribute_values (object_id, attribute_id, 
attr_value) FROM stdin;
LOG:  statement: SELECT 1
LOG:  statement: SELECT 1
LOG:  statement: SELECT 1
LOG:  statement: SELECT 1
LOG:  statement: SELECT 1
LOG:  statement: SELECT 1
LOG:  statement: SELECT 1

NODE_2
LOG:  statement: COPY acs_attribute_values (object_id, attribute_id, 
attr_value) FROM stdin
LOG:  connection received: host=moonknight.uv.es port=34809
LOG:  connection authorized: user=postgres database=template1
LOG:  statement: SELECT 1
LOG:  disconnection: session time: 0:00:00.004 user=postgres 
database=template1 host=moonknight.uv.es port=34809
LOG:  incomplete message from client
CONTEXT:  COPY acs_attribute_values, line 111: 
"1570785I67IÿÃÿáÂEExifÀÀII*À\bÀÀÀ\vÀNABÀ\vÀÀÀÂÀÀÀOABÀFÀÀÀ²ÀÀÀPABÀFÀÀÀ..."
ERROR:  unexpected EOF on client connection
CONTEXT:  COPY acs_attribute_values, line 111: 
"1570785I67IÿÃÿáÂEExifÀÀII*À\bÀÀÀ\vÀNABÀ\vÀÀÀÂÀÀÀOABÀFÀÀÀ²ÀÀÀPABÀFÀÀÀ..."
STATEMENT:  COPY acs_attribute_values (object_id, attribute_id, 
attr_value) FROM stdin
LOG:  could not send data to client: Tubería rota
LOG:  unexpected EOF on client connection
LOG:  disconnection: session time: 0:00:24.216 user=postgres 
database=openacsdb_5_3_desa host=moondragon.uv.es port=38090
LOG:  connection received: host=moondragon.uv.es port=45655
LOG:  connection authorized: user=postgres database=template1
LOG:  statement: SELECT 1

syslog
...
Apr  8 19:55:33 moonknight kernel: pgreplicate[14196]: segfault at 
0000000000002013 rip 00002b8e4d5f7920 rsp 00007fff5de840f8 error 4
Apr  8 19:55:33 moonknight kernel: pgreplicate[14197]: segfault at 
0000000000002013 rip 00002b8e4d5f7920 rsp 00007fff5de840f8 error 4
Apr  8 19:55:33 moonknight kernel: pgreplicate[14198]: segfault at 
0000000000002013 rip 00002b8e4d5f7920 rsp 00007fff5de840f8 error 4
Apr  8 19:55:33 moonknight kernel: pgreplicate[14199]: segfault at 
0000000000002013 rip 00002b8e4d5f7920 rsp 00007fff5de840f8 error 4
Apr  8 19:55:33 moonknight kernel: pgreplicate[14200]: segfault at 
0000000000002013 rip 00002b8e4d5f7920 rsp 00007fff5de840f8 error 4
Apr  8 19:55:33 moonknight kernel: pgreplicate[14201]: segfault at 
0000000000002013 rip 00002b8e4d5f7920 rsp 00007fff5de840f8 error 4
------------------------------------------------------------...