Vertica.log growing rapidly
search cancel

Vertica.log growing rapidly

book

Article ID: 396750

calendar_today

Updated On:

Products

Network Observability CA Performance Management

Issue/Introduction

The vertica.log is growing rapidly. On all 3 nodes we constantly see messages that look like this:

2025-05-03 06:33:01.464 Multiplex connection poller:0x7f02aa4d5700 [Dist] <Socket> MultiplexedSendConnection (0x7f0a2803dad0) (##.##.#.###:5434)[fd 82]: set poller mode: 0
2025-05-03 06:33:01.464 Multiplex connection poller:0x7f02aa4d5700 [Dist] <Socket> MultiplexedSendConnection (0x7f0a2803dad0) (##.##.#.###:5434)[fd 82]: set poller mode: 0
2025-05-03 06:33:01.464 Multiplex connection poller:0x7f0b3e7fc700 [Dist] <Socket_Low> MultiplexedSendConnection (0x7f0b50006670) (##.##.#.###:5434)[fd 30]: socketHasData called

Environment

Dx NetOps Performance Management any version

Cause

Debug turned on

Resolution

Run the following queries to see what is turned on:

  • select * from configuration_parameters where parameter_name ilike '%Options';
  • select print_debug_log();

 

In this case "DIST : <ALL>" to the debug_log.conf file in the catalog directory.

 

Run the following to cleat the logging and prevent the vertica.log from growing rapidly

  • select clear_debug_log_allnodes('Dist','ALL');
  • DIST : <ALL> should also be removed / commented out from  debug_log.conf file in the catalog directory so it doesn't restart debug when the node is restarted