<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5"></div></div>
I can reproduce this. Replication stops and I see things in the slon log like:<br>
<br>
<br>
2013-07-02 13:39:03 EDT INFO remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1<br>
2013-07-02 13:39:03 EDT ERROR remoteWorkerThread_1_1: error at end of COPY IN: ERROR: Slony-I: type lookup for column name failed in logApply()<br>
CONTEXT: COPY sl_log_1, line 1: "1 1068182 1 1 public stest I 0 {id,10,name,TEST}"<br>
<br></blockquote><div><br></div><div>I couldn't able to generate this error within my setup, beyond any doubt I may be doing something not right. </div><div>Its been a while am monitoring the logs after executing manual DDL on replication table, replication doesn't crashes. But st_lag_time & st_lag_num_events of sl_status keep increasing. </div>
<div><br></div><div><div>postgres=# select * from _newbuild.sl_status ;</div><div>-[ RECORD 1 ]-------------+---------------------------------</div><div>st_origin | 1</div><div>st_received | 2</div>
<div>st_last_event | 5000000041</div><div>st_last_event_ts | 2013-06-15 19:52:38.989129+05:30</div><div>st_last_received | 5000000021</div><div>st_last_received_ts | 2013-06-15 23:17:10.608269+05:30</div>
<div>st_last_received_event_ts | 2013-06-15 19:49:18.801361+05:30</div><div>st_lag_num_events | 20</div><div>st_lag_time | 05:00:22.268792</div></div><div> </div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">2. Interesting, neither DDL nor DML's captured by archives in this version.<br>
-bash-4.1$ fgrep -i alter *<br>
-bash-4.1$ fgrep -i insert *<br>
-bash-4.1$ </blockquote></div></blockquote><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im"></div>
The DML actually is captured (at least for me) but the .sql files in 2.2 use COPY not insert.<br>
<br>
Try<br>
fgrep -i stest *<br>
<br>
Mine looks like:<br>
<br>
COPY "_test"."sl_log_archive" ( log_origin, log_txid,log_tableid,log_<u></u>actionseq,log_tablenspname, log_tablerelname, log_cmdtype, log_cmdupdncols,log_cmdargs) FROM STDIN;<br>
1 1068182 1 1 public stest I 0 {id,10,name,TEST}<br>
<br></blockquote><div><br></div><div>Yeah, actually, I read in the BETA documentation about this section that now data storing/transferring in sl_log_1/sl_log_2 has changed its protocol to COPY instead of DML events. I have watched this changes while testing but due to dual versions testing I executed fgrep command with INSERT instead of COPY. Thanks for correcting.</div>
<div><br></div><div>Previous </div><div><div>==> slony1_log_2_00000000000000000005.sql <==</div><div>-- start of Slony-I data</div><div>------------------------------------------------------------------</div><div>insert into "public"."stest" ("id") values ('103');</div>
<div><br></div><div>Latest:</div><div>==> slony1_log_2_00000000000000000006.sql <==</div><div>------------------------------------------------------------------</div><div>COPY "_rep220"."sl_log_archive" ( log_origin, log_txid,log_tableid,log_actionseq,log_tablenspname, log_tablerelname, log_cmdtype, log_cmdupdnc</div>
<div>ols,log_cmdargs) FROM STDIN;</div><div>1 565688 1 2 public stest I 0 {id,1000}</div><div>\.</div></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
The DDL isn't captured though, this is an omission that we probably should fix.<br></blockquote><div> </div><div>Seems its not captured in earlier version too ? am i right. So it would be a feature request to include DDLs in .sql files. </div>
<div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Also, are there places in the documentation where we need to be more clear on the changes in 2.2, particularly saying that the log shipping format has changed ? ( I am open to ideas on where)<div class="HOEnZb"><div class="h5">
</div></div></blockquote><div><br></div><div>Just two areas:<br></div><div><a href="http://slony.info/documentation/2.1/logshipping.html">http://slony.info/documentation/2.1/logshipping.html</a></div><div><br></div><div><a href="http://slony.info/documentation/slon.html">http://slony.info/documentation/slon.html</a></div>
<div>-a option section.</div><div><br></div><div><br></div></div><div>--</div>Regards<div>Raghav</div><div>Blog: htt://<a href="http://raghavt.blogspot.com/" target="_blank">raghavt.blogspot.com/</a></div>