search

rsyslog / rsyslog-doc

documentation for the rsyslog project
Other
99 stars 249 forks source link

no ommysql reconnect #955

Closed a1bert01 closed 2 years ago

a1bert01 commented 2 years ago

ubuntu focal rsyslogd ommysql does not reconnect to mysql after loosing connection to server due to timeout:

ommysql: db error (4031): The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior. [v8.2001.0]

rsyslogd[xx]: The error statement was: START TRANSACTION [v8.2001.0 try https://www.rsyslog.com/e/2218 ]
rsyslogd[xx]: action 'action-9-ommysql' (module 'ommysql') message lost, could not be processed. Check for additional error messages before this one. [v8.2001.0 try https://www.rsyslog.com/e/2218 ]
syslogd  8.2001.0 (aka 2020.01) compiled with:
    PLATFORM:               x86_64-pc-linux-gnu
    PLATFORM (lsb_release -d):      
    FEATURE_REGEXP:             Yes
    GSSAPI Kerberos 5 support:      Yes
    FEATURE_DEBUG (debug build, slow code): No
    32bit Atomic operations supported:  Yes
    64bit Atomic operations supported:  Yes
    memory allocator:           system default
    Runtime Instrumentation (slow code):    No
    uuid support:               Yes
    systemd support:            Yes
    Config file:                /etc/rsyslog.conf
    PID file:               /run/rsyslogd.pid
    Number of Bits in RainerScript integers: 64
a1bert01 commented 2 years ago

sorry wrong section