Summary
When a table that is used in a Solr core is dropped, entries may remain in the solr_admin keyspace
Symptoms
When a CQL table is indexed by a solr core, records are created in the solr_admin.solr_resources table.
Cause
When a table was dropped, data was left behind. This was due to the following internal jira:
DSP-4068 - Dropping a solr table leaves data behind in solr_admin
Workaround
Prior to upgrading for this fix, the entries will need to be removed via cqlsh. For example to list the entries:
select core_name, resource_name from solr_admin.solr_resources ;
core_name | resource_name ----------+---------------- mycore | schema.xml mycore | solrconfig.xml
Solution
The problem is fixed in the following DSE releases:
DSE 4.5.6, 4.6.1, 4.7.0
Note: any data left behind before upgrade will need to be removed manually. The fix prevents the problem occurring, it will not clean up previous entries.