Your message dated Wed, 15 Jul 2015 01:19:26 +0000
with message-id <e1zfbm6-0004a6...@franck.debian.org>
and subject line Bug#788183: fixed in rsyslog 8.11.0-2
has caused the Debian Bug report #788183,
regarding postgresql logs filling with "WARNING: there is already a
transaction in progress"
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
788183: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=788183
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
Source: rsyslog
Source-Version: 8.11.0-2
We believe that the bug you reported is fixed in the latest version of
rsyslog, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to 788...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Michael Biebl <bi...@debian.org> (supplier of updated rsyslog package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@ftp-master.debian.org)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Wed, 15 Jul 2015 02:49:48 +0200
Source: rsyslog
Binary: rsyslog rsyslog-mysql rsyslog-pgsql rsyslog-mongodb
rsyslog-elasticsearch rsyslog-kafka rsyslog-gssapi rsyslog-gnutls rsyslog-relp
Architecture: source amd64
Version: 8.11.0-2
Distribution: unstable
Urgency: medium
Maintainer: Michael Biebl <bi...@debian.org>
Changed-By: Michael Biebl <bi...@debian.org>
Description:
rsyslog - reliable system and kernel logging daemon
rsyslog-elasticsearch - Elasticsearch output plugin for rsyslog
rsyslog-gnutls - TLS protocol support for rsyslog
rsyslog-gssapi - GSSAPI authentication and encryption support for rsyslog
rsyslog-kafka - Kafka output plugin for rsyslog
rsyslog-mongodb - MongoDB output plugin for rsyslog
rsyslog-mysql - MySQL output plugin for rsyslog
rsyslog-pgsql - PostgreSQL output plugin for rsyslog
rsyslog-relp - RELP protocol support for rsyslog
Closes: 788183
Changes:
rsyslog (8.11.0-2) unstable; urgency=medium
.
* Properly handle transactions in ompgsql. Patch cherry-picked from upstream
Git. (Closes: #788183)
Checksums-Sha1:
f636a9e53b350a589bca081c81bed8af8bc9a372 2667 rsyslog_8.11.0-2.dsc
2a75dcad834c347697a0eaacc66d600dd4f77d78 24460 rsyslog_8.11.0-2.debian.tar.xz
786e2f4d934c5c88d7ee5be33b77e565ab4ec46b 167984
rsyslog-elasticsearch_8.11.0-2_amd64.deb
3dc5d12ced66c9e0ea07bda6ca252892b1b2c2d4 163478
rsyslog-gnutls_8.11.0-2_amd64.deb
6ba514a14e7b7eeb623ccbc2fb9234326e7a6797 164472
rsyslog-gssapi_8.11.0-2_amd64.deb
64764770848f0184e397aa41f2ab1a9af7d38272 161548
rsyslog-kafka_8.11.0-2_amd64.deb
9a02ca44bc08410bb73c5ca3a8132b030d676943 159032
rsyslog-mongodb_8.11.0-2_amd64.deb
28badcd381a452dcebf20dfed6cdfb92a6e39e5c 158850
rsyslog-mysql_8.11.0-2_amd64.deb
0fd7b3c406180019771f19bfeabf5960d70fbf9f 157484
rsyslog-pgsql_8.11.0-2_amd64.deb
ac113d41c4983f0197b2825dc9d0865047a6417e 163246 rsyslog-relp_8.11.0-2_amd64.deb
e8c635f0022250dbae35b85bd105171339371dbc 507310 rsyslog_8.11.0-2_amd64.deb
Checksums-Sha256:
cf4e1fa79a6da6f4a97d3609b2665a4d24eb83855b9df3ea6ca4e180af9b3d0f 2667
rsyslog_8.11.0-2.dsc
250ab9ba56dd20b40792d11b466e5a4a63a0cb098c4a0cb9762b9945b1f92677 24460
rsyslog_8.11.0-2.debian.tar.xz
a9cf84bdc5b97a5f298dbf4f809501290ef5985628cc4b2695bc4bba21f2b4c0 167984
rsyslog-elasticsearch_8.11.0-2_amd64.deb
e5737006d5ad04d0ad91e62dab6ec951496106ae4fdcd5d0f27cbe7a35e52f93 163478
rsyslog-gnutls_8.11.0-2_amd64.deb
79b86af22a4cf53ee68cffa28735c266ac5cbfa41dbc4843a7d40339a9697eeb 164472
rsyslog-gssapi_8.11.0-2_amd64.deb
efe6f646aacd6aa1457ed4343e88aae9e5323c760e8772f545ddac90fb48b703 161548
rsyslog-kafka_8.11.0-2_amd64.deb
3dbcceca6e88fa9d5381861e311852f6b6afb004a3967fa388875aadce1edd22 159032
rsyslog-mongodb_8.11.0-2_amd64.deb
6aa97c923c582328d99d6b2ae4de65f9c79b081b464c5e21b029a7b2628397f2 158850
rsyslog-mysql_8.11.0-2_amd64.deb
04411e502dae34478d8d38c2bb04f4952ede220f00f7f30e18c66d3427087762 157484
rsyslog-pgsql_8.11.0-2_amd64.deb
47b4de3e5e1471780e6797512726849ff18428c299e0b2a789175422c433452c 163246
rsyslog-relp_8.11.0-2_amd64.deb
e5d5faea876003adfb713e22a66b72c7d02f7bc94464ec66f84fe14556574ae5 507310
rsyslog_8.11.0-2_amd64.deb
Files:
582a57d9115bf90791710d5f84a9db99 2667 admin important rsyslog_8.11.0-2.dsc
ba9877ec4e61dd10659d2aa3aae04598 24460 admin important
rsyslog_8.11.0-2.debian.tar.xz
3caa37b2d8b9a1dcfa576a74b7de3cb6 167984 admin extra
rsyslog-elasticsearch_8.11.0-2_amd64.deb
7ad02de45d029370946e3d2a58c794ac 163478 admin extra
rsyslog-gnutls_8.11.0-2_amd64.deb
bbf6e7bb0f8922ce3f4ed716fadaa713 164472 admin extra
rsyslog-gssapi_8.11.0-2_amd64.deb
c63022c4ede26c44093aef5530275d06 161548 admin extra
rsyslog-kafka_8.11.0-2_amd64.deb
0af5e43ff5c0c3c2af3495699937577f 159032 admin extra
rsyslog-mongodb_8.11.0-2_amd64.deb
89680fd240445f0f927bf051c7f4b71f 158850 admin extra
rsyslog-mysql_8.11.0-2_amd64.deb
43fdefeca08fc2702ffeacabd61cc97d 157484 admin extra
rsyslog-pgsql_8.11.0-2_amd64.deb
7417b55ba3b8af066e358544e12165d9 163246 admin extra
rsyslog-relp_8.11.0-2_amd64.deb
6923595e1fa5c35eff7b29c210a87306 507310 admin important
rsyslog_8.11.0-2_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
iQIcBAEBCAAGBQJVpbLaAAoJEGrh3w1gjyLcjesQAJqZT3OnB8W+JYuriWCe65Os
19aaVjCLTFteRlwJvPs9pYVEafkNUqShMPiSY6zJ13ygoHrw87iWL0Lnw1vD9jmp
RSuFAfn8JFxlf9P5/rj8eQmvwT+Jh/sQVt3BL+UrFrYMXsRjTb51zMKJxnGHLlst
uB1uFGoqKrsooknSiSuaLs5lGMuMRYqF7TaOihPN6N1GbHGOISd+0Gmpgo72MrPh
ELgKznxkM+n0Msd11b7mC8W/dCDmYjru1s+nkW+zGwWK1OxxCKQJ4WtwTraAVCR2
cTdu3nObTvXDjzk33V9W+c88zaNxa9+NlNwkxQuw7HWDbLFLJWRFRc8PFYUoC8Hy
HOhiam0ZZEs05/gT9dUQxn+NQE5s8sux1uUH9vYJ60Cn2GK5kZqBVmvUxQ/JRTBx
tl5ahZtv2O5JLsuq5zovwaukcDNXHD7HBhJlPmO5Y4WCoHJNNY7t3UJ3HV3wKo6k
Re21E+TrZGzV4q5IJNCbAebg38OPmh1I9xWMFi3BtiLZYJ8MDZKQ14Xi5bGWEeL/
4Mc/htz6CxCYz3FeHJ/cGlsDh3BbwvYhxSMqyGCXPbb0o7YBBKqNA1XIs5xRhmiQ
iCw7FvIttatRwRftLM9euXTcnOAPcnTCSqijNITEXuhWzpGEVXR57r0xDaXi/ZLd
0wlk1eT5FpvTAjZ8IKW6
=vnmC
-----END PGP SIGNATURE-----
--- End Message ---
