dropping tables with multiple sql nodes
I have a configuration with 2 SQL nodes (and 2 NDB nodes, though I don't think that is relevant).
The following results in error 241 (invalid schema object version):
- create a table on SQL node A
- access the table on node B (e.g., 'select * from MyTable')
- drop the table on node A
- re-create the table on node A
- try to access the table from node B => Results in error 241
If I were to kill node B and restart it after the table was accessed the first time, there would be no error. It is as though node B reads the schema info when it is first needed and then caches it and gets sick if the schema for the table in NDB ever changes.
Is this a known bug? I could not find anything on it.
- rick
Subject
Views
Written By
Posted
dropping tables with multiple sql nodes
1733
January 25, 2006 04:20PM
1260
January 26, 2006 08:08AM
1602
January 26, 2006 03:50PM
1690
June 06, 2006 02:09PM
1266
June 06, 2006 11:40PM
1166
June 13, 2006 04:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.