Why my HANA logs are groving so fast (every 20 minutes)?

[Former Member]

Dear all,

Why my logs in

hana01:/usr/sap/NDB/HDB00/backup/log

are groving so fast (every 20 minutes)?

even when I change my Backup Destinantion to another location /HANA_DATA/hana_backup

-rw-r--r-- 1 ndbadm sapsys 53248 Nov 27 01:23 log_backup_4_0_3600576_3601280

-rw-r--r-- 1 ndbadm sapsys      53248 Nov 27 01:42 log_backup_4_0_3601280_3601984

-rw-r--r-- 1 ndbadm sapsys 53248 Nov 27 01:57 log_backup_4_0_3601984_3602688

-rw-r--r-- 1 ndbadm sapsys 53248 Nov 27 02:13 log_backup_4_0_3602688_3603392

-rw-r--r-- 1 ndbadm sapsys 53248 Nov 27 02:32 log_backup_4_0_3603392_3604096

-rw-r--r-- 1 ndbadm sapsys 45056 Nov 27 02:47 log_backup_4_0_3604096_3604672

-rw-r--r-- 1 ndbadm sapsys 57344 Nov 27 03:04 log_backup_4_0_3604672_3605440

-rw-r--r-- 1 ndbadm sapsys 57344 Nov 27 03:22 log_backup_4_0_3605440_3606208

-rw-r--r-- 1 ndbadm sapsys 40960 Nov 27 03:38 log_backup_4_0_3606208_3606720

-rw-r--r-- 1 ndbadm sapsys 65536 Nov 27 03:57 log_backup_4_0_3606720_3607616

-rw-r--r-- 1 ndbadm sapsys 61440 Nov 27 04:17 log_backup_4_0_3607616_3608448

-rw-r--r-- 1 ndbadm sapsys 57344 Nov 27 04:37 log_backup_4_0_3608448_3609216

-rw-r--r-- 1 ndbadm sapsys 57344 Nov 27 04:57 log_backup_4_0_3609216_3609984

-rw-r--r-- 1 ndbadm sapsys 65536 Nov 27 05:15 log_backup_4_0_3609984_3610880

-rw-r--r-- 1 ndbadm sapsys 61440 Nov 27 05:37 log_backup_4_0_3610880_3611712

-rw-r--r-- 1 ndbadm sapsys 57344 Nov 27 05:57 log_backup_4_0_3611712_3612480

-rw-r--r-- 1 ndbadm sapsys 69632 Nov 27 06:18 log_backup_4_0_3612480_3613440

-rw-r--r-- 1 ndbadm sapsys 57344 Nov 27 06:38 log_backup_4_0_3613440_3614208

-rw-r--r-- 1 ndbadm sapsys 57344 Nov 27 06:58 log_backup_4_0_3614208_3614976

-rw-r--r-- 1 ndbadm sapsys 69632 Nov 27 07:18 log_backup_4_0_3614976_3615936

-rw-r--r-- 1 ndbadm sapsys 57344 Nov 27 07:38 log_backup_4_0_3615936_3616704

-rw-r--r-- 1 ndbadm sapsys 57344 Nov 27 07:58 log_backup_4_0_3616704_3617472

-rw-r--r-- 1 ndbadm sapsys 69632 Nov 27 08:18 log_backup_4_0_3617472_3618432

-rw-r--r-- 1 ndbadm sapsys 57344 Nov 27 08:38 log_backup_4_0_3618432_3619200

-rw-r--r-- 1 ndbadm sapsys 69632 Nov 27 08:58 log_backup_4_0_3619200_3620160

-rw-r--r-- 1 ndbadm sapsys     106496 Nov 27 09:17 log_backup_4_0_3620160_3621696

-rw-r--r-- 1 ndbadm sapsys     122880 Nov 27 09:32 log_backup_4_0_3621696_3623488

-rw-r--r-- 1 ndbadm sapsys 77824 Nov 27 09:48 log_backup_4_0_3623488_3624576

-rw-r--r-- 1 ndbadm sapsys 73728 Nov 27 10:04 log_backup_4_0_3624576_3625600

