cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP_trial 2022 HDB start problems: log full still active in log partition

WRoeckelein
Active Participant
0 Kudos
231

Hi all,

HDB of my #abap_trial 2022 hangs on startup, in /hana/shared/HDB/HDB02/vhcala4hci/trace/daemon__0000783__children.trc I found these messages

[935]{-1}[-1/-1] 2024-06-12 09:57:58.194184 i EventHandler EventManagerImpl.cpp(00962) : Could not set event 'LogFullEvent[volumeid=1,eventid=1,part=/hana/log/HDB/mnt00001/hdb00001/]' to state 'handled'
[962]{-1}[-1/-1] 2024-06-12 09:57:58.194220 i Logger LogSegment.cpp(03175) : log partition disk usage 100% >= log_disk_usage_limit 95%, do not create new log segment
[962]{-1}[-1/-1] 2024-06-12 09:57:58.194229 i Logger LogSegment.cpp(03294) : Retry of log segment creation failed, log full still active in log partition /hana/log/HDB/mnt00001/hdb00001/, awaiting free segment or additional disk space

df says

Filesystem 1K-blocks Used Available Use% Mounted on
overlay 263112772 261397492 0 100% /
tmpfs 65536 0 65536 0% /dev
tmpfs 10240832 0 10240832 0% /sys/fs/cgroup
shm 65536 0 65536 0% /dev/shm
/dev/sdd 263112772 261397492 0 100% /etc/hosts
tmpfs 10240832 0 10240832 0% /proc/acpi
tmpfs 10240832 0 10240832 0% /sys/firmware

Some ideas on how to overcome this? @julieplummer20 any hint?

Thanks,

  Wolfgang

WRoeckelein
Active Participant
0 Kudos

to be deleted

View Entire Topic
julieplummer20
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Wolfgang,

Perhaps I'm missing something, but default log segment count = 10240. Have you enlarged this, ie: 

  1. Stop the Hana DB.
  2. Increase the limit (e.g. <count> = 10240) :
    • hdblogdiag directory --enlarge <count> /hana/log/<sid>/mnt<id>/hdb<id>
    • The parameter <count> specifies the number of new entries which can be appended to the log segment directory.
  3. After extending the directory the database can be restarted and additional <count> log segments will be allocated.

Just let me know if I have missed something.

Best wishes,

JUlie.

WRoeckelein
Active Participant
0 Kudos

Hi @julieplummer20 ,

thanks for the quick answer. However despite several extensions already the error won't go away

[833]{-1}[-1/-1] 2024-06-12 13:55:40.178800 i Logger LoggerImpl.cpp(01435) : Replayed 323456B (0MB) of log in 0.045049 seconds; 6.84747MB/s; max known TID=67656961
[833]{-1}[-1/-1] 2024-06-12 13:55:40.178875 i Logger LoggerImpl.cpp(01010) : Starting logger with 8 log buffers per partition, 1024KB each, segment size 64MB, log mode normal, currentWritePos=0xfd479f80
[966]{-1}[-1/-1] 2024-06-12 13:55:40.178996 i Logger LogSegment.cpp(03175) : log partition disk usage 100% >= log_disk_usage_limit 95%, do not create new log segment
[966]{-1}[-1/-1] 2024-06-12 13:55:40.179001 w Logger LogSegment.cpp(03250) : Log full - log_disk_usage_limit 95% reached in log partition /hana/log/HDB/mnt00001/hdb00001/, current disk usage is 100%, awaiting free segment or additional free disk space
[966]{-1}[-1/-1] 2024-06-12 13:55:40.179008 i EventHandler EventManagerImpl.cpp(00680) : New event reported: 'LogFullEvent[volumeid=1,eventid=1,part=/hana/log/HDB/mnt00001/hdb00001/]'

ls -l /hana/log/HDB/mnt00001/hdb00001/ gives now

total 298388
0 -rw-r--r-- 1 hdbadm sapsys 0 Oct 16 2017 __DO_NOT_TOUCH_FILES_IN_THIS_DIRECTORY__
4 -rw-r--r-- 1 hdbadm sapsys 36 Jun 11 16:21 landscape.id
65536 -rw-r--r-- 1 hdbadm sapsys 67108864 Mar 3 2023 logsegment_000_00000016.dat
65536 -rw-r--r-- 1 hdbadm sapsys 67108864 Jun 11 19:51 logsegment_000_00000017.dat
65536 -rw-r--r-- 1 hdbadm sapsys 67108864 Jun 11 19:54 logsegment_000_00000018.dat
29076 -rw-r--r-- 1 hdbadm sapsys 29773824 Jun 12 13:53 logsegment_000_directory.dat
1328 -rw-r--r-- 1 hdbadm sapsys 1359872 Jun 11 19:57 logsegment_000_directory.dat_3_1718196457310367
7932 -rw-r--r-- 1 hdbadm sapsys 8122368 Jun 12 12:47 logsegment_000_directory.dat_3_1718199375099519
14540 -rw-r--r-- 1 hdbadm sapsys 14888960 Jun 12 13:36 logsegment_000_directory.dat_3_1718199825061521
21148 -rw-r--r-- 1 hdbadm sapsys 21655552 Jun 12 13:43 logsegment_000_directory.dat_3_1718200121402079
27752 -rw-r--r-- 1 hdbadm sapsys 28418048 Jun 12 13:48 logsegment_000_directory.dat_3_1718200424066429

Regards,

  Wolfgang