Solved

SAP hana failed to restore out place

  • 27 March 2021
  • 2 replies
  • 2048 views

Badge

Hi community.

I have the follow problem to try to restore a sap hana database out place.

 

SAP HANA Error [hdbsql execution Failed.
448: recovery could not be completed: [3020067] Buffer does not provide complete page.; $EndPos$=0x00007f60c9932000; $ReadPos$=0x00007f60c9913000; $PageSize$=262144, [110507] Backint exited with exit code 1 instead of 0. console output: No additional Information was received SQLSTATE: HY000].

 

219989 35b55 03/27 18:25:10 41123561 ::restoreFile() - READ ERROR encountered by the Data Mover.
219989 35b55 03/27 18:25:10 41123561 ::restoreFile() -
#ERROR /usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_2_1
219989 35b55 03/27 18:25:10 41123561 ::performRestore() - Failed to Restore the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_2_1 retCode=2 errno=0
219989 35b55 03/27 18:25:10 41123561 ::performRestore() -
#ERROR /usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_2_1
219989 35b55 03/27 18:25:10 41123561 ::performRestore() - Restore Failed; 0 File(s) Restored; total transferred bytes=0
219989 35b55 03/27 18:25:10 41123561 ::performRestore() - SAP HANA GENERIC_ERROR: [Partially restored the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_2_1]
219989 35b55 03/27 18:25:10 41123561 Sending FAILED complete message to JM, 41123561
219989 35b55 03/27 18:25:10 41123561 ::performRestore() - Success in sending FAILURE to server
219989 35b55 03/27 18:25:10 41123561 CVOraBackint::sendRestoreJobStatus() -  job status is FAIL
219907 35b03 03/27 18:25:11 41123561 ::restoreFile() - Write to the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_4 failed; errno=32 retCode=-1
219906 35b02 03/27 18:25:11 41123561 ::restoreFile() - Write to the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_3 failed; errno=32 retCode=-1
219904 35b00 03/27 18:25:11 41123561 ::restoreFile() - Write to the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_2 failed; errno=32 retCode=-1
219903 35aff 03/27 18:25:11 41123561 ::restoreFile() - Write to the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_1 failed; errno=32 retCode=-1
219907 35b03 03/27 18:25:11 41123561 ::performRestore() - backint: ERROR: System error: /usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_4, rc=32: Broken pipe
219906 35b02 03/27 18:25:11 41123561 ::performRestore() - backint: ERROR: System error: /usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_3, rc=32: Broken pipe
219904 35b00 03/27 18:25:11 41123561 ::performRestore() - backint: ERROR: System error: /usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_2, rc=32: Broken pipe
219903 35aff 03/27 18:25:11 41123561 ::performRestore() - backint: ERROR: System error: /usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_1, rc=32: Broken pipe
219907 35b03 03/27 18:25:11 41123561 ::performRestore() - Failed to Restore the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_4 retCode=2 errno=32
219903 35aff 03/27 18:25:11 41123561 ::performRestore() - Failed to Restore the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_1 retCode=2 errno=32
219906 35b02 03/27 18:25:11 41123561 ::performRestore() - Failed to Restore the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_3 retCode=2 errno=32
219907 35b03 03/27 18:25:11 41123561 ::performRestore() - Restore Failed; 0 File(s) Restored; total transferred bytes=0
219904 35b00 03/27 18:25:11 41123561 ::performRestore() - Failed to Restore the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_2 retCode=2 errno=32
219903 35aff 03/27 18:25:11 41123561 ::performRestore() - Restore Failed; 0 File(s) Restored; total transferred bytes=0
219906 35b02 03/27 18:25:11 41123561 ::performRestore() - Restore Failed; 0 File(s) Restored; total transferred bytes=0
219904 35b00 03/27 18:25:11 41123561 ::performRestore() - Restore Failed; 0 File(s) Restored; total transferred bytes=0
219882 35aea 03/27 18:25:11 41123561 ::rstParent() -
#ERROR /usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_2
219882 35aea 03/27 18:25:11 41123561 ::rstParent() - Child=<219904> Stream Failed; numFiles=0 numFailed=1 totSize=0
219882 35aea 03/27 18:25:11 41123561 ::rstParent() - One or more Child Proccess Failed - Ready to exit.
219882 35aea 03/27 18:25:11 41123561 ::rstParent() - Calling SapCompletePhase
219882 35aea 03/27 18:25:11 41123561 ::dumpStats() - restore Failed; numFiles=0 numFailed=1 totSize=0
219882 35aea 03/27 18:25:11 41123561 CVOraBackint::sendRestoreJobStatus() -  job status is FAIL
219904 35b00 03/27 18:25:11 41123561 ::performRestore() - SAP HANA GENERIC_ERROR: [Failed to write the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_2]
219904 35b00 03/27 18:25:11 41123561 ::sendMsgToBkpParent() - Parent Proccess=<219882> is not Running.
219904 35b00 03/27 18:25:11 41123561 ::sendMsgToBkpParent() - Parent Proccess=<219882> is not Running.
219904 35b00 03/27 18:25:11 41123561 ::rstChild() - backintChild=<219904> Exiting; STREAM_FAILED
219906 35b02 03/27 18:25:11 41123561 ::performRestore() - SAP HANA GENERIC_ERROR: [Failed to write the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_3]
219906 35b02 03/27 18:25:11 41123561 ::sendMsgToBkpParent() - Parent Proccess=<219882> is not Running.
219906 35b02 03/27 18:25:11 41123561 ::sendMsgToBkpParent() - Parent Proccess=<219882> is not Running.
219906 35b02 03/27 18:25:11 41123561 ::rstChild() - backintChild=<219906> Exiting; STREAM_FAILED
219903 35aff 03/27 18:25:11 41123561 ::performRestore() - SAP HANA GENERIC_ERROR: [Failed to write the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_1]
219903 35aff 03/27 18:25:11 41123561 ::sendMsgToBkpParent() - Parent Proccess=<219882> is not Running.
219907 35b03 03/27 18:25:11 41123561 ::performRestore() - SAP HANA GENERIC_ERROR: [Failed to write the file=/usr/sap/H4P/SYS/global/hdb/backint/DB_H4P/41088714_COMPLETE_DATA_BACKUP_databackup_3_4]
219903 35aff 03/27 18:25:11 41123561 ::sendMsgToBkpParent() - Parent Proccess=<219882> is not Running.
219903 35aff 03/27 18:25:11 41123561 ::rstChild() - backintChild=<219903> Exiting; STREAM_FAILED
219907 35b03 03/27 18:25:11 41123561 ::sendMsgToBkpParent() - Parent Proccess=<219882> is not Running.
219907 35b03 03/27 18:25:11 41123561 ::sendMsgToBkpParent() - Parent Proccess=<219882> is not Running.
219907 35b03 03/27 18:25:11 41123561 ::rstChild() - backintChild=<219907> Exiting; STREAM_FAILED

icon

Best answer by Jordan 30 March 2021, 01:10

View original

2 replies

Userlevel 7
Badge +23

@bemaldonadod did you open a support case for this issue?  I searched for your e-mail and am not seeing one.

Thanks!

Userlevel 5
Badge +11

Hi @bemaldonadod ,

 

Are you able to please log out a Support incident for this one? Looks like there may be some read errors from media causing issues with the restore however we will require a full log bundle to review this properly.

 

Thank you

Reply