<div>Hi Again,</div><div><br></div><div>Sorry for my too many posts on beta :), its all my curiosity to test Beta.</div><div><br></div><div>Planned to upgrade 2.1.2 to 2.2.0Beta and steps followed as:</div><div><br></div><div>
1. Stop all running slon proces on all nodes.</div><div>2. Install new Version of Slony 2.2.0B binaries.</div><div>3. As per documentation, its said to optimize the cleanup_interval parameter to lower in seconds to trim data out of sl_log_1/sl_log_2 as these tables layout has changed in newer version. </div>
<div>I have set cleanup_interval="10 seconds"</div><div><br></div><div>4. Execute SLONIK upgradation script.</div><div>5. Start slony with new binaries on all nodes.</div><div><br></div><div>My primary.conf (slave.conf also similar just the node information changed)</div>
<div><br></div><div>-bash-4.1$ more primary.conf</div><div>## Master Slon Conf:</div><div>vac_frequency=3</div><div>cleanup_interval="10 seconds"</div><div>log_level=4</div><div>sync_interval=2000</div><div>sync_interval_timeout=10000</div>
<div>sync_group_maxsize=6</div><div>slon_config_cleanup_interval="5 seconds"</div><div>syslog=0</div><div>log_pid=false</div><div>log_timestamp=true</div><div>pid_file='/tmp/master_slon.pid'</div><div>syslog_ident=slon</div>
<div>cluster_name='newbuild'</div><div>conn_info='dbname=postgres host=localhost user=postgres port=5432 password=postgres'</div><div>desired_sync_time=60000</div><div>sql_on_connection="SET log_min_duration_statement TO '1000';"</div>
<div><br></div><div>One row still existed in sl_log_1 while upgrading, which was not cleaned up by SLON process:</div><div><br></div><div>postgres=# select * from _newbuild.sl_log_1 ;</div><div> log_origin | log_txid | log_tableid | log_actionseq | log_cmdtype | log_cmddata</div>
<div>------------+----------+-------------+---------------+-------------+---------------------</div><div> 1 | 592401 | 1 | 1 | I | ("id") values ('2')</div><div>
(1 row)</div><div><br></div><div>Till, step 4 all went fine, and slony schema has been upgraded to latest:</div><div><br></div><div>postgres=# select substr(version(),1,26) as "PostgreSQL-Version",_newbuild.slonyversion();</div>
<div> PostgreSQL-Version | slonyversion</div><div>----------------------------+--------------</div><div> PostgreSQL 9.2.3 on x86_64 | 2.2.0.b4</div><div>(1 row)</div><div><br></div><div>But, when I started slon process with new binaries, it has immediately crashed with below error:</div>
<div><br></div><div>2013-06-16 10:04:23 IST ERROR remoteWorkerThread_1_1: error executing COPY OUT: "COPY ( select log_origin, log_txid, NULL::integer, log_actionseq, NULL::text, NULL::text, log_cmdtype, NULL::integer, log_cmdargs from "_newbuild".sl_log_script where log_origin = 1 and log_txid >= "pg_catalog".txid_snapshot_xmax('592613:592613:') and log_txid < '592630' and "pg_catalog".txid_visible_in_snapshot(log_txid, '592630:592630:') union all select log_origin, log_txid, NULL::integer, log_actionseq, NULL::text, NULL::text, log_cmdtype, NULL::integer, log_cmdargs from "_newbuild".sl_log_script where log_origin = 1 and log_txid in (select * from "pg_catalog".txid_snapshot_xip('592613:592613:') except select * from "pg_catalog".txid_snapshot_xip('592630:592630:') ) union all select log_origin, log_txid, log_tableid, log_actionseq, log_tablenspname, log_tablerelname, log_cmdtype, log_cmdupdncols, log_cmdargs from "_newbuild".sl_log_1 where log_origin = 1 and log_tableid in (1) and log_txid >= '592613' and log_txid < '592630' and "pg_catalog".txid_visible_in_snapshot(log_txid, '592630:592630:') union all select log_origin, log_txid, log_tableid, log_actionseq, log_tablenspname, log_tablerelname, log_cmdtype, log_cmdupdncols, log_cmdargs from "_newbuild".sl_log_1 where log_origin = 1 and log_tableid in (1) and log_txid in (select * from "pg_catalog".txid_snapshot_xip('592613:592613:') except select * from "pg_catalog".txid_snapshot_xip('592630:592630:') ) order by log_actionseq) TO STDOUT" ERROR: column "log_cmdtype" does not exist</div>
<div>LINE 1: ...::integer, log_actionseq, NULL::text, NULL::text, log_cmdtyp...</div><div> ^</div><div>2013-06-16 10:04:23 IST DEBUG2 remoteWorkerThread_1: cleanup</div>
<div>2013-06-16 10:04:23 IST ERROR remoteWorkerThread_1: SYNC aborted</div><div><br></div><div>What might be the issue ? Please advice me.</div><div><br></div><div>Thanks in advance</div><div><br></div>-- <br><div>Regards</div>
<div>Raghav</div><div>Blog: htt://<a href="http://raghavt.blogspot.com/" target="_blank">raghavt.blogspot.com/</a></div>