Symptom
The HANA Tenant Database keeps failing during restarts of the indexserver, with the same error messages repeated over and over in the trace files prior to the service shutdown :
[210922]{-1}[-1/-1] 2023-05-19 17:56:47.045437 i Basis TraceStream.cpp(00718) : ==== Starting hdbindexserver, version 2.00.055.00.1615413201 (fa/hana2sp05), build linuxx86_64 05fd01c3749db22de9f4eea75e45ed541c4b9a22 2021-03-10 22:59:24 ld4554 gcc (SAP release 20200227, based on SUSE gcc9-9.2.1+r275327-1.3.7) 9.2.1 20190903 [gcc-9-branch revision 275330]
[210922]{-1}[-1/-1] 2023-05-19 17:56:47.045477 i Memory mmEnv.cpp(00186) : Per core memory pools
...
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.305130 i FileIO FileStatistics.cpp(00386) : FileFactoryConfiguration::initial(path="/usr/sap/SID/SYS/global/hdb/backint/DB_SID/"[DATA_BACKUP], async_write_submit_active=on,async_write_submit_blocks=all,async_read_submit=on,num_submit_queues=1,num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.305295 i FileIO FileStatistics.cpp(01163) : SubmitQueueConfiguration::initial(path="/usr/sap/SID/SYS/global/hdb/backint/DB_SID/"[DATA_BACKUP], num_submit_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.306102 i FileIO FileStatistics.cpp(01372) : CompletionQueueConfiguration::initial(path="/usr/sap/SID/SYS/global/hdb/backint/DB_SID/"[DATA_BACKUP], num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64)
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.307048 i FileIO FileStatistics.cpp(00386) : FileFactoryConfiguration::initial(path="/usr/sap/SID/SYS/global/hdb/backint/DB_SID/"[LOG_BACKUP], async_write_submit_active=on,async_write_submit_blocks=all,async_read_submit=on,num_submit_queues=1,num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.307194 i FileIO FileStatistics.cpp(01163) : SubmitQueueConfiguration::initial(path="/usr/sap/SID/SYS/global/hdb/backint/DB_SID/"[LOG_BACKUP], num_submit_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.307964 i FileIO FileStatistics.cpp(01372) : CompletionQueueConfiguration::initial(path="/usr/sap/SID/SYS/global/hdb/backint/DB_SID/"[LOG_BACKUP], num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64)
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.308909 i FileIO FileStatistics.cpp(00386) : FileFactoryConfiguration::initial(path="/usr/sap/SID/SYS/global/hdb/backint/DB_SID/"[CATALOG_BACKUP], async_write_submit_active=on,async_write_submit_blocks=all,async_read_submit=on,num_submit_queues=1,num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.309056 i FileIO FileStatistics.cpp(01163) : SubmitQueueConfiguration::initial(path="/usr/sap/SID/SYS/global/hdb/backint/DB_SID/"[CATALOG_BACKUP], num_submit_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.309871 i FileIO FileStatistics.cpp(01372) : CompletionQueueConfiguration::initial(path="/usr/sap/SID/SYS/global/hdb/backint/DB_SID/"[CATALOG_BACKUP], num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64)
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.311007 i FileIO FileStatistics.cpp(00386) : FileFactoryConfiguration::initial(path="/usr/sap/SID/HDB00/backup/log/DB_SID/"[CATALOG_BACKUP], async_write_submit_active=on,async_write_submit_blocks=all,async_read_submit=on,num_submit_queues=1,num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.311143 i FileIO FileStatistics.cpp(01163) : SubmitQueueConfiguration::initial(path="/usr/sap/SID/HDB00/backup/log/DB_SID/"[CATALOG_BACKUP], num_submit_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64)
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.311958 i FileIO FileStatistics.cpp(01372) : CompletionQueueConfiguration::initial(path="/usr/sap/SID/HDB00/backup/log/DB_SID/"[CATALOG_BACKUP], num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64)
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.365856 w Backup BackupMgr_Manager.cpp(01515) : loadSnapshotInfo: destination file /hana/data/SID/mnt00001/hdb00003.00005/fallback_databackup_0_1 doesn't exist
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.365908 w Backup BackupMgr_Manager.cpp(01515) : loadSnapshotInfo: destination file /hana/data/SID/mnt00001/hdb00003.00005/snapshot_databackup_0_1 doesn't exist
[210922]{-1}[-1/-1] 2023-05-19 17:56:58.448884 i Service_Shutdown TrexService.cpp(00593) : Preparing for shutting service down
[211041]{-1}[-1/-1] 2023-05-19 17:56:58.451185 i Service_Shutdown TREXIndexServer.cpp(02604) : Stopping data backup
[211041]{-1}[-1/-1] 2023-05-19 17:56:58.451195 i Service_Shutdown TREXIndexServer.cpp(02609) : preparing auditing shutdown
Read more...
Environment
SAP HANA, Platform Edition 2.0
Product
SAP HANA, platform edition 2.0
Keywords
KBA , HAN-DB-PER , SAP HANA Database Persistence , HAN-DB-BAC , SAP HANA Backup & Recovery , 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