Symptom
-
A HANA service is suddenly terminated and restarted without a crashdump generated nor a visible reason for it in the HANA trace files.
-
HANA Trace files from the SYSTEMDB and Tenant DB show the following events :
-
system_availability_<>.trc shows a service stoppage on the indexserver :
-
0;2024-04-25 13:41:27.926461;2e10448b-4a01-134e-9fd1-e8e49540c803;1;ping;;;yes;ok;yes;ok;;;Hostname;;;;;worker;worker;1;1;;;;;;;
0;2024-04-25 13:56:27.927534;77631387-b9a9-914b-a60b-2664f72da5c8;1;ping;;;yes;ok;yes;ok;;;Hostname;;;;;worker;worker;1;1;;;;;;;
0;2024-04-25 13:57:15.618967;f635ad62-7555-1b44-adb5-eed5170bcfea;1;service_stopping;watchdog,defunct;;unknown;warning;partial;warning;stopping;;Hostname;30003;indexserver;4;SID;worker;worker;1;1;;;;;;;
0;2024-04-25 14:11:27.928583;3a5e7d44-7ff5-fe43-8d69-3a9c2d5e2d02;1;ping;;;unknown;warning;partial;warning;;;Hostname;;;;;worker;worker;1;1;;;;;;;
0;2024-04-25 14:26:27.929654;503135ed-0a09-2740-8e2e-3792650d17bc;1;ping;;;unknown;warning;partial;warning;;;Hostname;;;;;worker;worker;1;1;;;;;;;
0;2024-04-25 14:31:13.501137;4bbaa6ac-0508-8141-a12a-da1f469e7576;1;service_starting;;;unknown;ok;partial;ok;starting;;Hostname;30003;indexserver;4;SID;worker;worker;1;1;;;;;;;
0;2024-04-25 14:34:04.562732;8e94a9c3-a105-c346-bba1-afb57b739669;1;service_started;;;yes;ok;yes;ok;yes;;Hostname;30003;indexserver;4;SID;worker;worker;1;1;;;;;;;
0;2024-04-25 14:41:27.930751;fb2bbf5c-a98a-da40-a77b-7be10505fe97;1;ping;;;yes;ok;yes;ok;;;Hostname;;;;;worker;worker;1;1;;;;;;;
0;2024-04-25 14:56:27.931809;13d236ac-9c93-c04a-8d2a-11f7a0fa8af2;1;ping;;;yes;ok;yes;ok;;;Hostname;;;;;worker;worker;1;1;;;;;;;
-
-
nameserver
-
[1745044]{-1}[-1/-1] 2024-04-25 13:57:15.618898 i Service_Shutdown TREXNameServer.cpp(05273) : setStopping(indexserver@Hostname:30003)
-
-
indexserver restart event
-
[1768995]{-1}[-1/-1] 2024-04-25 14:31:11.871584 i Basis TraceStream.cpp(00526) : ==== Starting hdbindexserver, version 2.00.074.00.1698716871
-
-
var/log/messages
-
Apr 25 13:57:12 Hostname systemd[1]: Started Process Core Dump (PID 1746857/UID 0).
Apr 25 13:57:12 Hostname systemd-coredump[1746858]: Resource limits disable core dumping for process 3410 (hdbindexserver).
Apr 25 13:57:12 Hostname systemd-coredump[1746858]: Process 3410 (hdbindexserver) of user 41633 dumped core.
-
-
No performance degradation at this time either checking "HANA_Global_CriticalTimeFrames_2.00.060+.txt"
-
Read more...
Environment
SAP HANA Platform Edition 2.0
Product
Keywords
HANA, DB, HANA Database, HANA service, indexserver, OS, Operating system, var/log/messages, systemd-coredump, process, termination , KBA , HAN-DB , SAP HANA Database , BC-OP-LNX , Linux , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview