[Bug] oap 10.2.0 +ES 7.17,Failed to load metrics for merging

[saber-wang]

After upgrading from version 9.3 to 10.2, the OAP has persistent abnormalities. We attempted to delete all endpoint-related indexes, but it was ineffective. Upon checking the endpoint_traffic index, it was found that the last_ping field does not exist.

2025-08-08 17:05:02,959 notprivacysafe.graphql.execution.SimpleDataFetcherExceptionHandler 46 [ForkJoinPool-1-worker-14] WARN  [] - Exception while fetching data (/result) : java.lang.NullPointerException: Cannot invoke "java.lang.Number.longValue()" because the return value of "org.apache.skywalking.oap.server.core.storage.type.Convert2Entity.get(String)" is null
java.lang.RuntimeException: java.lang.NullPointerException: Cannot invoke "java.lang.Number.longValue()" because the return value of "org.apache.skywalking.oap.server.core.storage.type.Convert2Entity.get(String)" is null
	at org.apache.skywalking.oap.query.graphql.AsyncQueryUtils.lambda$queryAsync$0(AsyncQueryUtils.java:44) ~[query-graphql-plugin-10.2.0.jar:10.2.0]
	at java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) [?:?]
	at java.util.concurrent.CompletableFuture$AsyncSupply.exec(Unknown Source) [?:?]
	at java.util.concurrent.ForkJoinTask.doExec(Unknown Source) [?:?]
	at java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(Unknown Source) [?:?]
	at java.util.concurrent.ForkJoinPool.scan(Unknown Source) [?:?]
	at java.util.concurrent.ForkJoinPool.runWorker(Unknown Source) [?:?]
	at java.util.concurrent.ForkJoinWorkerThread.run(Unknown Source) [?:?]
Caused by: java.lang.NullPointerException: Cannot invoke "java.lang.Number.longValue()" because the return value of "org.apache.skywalking.oap.server.core.storage.type.Convert2Entity.get(String)" is null
	at org.apache.skywalking.oap.server.core.analysis.manual.endpoint.EndpointTraffic$Builder.storage2Entity(EndpointTraffic.java:122) ~[server-core-10.2.0.jar:10.2.0]
	at org.apache.skywalking.oap.server.storage.plugin.elasticsearch.query.MetadataQueryEsDAO.lambda$findEndpoint$3(MetadataQueryEsDAO.java:258) ~[storage-elasticsearch-plugin-10.2.0.jar:10.2.0]
	at org.apache.skywalking.oap.server.library.client.elasticsearch.ElasticSearchScroller.scroll(ElasticSearchScroller.java:63) ~[library-client-10.2.0.jar:10.2.0]
	at org.apache.skywalking.oap.server.storage.plugin.elasticsearch.query.MetadataQueryEsDAO.findEndpoint(MetadataQueryEsDAO.java:267) ~[storage-elasticsearch-plugin-10.2.0.jar:10.2.0]
	at org.apache.skywalking.oap.server.core.query.MetadataQueryService.findEndpoint(MetadataQueryService.java:127) ~[server-core-10.2.0.jar:10.2.0]
	at org.apache.skywalking.oap.query.graphql.resolver.MetadataQueryV2.lambda$findEndpoint$6(MetadataQueryV2.java:91) ~[query-graphql-plugin-10.2.0.jar:10.2.0]
	at org.apache.skywalking.oap.query.graphql.AsyncQueryUtils.lambda$queryAsync$0(AsyncQueryUtils.java:41) ~[query-graphql-plugin-10.2.0.jar:10.2.0]
	... 7 more
2025-08-08 17:05:27,020 org.apache.skywalking.oap.server.core.analysis.worker.MetricsPersistentWorker 358 [pool-9-thread-1] ERROR [] - [10.2.0-a0a00b9] Failed to load metrics for merging
java.lang.NullPointerException: Cannot invoke "java.lang.Number.longValue()" because the return value of "org.apache.skywalking.oap.server.core.storage.type.Convert2Entity.get(String)" is null
	at org.apache.skywalking.oap.server.core.analysis.manual.endpoint.EndpointTraffic$Builder.storage2Entity(EndpointTraffic.java:122) ~[server-core-10.2.0.jar:10.2.0]
	at org.apache.skywalking.oap.server.core.analysis.manual.endpoint.EndpointTraffic$Builder.storage2Entity(EndpointTraffic.java:115) ~[server-core-10.2.0.jar:10.2.0]
	at org.apache.skywalking.oap.server.storage.plugin.elasticsearch.base.MetricsEsDAO.lambda$multiGet$9(MetricsEsDAO.java:92) ~[storage-elasticsearch-plugin-10.2.0.jar:10.2.0]
	at java.util.ArrayList.forEach(Unknown Source) ~[?:?]
	at org.apache.skywalking.oap.server.storage.plugin.elasticsearch.base.MetricsEsDAO.lambda$multiGet$10(MetricsEsDAO.java:91) ~[storage-elasticsearch-plugin-10.2.0.jar:10.2.0]
	at java.util.HashMap.forEach(Unknown Source) ~[?:?]
	at org.apache.skywalking.oap.server.storage.plugin.elasticsearch.base.MetricsEsDAO.multiGet(MetricsEsDAO.java:86) ~[storage-elasticsearch-plugin-10.2.0.jar:10.2.0]
	at org.apache.skywalking.oap.server.core.analysis.worker.MetricsPersistentWorker.loadFromStorage(MetricsPersistentWorker.java:353) ~[server-core-10.2.0.jar:10.2.0]
	at org.apache.skywalking.oap.server.core.analysis.worker.MetricsPersistentWorker.prepareFlushDataToStorage(MetricsPersistentWorker.java:255) ~[server-core-10.2.0.jar:10.2.0]
	at org.apache.skywalking.oap.server.core.analysis.worker.MetricsPersistentWorker.buildBatchRequests(MetricsPersistentWorker.java:229) ~[server-core-10.2.0.jar:10.2.0]
	at org.apache.skywalking.oap.server.core.storage.PersistenceTimer.lambda$extractDataAndSave$3(PersistenceTimer.java:131) ~[server-core-10.2.0.jar:10.2.0]
	at java.util.concurrent.CompletableFuture$AsyncRun.run(Unknown Source) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ~[?:?]
	at java.lang.Thread.run(Unknown Source) [?:?]

[wu-sheng]

We don't support upgrade. Please remove all indices and templates in your elastic.