Bug 283 - explain_interval conf option is broken in 2.2
Summary: explain_interval conf option is broken in 2.2
Status: NEW
Alias: None
Product: Slony-I
Classification: Unclassified
Component: slon (show other bugs)
Version: devel
Hardware: PC Linux
: low enhancement
Assignee: Slony Bugs List
URL:
Depends on:
Blocks:
 
Reported: 2013-01-11 08:47 UTC by Steve Singer
Modified: 2015-01-23 15:03 UTC (History)
1 user (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Steve Singer 2013-01-11 08:47:30 UTC
The explain_interval configuration option will make slon do an 'explain' for longer running log selection queries.  This stopped working in 2.2

If set this to be one slon tries to do queries like the following:

"explain COPY ( select log_origin, log_txid, NULL::integer, log_actionseq, NULL::text, NULL::text, log_cmdtype, NULL::integer, log_cmdargs from "_disorder_replica".sl_log_script where log_origin = 5 and log_txid >= "pg_catalog".txid_snapshot_xmax('1:1:') and log_txid < '13352185' and "pg_catalog".txid_visible_in_snapshot(log_txid, '13352183:13352185:13352183') union all select log_origin, log_txid, NULL::integer, log_actionseq, NULL::text, NULL::text, log_cmdtype, NULL::integer, log_cmdargs from "_disorder_replica".sl_log_script where log_origin = 5 and log_txid in (select * from "pg_catalog".txid_snapshot_xip('1:1:') except select * from "pg_catalog".txid_snapshot_xip('13352183:13352185:13352183') ) order by log_actionseq) TO STDOUT" 

syntax error at or near "COPY"

Apparently you can't do an explain on a COPY.
Comment 1 Brian 2015-01-23 15:03:12 UTC
I've run across this too. Upgraded from 2.1 to 2.2 on a master (9.3) to slave (8.4), had explain_interval set to 60 and it caused replication to stall.