Your message dated Mon, 15 Mar 2021 18:03:23 +0000
with message-id <e1llryp-00025z...@fasolo.debian.org>
and subject line Bug#956083: fixed in autopostgresqlbackup 1.1-1.1
has caused the Debian Bug report #956083,
regarding autopostgresqlbackup: Fails to detect when DB dumps fail, and saves
useless backups
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.)
--
956083: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=956083
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: autopostgresqlbackup
Version: 1.1-1
Severity: critical
Tags: upstream
Justification: causes serious data loss
Due to a human error, today I had to resort to backups to recover data from a
PostgreSQL database. In the worst possible moment, I realised that ALL of the
backups we had of this database are useless.
Turns out that when dumping the database to a huge text file, the system was
running out of disk space, and so the file is truncated.
Instead of detecting the problem, aborting the backup, and sending an email to
the administrator, autopostgresqlbackup assumes the dump finished well,
proceeded to compress the truncated dump, and continued as if nothing had
happened. This had been going on for months without me realising, and so I have
no useful backup.
I am setting the severity as critical, because this bug has made me lose real
world data today.
The sad part is that the bug is pretty trivial to fix: all commands should be
checked for non-zero return codes, probably by setting the '-e' flag at the
beginning of the script.
I can't believe this has gone this long without anybody noticing, and how many
people might be trusting this tool for their backups. I'd say this deserves to
be fixed in stable too.
-- System Information:
Debian Release: 10.3
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 4.19.0-6-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_IE.UTF-8, LC_CTYPE=en_IE.UTF-8 (charmap=UTF-8),
LANGUAGE=en_IE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages autopostgresqlbackup depends on:
ii bsd-mailx [mailx] 8.1.2-0.20180807cvs-1
ii postgresql-client-common 200+deb10u3
Versions of packages autopostgresqlbackup recommends:
pn heirloom-mailx | biabam | mutt <none>
ii openssl 1.1.1d-0+deb10u2
Versions of packages autopostgresqlbackup suggests:
ii bzip2 1.0.6-9.2~deb10u1
ii xz-utils 5.2.4-1
-- no debconf information
--- End Message ---
--- Begin Message ---
Source: autopostgresqlbackup
Source-Version: 1.1-1.1
Done: Gunnar Wolf <gw...@debian.org>
We believe that the bug you reported is fixed in the latest version of
autopostgresqlbackup, 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 956...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Gunnar Wolf <gw...@debian.org> (supplier of updated autopostgresqlbackup
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, 10 Mar 2021 10:47:06 -0600
Source: autopostgresqlbackup
Architecture: source
Version: 1.1-1.1
Distribution: unstable
Urgency: medium
Maintainer: Emmanuel Bouthenot <kol...@debian.org>
Changed-By: Gunnar Wolf <gw...@debian.org>
Closes: 956083
Changes:
autopostgresqlbackup (1.1-1.1) unstable; urgency=medium
.
* Non-maintainer upload.
* Detect when a DB dump fails and abort operation (Closes: #956083)
Checksums-Sha1:
96b50e84258b259bf3e7764e4ad1745bbfe08aec 1354 autopostgresqlbackup_1.1-1.1.dsc
c6743f3843d43b119d54be5d2d8aecb04e719633 5000
autopostgresqlbackup_1.1-1.1.debian.tar.xz
1a0920010127e05584bf73e65435111f82875523 6588
autopostgresqlbackup_1.1-1.1_source.buildinfo
Checksums-Sha256:
6bd5d2cc57c9c09c137b8e08ea1336738875076b44e2d2e3b146789fcd8b3a9b 1354
autopostgresqlbackup_1.1-1.1.dsc
e29e17c56ca4419a0723e80058527d7c9ed14ac1c6bd4c6f8edf240526dd0e49 5000
autopostgresqlbackup_1.1-1.1.debian.tar.xz
8cb1589f9ca96b3ff1c80ab2257c3903608da391574d41b1cc7558a73ed9d9e1 6588
autopostgresqlbackup_1.1-1.1_source.buildinfo
Files:
ccdd0c5dbcc2062e6f4b54c373870228 1354 admin optional
autopostgresqlbackup_1.1-1.1.dsc
b1ebfc56c96b67422f1370d5e6ae0b5e 5000 admin optional
autopostgresqlbackup_1.1-1.1.debian.tar.xz
14bc70e18d6699557925fa6728c36330 6588 admin optional
autopostgresqlbackup_1.1-1.1_source.buildinfo
-----BEGIN PGP SIGNATURE-----
iHUEARYIAB0WIQRgswk9lhCOXLlxQu/i9jtDU/RZiQUCYEj/5QAKCRDi9jtDU/RZ
ia+HAQCJCxKWIV2zhbl4gUWJcKibadArQWdKbKkvfMOjQxWzXAD/bnFYDdPnInYo
5lDd7AxQVw0VK4SAZUZ41ETcBwuxmwE=
=9FXZ
-----END PGP SIGNATURE-----
--- End Message ---
