Thread: Problems creating view

Problems creating view

From
Martín Marqués
Date:
I'm having troble creating a view here. Particularly, each time I try to
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 = ugp.grupo;
LOG:  proceso de servidor (PID 12716) fue terminado por una señal 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:08 ART
LOG:  el registro de checkpoint está en 0/EBE6C90
LOG:  registro de redo en 0/EBE6C90; registro de undo en 0/0; apagado TRUE
LOG:  siguiente ID de transacción: 316713; siguiente OID: 781400
LOG:  el sistema de bases de datos no fue apagado apropiadamente; se está
efectuando la recuperación automática
LOG:  conexión recibida: host=[local] port=
FATAL:  el sistema de base de datos está iniciándose
LOG:  redo comienza en 0/EBE6CD0
LOG:  la dirección de página 0/8C00000 en el archivo de registro 0, segmento
14, posición 12582912 es inesperada
LOG:  redo listo en 0/EBFF350
LOG:  el sistema de bases de datos está listo


I can't create any VIEW at all. I'm using the latest debian testing PostgreSQL
(8.0.3):

martin@bugs:/space/home/martin$ dpkg -l postgresql-8.0
Desired=Unknown/Install/Remove/Purge/Hold

ii postgresql-8.0  8.0.3-15 object-relational SQL database, version 8.0 server

I don't know if to report a BUG to the debian guys. I just upgraded yesterday
PostgreSQL.

--
 09:04:54 up 7 days, 14:22,  2 users,  load average: 1.12, 1.68, 1.35
---------------------------------------------------------
Lic. Martín Marqués         |   SELECT 'mmarques' ||
Centro de Telemática        |       '@' || 'unl.edu.ar';
Universidad Nacional        |   DBA, Programador,
    del Litoral             |   Administrador
---------------------------------------------------------

Re: Problems creating view

From
Tom Lane
Date:
=?iso-8859-1?q?Mart=EDn_Marqu=E9s?= <martin@bugs.unl.edu.ar> writes:
> I can't create any VIEW at all. I'm using the latest debian testing PostgreSQL
> (8.0.3):

Maybe you got a corrupt download?

            regards, tom lane

Re: Problems creating view

From
Martín Marqués
Date:
El Sáb 24 Sep 2005 13:15, Tom Lane escribió:
> =?iso-8859-1?q?Mart=EDn_Marqu=E9s?= <martin@bugs.unl.edu.ar> writes:
> > I can't create any VIEW at all. I'm using the latest debian testing
> > PostgreSQL (8.0.3):
>
> Maybe you got a corrupt download?

How can I seek if it's a corrupt download or something else?

OK, I filed a BUG report at debian.org, even sent mail to Oliver and Martin
(the 2 persons that appear in de packagers list). I have had absolutly no
responce on the subject, and I really need to have this solved.

What should I do now?

--
 09:13:25 up 11 days, 14:30,  2 users,  load average: 1.75, 1.54, 1.42
---------------------------------------------------------
Lic. Martín Marqués         |   SELECT 'mmarques' ||
Centro de Telemática        |       '@' || 'unl.edu.ar';
Universidad Nacional        |   DBA, Programador,
    del Litoral             |   Administrador
---------------------------------------------------------

Re: Problems creating view

From
Martín Marqués
Date:
Just for the record, and put some closure, today I finaly got unstable
packages for postgresql-8.0 (up to yesterday the unstable package was the
same as the testing one on SPARC) and this problem creating views is gone.
From the changelog it looks like a bus error:

postgresql-8.0 (8.0.3-16) unstable; urgency=medium

  * Urgency medium since this fixes two release critical bugs in testing.
  * libpq-dev: Add missing dependency libssl-dev. Closes: #327380
  * Add debian/patches/07-relax-sslkey-permscheck.patch:
    - Relax security check on private SSL key file: The file is also
      considered safe if it has owner and/or group "root", and if it is
      group-readable (unless the group is something other than root or the
      database owner group).
    - Closes: #327901
  * Build with gcc 3.3 on ia64, hppa, mips, mipsel, and sparc. Building with
    gcc 4.0 causes bus errors. See bug #329197.

 -- Martin Pitt <mpitt@debian.org>  Wed, 21 Sep 2005 23:20:27 +0200

Thanks to all

El Mié 28 Sep 2005 09:16, Martín Marqués escribió:
> El Sáb 24 Sep 2005 13:15, Tom Lane escribió:
> > =?iso-8859-1?q?Mart=EDn_Marqu=E9s?= <martin@bugs.unl.edu.ar> writes:
> > > I can't create any VIEW at all. I'm using the latest debian testing
> > > PostgreSQL (8.0.3):
> >
> > Maybe you got a corrupt download?
>
> How can I seek if it's a corrupt download or something else?
>
> OK, I filed a BUG report at debian.org, even sent mail to Oliver and Martin
> (the 2 persons that appear in de packagers list). I have had absolutly no
> responce on the subject, and I really need to have this solved.
>
> What should I do now?

--
 07:33:54 up 12 days, 12:51,  2 users,  load average: 1.91, 1.90, 1.75
---------------------------------------------------------
Lic. Martín Marqués         |   SELECT 'mmarques' ||
Centro de Telemática        |       '@' || 'unl.edu.ar';
Universidad Nacional        |   DBA, Programador,
    del Litoral             |   Administrador
---------------------------------------------------------

Re: Problems creating view

From
Martijn van Oosterhout
Date:
On Thu, Sep 29, 2005 at 07:38:38AM -0300, Martín Marqués wrote:
> Just for the record, and put some closure, today I finaly got unstable
> packages for postgresql-8.0 (up to yesterday the unstable package was the
> same as the testing one on SPARC) and this problem creating views is gone.
> From the changelog it looks like a bus error:
>
> postgresql-8.0 (8.0.3-16) unstable; urgency=medium

<snip>

>   * Build with gcc 3.3 on ia64, hppa, mips, mipsel, and sparc. Building with
>     gcc 4.0 causes bus errors. See bug #329197.

Ah yes, I don't think PostgreSQL is particularly tested on gcc 4.0,
especially on non-i386. The core hackers are working through it though.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment