http://www.slony.info/bugzilla/show_bug.cgi?id=306

           Summary: Problem with upgrade function from 2.1.3 to 2.2.0.b4
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: stored procedures
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: rnancy at afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


Hi,

I have the following errors in the slony logs while trying to upgrade from
2.1.3 to 2.2.0.b4.

2013-07-25 21:20:09 UTC ERROR  remoteWorkerThread_8322_8322: error executing
COPY OUT: "COPY ( select log_origin, log_txid, NULL::integer, lo
g_actionseq, NULL::text, NULL::text, log_cmdtype, NULL::integer, log_cmdargs
from "_oxrsme".sl_log_script where log_origin = 8322 and log_txi
d >= "pg_catalog".txid_snapshot_xmax('101187245:101187245:') and log_txid <
'101187291' and "pg_catalog".txid_visible_in_snapshot(log_txid, '
101187291:101187291:') union all select log_origin, log_txid, NULL::integer,
log_actionseq, NULL::text, NULL::text, log_cmdtype, NULL::intege
r, log_cmdargs from "_oxrsme".sl_log_script where log_origin = 8322 and
log_txid in (select * from "pg_catalog".txid_snapshot_xip('101187245:
101187245:') except select * from
"pg_catalog".txid_snapshot_xip('101187291:101187291:') ) order by
log_actionseq) TO STDOUT" ERROR:  column 
"log_cmdtype" does not exist
2013-07-25 21:20:09 UTC ERROR  remoteWorkerThread_8322: SYNC aborted
2013-07-25 21:20:19 UTC ERROR  remoteWorkerThread_8322: "select last_value from
"_yyyyyyy".sl_log_status" PGRES_FATAL_ERROR ERROR:  current transaction is
aborted, commands ignored until end of transaction block.


\d _yyyyyyy.sl_log_script
    Table "_yyyyyyy.sl_log_script"
    Column     |  Type   | Modifiers 
---------------+---------+-----------
 log_origin    | integer | 
 log_txid      | bigint  | 
 log_actionseq | bigint  | 
 log_query     | text    | 
 log_only_on   | text    | 
Indexes:
    "sl_log_script_idx1" btree (log_origin, log_txid, log_actionseq)

Thanks.

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.