Package: rsyslog-pgsql
Version: 8.4.2-1
Severity: grave
Justification: renders package unusable
Dear Maintainer,
I have a setup where host_a running rsyslog writes logs to a remote
server host_b running postgresql 9.1 (a server running wheezy at the
moment). Since upgrading host_a (the rsyslog server) from wheezy to
jessie the postgresql logs on host_b started filling up with lines
like:
--- BEGIN host_b /var/log/postgresql/postgresql-9.1-main.log ---
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
2015-06-09 08:11:27 CEST WARNING: there is already a transaction in progress
--- END ---
(hundreds of lines per second!)
The configuration on host_a for ompgsql :
--- BEGIN host_a /etc/rsyslog.d/ompgsql.conf ---
# Provides UDP syslog reception
module(load="imudp")
input(type="imudp" port="514")
# Provides TCP syslog reception
module(load="imtcp")
input(type="imtcp" port="514")
module(load="mmutf8fix")
action(type="mmutf8fix" mode="controlcharacters")
$template pgsqltemplate,"INSERT INTO logs (host, facility, priority, level,
tag, \
program, msg, hostname) VALUES ( '%fromhost-ip%',
'%syslogfacility-text%', '%syslogpriority-text%', \
'%syslogseverity-text%','%syslogtag%', '%programname%', '%msg%' ,
'%hostname%')",stdsql
$ModLoad ompgsql
*.* :ompgsql:caradhras.local,syslog,syslog,XXXXXXXX;pgsqltemplate
--- END ---
For now I have downgraded to rsyslog and rsyslog-pgsql version
7.6.3-2~bpo70+1 from wheezy-backports, which does not have this
problem.
Sammy
-- System Information:
Debian Release: 8.1
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.16.0-4-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Disclaimer: http://transtrend.com/disclaimer.txt
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
