On Tue, Nov 10, 2015 at 3:20 PM, Sebastian Estevez < sebastian.este...@datastax.com> wrote:
> #1 The cause of this problem is a CREATE TABLE statement collision. Do not > generate tables > dynamically from multiple clients, even with IF NOT EXISTS. First thing you > need to do is > fix your code so that this does not happen. Just create your tables manually > from cqlsh allowing > time for the schema to settle. > > #2 Here's the fix: > > 1) Change your code to not automatically re-create tables (even with IF NOT > EXISTS). > > 2) Run a rolling restart to ensure schema matches across nodes. Run nodetool > describecluster > > around your cluster. Check that there is only one schema version. > > Thanks, that seems to have resolved the schema version inconsistency (though I'm still getting the original error). > ON EACH NODE: > > 3) Check your filesystem and see if you have two directories for the table in > > question in the data directory. > > Stupid question, but how do I find the problem table? The error message complains about a keyspace (by uuid); I haven't seen errors relating to a specific table. I've poked around in the data directory, but I'm not sure what I'm looking for.
