Your message dated Wed, 20 Apr 2011 15:08:30 +0000
with message-id <[email protected]>
and subject line Bug#616180: fixed in postgresql-8.4 8.4.8-1
has caused the Debian Bug report #616180,
regarding postgresql-9.0: FTBFS on sparc64, testsuite issues with int8
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.)
--
616180: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=616180
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-9.0
Version: 9.0.3-1
Severity: important
Tags: patch
User: [email protected]
Usertags: sparc64
postgresql-9.0 fails to build on sparc64 due to testsuite errors with
int8. The division by 0 is not trapped and a SIGFPE is issued instead of
an error.
Postgresql people claims it's a gcc bug, while gcc people says the code
is incorrect [1]. Whatever the real issue is, the fix is very simple
(actually taken in another part from the very same file), so it's
probably the best to simply apply it.
[1] http://gcc.gnu.org/bugzilla/show_bug.cgi?id=29968
--- postgresql-9.0-9.0.3.orig/src/backend/utils/adt/int8.c
+++ postgresql-9.0-9.0.3/src/backend/utils/adt/int8.c
@@ -592,9 +592,13 @@ int8div(PG_FUNCTION_ARGS)
int64 result;
if (arg2 == 0)
+ {
ereport(ERROR,
(errcode(ERRCODE_DIVISION_BY_ZERO),
errmsg("division by zero")));
+ /* ensure compiler realizes we mustn't reach the division (gcc
bug) */
+ PG_RETURN_NULL();
+ }
result = arg1 / arg2;
@@ -815,9 +819,13 @@ int84div(PG_FUNCTION_ARGS)
int64 result;
if (arg2 == 0)
+ {
ereport(ERROR,
(errcode(ERRCODE_DIVISION_BY_ZERO),
errmsg("division by zero")));
+ /* ensure compiler realizes we mustn't reach the division (gcc
bug) */
+ PG_RETURN_NULL();
+ }
result = arg1 / arg2;
@@ -999,9 +1007,13 @@ int82div(PG_FUNCTION_ARGS)
int64 result;
if (arg2 == 0)
+ {
ereport(ERROR,
(errcode(ERRCODE_DIVISION_BY_ZERO),
errmsg("division by zero")));
+ /* ensure compiler realizes we mustn't reach the division (gcc
bug) */
+ PG_RETURN_NULL();
+ }
result = arg1 / arg2;
-- System Information:
Debian Release: wheezy/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: sparc64
Kernel: Linux 2.6.32-bpo.5-sparc64-smp (SMP w/32 CPU cores)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
--- End Message ---
--- Begin Message ---
Source: postgresql-8.4
Source-Version: 8.4.8-1
We believe that the bug you reported is fixed in the latest version of
postgresql-8.4, which is due to be installed in the Debian FTP archive:
postgresql-8.4_8.4.8-1.diff.gz
to main/p/postgresql-8.4/postgresql-8.4_8.4.8-1.diff.gz
postgresql-8.4_8.4.8-1.dsc
to main/p/postgresql-8.4/postgresql-8.4_8.4.8-1.dsc
postgresql-8.4_8.4.8-1_amd64.deb
to main/p/postgresql-8.4/postgresql-8.4_8.4.8-1_amd64.deb
postgresql-8.4_8.4.8.orig.tar.gz
to main/p/postgresql-8.4/postgresql-8.4_8.4.8.orig.tar.gz
postgresql-client-8.4_8.4.8-1_amd64.deb
to main/p/postgresql-8.4/postgresql-client-8.4_8.4.8-1_amd64.deb
postgresql-contrib-8.4_8.4.8-1_amd64.deb
to main/p/postgresql-8.4/postgresql-contrib-8.4_8.4.8-1_amd64.deb
postgresql-doc-8.4_8.4.8-1_all.deb
to main/p/postgresql-8.4/postgresql-doc-8.4_8.4.8-1_all.deb
postgresql-plperl-8.4_8.4.8-1_amd64.deb
to main/p/postgresql-8.4/postgresql-plperl-8.4_8.4.8-1_amd64.deb
postgresql-plpython-8.4_8.4.8-1_amd64.deb
to main/p/postgresql-8.4/postgresql-plpython-8.4_8.4.8-1_amd64.deb
postgresql-pltcl-8.4_8.4.8-1_amd64.deb
to main/p/postgresql-8.4/postgresql-pltcl-8.4_8.4.8-1_amd64.deb
postgresql-server-dev-8.4_8.4.8-1_amd64.deb
to main/p/postgresql-8.4/postgresql-server-dev-8.4_8.4.8-1_amd64.deb
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.
Martin Pitt <[email protected]> (supplier of updated postgresql-8.4 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: Wed, 20 Apr 2011 15:25:02 +0200
Source: postgresql-8.4
Binary: postgresql-8.4 postgresql-client-8.4 postgresql-server-dev-8.4
postgresql-doc-8.4 postgresql-contrib-8.4 postgresql-plperl-8.4
postgresql-plpython-8.4 postgresql-pltcl-8.4
Architecture: source all amd64
Version: 8.4.8-1
Distribution: unstable
Urgency: medium
Maintainer: Martin Pitt <[email protected]>
Changed-By: Martin Pitt <[email protected]>
Description:
postgresql-8.4 - object-relational SQL database, version 8.4 server
postgresql-client-8.4 - front-end programs for PostgreSQL 8.4
postgresql-contrib-8.4 - additional facilities for PostgreSQL
postgresql-doc-8.4 - documentation for the PostgreSQL database management
system
postgresql-plperl-8.4 - PL/Perl procedural language for PostgreSQL 8.4
postgresql-plpython-8.4 - PL/Python procedural language for PostgreSQL 8.4
postgresql-pltcl-8.4 - PL/Tcl procedural language for PostgreSQL 8.4
postgresql-server-dev-8.4 - development files for PostgreSQL 8.4 server-side
programming
Closes: 616180
Changes:
postgresql-8.4 (8.4.8-1) unstable; urgency=medium
.
Priority medium due to data-loss pg_upgrade bug.
.
[ Martin Pitt ]
* New upstream bug fix release:
- If your installation was upgraded from a previous major release by
running pg_upgrade, you should take action to prevent possible data loss
due to a now-fixed bug in pg_upgrade. The recommended solution is to run
"VACUUM FREEZE" on all TOAST tables. More information is available at
http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix.
- Fix pg_upgrade's handling of TOAST tables.
This error poses a significant risk of data loss for installations
that have been upgraded with pg_upgrade. This patch corrects the
problem for future uses of pg_upgrade, but does not in itself cure
the issue in installations that have been processed with a buggy
version of pg_upgrade.
- Suppress incorrect "PD_ALL_VISIBLE flag was incorrectly set"
warning.
- Disallow including a composite type in itself.
- Avoid potential deadlock during catalog cache initialization.
- Fix dangling-pointer problem in BEFORE ROW UPDATE trigger handling
when there was a concurrent update to the target tuple.
- Disallow "DROP TABLE" when there are pending deferred trigger
events for the table.
Formerly the "DROP" would go through, leading to "could not open
relation with OID nnn" errors when the triggers were eventually
fired.
- Prevent crash triggered by constant-false WHERE conditions during
GEQO optimization.
- Improve planner's handling of semi-join and anti-join cases.
- Fix selectivity estimation for text search to account for NULLs.
- Improve PL/pgSQL's ability to handle row types with dropped columns.
- Fix PL/Python memory leak involving array slices.
- Fix pg_restore to cope with long lines (over 1KB) in TOC files.
- Put in more safeguards against crashing due to division-by-zero
with overly enthusiastic compiler optimization. (Closes: #616180)
* debian/control: Stop building the versionless metapackages and client-side
libraries, they are built by postgresql-9.0 now. Add libpq-dev build
dependency.
* debian/rules: Drop check for uninstalled files, since it'd now break the
build due to the uninstalled libraries.
.
[ Matthias Klose ]
* Add 15-bool-altivec.patch: Fix definition of bool on __APPLE_ALTIVEC__
architecture (ppc64).
Checksums-Sha1:
99d3de23d63f2da42b81cf9ced3d9b1761b3049f 2349 postgresql-8.4_8.4.8-1.dsc
2f9fd441098753f9ccaef8cffbd596e40afea379 17658079
postgresql-8.4_8.4.8.orig.tar.gz
78746054a15d7d2a3d0303de8125c68da95a2830 41088 postgresql-8.4_8.4.8-1.diff.gz
d1a4a8c2422803292e454eec061816ad78893f5b 2155644
postgresql-doc-8.4_8.4.8-1_all.deb
ab1c6d7d070520bfc1d62726246e6c70fe466c0a 5367122
postgresql-8.4_8.4.8-1_amd64.deb
2f9c2604497636b7d5853abd7b71724bc75a5d00 1480666
postgresql-client-8.4_8.4.8-1_amd64.deb
16c4c3e281de82e4af06c78e193a5475a70c9b13 644606
postgresql-server-dev-8.4_8.4.8-1_amd64.deb
8ce4b4cbe52bed43753ebc346adb2392ade85fe0 440174
postgresql-contrib-8.4_8.4.8-1_amd64.deb
0e79b818002af3b350dd7ea40b4834416c68719a 61636
postgresql-plperl-8.4_8.4.8-1_amd64.deb
b9c6f930d3deb55b3bea84a87be14502c16d3127 61902
postgresql-plpython-8.4_8.4.8-1_amd64.deb
c7e40fb55793e08b9af5e0a04e70ed6070989201 47914
postgresql-pltcl-8.4_8.4.8-1_amd64.deb
Checksums-Sha256:
6a97f2c03af33942ab180c4cb439fc177e6794949a6c215309785973f950e352 2349
postgresql-8.4_8.4.8-1.dsc
774c0d1f06a216d9534e3724630a96b063009ad1f4ece3fa92ce1f26457bfea4 17658079
postgresql-8.4_8.4.8.orig.tar.gz
f21453430c999353547a0e6a312c3a68f289072b2bb46b9930a34395aa0dce36 41088
postgresql-8.4_8.4.8-1.diff.gz
fd67dc376f425e8ef8d901b4677dda234bca4ab1de68045946a2a6998d5051f1 2155644
postgresql-doc-8.4_8.4.8-1_all.deb
4cbd0380bc68cdd0068b6648aeb4cad5623dd6bd50d8d546c2691eea56febab0 5367122
postgresql-8.4_8.4.8-1_amd64.deb
f6b6ce30db0677a6d2bfbffc28d46d7efa9ea83622d2c9785b7e607722d7874a 1480666
postgresql-client-8.4_8.4.8-1_amd64.deb
332cd12fb5a5e63eb8acc505f044873b2d8c60e40e918a1eb71372a71191a879 644606
postgresql-server-dev-8.4_8.4.8-1_amd64.deb
2e32463e35fae21eb7e66d698d29bc3af4651a4d9e3fb94318394cb56c018b78 440174
postgresql-contrib-8.4_8.4.8-1_amd64.deb
07606d0998a738fbd9debc250aa6a5e0c58007c43c968de7f1192d561521e6d8 61636
postgresql-plperl-8.4_8.4.8-1_amd64.deb
8543b1661be6ed197e486b5367f85e4ecc00f9098501c73696ea61ffc1cb444b 61902
postgresql-plpython-8.4_8.4.8-1_amd64.deb
2323c07b3041f45b73cad8de0e38f3276e4ccb6f5782cc4afb57b9a8f16c5f19 47914
postgresql-pltcl-8.4_8.4.8-1_amd64.deb
Files:
9dece918943725fd4fab02f14e32d39b 2349 database optional
postgresql-8.4_8.4.8-1.dsc
a387ef3727e62b6e082fd2dd02d7a374 17658079 database optional
postgresql-8.4_8.4.8.orig.tar.gz
15b35cad88f630d579a23d3c50768a36 41088 database optional
postgresql-8.4_8.4.8-1.diff.gz
7fb835a4914b8079b5e67c5b5377a593 2155644 doc optional
postgresql-doc-8.4_8.4.8-1_all.deb
ee9a321531a20c439c65e95f12ec484f 5367122 database optional
postgresql-8.4_8.4.8-1_amd64.deb
3bf46ca7ff2f4e8acef2f837be2bf4a3 1480666 database optional
postgresql-client-8.4_8.4.8-1_amd64.deb
ff0c4c89b11806399118cfd365ab7e86 644606 libdevel optional
postgresql-server-dev-8.4_8.4.8-1_amd64.deb
10d35206c18dea0b9c834acbda0453c8 440174 database optional
postgresql-contrib-8.4_8.4.8-1_amd64.deb
eaaae1fe711a0192faa1587de9347961 61636 database optional
postgresql-plperl-8.4_8.4.8-1_amd64.deb
8a3d421009d2684d6bb5ce4bad5f3553 61902 database optional
postgresql-plpython-8.4_8.4.8-1_amd64.deb
701240b511869e61083fafa90c36c715 47914 database optional
postgresql-pltcl-8.4_8.4.8-1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iQIcBAEBCAAGBQJNruO2AAoJEPmIJawmtHuf+iYQALBd9DCIDgChNggBYPFEZ+bw
yr1YX4flw7boTl/QZulcfO5Hoq51o4QuWrhpjg55yXD5DogHM3RH0ddYfKS8FYuE
o/AeZOHi0eA9xZMPN5957Q/lgCuPy+28C7scmhVmrFoJ+VxwLtkLjCHZmr/O0L4H
YvM2JqhT/aVyh4OPg58U7td89A5C0CyTJGal+FXg8kEbM/GUck214pNuPFyDjXda
h0tLv0mEW6s05XyVxyhWy/7HSzAxm3qCsgvOSf8EiLTTtkHyw7eDDNszbiGnL6Ru
Fztu3DbrEgQnQElK3iXtnK2y4umW6yMiisi0jgQpuwb7P8JFElay/3YRzNFL6/cz
VOke4xCnfoHUnoNBhonBT0NHdhxa4GqFQDLlWewpiw5Tr0avsdOXi8LvN/tD4R0C
8mVk2ZuNRmUQRAAdYboAugiG1ZOX382xc+QDDtWX51XEn0VrFyYRQ0asUk9wHGXY
H+zZ+Jt995ysWksZE/2y05tPFhJ0Mm0d7RMVXI44KSlqXxBl7BrZSqNj16eQRsqe
qMYainjnsqlLgsXhdPNtXiJ5h5dE4gOh+P7Nfd9u0m5AbjI+L5MVrauqnh3tV33K
d8QvYvm6Z6ryfYflfmm2SXlFd5mwlL7nbNIWx2JpCpwyk7JKR59vXeeAIonVmSYF
giRENnUt7sw//tbi6QC7
=pH7h
-----END PGP SIGNATURE-----
--- End Message ---
