Re: [HACKERS] initdb problems

Hi All,

My problems seem to be getting worse!!

Yesterday I was only getting a crash when I tried to create a table.

Today, with the latest from cvs I'm getting a crash on a simple select.

Here's the backtrace:-

Program received signal SIGSEGV, Segmentation fault.
0x95564 in transformTargetList (pstate=0x15c790, targetlist=0x15ec10)
at parse_target.c:583
583 attrname =
strVal(lfirst(att->attrs));
(gdb) bt
#0 0x95564 in transformTargetList (pstate=0x15c790, targetlist=0x15ec10)
at parse_target.c:583
#1 0x885f4 in transformSelectStmt (pstate=0x15c790, stmt=0x15c7d0) at
analyze.c:867
#2 0x877a8 in transformStmt (pstate=0x15c790, parseTree=0x15c7d0) at
analyze.c:190
#3 0x87504 in parse_analyze (pl=0x15eb50, parentParseState=0x0) at analyze.c:76
#4 0x8e8fc in parser (str=0x0, typev=0x0, nargs=0) at parser.c:64
#5 0xaef60 in pg_parse_and_plan (
query_string=0xefffd1a0 " select * from pg_class;", typev=0x0, nargs=0,
queryListP=0xefffd0bc, dest=Remote, aclOverride=0 '\000') at postgres.c:402
#6 0xaf420 in pg_exec_query_dest (
query_string=0xefffd1a0 " select * from pg_class;", dest=Remote,
aclOverride=0 '\000') at postgres.c:668
#7 0xaf3d4 in pg_exec_query (query_string=0xefffd1a0 " select * from
pg_class;")
at postgres.c:643
#8 0xb0388 in PostgresMain (argc=1169408, argv=0xeffff1a0, real_argc=10,
real_argv=0xeffffd84) at postgres.c:1480
#9 0x98f7c in DoBackend (port=0xff400) at postmaster.c:1412
#10 0x989b8 in BackendStartup (port=0x15fc00) at postmaster.c:1191
#11 0x97fe4 in ServerLoop () at postmaster.c:725
#12 0x97b3c in PostmasterMain (argc=0, argv=0xeffffd84) at postmaster.c:534
#13 0x6c30c in main (argc=10, argv=0xeffffd84) at main.c:93

For info, each time I do a cvs update and then copy the entire tree to
another machine. The target directory on the other machine is an empty
/usr/local/pgsql.

I then do a configure/make/make install/initdb before commencing
any testing.

I'm starting to get worried about my hardware/OS as no-one else
seems to be reporting similar problems.

For reference.

SPARC/Linux (Redhat 4.2) running on a SPARCstation IPC.

Is anyone else trying to build the latest source on any SPARC
hardware with any OS? (Solaris,SunOS)

Keith.

Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
>
> Seems like there is some problem with cvs and people seeing all my
> changes, causing initdb problems.
>
> The only solution that has worked for two people is to re-download the
> entire cvs tree.