-rw-r--r-- 1 ndbadm sapsys 65536 Nov 27 10:22 log_backup_4_0_3625600_3626496

-rw-r--r-- 1 ndbadm sapsys 98304 Nov 27 10:39 log_backup_4_0_3626496_3627904

-rw-r--r-- 1 ndbadm sapsys 77824 Nov 27 10:55 log_backup_4_0_3627904_3628992

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 27 11:15 log_backup_4_0_3628992_3630208

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 27 11:35 log_backup_4_0_3630208_3631488

-rw-r--r-- 1 ndbadm sapsys 73728 Nov 27 11:55 log_backup_4_0_3631488_3632512

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 27 12:15 log_backup_4_0_3632512_3633728

-rw-r--r-- 1 ndbadm sapsys     114688 Nov 27 12:35 log_backup_4_0_3633728_3635392

-rw-r--r-- 1 ndbadm sapsys 73728 Nov 27 12:53 log_backup_4_0_3635392_3636416

-rw-r--r-- 1 ndbadm sapsys 77824 Nov 27 13:09 log_backup_4_0_3636416_3637504

-rw-r--r-- 1 ndbadm sapsys     126976 Nov 27 13:25 log_backup_4_0_3637504_3639360

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 27 13:45 log_backup_4_0_3639360_3640640

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 27 14:06 log_backup_4_0_3640640_3641792

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 27 14:25 log_backup_4_0_3641792_3643008

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 27 14:46 log_backup_4_0_3643008_3644288

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 27 15:06 log_backup_4_0_3644288_3645440

-rw-r--r-- 1 ndbadm sapsys 69632 Nov 27 15:22 log_backup_4_0_3645440_3646400

-rw-r--r-- 1 ndbadm sapsys 73728 Nov 27 15:37 log_backup_4_0_3646400_3647424

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 27 15:56 log_backup_4_0_3647424_3648704

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 27 16:16 log_backup_4_0_3648704_3649920

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 27 16:36 log_backup_4_0_3649920_3651072

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 27 16:56 log_backup_4_0_3651072_3652352

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 27 17:16 log_backup_4_0_3652352_3653568

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 27 17:37 log_backup_4_0_3653568_3654720

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 27 17:57 log_backup_4_0_3654720_3655872

-rw-r--r-- 1 ndbadm sapsys 73728 Nov 27 18:15 log_backup_4_0_3655872_3656896

-rw-r--r-- 1 ndbadm sapsys 69632 Nov 27 18:30 log_backup_4_0_3656896_3657856

-rw-r--r-- 1 ndbadm sapsys 77824 Nov 27 18:47 log_backup_4_0_3657856_3658944

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 27 19:07 log_backup_4_0_3658944_3660224

-rw-r--r-- 1 ndbadm sapsys 69632 Nov 27 19:25 log_backup_4_0_3660224_3661184

-rw-r--r-- 1 ndbadm sapsys 65536 Nov 27 19:40 log_backup_4_0_3661184_3662080

-rw-r--r-- 1 ndbadm sapsys 77824 Nov 27 19:57 log_backup_4_0_3662080_3663168

-rw-r--r-- 1 ndbadm sapsys 94208 Nov 27 20:17 log_backup_4_0_3663168_3664512

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 27 20:37 log_backup_4_0_3664512_3665664

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 27 20:57 log_backup_4_0_3665664_3666816

-rw-r--r-- 1 ndbadm sapsys 94208 Nov 27 21:18 log_backup_4_0_3666816_3668160

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 27 21:38 log_backup_4_0_3668160_3669312

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 27 21:58 log_backup_4_0_3669312_3670464

