Thu Mar 5 22:42:24 PST 2009
- Previous message: [Slony1-general] Cascaded Slaves & sl_log bloat prevention?
- Next message: [Slony1-general] repair config failing
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Any idea what is going on here? $ slonik << EOM > cluster name = sl; > node 1 admin conninfo = 'dbname=lpmain_staging_new user=slony'; > repair config (set id=1, event node=1, execute only on=1); > EOM <stdin>:3: PGRES_FATAL_ERROR select "_sl".updateReloid(1, 1); - ERROR: duplicate key value violates unique constraint "sl_table_tab_reloid_key" CONTEXT: SQL statement "update "_sl".sl_table set tab_reloid = PGC.oid from pg_catalog.pg_class PGC, pg_catalog.pg_namespace PGN where "_sl".slon_quote_brute("_sl".sl_table.tab_relname) = "_sl".slon_quote_brute(PGC.relname) and PGC.relnamespace = PGN.oid and "_sl".slon_quote_brute(PGN.nspname) = "_sl".slon_quote_brute("_sl".sl_table.tab_nspname)" PL/pgSQL function "updatereloid" line 39 at SQL statement The database is a freshly restored dump of the master node. Slony is 1.2.13 -- Stuart Bishop <stuart at stuartbishop.net> http://www.stuartbishop.net/
- Previous message: [Slony1-general] Cascaded Slaves & sl_log bloat prevention?
- Next message: [Slony1-general] repair config failing
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list