Tue Jan 25 14:59:02 PST 2011
- Previous message: [Slony1-hackers] automatic WAIT FOR proposal
- Next message: [Slony1-hackers] Bulk add of tables
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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"
- Previous message: [Slony1-hackers] automatic WAIT FOR proposal
- Next message: [Slony1-hackers] Bulk add of tables
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-hackers mailing list