Thread: BUG #2083: initdb fails with: child process was terminated by signal 11

The following bug has been logged online:

Bug reference:      2083
Logged by:          Wilfried Weiss
Email address:      Wilfried.Weiss@Pilkington.de
PostgreSQL version: 8.1.0
Operating system:   AIX 5.1
Description:        initdb fails with: child process was terminated by
signal 11
Details:

make of PostgreSQL completed without problems:

Configure parms:
./configure --enable-odbc --enable-syslog
--with-includes=/opt/freeware/include --with-libraries=/opt/freew
are/lib --with-tclconfig=/opt/freeware/lib

C-Compiler IBM C for AIX Version 6.0

This worked well until PostgreSQL 8.0.3.

initdb has the following output:

$ initdb -d
Running in debug mode.
VERSION=8.1.0
PGDATA=/database/data
share_path=/usr/local/pgsql/share
PGPATH=/usr/local/pgsql/bin
POSTGRES_SUPERUSERNAME=postgres
POSTGRES_BKI=/usr/local/pgsql/share/postgres.bki
POSTGRES_DESCR=/usr/local/pgsql/share/postgres.description
POSTGRESQL_CONF_SAMPLE=/usr/local/pgsql/share/postgresql.conf.sample
PG_HBA_SAMPLE=/usr/local/pgsql/share/pg_hba.conf.sample
PG_IDENT_SAMPLE=/usr/local/pgsql/share/pg_ident.conf.sample
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 en_US.
The default database encoding has accordingly been set to LATIN1.

fixing permissions on existing directory /database/data ... ok
creating directory /database/data/global ... ok
creating directory /database/data/pg_xlog ... ok
creating directory /database/data/pg_xlog/archive_status ... ok
creating directory /database/data/pg_clog ... ok
creating directory /database/data/pg_subtrans ... ok
creating directory /database/data/pg_twophase ... ok
creating directory /database/data/pg_multixact/members ... ok
creating directory /database/data/pg_multixact/offsets ... ok
creating directory /database/data/base ... ok
creating directory /database/data/base/1 ... ok
creating directory /database/data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in /database/data/base/1 ... DEBUG:  invoking
IpcMemoryCreate(size=1335296)
LOG:  database system was shut down at 2005-12-01 08:40:47 NFT
LOG:  checkpoint record is at 0/20
LOG:  redo record is at 0/20; undo record is at 0/20; shutdown TRUE
LOG:  next transaction ID: 3; next OID: 10000
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system is ready
child process was terminated by signal 11
initdb: removing contents of data directory "/database/data"
$

Wilfried Weiss wrote:
> Configure parms:
> ./configure --enable-odbc --enable-syslog
> --with-includes=/opt/freeware/include --with-libraries=/opt/freew
> are/lib --with-tclconfig=/opt/freeware/lib
>
> C-Compiler IBM C for AIX Version 6.0
>
> This worked well until PostgreSQL 8.0.3.

If you pass configure the flag "--without-readline", does gmake check
succeed?  If it does and you need readline capabilities in the copy of
psql on your AIX box, there are a few options:

  0) use libedit (patching postgres' configure scripts is required
     unless readline is removed from the server)
  1) installing readline 5.0 and replacing your standard 4.3 build
  2) relinking your existing libreadline so that it doesn't export
     strncpy and other functions that it shouldn't
  3) use an external readline wrapper around the readline-less psql

By the way, which maintenance level is your server at?

--
Seneca Cunningham
scunning@ca.afilias.info

Hi Senenca,

I think that I do not need readline, so I will try to recompile --without-r=
eadline.
The server is running AIX 5.1 ML 2. Before I recompile I will apply ML 7, t=
hought I already did it.
As this is an old F40 I cannot upgrade to AIX 5.2 or above, so I have to st=
ay on 5.1.

I think there must have been a major change from 8.0.3 to 8.0.4 as I did no=
t notice any problem on 8.0.3.

Thank you for the quick help.
I will tell you whether it worked.

Regards
Wilfried Weiss

-----Urspr=FCngliche Nachricht-----
Von: Seneca Cunningham [mailto:scunning@ca.afilias.info]
Gesendet: Donnerstag, 1. Dezember 2005 20:22
An: Weiss, Wilfried
Cc: pgsql-bugs@postgresql.org
Betreff: Re: [BUGS] BUG #2083: initdb fails with: child process was
terminated by signal 11


Wilfried Weiss wrote:
> Configure parms:=20
> ./configure --enable-odbc --enable-syslog
> --with-includes=3D/opt/freeware/include --with-libraries=3D/opt/freew
> are/lib --with-tclconfig=3D/opt/freeware/lib
>=20
> C-Compiler IBM C for AIX Version 6.0
>=20
> This worked well until PostgreSQL 8.0.3.

If you pass configure the flag "--without-readline", does gmake check
succeed?  If it does and you need readline capabilities in the copy of
psql on your AIX box, there are a few options:

  0) use libedit (patching postgres' configure scripts is required
     unless readline is removed from the server)
  1) installing readline 5.0 and replacing your standard 4.3 build
  2) relinking your existing libreadline so that it doesn't export
     strncpy and other functions that it shouldn't
  3) use an external readline wrapper around the readline-less psql

By the way, which maintenance level is your server at?

--=20
Seneca Cunningham
scunning@ca.afilias.info