Your message dated Sun, 30 Aug 2015 09:47:11 +0000 with message-id <[email protected]> and subject line Bug#788183: fixed in rsyslog 8.4.2-1+deb8u1 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 [email protected] immediately.) -- 788183: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=788183 Debian Bug Tracking System Contact [email protected] 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.4.2-1+deb8u1 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 [email protected], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Michael Biebl <[email protected]> (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 [email protected]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Format: 1.8 Date: Sat, 29 Aug 2015 13:52:34 +0200 Source: rsyslog Binary: rsyslog rsyslog-mysql rsyslog-pgsql rsyslog-mongodb rsyslog-elasticsearch rsyslog-gssapi rsyslog-gnutls rsyslog-relp Architecture: source amd64 Version: 8.4.2-1+deb8u1 Distribution: jessie Urgency: medium Maintainer: Michael Biebl <[email protected]> Changed-By: Michael Biebl <[email protected]> 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-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.4.2-1+deb8u1) jessie; urgency=medium . * Disable transactions in ompgsql as they were not working properly. Patch cherry-picked from upstream Git. (Closes: #788183) Checksums-Sha1: 64ec92dfe6b12d98150f578199ee76ddbb236ded 2594 rsyslog_8.4.2-1+deb8u1.dsc 14a7c1b128df361caec4f391160168102b36c94f 23340 rsyslog_8.4.2-1+deb8u1.debian.tar.xz fcacc2e86f4b665b251a6c16b116bcb41c2f65f8 545278 rsyslog_8.4.2-1+deb8u1_amd64.deb 16ccb79bcd4cbaf8e795dd3de6b30afd450e8a09 164336 rsyslog-mysql_8.4.2-1+deb8u1_amd64.deb b6a8ed5a314203ee6bd05b7ed0320432351b7553 162972 rsyslog-pgsql_8.4.2-1+deb8u1_amd64.deb 7bb1c126047f508fd4a00d12b976d1d3246599cb 164324 rsyslog-mongodb_8.4.2-1+deb8u1_amd64.deb 4815df07f2c911eee96f49f6ee192e54ede234d2 171614 rsyslog-elasticsearch_8.4.2-1+deb8u1_amd64.deb 5044335e70074af599b70f773844a289ac88c57b 169700 rsyslog-gssapi_8.4.2-1+deb8u1_amd64.deb 59b775d991a987e2eb15c24ac1253a8591f07599 168290 rsyslog-gnutls_8.4.2-1+deb8u1_amd64.deb 4070a6d3259881295eb09ff4a2993c7d2624f7fe 168432 rsyslog-relp_8.4.2-1+deb8u1_amd64.deb Checksums-Sha256: 0e90904d1cf5655097618e3c08d146cbe02f0aead4fd3b15bdafc183febe6151 2594 rsyslog_8.4.2-1+deb8u1.dsc 2c43d6e89492401f1386df891bd42b2723df77c2b421365e2e263b891abcd6ac 23340 rsyslog_8.4.2-1+deb8u1.debian.tar.xz 40a85f8629d4ca0b08de01eb231450864bd3dc0d25115deb177e23d6ad6a1bf3 545278 rsyslog_8.4.2-1+deb8u1_amd64.deb be28aa73b1eae63f1863ae8f9bf5e3bab567e34d95780ce5da2c1aff9c6259bc 164336 rsyslog-mysql_8.4.2-1+deb8u1_amd64.deb 01b160f7f3a53fa8ed20631a9a8a1ff718026a9317b771e193f9443a34e60c3f 162972 rsyslog-pgsql_8.4.2-1+deb8u1_amd64.deb 65c2e89b745220dc903e1f148a619822d63e925f25cac70ba83053c2d95e7b8f 164324 rsyslog-mongodb_8.4.2-1+deb8u1_amd64.deb ad4d9ab906ebb9f05ed24a53b00dd0f3e0c48639350d50a16d0f12f6a26e07a0 171614 rsyslog-elasticsearch_8.4.2-1+deb8u1_amd64.deb dcd2f4043774710a09cebfe52ceb2eadc880c34d969f33ab590cca03375cf5aa 169700 rsyslog-gssapi_8.4.2-1+deb8u1_amd64.deb eb432b8b79fded5100773bbd602189f5f5b1d38abb5ced33132e5da1cf29674b 168290 rsyslog-gnutls_8.4.2-1+deb8u1_amd64.deb 6c22b963a4019b9d94059b62e73cd5b825fad9baf736747f9e7351bc112c7621 168432 rsyslog-relp_8.4.2-1+deb8u1_amd64.deb Files: 27cb0b2cb88c210f42e7e8d09335b156 2594 admin important rsyslog_8.4.2-1+deb8u1.dsc 8a919b316989a68b20d16089bb939a6d 23340 admin important rsyslog_8.4.2-1+deb8u1.debian.tar.xz b0d9f0b7370c301e357caf4d14ed7606 545278 admin important rsyslog_8.4.2-1+deb8u1_amd64.deb 927be8336bd4a061132f546579b65bbc 164336 admin extra rsyslog-mysql_8.4.2-1+deb8u1_amd64.deb c08b15835dc9fbcf58295aeb6041eaee 162972 admin extra rsyslog-pgsql_8.4.2-1+deb8u1_amd64.deb 54cfe51d97b0a404f8d192014bc93c43 164324 admin extra rsyslog-mongodb_8.4.2-1+deb8u1_amd64.deb b6e2948ddb5c0892c95cdac8e752c098 171614 admin extra rsyslog-elasticsearch_8.4.2-1+deb8u1_amd64.deb 6e4870605efbcadfd0592ca403d17295 169700 admin extra rsyslog-gssapi_8.4.2-1+deb8u1_amd64.deb 1fd65f3f95be9e6a4148a6dfb9d83f9b 168290 admin extra rsyslog-gnutls_8.4.2-1+deb8u1_amd64.deb 6ae0d46714a98ee8050cb52445668cbf 168432 admin extra rsyslog-relp_8.4.2-1+deb8u1_amd64.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBCAAGBQJV4bdXAAoJEGrh3w1gjyLcaHoQAIKlZFEjvkqWgdeyO8VByLXh 2TvAoqGj109SWV4yfBAIXO6mAcC+xNKuLzw8N2T1IL8JxXglzZcvwmuGcyW5TOyj BXkkI+MqOceMUQr2BU+pkx9R0WERSCXRlvJVxOu6QM04RMuHP0wpDUhlJIOo3HlV kBGssRpQLV+W69/YlVAiPFA+5LPLchIbgW9/WtncDUEXYvsZ4jDofgM+NV64pEON hu7JqltSZ932VpaLyuHDfTeO0IrlHjChpSYsXLXrNTztuW79N9bF+LfTlKcwRZHE AQ8XrpTgJHHHN1futtjagJ4SVNEe8qVh9DcW4H6EyRnUhs0wUjzJAbrz+F626nYk CYnTavgIyqS5w/UMwBDqoLd4RttJhRt468FtXP4Kk7paEq1jYOHnDzfgzcjRaaZc O/IqtsQwvLxIWhnWiSazmnHs1QbFqzyLGXgA2VGZJ/bynqpxVv2vNQQ3hBPjFukg RQkhxuc5tv4BDJD/aUQHq8TdkBSz2UjgIXUTHAhidOufuwLdFpyP3zzJX/VXnUJ4 HyZxIUQz67SE6OGsqHyy9v03YSoV6laq+HIyD9iNetGrJBQCDd+G1ZhGxy9lKxKU HY/HNUg6SvHyCZVpkCqG6RM0bwPBtkuCzpx5tlLG735bSSu+6MitX2r1tkuWbgnc JCaZ9v9k9Wyss9FOim1m =LyBB -----END PGP SIGNATURE-----
--- End Message ---
