6.4 error with oid type

From: Fuad Abdallah <abdallah(at)mpiz-koeln(dot)mpg(dot)de>
To: hackers(at)postgreSQL(dot)org
Subject: 6.4 error with oid type
Date: 1998-11-10 20:25:42
Message-ID: Pine.SGI.4.02.9811102111040.418061-100000@nazgul.mpiz-koeln.mpg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

after posting this problem to the admin and general group i hope it's ok
to summarize the problem to this list.

I have build postgres 6.4 under irix 6.5.1 with the irix cc 7.2.1
The regression test works without problem but many things still seem to be
broken:

1) destroying a database fails with the following error
ERROR: typeidTypeRelid: Invalid type - oid = 0
destroydb: database destroy failed on test.

2) pg_dump fails
pg_dump error in finding the template1 database

the debug info from the server shows
StartTransactionCommand
query: SELECT oid from pg_database where datname = 'template1'
ProcessQuery
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 422466 exited with
status 139
/usr/local/pgsql/bin/postmaster: CleanupProc: reinitializing shared memory
and semaphores
shmem_exit(0) [#0]

3) vacuum a database reports something unusual
NOTICE: Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES
(915) IS NOT THE SAME AS HEAP' (937)

4) selecting psql \dd command fails
ERROR: typeidTypeRelid: Invalid type - oid = 0

Overall, i guess the handling of the oid type does not seem to work,
selecting oid from any table
crashes the server :-(

I have checked the versions of bison and flex
bison --version
GNU Bison version 1.25
flex --version
flex version 2.5.4

so this is probably not the reason.

The same problem has been reported for DEC OS 4.0d (if i remember it
correctly, using cc -std1).

I would be _very_ pleased if somebody could check this error. If it is
required, a developer can get access to the postgres account on the
machine i used to build postgres.

Best Regards,
Fuad

--
Fuad Abdallah
Max-Planck-Institut fuer Zuechtungsforschung / ZWDV
Tel.: 0221/5062-739 / Priv: 0221/584563

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1998-11-10 21:13:05 Re: [HACKERS] include/port directory?
Previous Message Brook Milligan 1998-11-10 19:04:46 Re: [HACKERS] include/port directory?