Hi, Can you file this bug upstream please under https://github.com/rsyslog/rsyslog and report back with the bug number. Thanks, Michael
Am 9. Juni 2015 08:57:56 MESZ, schrieb Sammy Atmadja <sa...@transtrend.com>: >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 -- Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
