The log volume is full, and the database does not respond or start anymore. you can fix this issue by using SAP Note 1679938
SAP Note: – 1679938
You notice that log volume is full, and the database doesn’t accept any new request. Trace of the service with the full log volume contains Disk Full Event messages: –
LoggerImpl.cpp(00095) : Logger notified of new DiskFull: DiskFullEvent[id= XXX,
path=/hana/log/<SID>/mntXXXXX/hdbXXXXX/, state= NEW]
Other Terms HANA, in-Memory, logvolume, full, no requests, DISKFULL event.
Reason and Prerequisites
The log volume is full, and the database does not respond or start anymore.
Solution
1. Stop the database: HDB stop
2. Wait that the database on all hosts is stopped completely.
3. Change directory into folder mnt00001 of the log volume (Default:/hana/log/<SID>/), e.g.:
cd /hana/log/<SID>/mnt00001
4. You have to move one of the log volumes temporarily to another volume where enough space is available. You should free at least 2 to 5 GB of space to ensure that the database has enough space to start. To find out the space consumption of each volume execute:du -sh *
5. Copy logsegment file which consumes at least 2 to 5 GB of space (e.g. hdb00003) to a volume with sufficient free space, e.g. to the data volume (Default:/hana/data/<SID>), e.g.:
6. Create tamp directory.mkdir /backup/logqas/devmntlog
7. Copy logsegment file to devmntlog folder/hana/logqas/mnt00001/hdb00003> cp logsegment_000_00000151.dat /backup/logqas/devmntlog
8. Delete file from original location.rm -f /hana/logqas/mnt00001/hdb00003/logsegment_000_00000151.dat
9. Create a symbolic link to the new folder in the old location:/hana/logqas/mnt00001/hdb00003> ln -s /backup/logqas/devmntlog/logsegment_000_00000151.dat
/hana/logqas/mnt00001/hdb00003/logsegment_000_00000151.dat
10. Start the database:HDB start
11. Wait until log backups are performed.
12. Use the following SQL-Statement to clean up the log volume: ALTER SYSTEM RECLAIM LOG;
13. Stop the database again:
HDB stop
14. Wait that the database on all hosts is stopped completely.
15. Remove the symbolic link:rm -f /hana/logqas/mnt00001/hdb00003/logsegment_000_00000151.dat
16. Move the log file back to its original location:mv /backup/logqas/devmntlog /logsegment_000_00000151.dat /hana/logqas/mnt00003/hdb00003
17. Remove the temporary log folder:rmdir /backup/logqas/devmntlog
18. Start the database:HDB start