Hi,
I built and installed PostgreSQL 7.4.2 on a Solaris 2.8 machine. When I run
initdb it core dumps while "vacuuming database template1" in
execUtils.c:783.
Here are the configure flags I used:




configure --with-java --enable-debug --enable-cassert --without-readline --p
refix=/opt/foo/pgsql

I tried 7.4.1, and got the same problem.

....
creating conversions... ok
setting privileges on built-in objects... ok
creating information schema... ok
vacuuming database template1... Segmentation Fault - core dumped


../postgres -F -D/opt/foo/db/pgdatabase -O -c search_path=pg_catalog -c
exit_on_error=true template1

bash$ gdb ./postgres
GNU gdb 6.0
This GDB was configured as "sparc-sun-solaris2.8"...
(gdb) run -F -D/opt/foo/db/pgdatabase -O -c search_path=pg_catalog -c
exit_on_error=true template1
Starting program:
/opt/foo/pgsql/bin/postgres -F -D/opt/foo/db/pgdatabase -O -c
search_path=pg_catalog -c exit_on_error=true template1

POSTGRES backend interactive interface
$Revision: 1.375.2.1 $ $Date: 2003/11/24 14:50:02 $

backend> ANALYZE;
backend> VACUUM FULL FREEZE;

Program received signal SIGSEGV, Segmentation fault.
ExecInsertIndexTuples (slot=0x375100, tupleid=0xffbef4bc, estate=0x37b0a8,
is_vacuum=1 '\001') at execUtils.c:783
783 numIndices = resultRelInfo->ri_NumIndices;
(gdb) where
#0 ExecInsertIndexTuples (slot=0x375100, tupleid=0xffbef4bc,
estate=0x37b0a8, is_vacuum=1 '\001') at execUtils.c:783
#1 0x000d4f5c in repair_frag (vacrelstats=0xffbed448, onerel=0xffbed454,
vacuum_pages=0x0, fraged_pages=0x0, nindexes=0,
Irel=0x2f303030) at vacuum.c:2176
#2 0x000d1a7c in full_vacuum_rel (onerel=0x98, vacstmt=0x27a000) at
vacuum.c:958


$ uname -a
SunOS foo 5.8 Generic_108528-10 sun4u sparc SUNW,Sun-Blade-100

Any ideas?
Thanks



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org