How to stop Failed SQL Execution?

Tags: #om_dbi

#1 Bohdan.Lisovskyi

Hi. I am new in NXlog. I am using om_dbi module to execute some SQL to insert my logs to pqsql. But I have the following ERROR "om_dbi failed to execute SQL statement", and NXLOG is trying to repeat this SQL again and again. How to stop this loop SQL execution after the first failure.

#2 manuel.munozDeactivated Nxlog ✓
#1 Bohdan.Lisovskyi
Hi. I am new in NXlog. I am using om_dbi module to execute some SQL to insert my logs to pqsql. But I have the following ERROR "om_dbi failed to execute SQL statement", and NXLOG is trying to repeat this SQL again and again. How to stop this loop SQL execution after the first failure.

Hi Bohdan,

We are happy to help. Could you please post nxlog.conf and nxlog.log files?