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 debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org