# date; /bin/yum list rsyslog rsyslog-mysql ;date
Thu Dec 1 09:47:18 CST 2022
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: download.cf.centos.org
* epel: mirror.genesisadaptive.com
* extras: download.cf.centos.org
* remi-php56: mirror.pit.teraswitch.com
* remi-safe: mirror.pit.teraswitch.com
* updates: download.cf.centos.org
Installed Packages
rsyslog.x86_64 8.2210.0-1.el7
@rsyslog_v8
rsyslog-mysql.x86_64 8.2210.0-1.el7
@rsyslog_v8
Thu Dec 1 09:47:19 CST 2022
Sample of numerous error messages (/var/log/messages):
rsyslogd[17344]: ommysql: db error (1172): Result consisted of more than
one row [v8.2210.0]
rsyslogd[17344]: The error statement was: insert into SystemEvents
(Message, Facility, FromHost, Priority, DeviceReportedTime, ReceivedAt,
InfoUnitID, SysLogTag) values ('close
"/incoming/wood.pgez.scen.11302022.sa.pgp" bytes read 0 written 2603
[postauth]', 10, 'hermes', 6, '20221201081257', '20221201081257', 1,
'sshd[19654]:') [v8.2210.0 try https://www.rsyslog.com/e/2218 ]
rsyslogd[17344]: rsyslogd[internal_messages]: 215 messages lost due to
rate-limiting (500 allowed within 5 seconds)
rsyslogd[17344]: action 'Sftp' (module 'ommysql.so') message lost, could
not be processed. Check for additional error messages before this one.
[v8.2210.0 try https://www.rsyslog.com/e/2218 ]
We have been writing all data from Internet file transfers to a Mysql table
for years. Recently, we began seeing intermittent errors like those above.
What is happening here?
What can we do to fix this problem?
Please, advise. Thank you.
~ Mike
_______________________________________________
rsyslog mailing list
https://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
What's up with rsyslog? Follow https://twitter.com/rgerhards
NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad of
sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you DON'T LIKE
THAT.
