Vertica writing logs to boot.log file instead of vertica.log
Vertica application is writing its data to /opt/vertica which the data file is 1.3G. But Its writing logs to /var/log/boot.log stating low disk space from a check that it runs. It seems that this log file gets large as the vertica process keeps writing there and overtime the log file causes the filesystem space to go to 100 percent. I need help to look at more how this vertica program works and where if the config for the logging it doing in boot.log.
You can See below. I backed up and zero out the boot.log file to free a little space for now.
But the log file is still costantly being written to by this LowDiskSpaceCheck.
Sep 9 04:29:10 qadae-vtc21a vertica 2015-09-09 04:29:00.001 LowDiskSpaceCheck:0x7fbed800f770-a000000329e1da [Txn] <INFO> Begin Txn: a000000329e1da 'LowDiskSpaceCheck'
Sep 9 04:29:10 qadae-vtc21a vertica 2015-09-09 04:29:00.001 LowDiskSpaceCheck:0x7fbed800f770-a000000329e1da [Txn] <INFO> Rollback Txn: a000000329e1da 'LowDiskSpaceCheck'
Sep 9 04:29:10 qadae-vtc21a vertica 2015-09-09 04:29:00.001 LowDiskSpaceCheck:0x7fbed800f770 [Util] <INFO> Task 'LowDiskSpaceCheck' enabled
Sep 9 04:29:20 qadae-vtc21a vertica 2015-09-09 04:29:10.001 LowDiskSpaceCheck:0x7fbed800fac0-a000000329e1db [Txn] <INFO> Begin Txn: a000000329e1db 'LowDiskSpaceCheck'
Sep 9 04:29:20 qadae-vtc21a vertica 2015-09-09 04:29:10.001 LowDiskSpaceCheck:0x7fbed800fac0-a000000329e1db [Txn] <INFO> Rollback Txn: a000000329e1db 'LowDiskSpaceCheck'
Sep 9 04:29:20 qadae-vtc21a vertica 2015-09-09 04:29:10.001 LowDiskSpaceCheck:0x7fbed800fac0 [Util] <INFO> Task 'LowDiskSpaceCheck' enabled
Sep 9 04:29:30 qadae-vtc21a vertica 2015-09-09 04:29:20.001 LowDiskSpaceCheck:0x7fbed8010eb0-a000000329e1dc [Txn] <INFO> Begin Txn: a000000329e1dc 'LowDiskSpaceCheck'
Sep 9 04:29:30 qadae-vtc21a vertica 2015-09-09 04:29:20.001 LowDiskSpaceCheck:0x7fbed8010eb0-a000000329e1dc [Txn] <INFO> Rollback Txn: a000000329e1dc 'LowDiskSpaceCheck'
Sep 9 04:29:30 qadae-vtc21a vertica 2015-09-09 04:29:20.001 LowDiskSpaceCheck:0x7fbed8010eb0 [Util] <INFO> Task 'LowDiskSpaceCheck' enabled
I tried below parametrs but no use:
1. changed SyslogEnabled parameter from "1" to "0"
2. Disabled Log temporary. Which is not recomended but i tried.
The command to stop all [Txn]<INFO> from logging is as follows:
select clear_debug_log('TXN', 'INFO');
Comments
can some one help me to remove the Syslog path from the event_configurations?
select * from event_configurations;
event_id | event_delivery_channels
-------------------------------------------+--------------------------------
Low Disk Space | Vertica Log, SNMP Trap, Syslog
Changing the output from 1 to 0 just means that the system is returning True instead of False. You will need to locate the source file that controls where the logs are saved and change the file path. Preferably commenting out the default and adding yours underneath incase you need to revert back to the other.
If your unable to find the source file or it is encrypted in binary or other and you cant decrypt it or find / know the key to do so. You could write a shell script to do this for you. It should be basic to moderate shell scripting level you could probably find a guide or tutorial and learn in afternoon probably.
It might help you to dual or live boot a linux OS to locate or change the files you want.
Hi hansolo,
Thank you so much for taking time to reply to the thread and helping me.
I am little confised with your answer, could you please explain me in details or give me a step by step process of how to find the source file and how to make changes?
Thanks in advance.