Thu Dec 7 19:23:42 PST 2006
- Previous message: [Slony1-general] problem and a solution for uninstalling node error: Table with id 36 not found
- Next message: [Slony1-general] Clusters of clusters?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Mark Stosberg <mark at summersault.com> writes: > I had an 1.1.5 install of slony to play with that I wanted to destroy > and replace with 1.2.1. (This was just a testing environment.). > > However, I was getting this error returned: > > "Table with id 36 not found" > > It would be a lot more user friendly if this message came with some hint > want to do next, and preferably also printed the table name. There are three places where that error can be returned. In all three cases, I wouldn't expect to be able to consult sl_table to figure out which table it was that wasn't found. The nature of the failure suggests that the table isn't findable. > Here is the workaround that I was able to use: > > 1. I connected to the database involved, and reviewed the tables known > to slon: > select tab_id, tab_relname from _saveapet.sl_table; > > Table "36" had been dropped while slon wasn't running. > > 2. I deleted the related row: > delete from _saveapet.sl_table where tab_id = 36; > > Now I could finish uninstalling the node. Luckily enough, the problem was evidently that you had dropped the table, so there was some idea left (in sl_table) as to what table it was. That's not something I'd consider I could "expect." > It would also seem that slonik could have just saved the the trouble > here and skipped the troublesome row, since the whole table was able to > get destroyed anyway... That is worthy of thought, although I'd not be inclined to blindly proceed towards that before thinking through whether there may be problems with that approach... -- select 'cbbrowne' || '@' || 'ca.afilias.info'; <http://dba2.int.libertyrms.com/> Christopher Browne (416) 673-4124 (land)
- Previous message: [Slony1-general] problem and a solution for uninstalling node error: Table with id 36 not found
- Next message: [Slony1-general] Clusters of clusters?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list