-rw-r--r-- 1 ndbadm sapsys 98304 Nov 27 22:22 log_backup_4_0_3670464_3671872

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 27 22:43 log_backup_4_0_3671872_3673024

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 27 23:03 log_backup_4_0_3673024_3674176

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 27 23:23 log_backup_4_0_3674176_3675392

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 27 23:40 log_backup_4_0_3675392_3676608

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 28 00:03 log_backup_4_0_3676608_3677824

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 28 00:23 log_backup_4_0_3677824_3679040

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 28 00:43 log_backup_4_0_3679040_3680320

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 28 01:03 log_backup_4_0_3680320_3681472

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 28 01:23 log_backup_4_0_3681472_3682688

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 28 01:43 log_backup_4_0_3682688_3683968

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 28 02:04 log_backup_4_0_3683968_3685120

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 28 02:24 log_backup_4_0_3685120_3686336

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 28 02:44 log_backup_4_0_3686336_3687616

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 28 03:04 log_backup_4_0_3687616_3688768

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 28 03:24 log_backup_4_0_3688768_3689984

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 28 03:44 log_backup_4_0_3689984_3691136

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 28 04:00 log_backup_4_0_3691136_3692352

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 28 04:24 log_backup_4_0_3692352_3693632

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 28 04:44 log_backup_4_0_3693632_3694784

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 28 05:04 log_backup_4_0_3694784_3696064

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 28 05:24 log_backup_4_0_3696064_3697280

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 28 05:45 log_backup_4_0_3697280_3698432

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 28 06:05 log_backup_4_0_3698432_3699712

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 28 06:25 log_backup_4_0_3699712_3700928

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 28 06:45 log_backup_4_0_3700928_3702080

-rw-r--r-- 1 ndbadm sapsys 94208 Nov 28 07:05 log_backup_4_0_3702080_3703424

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 28 07:25 log_backup_4_0_3703424_3704640

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 28 07:45 log_backup_4_0_3704640_3705792

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 28 08:05 log_backup_4_0_3705792_3707072

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 28 08:25 log_backup_4_0_3707072_3708288

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 28 08:46 log_backup_4_0_3708288_3709440

-rw-r--r-- 1 ndbadm sapsys 81920 Nov 28 09:06 log_backup_4_0_3709440_3710592

-rw-r--r-- 1 ndbadm sapsys 90112 Nov 28 09:25 log_backup_4_0_3710592_3711872

-rw-r--r-- 1 ndbadm sapsys 86016 Nov 28 09:46 log_backup_4_0_3711872_3713088

-rw-r--r-- 1 ndbadm sapsys 94208 Nov 28 10:06 log_backup_4_0_3713088_3714432

[Former Member]

Even after setting the parmater to log_backup_timeout_s=1200 (20min) the logs are getting backedup very very qucikly i.e every 3 mins . I have seen this is because....the parmater will only work if the HANA DB is idel i.e you logs will backedup for every 20mins only if it ideal(no commint transactions).

Perhaps i feel that is is a kind of expected behaviour , but i see it is also consider as a bug in some of the blogs. If someone from SAP can suggest on this it will clear our doubts

[Former Member]

A log will be backed up if either the log_backup_timeout_s is reached or the log_segment_size_mb is reached. Some services like scriptserver.ini (8 MB), xsengine.ini (8 MB) or statisticsserver.ini (64 MB) have a rather small log_segment_size_mb. If required, the log_segment_size_mb can be increased (see e.g. SAP Note 2019148 for statistics server or SAP Note 2062080 for xsengine).

[former_member302691]

Thanks for you help, but even I have B1if installed it's not working now, and my log keep growing every minute.

Anyway where do you disable logging for SAP Integration Service?

And another question, how did you realize that it was the problem?

Is there any log that I can check and find the problem?

Thanks and regard.s.

[Former Member]

Hi Grzegorz,

have a look at HANA parameter global.ini [persistence] log_backup_timeout_s. I assume it is set to 1200 (seconds which is 20 minutes). So it is perfectly normal if HANA writes a log file every 20 minutes.

Regards,

Mark

[Former Member]

Dear Mark,

in my case this param was set to 14400 - and even there 1 GB log file was created every 20 min.

As as said above - in my case there was extended logging level for SAP integration service.

Disabling logging from SAP integration service (integration framework for SAP B1) solved my issue.

Cheers!

[former_member302691]

Hello,

did you have an answer about it?

I'm having same problem with 9.1

Regards.

[Former Member]

Hi,

in my case there was B1if (SAP Business One integration service) running on windows server that has enabled extended logginng.

Turning off logging in B1if stops this hudge lfiles creation on HANA.