Matthew Vernon Matthew.Vernon at sruc.ac.uk
Thu Dec 20 04:36:24 PST 2012
Hi,

I made a stupid mistake (I DROPped a SCHEMA with some tables in that I
was replicating with slonik), and now slonik is woefully confused:

postgres at star:~$ slonik_unsubscribe_set agcensus 6 | slonik
<stdin>:4: PGRES_FATAL_ERROR select "_epic_cluster".unsubscribeSet(2,
6);  - ERROR:  Slony-I: alterTableDropTriggers(): Table with id 13 not found
CONTEXT:  SQL statement "SELECT
"_epic_cluster".alterTableDropTriggers(v_tab_row.tab_id)"
PL/pgSQL function "unsubscribeset" line 37 at PERFORM
<stdin>:7: Failed to unsubscribe node 6 from set 2

If I re-create the schema and tables, I still get this error.

How can I sort this out?

Thanks,

Matthew

--
Matthew Vernon
Quantitative Veterinary Epidemiologist
Epidemiology Research Unit, SRUC Inverness
http://www.sruc.ac.uk/mvernon

Please don't print this e-mail unless you really need to.
This e-mail message is confidential to the intended recipient at the email address to which it has been addressed. If the message has been received by you in error, it may not be disclosed to or used by anyone other than the intended addressee, nor may it be copied in any way. If it is not intended for you please inform us, immediately, then delete it from your system. If the content is not about the business of the organisation then the message is not from us nor is it sanctioned by us. Anything in this e-mail or its attachments which does not relate to SRUC's or SAC Commercial Limited's official business is neither given nor endorsed by SRUC or SAC Commercial Limited.
SRUC
A Charitable company limited by guarantee, Scottish Charity Number: SC003712.
Registered in Scotland, Company Number: SC103046 - Registered Office: Peter Wilson Building, King’s Buildings, West Mains Road, Edinburgh EH9 3JG
SAC Commercial Limited, an SRUC company
Registered in Scotland, Company Number: SC148684 - Registered Office: Peter Wilson Building, King’s Buildings, West Mains Road, Edinburgh EH9 3JG


More information about the Slony1-general mailing list