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.