Syslog-ng service start failure

The syslog-ng service will not restart. This stems from a problem I had when I ran the validate.php and got a “Your database is out of date” error. I ran the ./lnms migrate only to get an error (General error: 1206 The total number of locks exceeds the lock table size (SQL: ALTER TABLE ‘syslog’ MODIFY facility
varchar(10)
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci
NULL ; )

Now I’m getting this error on the syslog service. Copied and pasted below the output form the status. Any help would be appreciated.

root@sclibrenms:/etc/syslog-ng# systemctl status syslog-ng.service
● syslog-ng.service - System Logger Daemon
Loaded: loaded (/lib/systemd/system/syslog-ng.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Tue 2021-04-06 12:15:02 CDT; 3min 36s ago
Docs: man:syslog-ng(8)
Process: 38004 ExecStart=/usr/sbin/syslog-ng -F $SYSLOGNG_OPTS (code=exited, status=1/FAILURE)
Main PID: 38004 (code=exited, status=1/FAILURE)
Status: “Starting up… (Tue Apr 6 12:15:02 2021”

Apr 06 12:15:02 sclibrenms systemd[1]: syslog-ng.service: Main process exited, code=exited, status=1/FAILURE
Apr 06 12:15:02 sclibrenms systemd[1]: syslog-ng.service: Failed with result ‘exit-code’.
Apr 06 12:15:02 sclibrenms systemd[1]: Failed to start System Logger Daemon.
Apr 06 12:15:02 sclibrenms systemd[1]: syslog-ng.service: Scheduled restart job, restart counter is at 5.
Apr 06 12:15:02 sclibrenms systemd[1]: Stopped System Logger Daemon.
Apr 06 12:15:02 sclibrenms systemd[1]: syslog-ng.service: Start request repeated too quickly.
Apr 06 12:15:02 sclibrenms systemd[1]: syslog-ng.service: Failed with result ‘exit-code’.
Apr 06 12:15:02 sclibrenms systemd[1]: Failed to start System Logger Daemon.

This topic was automatically closed 186 days after the last reply. New replies are no longer allowed.