Re: Problem with INITDB and "unrecognized node type: 650" - New Info - Mailing list pgsql-ports

Here's what happens when completely redone without any thread nonsense,
and lower optimization:

/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
creating directory /usr/local/pgsql/data/pg_xlog ... ok
creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/data/pg_clog ... ok
creating directory /usr/local/pgsql/data/pg_subtrans ... ok
creating directory /usr/local/pgsql/data/base ... ok
creating directory /usr/local/pgsql/data/base/1 ... ok
creating directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1000
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... ok
initializing pg_shadow ... ok
enabling unlimited row size for system tables ... ok
initializing pg_depend ... FATAL:  unrecognized node type: 650
child process exited with exit code 1
initdb: removing contents of data directory "/usr/local/pgsql/data"

 -----Original Message-----
From:   Mohan, Ross 
Sent:   Saturday, June 04, 2005 12:15 AM
To:     'Simon Riggs'
Cc:     'psql-ports@postgresql.org'
Subject:        Problem with INITDB and "unrecognized node type: 650"

Simon,

Sorry to ping you directly, but your recent conversation with Tom Lane
on a very similar issue in RelOptInfo leads me to believe you'll be
able to suss this out immediately.



Background: 

1) Building PG8.0.2 on AIX5.3/64bit.
2) Configure/Make/Build all complete OK.
3) I attempt to initdb and:

##################################################################################################
postgres@ [/home/app/postgresql-8.0.2] /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
creating directory /usr/local/pgsql/data/pg_xlog ... ok
creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/data/pg_clog ... ok
creating directory /usr/local/pgsql/data/pg_subtrans ... ok
creating directory /usr/local/pgsql/data/base ... ok
creating directory /usr/local/pgsql/data/base/1 ... ok
creating directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1000
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... ok
initializing pg_shadow ... ok
enabling unlimited row size for system tables ... ok
initializing pg_depend ... ok
creating system views ... WARNING:  could not dump unrecognized node type: 650
WARNING:  could not dump unrecognized node type: 650
WARNING:  could not dump unrecognized node type: 650
WARNING:  could not dump unrecognized node type: 650
WARNING:  could not dump unrecognized node type: 650
WARNING:  could not dump unrecognized node type: 650
WARNING:  could not dump unrecognized node type: 650
WARNING:  could not dump unrecognized node type: 650
FATAL:  badly formatted node string "} {} {} {} {} {} {} {})} :rtekin"...
child process exited with exit code 1
##################################################################################################



This is generated by initdb.c, of course, calling fputs, and PG_CMD_OPEN...It eventually
gets kicked out of outfuncs.c.

I get stuck there: why is this happening? Does anything jump out to you?

Any thoughts or comments (including, "Why don't you just commit suicide?") most welcome.


Thanks.

- Ross Mohan

p.s. 

compiler flags:
CFLAGS=' -q64  -O4 -qnoipa -qphsinfo -qthreaded  -I/usr/local/include/readline -I/usr/local/include -L/home/app/zlib-1.2.2 -lz '