Solution to Bus error(coredump) from postgres binary

From: "Jayaprakash, Sowmiya Lakshmi (STSD)" <sowmiya-lakshmi(dot)jayaprakash(at)hp(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Solution to Bus error(coredump) from postgres binary
Date: 2007-08-20 10:42:53
Message-ID: 05BB98D031593641ACFEDDC27FFCEA6502FF4493@qcaexc02.asiapacific.cpqcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-08-20 11:21:50 Re: Help creating a function
Previous Message Andrei Kovalevski 2007-08-20 09:40:54 Re: Installation problems