After Upgrade Navigator Metadata Server is in Bad Health with "Error upgrading solr configuration or data. org.apache.solr.client.solrj.impl.HttpSolrServer$RemoteSolrException: undefined field: "id""
Last updated on JANUARY 02, 2018
Applies to:
Big Data Appliance Integrated Software - Version 4.5.0 and laterLinux x86-64
Symptoms
After upgrade from BDA V4.5/CDH 5.7.1 to CDH BDA V4.9/CDH 5.11.1 and then upgrade from BDA v4.9/CDH 5.11.1 to BDA V4.10/CDH 5.12.1 the Cloudera Management server is in bad health.
It fails with an error like:
org.apache.solr.client.solrj.impl.HttpSolrServer$RemoteSolrException: undefined field: "id"
at org.apache.solr.client.solrj.impl.HttpSolrServer.executeMethod(HttpSolrServer.java:552)
at org.apache.solr.client.solrj.impl.HttpSolrServer.request(HttpSolrServer.java:210)
at org.apache.solr.client.solrj.impl.HttpSolrServer.request(HttpSolrServer.java:206)
at org.apache.solr.client.solrj.request.QueryRequest.process(QueryRequest.java:91)
at org.apache.solr.client.solrj.SolrServer.query(SolrServer.java:301)
at com.cloudera.nav.server.NavServerUtil.getMaxIdInSolr(NavServerUtil.java:197)
at com.cloudera.nav.server.SolrSchemaUpgrade.updateMaxIdInDatabase(SolrSchemaUpgrade.java:1035)
at com.cloudera.nav.server.SolrSchemaUpgrade.upgradeSolr(SolrSchemaUpgrade.java:261)
at com.cloudera.nav.server.NavServer.run(NavServer.java:439)
at com.cloudera.nav.server.NavServer.main(NavServer.java:122)
Logging into MySQL and querying "select * from NAV_UPGRADE_ORDINAL;" from the Navigator Metadata database is found to return an incorrect ORDINAL value.
For example, on BDA V4.10/CM 5.12.1 logging into MySQL and querying "select * from NAV_UPGRADE_ORDINAL;" from the Navigator Metadata database should return ORDINAL value of 26 as below. If anything is else is returned this indicates a problem. Note that the values are specific to the CM release. Also note that the ORDINAL value is the current value and OLD_ORDINAL the prior version.
For BDA 4.10/CM 5.12.1 the correct ORDINAL value is 26 e.g.:
Other values indicate an error.
A list of ORDINAL values on other BDA/CM versions is:
| Navigator Version | Cloudera Manager Version | Ordinal Number |
| 2.6.0 | 5.7.0 | 11 |
| 2.6.1 | 5.7.1 | 11 |
| 2.6.2 | 5.7.2 | 11 |
| 2.6.3 | 5.7.3 | 12 |
| 2.6.4 | 5.7.4 | 12 |
| 2.7.0 | 5.8.0 | 13 |
| 2.7.1 | 5.8.1 | 13 |
| 2.7.2 | 5.8.2 | 14 |
| 2.7.3 | 5.8.3 | 14 |
| 2.8.0 | 5.9.0 | 14 |
| 2.8.1 | 5.9.1 | 14 |
| 2.8.2 | 5.9.2 | 14 |
| 2.8.3 | 5.9.3 | 14 |
| 2.9.0 | 5.10.0 | 14 |
| 2.9.1 | 5.10.1 | 20 |
| 2.9.2 | 5.10.2 | 20 |
| 2.10.0 | 5.11.0 | 21 |
| 2.10.1 | 5.11.1 | 22 |
| 2.10.2 | 5.11.2 | 22 |
| 2.11.0 | 5.12.0 | 26 |
| 2.11.1 | 5.12.1 | 26 |
| 2.12.0 | 5.13.0 | 26 |
Note: BDA V4.5 supports CM 5.7.0, BDA V4.6 supports CM 5.8.1, BDA V4.7 supports CM 5.9.0, BDA V4.8 supports 5.10.1, BDA V4.9 supports CM 5.11.1, BDA V4.10 supports CM 5.12.1, BDA V4.11 supports CM 5.13.1.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms