Skip to Content
2
Former Member
Jun 11, 2014 at 09:33 AM

[1000002] Allocation failed error on backup recovery

1563 Views

Dear experts

We are facing a critical error when importing a HANA data backup.

We had a HANA box with 256GB RAM from which we made a full data backup.

Now we are trying to import that data backup into a new HANA box using the HANA Studio and following the steps. New server has similar configuration but less RAM (64GB). According the HANA experts it would be possible to import that backup into that server.

The think is that almost all services are correctly imported but the indexserver which is giving an error

RECOVERY RECOVER DATA finished with error: [448] recovery could not be completed, volume 2, reached log position 0,

[1000002] Allocation failed ; $size$=16777216; $name$=Page; $type$=pool; $inuse_count$=2693; $allocated_size$=45181042688

We have been digging into entire SDN and SAP Noted but have not been able to find anything.

We have also been trying with different values of parameter data_backup_buffer_size in global.ini but also with no success.

Does somebody know how to deal with that allocation error in order to complete the full recover?

Thanks a lot.

Below detailed logs (it get's hang usually at 45% of completion of indexserver.ini)

2014-06-10T19:31:19+00:00 P017337 1468742af9a INFO RECOVERY state of service: indexserver, hdbqatar:30003, volume: 2, RecoveryExecuteDataRecoveryInProgress

2014-06-10T19:31:19+00:00 P017337 1468742af9a INFO RECOVERY using file: /exports/Old_backup/20140501_HANA001/COMPLETE_DATA_BACKUP_databackup_2_1

2014-06-10T19:31:19+00:00 P017337 1468742af9a INFO RECOVERY progress of service: indexserver, hdbqatar:30003, volume: 2, 0% 0/260888956928

2014-06-10T19:31:26+00:00 P017337 1468742af9a INFO RECOVERY progress of service: statisticsserver, hdbqatar:30005, volume: 3, 100% 2404741120/2404741120

2014-06-10T19:31:26+00:00 P017337 1468742af9a INFO RECOVERY state of service: statisticsserver, hdbqatar:30005, volume: 3, RecoveryExecuteDataRecoveryFinished

2014-06-10T19:31:26+00:00 P017337 1468742af9a INFO RECOVERY state of service: statisticsserver, hdbqatar:30005, volume: 3, RecoveryLogInitializationStarted

2014-06-10T19:31:27+00:00 P017337 1468742af9a INFO RECOVERY state of service: statisticsserver, hdbqatar:30005, volume: 3, RecoveryLogInitializationFinished

2014-06-10T19:33:22+00:00 P017337 1468742af9a INFO RECOVERY progress of service: indexserver, hdbqatar:30003, volume: 2, 5% 13421772800/260888956928

2014-06-10T19:35:09+00:00 P017337 1468742af9a INFO RECOVERY progress of service: indexserver, hdbqatar:30003, volume: 2, 10% 26306674688/260888956928

2014-06-10T19:36:41+00:00 P017337 1468742af9a INFO RECOVERY progress of service: indexserver, hdbqatar:30003, volume: 2, 15% 39191576576/260888956928

2014-06-10T19:38:18+00:00 P017337 1468742af9a INFO RECOVERY progress of service: indexserver, hdbqatar:30003, volume: 2, 20% 52613349376/260888956928

2014-06-10T19:39:43+00:00 P017337 1468742af9a INFO RECOVERY progress of service: indexserver, hdbqatar:30003, volume: 2, 25% 65498251264/260888956928

2014-06-10T19:41:11+00:00 P017337 1468742af9a INFO RECOVERY progress of service: indexserver, hdbqatar:30003, volume: 2, 30% 78383153152/260888956928

2014-06-10T19:42:44+00:00 P017337 1468742af9a INFO RECOVERY progress of service: indexserver, hdbqatar:30003, volume: 2, 35% 91804925952/260888956928

2014-06-10T19:44:11+00:00 P017337 1468742af9a INFO RECOVERY progress of service: indexserver, hdbqatar:30003, volume: 2, 40% 104689827840/260888956928

2014-06-10T19:45:57+00:00 P017337 1468742af9a INFO RECOVERY progress of service: indexserver, hdbqatar:30003, volume: 2, 45% 117574729728/260888956928

2014-06-10T19:50:58+00:00 P017337 1468742af9a ERROR RECOVERY RECOVER DATA finished with error: [448] recovery could not be completed, volume 2, reached log position 0, [1000002] Allocation failed ; $size$=16777216; $name$=Page; $type$=pool; $inuse_count$=2693; $allocated_size$=45181042688