Solution to Bus error(coredump) from postgres binary - Mailing list pgsql-general

Hi,

I'm in the process of building Postgres 7.4.2 on a HP-UX PA Machine. I'm
in a stage where postgres builds properly, but when initdb is run, it is
resulting in a bus error/coredump. The core seems to come from postgres
binary. I tried to look further into this. The point of failure is the
trigger creation of pg_sync_pg_pwd. Please find the details captured
from the machine and the back trace of the core below. I see that there
have already been some mail thread discussion on this particular issue.
But I couldn't find the solution as such. Can you please help me in
fixing this and proceeding with the postgres installation? The
version/details of gcc I have used for compilation is as given below:

PA:/opt/sfmdb/pgsql/bin:>/usr/local/bin/gcc -v
Using built-in specs.
Target: hppa2.0w-hp-hpux11.23
Configured with: ../gcc/configure
Thread model: single
gcc version 4.1.0
PA:/opt/sfmdb/pgsql/bin:>

************************

PA:/opt/sfmdb/pgsql/bin:>/opt/sfmdb/pgsql/bin/initdb -D /tmp/test1
The files belonging to this database system will be owned by user
"test1".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /tmp/test1... ok
creating directory /tmp/test1/base... ok
creating directory /tmp/test1/global... ok
creating directory /tmp/test1/pg_xlog... ok
creating directory /tmp/test1/pg_clog... ok
selecting default max_connections... 100
selecting default shared_buffers... 1000
creating configuration files... ok
creating template1 database in /tmp/test1/base/1... ok
initializing pg_shadow... /opt/sfmdb/pgsql/bin/initdb[662]: 9173 Bus
error(coredump)

initdb: failed
PA:/opt/sfmdb/pgsql/bin:>
***************************

PA:/opt/sfmdb/pgsql/bin:>gdb -c /tmp/test1/base/1/core postgres
HP gdb 5.1.1 for PA-RISC 1.1 or 2.0 (narrow), HP-UX 11.00
and target hppa1.1-hp-hpux11.00.
Copyright 1986 - 2001 Free Software Foundation, Inc.
Hewlett-Packard Wildebeest 5.1.1 (based on GDB) is covered by the
GNU General Public License. Type "show copying" to see the conditions to
change it and/or distribute copies. Type "show warranty" for
warranty/support.
..
Core was generated by `postgres'.
Program terminated with signal 10, Bus error.
Unknown si_code.  Report to HP.
#0  0x1fa6e8 in CreatePortal+0x250 ()
(gdb) bt all
No symbol "all" in current context.
(gdb) bt
#0  0x1fa6e8 in CreatePortal+0x250 ()
#1  0x1fa53c in CreatePortal+0xa4 ()
#2  0x16d420 in exec_simple_query+0x1a8 ()
#3  0x16eb9c in PostgresMain+0x12bc ()
#4  0x10dc7c in main+0x234 ()
(gdb)

**************************
PA:/opt/sfmdb/pgsql/bin:>./postgres -F -D/tmp/test4 -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> CREATE TRIGGER pg_sync_pg_pwd AFTER INSERT OR UPDATE OR DELETE
ON pg_shadow FOR EACH ROW EXECUTE PROCEDURE
update_pg_pwd_and_pg_group();
Bus error(coredump)
PA:/opt/sfmdb/pgsql/bin:>

Thanks a lot,
Sowmiya