Another suggestion before resetlocalschema. Try rolling restart all the nodes in the cluster and see if it fix the problem. After the restart all the nodes will use the same schema for the table.
On Sunday, April 5, 2020, David Ni <zn1...@126.com> wrote: > Hi Erick > Thank you very much for your friendly note. > ERROR [AntiEntropyStage:1] 2020-04-04 13:57:09,614 > RepairMessageVerbHandler.java:177 - Table with id 21a3fa90-74c7-11ea-978a- > b556b0c3a5ea was dropped during prepare phase of repair > cassandra@cqlsh:system_schema> select keyspace_name,table_name,id from > tables where keyspace_name='oapi_dev' and table_name='logtabl'; > keyspace_name | table_name | id > ---------------+------------+-------------------------------------- > oapi_dev | logtabl | 830028a0-7584-11ea-a277-bdf3d1289bdd > the table id does not match the id from system_schema.tables > how to fix it? > > > > > At 2020-04-04 14:44:16, "Erick Ramirez" <erick.rami...@datastax.com> > wrote: > > Is it possible someone else dropped then recreated the logtabl table? > Also, did you confirm that the missing table ID matches the ID of logtabl? > > On a friendly note, there are a number of users here like me who respond > to questions on the go. I personally find it difficult to read screenshots > on my phone so if it isn't too much trouble, it would be preferable if you > pasted the text here instead. Cheers! > > > > > > > > >
