Your message dated Tue, 20 Dec 2005 11:17:23 -0800
with message-id <[EMAIL PROTECTED]>
and subject line Bug#330296: fixed in postgresql-8.0 8.0.5-1
has caused the attached Bug report 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 I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 27 Sep 2005 11:06:11 +0000
>From martin@bugs.unl.edu.ar Tue Sep 27 04:06:11 2005
Return-path: <martin@bugs.unl.edu.ar>
Received: from bugs.unl.edu.ar [168.96.132.208]
by spohr.debian.org with esmtp (Exim 3.36 1 (Debian))
id 1EKDHm-0002mD-00; Tue, 27 Sep 2005 04:06:11 -0700
Received: from localhost (localhost [127.0.0.1])
by bugs.unl.edu.ar (Postfix) with ESMTP id 7268011E4A;
Tue, 27 Sep 2005 08:02:04 -0300 (ART)
Received: from bugs.unl.edu.ar ([127.0.0.1])
by localhost (bugs [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
id 04692-05; Tue, 27 Sep 2005 08:02:04 -0300 (ART)
Received: by bugs.unl.edu.ar (Postfix, from userid 1000)
id B158B11DBC; Tue, 27 Sep 2005 08:02:03 -0300 (ART)
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
From: Martin Marques <martin@bugs.unl.edu.ar>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: postgresql-8.0: Can't create VIEWS with latest testing upgrade
X-Mailer: reportbug 3.17
Date: Tue, 27 Sep 2005 08:02:03 -0300
Message-Id: <[EMAIL PROTECTED]>
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at bugs.unl.edu.ar
Content-Transfer-Encoding: quoted-printable
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2005_01_02
Package: postgresql-8.0
Version: 8.0.3-15
Severity: normal
I'm having troble creating a view here. Particularly, each time I try to=20
create a view, I get a FATAL error and the database server restarts.
Here are the logs:
LOG: sentencia: CREATE VIEW biblioteca.permisosoperadorprocesos AS
SELECT uag.admin, ugp.proceso
FROM unionadmingrupo uag, uniongrupoproceso ugp
WHERE uag.grupo =3D ugp.grupo;
LOG: proceso de servidor (PID 12716) fue terminado por una se=F1al 10
LOG: terminando todos los otros procesos de servidor activos
LOG: todos los procesos fueron terminados; reinicializando
LOG: el sistema de bases de datos fue interrumpido en 2005-09-24 09:06:0=
8 ART
LOG: el registro de checkpoint est=E1 en 0/EBE6C90
LOG: registro de redo en 0/EBE6C90; registro de undo en 0/0; apagado TRU=
E
LOG: siguiente ID de transacci=F3n: 316713; siguiente OID: 781400
LOG: el sistema de bases de datos no fue apagado apropiadamente; se est=E1=
=20
efectuando la recuperaci=F3n autom=E1tica
LOG: conexi=F3n recibida: host=3D[local] port=3D
FATAL: el sistema de base de datos est=E1 inici=E1ndose
LOG: redo comienza en 0/EBE6CD0
LOG: la direcci=F3n de p=E1gina 0/8C00000 en el archivo de registro 0, s=
egmento=20
14, posici=F3n 12582912 es inesperada
LOG: redo listo en 0/EBFF350
LOG: el sistema de bases de datos est=E1 listo
This is on my SUN Ultra5 SPARC.
Table creation is OK, but I get these errors with any view, not just this=
=20
one, that I try to create.
-- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (800, 'testing'), (500, 'stable'), (50, 'unstable')
Architecture: sparc (sparc64)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.12-1-sparc64
Locale: LANG=3Des_AR, LC_CTYPE=3Des_AR (charmap=3DISO-8859-1)
Versions of packages postgresql-8.0 depends on:
ii libc6 2.3.5-6 GNU C Library: Shared librar=
ies an
ii libcomerr2 1.38-2 common error description lib=
rary
ii libkrb53 1.3.6-5 MIT Kerberos runtime librari=
es
ii libpam0g 0.76-23 Pluggable Authentication Mod=
ules l
ii libpq4 8.0.3-15 PostgreSQL C client library
ii libreadline5 5.0-10 GNU readline and history lib=
raries
ii libssl0.9.7 0.9.7g-2 SSL shared libraries
ii postgresql-client-8.0 8.0.3-15 front-end programs for Postg=
reSQL=20
ii postgresql-common 26 manager for PostgreSQL datab=
ase cl
ii zlib1g 1:1.2.3-4 compression library - runtim=
e
postgresql-8.0 recommends no packages.
-- no debconf information
---------------------------------------
Received: (at 330296-close) by bugs.debian.org; 20 Dec 2005 19:21:35 +0000
>From [EMAIL PROTECTED] Tue Dec 20 11:21:35 2005
Return-path: <[EMAIL PROTECTED]>
Received: from katie by spohr.debian.org with local (Exim 4.50)
id 1EomzD-0003uV-7G; Tue, 20 Dec 2005 11:17:23 -0800
From: Martin Pitt <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
X-Katie: $Revision: 1.65 $
Subject: Bug#330296: fixed in postgresql-8.0 8.0.5-1
Message-Id: <[EMAIL PROTECTED]>
Sender: Archive Administrator <[EMAIL PROTECTED]>
Date: Tue, 20 Dec 2005 11:17:23 -0800
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-CrossAssassin-Score: 2
Source: postgresql-8.0
Source-Version: 8.0.5-1
We believe that the bug you reported is fixed in the latest version of
postgresql-8.0, which is due to be installed in the Debian FTP archive:
postgresql-8.0_8.0.5-1.diff.gz
to pool/main/p/postgresql-8.0/postgresql-8.0_8.0.5-1.diff.gz
postgresql-8.0_8.0.5-1.dsc
to pool/main/p/postgresql-8.0/postgresql-8.0_8.0.5-1.dsc
postgresql-8.0_8.0.5-1_i386.deb
to pool/main/p/postgresql-8.0/postgresql-8.0_8.0.5-1_i386.deb
postgresql-8.0_8.0.5.orig.tar.gz
to pool/main/p/postgresql-8.0/postgresql-8.0_8.0.5.orig.tar.gz
postgresql-client-8.0_8.0.5-1_i386.deb
to pool/main/p/postgresql-8.0/postgresql-client-8.0_8.0.5-1_i386.deb
postgresql-contrib-8.0_8.0.5-1_i386.deb
to pool/main/p/postgresql-8.0/postgresql-contrib-8.0_8.0.5-1_i386.deb
postgresql-doc-8.0_8.0.5-1_all.deb
to pool/main/p/postgresql-8.0/postgresql-doc-8.0_8.0.5-1_all.deb
postgresql-plperl-8.0_8.0.5-1_i386.deb
to pool/main/p/postgresql-8.0/postgresql-plperl-8.0_8.0.5-1_i386.deb
postgresql-plpython-8.0_8.0.5-1_i386.deb
to pool/main/p/postgresql-8.0/postgresql-plpython-8.0_8.0.5-1_i386.deb
postgresql-pltcl-8.0_8.0.5-1_i386.deb
to pool/main/p/postgresql-8.0/postgresql-pltcl-8.0_8.0.5-1_i386.deb
postgresql-server-dev-8.0_8.0.5-1_i386.deb
to pool/main/p/postgresql-8.0/postgresql-server-dev-8.0_8.0.5-1_i386.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.0 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: SHA1
Format: 1.7
Date: Tue, 20 Dec 2005 18:35:24 +0100
Source: postgresql-8.0
Binary: postgresql-client-8.0 postgresql-plperl-8.0 postgresql-doc-8.0
postgresql-pltcl-8.0 postgresql-plpython-8.0 postgresql-contrib-8.0
postgresql-server-dev-8.0 postgresql-8.0
Architecture: source i386 all
Version: 8.0.5-1
Distribution: unstable
Urgency: low
Maintainer: Martin Pitt <[EMAIL PROTECTED]>
Changed-By: Martin Pitt <[EMAIL PROTECTED]>
Description:
postgresql-8.0 - object-relational SQL database, version 8.0 server
postgresql-client-8.0 - front-end programs for PostgreSQL 8.0
postgresql-contrib-8.0 - additional facilities for PostgreSQL
postgresql-doc-8.0 - documentation for the PostgreSQL database management
system
postgresql-plperl-8.0 - PL/Perl procedural language for PostgreSQL 8.0
postgresql-plpython-8.0 - PL/Python procedural language for PostgreSQL 8.0
postgresql-pltcl-8.0 - PL/TCL procedural language for PostgreSQL 8.0
postgresql-server-dev-8.0 - development files for PostgreSQL 8.0 server-side
programming
Closes: 330296 342349 342583 342740
Changes:
postgresql-8.0 (8.0.5-1) unstable; urgency=low
.
* New upstream bugfix release, relevant changes:
- Fix race condition in transaction log management.
- Fix bgwriter problems after recovering from errors.
- Prevent failure if client sends Bind protocol message when current
transaction is already aborted.
- "/contrib/ltree" fixes.
- Fix intermittent failure when log_line_prefix includes %i.
- Fix missing updates of "pg_group" flat file.
- Fix longstanding planning error for outer joins.
- Postpone timezone initialization until after "postmaster.pid" is
created. This avoids confusing startup scripts that expect the pid file
to appear quickly.
- Prevent core dump in pg_autovacuum when a table has been dropped.
- Fix problems with whole-row references (foo.*) to subquery results.
* Remove debian/patches/08-pg_group-update.patch (upstream now).
* debian/postgresql-8.0.postrm: Check if a /etc/postgresql/8.0 subdirectory
is really a cluster directory before trying to remove it. Closes: #342349
* debian/postgresql-8.0.postrm: Also clean start.conf if purging without
pg_dropcluster.
* Remove debian/patches/13-server-includedir.patch and fix --includedir
configure parameter. This was an obsolete modification from the time when
libpq was built from 8.0. Now p-server-dev-8.0 does not break the builds
of server extensions any more. Closes: #342583
* debian/control: Remove useless libpq-dev dependency of p-server-dev-8.0.
* postgresql-server-dev-8.0, Makefile.global: Change CC and CPP variables
back to the canonical 'cc' and 'cc -E' values. Closes: #342740
* debian/rules: Fail the build if the test suite fails. This will happen on
mips and mipsel, PostgreSQL does not work on these architectures. The mips
and mipsel binaries will be removed from sid and testing. Closes: #330296
* Add debian/patches/11-testsuite-ignore-horology.patch: Ignore 'horology'
test suite failure for now until the test suite can be persuaded to use
the timezone data from the temporary installation instead of the installed
system.
* Add debian/patches/11-testsuite-ignore-stats.patch: Ignore 'stats' test
suite failure for now until buildds are fixed which cannot resolve
'localhost'.
Files:
5351b12b9a47cbdac3ef7dfbae684c4c 1073 misc optional postgresql-8.0_8.0.5-1.dsc
2335779c98ffb8a4074f41a32d64609b 10876120 misc optional
postgresql-8.0_8.0.5.orig.tar.gz
683d8bf37774be33fe0b31acc7cd455d 20802 misc optional
postgresql-8.0_8.0.5-1.diff.gz
14ea59831a3cfd0888271bd08a2d8a55 1275978 doc optional
postgresql-doc-8.0_8.0.5-1_all.deb
8a9be84a90925cd64e6fe283cbd1ed3e 3979470 misc optional
postgresql-8.0_8.0.5-1_i386.deb
6f42b6019f30998fa9eac588d2c30ebf 1162848 misc optional
postgresql-client-8.0_8.0.5-1_i386.deb
2fe9ac8bcdc5556433558788013c8fdf 476578 libdevel optional
postgresql-server-dev-8.0_8.0.5-1_i386.deb
91ba2b03367119fec2fefd3705ede4cf 495556 misc optional
postgresql-contrib-8.0_8.0.5-1_i386.deb
74253a3dc585ce7cbfd662e09ad6672c 30426 misc optional
postgresql-plperl-8.0_8.0.5-1_i386.deb
5041ea09cd4e1246712643b946dbd2c5 26208 misc optional
postgresql-plpython-8.0_8.0.5-1_i386.deb
2703e2e7fe4f3f77dc464f0f9b42ed06 27710 misc optional
postgresql-pltcl-8.0_8.0.5-1_i386.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFDqFUZDecnbV4Fd/IRArWHAKC9Pgmz6+PWPebOkW/FkT8RBhOuNACcCBOF
K1sPYO/D/kktyHt6UCLn+ho=
=G6Tq
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
