[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-ports
Subject: Re: [PORTS] Problem with INITDB and "unrecognized node type: 650" - New Info
From: "Mohan, Ross" <RMohan () arbinet ! com>
Date: 2005-06-04 4:50:51
Message-ID: CC74E7E10A8A054798B6611BD1FEF4D30625DB4D () vamail01 ! thexchange ! com
[Download RAW message or body]
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 '
>
>
>
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6603.0">
<TITLE>RE: Problem with INITDB and "unrecognized node type: 650" - New \
Info</TITLE> </HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Here's what happens when \
completely redone without any thread nonsense, </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">and lower \
optimization:</FONT></SPAN> </P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">/usr/local/pgsql/bin/initdb -D \
/usr/local/pgsql/data</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">The files belonging to this \
database system will be owned by user "postgres".</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">This user must also own the \
server process.</FONT></SPAN> </P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">The database cluster will be \
initialized with locale C.</FONT></SPAN> </P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">fixing permissions on existing \
directory /usr/local/pgsql/data ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/global ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/pg_xlog ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/pg_xlog/archive_status ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/pg_clog ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/pg_subtrans ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/base ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/base/1 ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/pg_tblspc ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">selecting default \
max_connections ... 100</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">selecting default \
shared_buffers ... 1000</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating configuration files \
... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating template1 database in \
/usr/local/pgsql/data/base/1 ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">initializing pg_shadow ... \
ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">enabling unlimited row size \
for system tables ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">initializing pg_depend ... \
FATAL: unrecognized node type: 650</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">child process exited with \
exit code 1</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">initdb: removing contents \
of data directory "/usr/local/pgsql/data"</FONT></B></SPAN> </P>
<UL>
<P><SPAN LANG="en-us"><FONT FACE="Courier New"></FONT> <FONT SIZE=1 \
FACE="Tahoma">-----Original Message-----</FONT></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=1 FACE="Tahoma">From: </FONT></B> <FONT \
SIZE=1 FACE="Tahoma">Mohan, Ross </FONT></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=1 FACE="Tahoma">Sent: </FONT></B> \
<FONT SIZE=1 FACE="Tahoma">Saturday, June 04, 2005 12:15 AM</FONT></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=1 \
FACE="Tahoma">To: </FONT></B> <FONT SIZE=1 \
FACE="Tahoma">'Simon Riggs'</FONT></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=1 \
FACE="Tahoma">Cc: </FONT></B> <FONT SIZE=1 \
FACE="Tahoma">'psql-ports@postgresql.org'</FONT></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=1 \
FACE="Tahoma">Subject: </FONT></B> <FONT \
SIZE=1 FACE="Tahoma">Problem with INITDB and "unrecognized node type: \
650"</FONT></SPAN> </P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Simon, </FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Sorry to ping you directly, but \
your recent conversation with Tom Lane</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">on a very similar issue in \
RelOptInfo leads me to believe you'll be</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">able to suss this out \
immediately. </FONT></SPAN> </P>
<BR>
<BR>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Background: \
</FONT></SPAN> </P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">1) Building PG8.0.2 on \
AIX5.3/64bit. </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">2) Configure/Make/Build all \
complete OK. </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">3) I attempt to initdb \
and:</FONT></SPAN> </P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier \
New">##################################################################################################</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">postgres@ \
[/home/app/postgresql-8.0.2] /usr/local/pgsql/bin/initdb -D \
/usr/local/pgsql/data</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">The files belonging to this \
database system will be owned by user "postgres".</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">This user must also own the \
server process.</FONT></SPAN> </P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">The database cluster will be \
initialized with locale C.</FONT></SPAN> </P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">fixing permissions on existing \
directory /usr/local/pgsql/data ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/global ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/pg_xlog ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/pg_xlog/archive_status ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/pg_clog ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/pg_subtrans ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/base ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/base/1 ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating directory \
/usr/local/pgsql/data/pg_tblspc ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">selecting default \
max_connections ... 100</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">selecting default \
shared_buffers ... 1000</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating configuration files \
... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">creating template1 database in \
/usr/local/pgsql/data/base/1 ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">initializing pg_shadow ... \
ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">enabling unlimited row size \
for system tables ... ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">initializing pg_depend ... \
ok</FONT></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">creating system views ... \
WARNING: could not dump unrecognized node type: 650</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">WARNING: could not \
dump unrecognized node type: 650</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">WARNING: could not \
dump unrecognized node type: 650</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">WARNING: could not \
dump unrecognized node type: 650</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">WARNING: could not \
dump unrecognized node type: 650</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">WARNING: could not \
dump unrecognized node type: 650</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">WARNING: could not \
dump unrecognized node type: 650</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">WARNING: could not \
dump unrecognized node type: 650</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Courier New">FATAL: badly \
formatted node string "} {} {} {} {} {} {} {})} \
:rtekin"...</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">child process exited with exit \
code 1</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier \
New">##################################################################################################</FONT></SPAN>
</P>
<BR>
<BR>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">This is generated by initdb.c, \
of course, calling fputs, and PG_CMD_OPEN...It eventually </FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">gets kicked out of outfuncs.c. \
</FONT></SPAN> </P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">I get stuck there: why is this \
happening? Does anything jump out to you?</FONT></SPAN> </P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Any thoughts or comments \
(including, "Why don't you just commit suicide?") most welcome. \
</FONT></SPAN> </P>
<BR>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Thanks. </FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">- Ross Mohan</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">p.s. </FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">compiler flags:</FONT></SPAN>
<BR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">CFLAGS=' -q64 -O4 \
-qnoipa -qphsinfo -qthreaded -I/usr/local/include/readline -I/usr/local/include \
-L/home/app/zlib-1.2.2 -lz '</FONT></SPAN></P> <BR>
<BR>
<BR>
</UL>
</BODY>
</HTML>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic