JP Fletcher jpfletch at ca.afilias.info
Thu Sep 13 13:46:10 PDT 2007
Hi,

My 1.2.11 cluster abruptly stopped working, with the following error 
message present in the pg logs of the origin:

2007-09-13 20:29:06.358 UTC [1679750] cluster slony 10.1.2.133 ERROR:  
syntax error at or near "order" at character 283
2007-09-13 20:29:06.358 UTC [1679750] cluster slony 10.1.2.133 
STATEMENT:  declare LOG cursor for select     log_origin, log_xid, 
log_tableid,     log_actionseq, log_cmdtype,     
octet_length(log_cmddata),     case when octet_length(log_cmddata) <= 
8192         then log_cmddata         else null end from 
"_cluster".sl_log_1 where log_origin = 8143 and (  order by log_actionseq;


I had been changing some subscriptions around,  with no evidence of 
failure.  Apart from that, the cluster wasn't doing anything...

-- 
JP Fletcher
Database Administrator
Afilias Canada
voice: 416.646.3304 ext. 4123
fax: 416.646.3305
mobile: 416.561.4763
jpfletch at ca.afilias.info




More information about the Slony1-general mailing list