SAP Knowledge Base Article - Preview

2962772 - Issue with HANA log backup

Symptom

Log backups for volume hdb00003.00003 are failing with error:

2020-06-24T06:17:36-04:00 P062328 172e5d53512 ERROR LOGBCKUP state of service: indexserver, abcd1234-db1:30003, volume: 3, BackupLogError
2020-06-24T06:17:36-04:00 P062328 172e5d53512 ERROR LOGBCKUP state of service: indexserver, abcd1234-db1:30003, volume: 3, Error during stream receive: doCopy: error occurred (bytes to transfer: 1073741824, actually transferred: 1065484288), rc=$sysrc$: $sysmsg$

--

[63239]{-1}[-1/-1] 2020-06-24 06:49:41.952210 e Backup BackupExe_LogBackup.cpp(00852) : Report backup failure: Error during stream receive: doCopy: error occurred (bytes to transfer: 1073741824, actually transferred: 1065484288), rc=$sysrc$: $sysmsg$
[37230]{-1}[-1/-1] 2020-06-24 06:50:18.172769 i Backup BackupExecutor.cpp(00549) : Starting serial FILE backup in 1 chunks. 1.: Backup of BackupSource: [CATALOG] Version 1 @ 0x00007fd96fdcf380 into BackupDestination: [FILE][/backup/log/E61/DB_E61/log_backup_0_0_0_0.1592995818168], max size 18446744073709551615, version 10 @ 0x00007fda6fe5d080, channel="<root>/.log_backup_0_0_0_0.1592995818168" ((open, mode= W, access= rw-r-----, flags= ASYNC|DIRECT|TRUNCATE|UNALIGNED_SIZE), factory= (root= "/backup/log/E61/DB_E61/" (access= rw-r-----, flags= AUTOCREATE_PATH|DISKFULL_ERROR, usage= CATALOG_BACKUP, fs= nfs, config= (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)), callback=0x00007fda6f1c2580
[63239]{-1}[-1/-1] 2020-06-24 06:50:43.930224 e Multistream SynchronousPoolCopyHandler.cpp(00597) : updateTransferStats premature channel close: 0x00007fd3c0000000, state=Received, to transfer=134217728, transferred=125960192, transferredChunks=0, channelClosed=1, signalTime=0, assignedChannel="<root>/logsegment_000_00000019.dat" ((open, mode= RW, access= rw-rw-r--, flags= ASYNC|DIRECT|MUST_EXIST|LOCK|LAZY_OPEN), factory= (root= "/hana/log/E61/mnt00001/hdb00003.00003/" (access= rw-rw-r--, flags= AUTOCREATE_DIRECTORY, usage= LOG, fs= xfs, config= (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))
[63239]{-1}[-1/-1] 2020-06-24 06:50:43.999337 e Multistream SynchronousPoolCopyHandler.cpp(00161) : doCopy caught exception: exception 1: no.2110006 (Basis/IO/Stream/impl/SynchronousPoolCopyHandler.cpp:130) TID: 63239
Error during stream receive: doCopy: error occurred (bytes to transfer: 1073741824, actually transferred: 1065484288), rc=$sysrc$: $sysmsg$
exception throw location:
1: 0x00007fde7229b22d in Stream::SynchronousPoolCopyHandler::doCopy()+0x5d9 at SynchronousPoolCopyHandler.cpp:130 (libhdbbasis.so)
2: 0x00007fde7c3011d8 in Backup::BackupSrc_Copier::copySynchronousMultiplex(ltt::refcounted_handle<Stream::Channel>&, ltt::refcounted_handle<Stream::Channel>&, unsigned long, unsigned long, ltt::smartptr_handle<Stream::ProgressCallback> const&, bool)+0x2f4 at BackupSrc_Copier.cpp:118 (libhdbbackup.so)
3: 0x00007fde7c2fdbdc in Backup::BackupSrc_Copier::copySynchronous(ltt::refcounted_handle<Stream::Channel>&, ltt::refcounted_handle<Stream::Channel>&, unsigned long, unsigned long, ltt::smartptr_handle<Stream::ProgressCallback> const&)+0x8 at BackupSrc_Copier.cpp:33 (libhdbbackup.so)
4: 0x00007fde7c30486f in Backup::BackupSrc_Logging::executeSave(ltt::shared_ptr<Backup::BackupDest_Destination, ltt::default_deleter>, Backup::Backup_Progress&)+0x2db at BackupSrc_Logging.cpp:105 (libhdbbackup.so)
5: 0x00007fde7c371244 in Backup::BackupExe_LogBackupImpl::LogBackupThread::doLogBackup(ltt::smart_ptr<Backup::BackupExe_LogBackupInformationCollection> const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::map<unsigned long, ltt::shared_ptr<ltt::map<unsigned int, unsigned long, ltt::less<unsigned int>, ltt::rb_tree_balancier>, ltt::default_deleter>, ltt::less<unsigned long>, ltt::rb_tree_balancier>&, ltt::smart_ptr<Backup::BackupMgr_Client>&, Backup::LogBackupStatistics&, unsigned long)+0x3c0 at shared_ptr.hpp:294 (libhdbbackup.so)
6: 0x00007fde7c372208 in Backup::BackupExe_LogBackupImpl::LogBackupThread::executeCollectionBackup(ltt::smart_ptr<Backup::BackupExe_LogBackupInformationCollection>&)+0x3c4 at BackupExe_LogBackup.cpp:566 (libhdbbackup.so)
7: 0x00007fde7c36e78e in Backup::BackupExe_LogBackupImpl::LogBackupThread::run(void*&)+0x5ca at BackupExe_LogBackup.cpp:795 (libhdbbackup.so)
8: 0x00007fde723444e8 in Execution::Thread::staticMainImp(Execution::Thread*)+0x534 at Thread.cpp:529 (libhdbbasis.so)
9: 0x00007fde72333798 in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x164 at ThreadInterposition.cpp:633 (libhdbbasis.so)
10: 0x00007fde71ac7dd5 in start_thread+0xc1 (libpthread.so.0)
11: 0x00007fde7033d02d in __clone+0x69 (libc.so.6)
exception type information:
0: public ltt::exception@0x7fde71a2e960


It looks not to be a storage issue, because on the same location, the backup is running fine for other services (nameserver, indexserver) etc. Also, tried changing the location of log backup (via parameter basepath_logbackup) but the issue persists for this volume.


Read more...

Environment

SAP HANA DB 2.0

Product

SAP HANA, platform edition 2.0

Keywords

KBA , 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.