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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.