i have a lot of Messages regarding HA Sync, maybe someone can have a look on it?:
2011:03:22-13:57:16 firewall-2 postgres[4790]: [2-3] PL/pgSQL function "ins_accounting" line 35 at SQL statement
2011:03:22-13:57:16 firewall-2 postgres[4790]: [2-4] STATEMENT: select ins_accounting($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2011:03:22-13:57:22 firewall-2 postgres[4834]: [2-1] ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:57:22 firewall-2 postgres[4834]: [2-2] CONTEXT: SQL statement "update accounting set raw_in_pktlen = raw_in_pktlen + $1 , raw_in_pktcount = raw_in_pktcount + $2 ,
raw_out_pktlen = raw_out_pktlen + $3 , raw_out_pktcount = raw_out_pktcount + $4 , flow_count = flow_count + 1 where logday = $5 and srcip = $6 and (srcid = $7 or (srcid IS
NULL and $7 IS NULL)) and dstip = $8 and (dstid = $9 or (dstid IS NULL and $9 IS NULL)) and ip_protocol = $10 and l4_dport = $11 and afc_proto = $12 "
2011:03:22-13:57:22 firewall-2 postgres[4834]: [2-3] PL/pgSQL function "ins_accounting" line 20 at SQL statement
2011:03:22-13:57:22 firewall-2 postgres[4834]: [2-4] STATEMENT: select ins_accounting($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2011:03:22-13:57:22 firewall-2 ulogd[6387]: pg1: ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:57:28 firewall-2 postgres[4855]: [2-1] ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:57:28 firewall-2 postgres[4855]: [2-2] CONTEXT: SQL statement "update accounting set raw_in_pktlen = raw_in_pktlen + $1 , raw_in_pktcount = raw_in_pktcount + $2 ,
raw_out_pktlen = raw_out_pktlen + $3 , raw_out_pktcount = raw_out_pktcount + $4 , flow_count = flow_count + 1 where logday = $5 and srcip = $6 and (srcid = $7 or (srcid IS
NULL and $7 IS NULL)) and dstip = $8 and (dstid = $9 or (dstid IS NULL and $9 IS NULL)) and ip_protocol = $10 and l4_dport = $11 and afc_proto = $12 "
2011:03:22-13:57:28 firewall-2 postgres[4855]: [2-3] PL/pgSQL function "ins_accounting" line 20 at SQL statement
2011:03:22-13:57:28 firewall-2 postgres[4855]: [2-4] STATEMENT: select ins_accounting($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2011:03:22-13:57:28 firewall-2 ulogd[6387]: pg1: ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:57:34 firewall-2 postgres[4879]: [2-1] ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:57:34 firewall-2 postgres[4879]: [2-2] CONTEXT: SQL statement "update accounting set raw_in_pktlen = raw_in_pktlen + $1 , raw_in_pktcount = raw_in_pktcount + $2 ,
raw_out_pktlen = raw_out_pktlen + $3 , raw_out_pktcount = raw_out_pktcount + $4 , flow_count = flow_count + 1 where logday = $5 and srcip = $6 and (srcid = $7 or (srcid IS
NULL and $7 IS NULL)) and dstip = $8 and (dstid = $9 or (dstid IS NULL and $9 IS NULL)) and ip_protocol = $10 and l4_dport = $11 and afc_proto = $12 "
2011:03:22-13:57:34 firewall-2 postgres[4879]: [2-3] PL/pgSQL function "ins_accounting" line 20 at SQL statement
2011:03:22-13:57:34 firewall-2 postgres[4879]: [2-4] STATEMENT: select ins_accounting($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2011:03:22-13:57:34 firewall-2 ulogd[6387]: pg1: ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:57:41 firewall-2 postgres[4902]: [2-1] ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:57:41 firewall-2 postgres[4902]: [2-2] CONTEXT: SQL statement "update accounting set raw_in_pktlen = raw_in_pktlen + $1 , raw_in_pktcount = raw_in_pktcount + $2 ,
raw_out_pktlen = raw_out_pktlen + $3 , raw_out_pktcount = raw_out_pktcount + $4 , flow_count = flow_count + 1 where logday = $5 and srcip = $6 and (srcid = $7 or (srcid IS
NULL and $7 IS NULL)) and dstip = $8 and (dstid = $9 or (dstid IS NULL and $9 IS NULL)) and ip_protocol = $10 and l4_dport = $11 and afc_proto = $12 "
2011:03:22-13:57:41 firewall-2 postgres[4902]: [2-3] PL/pgSQL function "ins_accounting" line 20 at SQL statement
2011:03:22-13:57:41 firewall-2 postgres[4902]: [2-4] STATEMENT: select ins_accounting($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2011:03:22-13:57:41 firewall-2 ulogd[6387]: pg1: ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:57:48 firewall-2 postgres[4946]: [2-1] ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:57:48 firewall-2 postgres[4946]: [2-2] CONTEXT: SQL statement "update accounting set raw_in_pktlen = raw_in_pktlen + $1 , raw_in_pktcount = raw_in_pktcount + $2 ,
raw_out_pktlen = raw_out_pktlen + $3 , raw_out_pktcount = raw_out_pktcount + $4 , flow_count = flow_count + 1 where logday = $5 and srcip = $6 and (srcid = $7 or (srcid IS
NULL and $7 IS NULL)) and dstip = $8 and (dstid = $9 or (dstid IS NULL and $9 IS NULL)) and ip_protocol = $10 and l4_dport = $11 and afc_proto = $12 "
2011:03:22-13:57:48 firewall-2 postgres[4946]: [2-3] PL/pgSQL function "ins_accounting" line 20 at SQL statement
2011:03:22-13:57:48 firewall-2 postgres[4946]: [2-4] STATEMENT: select ins_accounting($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2011:03:22-13:57:48 firewall-2 ulogd[6387]: pg1: ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:57:54 firewall-2 postgres[4968]: [2-1] ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:57:54 firewall-2 postgres[4968]: [2-2] CONTEXT: SQL statement "update accounting set raw_in_pktlen = raw_in_pktlen + $1 , raw_in_pktcount = raw_in_pktcount + $2 ,
raw_out_pktlen = raw_out_pktlen + $3 , raw_out_pktcount = raw_out_pktcount + $4 , flow_count = flow_count + 1 where logday = $5 and srcip = $6 and (srcid = $7 or (srcid IS
NULL and $7 IS NULL)) and dstip = $8 and (dstid = $9 or (dstid IS NULL and $9 IS NULL)) and ip_protocol = $10 and l4_dport = $11 and afc_proto = $12 "
2011:03:22-13:57:54 firewall-2 postgres[4968]: [2-3] PL/pgSQL function "ins_accounting" line 20 at SQL statement
2011:03:22-13:57:54 firewall-2 postgres[4968]: [2-4] STATEMENT: select ins_accounting($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2011:03:22-13:57:54 firewall-2 ulogd[6387]: pg1: ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:58:02 firewall-2 postgres[4991]: [2-1] ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:58:02 firewall-2 postgres[4991]: [2-2] CONTEXT: SQL statement "update accounting set raw_in_pktlen = raw_in_pktlen + $1 , raw_in_pktcount = raw_in_pktcount + $2 ,
raw_out_pktlen = raw_out_pktlen + $3 , raw_out_pktcount = raw_out_pktcount + $4 , flow_count = flow_count + 1 where logday = $5 and srcip = $6 and (srcid = $7 or (srcid IS
NULL and $7 IS NULL)) and dstip = $8 and (dstid = $9 or (dstid IS NULL and $9 IS NULL)) and ip_protocol = $10 and l4_dport = $11 and afc_proto = $12 "
2011:03:22-13:58:02 firewall-2 postgres[4991]: [2-3] PL/pgSQL function "ins_accounting" line 20 at SQL statement
2011:03:22-13:58:02 firewall-2 postgres[4991]: [2-4] STATEMENT: select ins_accounting($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2011:03:22-13:58:02 firewall-2 ulogd[6387]: pg1: ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:58:08 firewall-2 postgres[5012]: [2-1] ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
2011:03:22-13:58:08 firewall-2 postgres[5012]: [2-2] CONTEXT: SQL statement "update accounting set raw_in_pktlen = raw_in_pktlen + $1 , raw_in_pktcount = raw_in_pktcount + $2 ,
raw_out_pktlen = raw_out_pktlen + $3 , raw_out_pktcount = raw_out_pktcount + $4 , flow_count = flow_count + 1 where logday = $5 and srcip = $6 and (srcid = $7 or (srcid IS
NULL and $7 IS NULL)) and dstip = $8 and (dstid = $9 or (dstid IS NULL and $9 IS NULL)) and ip_protocol = $10 and l4_dport = $11 and afc_proto = $12 "
2011:03:22-13:58:08 firewall-2 postgres[5012]: [2-3] PL/pgSQL function "ins_accounting" line 20 at SQL statement
2011:03:22-13:58:08 firewall-2 postgres[5012]: [2-4] STATEMENT: select ins_accounting($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)
2011:03:22-13:58:08 firewall-2 ulogd[6387]: pg1: ERROR: Slony-I: Table accounting is replicated and cannot be modified on a subscriber node - role=0
Waiting for data... (interrupt to abort)
Robert
