Christopher Browne cbbrowne at ca.afilias.info
Tue Jan 25 14:59:02 PST 2011
http://www.slony.info/bugzilla/show_bug.cgi?id=181

I have set up a branch where I'm testing this, which has a regresison
test.
   https://github.com/cbbrowne/slony1-engine/tree/bulk-adding

I'm getting a segfault problem, with the following slonik script:

postgres at cbbrowne [05:53:26] [~/slony1-engine.github/tests] [bulk-adding *]
-> % cat /tmp/slony-regress.rZSbvU/slonik.script
include </tmp/slony-regress.rZSbvU/slonik.preamble>;
#init cluster (id=1, comment = 'Regress test node');
echo 'update functions on node 1 after initializing it';
update functions (id=1);
#create set (id=1, origin=1, comment='All test1 tables');
set add table (set id = 1, tables='public.*');

Errors reported thus:

-> % slonik /tmp/slony-regress.rZSbvU/slonik.script
/tmp/slony-regress.rZSbvU/slonik.script:3: update functions on node 1 after initializing it                                                                                         /tmp/slony-regress.rZSbvU/slonik.script:4: Possible unsupported PostgreSQL version (90100) 9.1, defaulting to 8.3 support
/tmp/slony-regress.rZSbvU/slonik.script:4: WARNING:  This node is running PostgreSQL 8.3 - cannot apply TRUNCATE triggers
CONTEXT:  SQL statement "SELECT "_slony_regress1".add_truncate_triggers()"
PL/pgSQL function "upgradeschema" line 12 at PERFORM
/tmp/slony-regress.rZSbvU/slonik.script:7: PGRES_FATAL_ERROR select max(tab_id) FROM "_slony_regress1".sl_table - ERROR:  schema "_slony_regress1" does not exist
LINE 1: select max(tab_id) FROM "_slony_regress1".sl_table
                                ^
[2]    29188 segmentation fault  slonik /tmp/slony-regress.rZSbvU/slonik.script

It's blowing up in slonik_get_next_tab_id(), somewhere near the end of
the function.

Something's suspicious about the way queries are getting free'ed.
-- 
let name="cbbrowne" and tld="afilias.info" in String.concat "@" [name;tld];;
Christopher Browne
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"


More information about the Slony1-hackers mailing list