MySQL Forums
Forum List  »  NDB clusters

dropping tables with multiple sql nodes
Posted by: Rick Porter
Date: January 25, 2006 04:20PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
dropping tables with multiple sql nodes
1733
January 25, 2006 04:20PM


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.