Did you by any chance drop and recreate the 2 tables during the upgrade? If so, they would now have different OIDs than before, causing sl_table.tab_reloid not to match. Just a thought.<br><br>/Gordon<br><br><div class="gmail_quote">
On Wed, Apr 14, 2010 at 4:12 PM, Tory M Blue <span dir="ltr"><<a href="mailto:tmblue@gmail.com">tmblue@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
So testing switchover after upgrading to 1.2 and 8.4.3 (well some are<br>
still on 8.3.4).<br>
<br>
And I'm getting this error when trying to switchover. I get this<br>
error when I tried to drop set 3 (thought about creating another set<br>
to see what the issue is).<br>
<br>
I have 9 tables, and 7 of the 9 seem to work, but slon seems to be<br>
missing, not replicating and in fact citing that the table with the id<br>
can't be found, yet I find it just fine.<br>
<br>
Even if there is no clean way to "fix" this, is there a hack to drop<br>
this set in order to try to recreate the set for testing? Odd that<br>
it's only these 2 "ancient" tables are causing grief.<br>
<br>
Ideas?<br>
<br>
Thanks<br>
Tory<br>
<br>
<br>
-bash-3.1$ ./switchover_to_node2.sh<br>
<stdin>:22: Moved Set 1<br>
<stdin>:29: Moved Set 2<br>
<stdin>:34: PGRES_FATAL_ERROR select "_cls".moveSet(3, 2); - ERROR:<br>
Slony-I: alterTableRestore(): Table with id 46 not found<br>
CONTEXT: SQL statement "SELECT "_cls".alterTableRestore( $1 )"<br>
PL/pgSQL function "moveset_int" line 33 at PERFORM<br>
SQL statement "SELECT "_cls".moveSet_int( $1 , $2 , $3 , 0)"<br>
PL/pgSQL function "moveset" line 61 at PERFORM<br>
Switchover complete<br>
<br>
Tables are in there and slon schema knows about them.<br>
<br>
46 | 24509700 | profile_fields | adm | 3 |<br>
profile_fields_pkey | t | profile_<br>
fields table<br>
47 | 24509710 | profile_values | adm | 3 |<br>
profile_values_pkey | t | profile_<br>
values table<br>
<br>
Yes the switchover failed and I just removed the lock on set 3, since<br>
it didn't actually move.<br>
_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>If I had more time, I could have written you a shorter letter. (Blaise Pascal)<br>