FAQ
Hello,

I am trying to set up pgsql on AIX 5.3L (2/2006)
I am using gcc 3.3 (the version supplied by IBM (Linux application toolkit for AIX))
running make produced the following output

rm -rf ./testtablespace
mkdir ./testtablespace
/bin/sh ./pg_regress --temp-install --top-builddir=../../.. --temp-port=55432 --schedule=./parallel_schedule --multibyte=SQL_ASCII --load-language=plpgsql
============== removing existing temp installation ==============
============== creating temporary installation ==============
============== initializing database system ==============

pg_regress: initdb failed
Examine ./log/initdb.log for the reason.

gmake[2]: *** [check] Error 2
gmake[2]: Leaving directory `/installs/PostgreSQL/postgresql-8.1.4/src/test/regress'
gmake[1]: *** [check] Error 2
gmake[1]: Leaving directory `/installs/PostgreSQL/postgresql-8.1.4/src/test'
gmake: *** [check] Error 2
make: 1254-004 The error code from the last command is 2.


Stop.

and I find the following in the logs.
(attached)

I am using user pgsql which was created specifically for postgre who owns the installation directory.
the directories are chmoded 777 just to make sure no permission are causing problems.

any clues?

Search Discussions

  • Tom Lane at Aug 11, 2006 at 12:53 pm

    Nzer Zaidenberg writes:
    I am trying to set up pgsql on AIX 5.3L (2/2006)
    I am using gcc 3.3 (the version supplied by IBM (Linux application toolkit for AIX))
    See doc/FAQ_AIX in the source distribution, or the latest version here:
    http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ_AIX

    The short answer seems to be that you need a newer gcc :-( and there may
    be various other issues depending on just how up-to-date your AIX is.

    regards, tom lane
  • Nzer Zaidenberg at Aug 12, 2006 at 11:41 am
    I have updated AIX 5.3L (suma update) to the latest level.
    I have tried newer flavours of gcc
    (first 4.0.0-1 from Linux Toolbox for AIX then 4.1.1)

    same error:

    ============== removing existing temp installation ==============
    ============== creating temporary installation ==============
    ============== initializing database system ==============

    pg_regress: initdb failed
    Examine ./log/initdb.log for the reason.

    gmake[2]: *** [check] Error 2
    gmake[2]: Leaving directory `/installs/PostgreSQL/postgresql-8.1.4/src/test/regress'
    gmake[1]: *** [check] Error 2
    gmake[1]: Leaving directory `/installs/PostgreSQL/postgresql-8.1.4/src/test'
    gmake: *** [check] Error 2
    make: 1254-004 The error code from the last command is 2.


    Stop.
    gcc --version
    gcc (GCC) 4.1.1
    Copyright (C) 2006 Free Software Foundation, Inc.
    This is free software; see the source for copying conditions. There is NO
    warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

    the log says
    tail ./src/test/regress/log/initdb.log
    creating directory /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/pg_multixact/members ... ok
    creating directory /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/pg_multixact/offsets ... ok
    creating directory /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/base ... ok
    creating directory /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/base/1 ... ok
    creating directory /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/pg_tblspc ... ok
    selecting default max_connections ... 10
    selecting default shared_buffers ... 50
    creating configuration files ... ok
    creating template1 database in /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/base/1 ... child process was terminated by signal 11
    initdb: data directory "/installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data" not removed at user's request

    any clues?

    thanks in advance

    Nezer J. Zaidenberg


    ----- Original Message ----
    From: Tom Lane <tgl@sss.pgh.pa.us>
    To: Nzer Zaidenberg <scipioenterprises@yahoo.com>
    Cc: pgsql-ports@postgresql.org
    Sent: Friday, August 11, 2006 3:53:10 PM
    Subject: Re: [PORTS] Problem compiling PostgreSQL 8.1.4 on AIX.

    Nzer Zaidenberg <scipioenterprises@yahoo.com> writes:
    I am trying to set up pgsql on AIX 5.3L (2/2006)
    I am using gcc 3.3 (the version supplied by IBM (Linux application toolkit for AIX))
    See doc/FAQ_AIX in the source distribution, or the latest version here:
    http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ_AIX

    The short answer seems to be that you need a newer gcc :-( and there may
    be various other issues depending on just how up-to-date your AIX is.

    regards, tom lane

    ---------------------------(end of broadcast)---------------------------
    TIP 3: Have you checked our extensive FAQ?

    http://www.postgresql.org/docs/faq
  • Tom Lane at Aug 12, 2006 at 3:42 pm

    Nzer Zaidenberg writes:
    same error:
    creating template1 database in /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/base/1 ... child process was terminated by signal 11
    initdb: data directory "/installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data" not removed at user's request
    OK, that crash should be leaving a core file --- try to get a stack
    trace from the core and post it here. If you didn't already configure
    with --enable-debug, do so and rebuild, else the trace won't be very
    useful. If you're not familar with gdb, the basic idea is

    $ gdb /path/to/postgres-executable /path/to/corefile
    gdb> bt
    gdb> q

    regards, tom lane
  • Nzer Zaidenberg at Aug 12, 2006 at 9:17 pm
    Hello Tom,

    Thanks for your prompt responses so far.

    I have reconfigured and rebuild as you advice.

    and i even have a core file. the problem is i have no clue which executable generated the core file.
    I tried some that looked trivial but they were not it.

    Is the a way to deduce based on the log or the script what executable has failed?

    PS> I am fully capable of using gdb.

    Thanks in advance.
    Nezer J. Zaidenebrg

    ----- Original Message ----
    From: Tom Lane <tgl@sss.pgh.pa.us>
    To: Nzer Zaidenberg <scipioenterprises@yahoo.com>
    Cc: pgsql-ports@postgresql.org
    Sent: Saturday, August 12, 2006 6:41:51 PM
    Subject: Re: [PORTS] Problem compiling PostgreSQL 8.1.4 on AIX.

    Nzer Zaidenberg <scipioenterprises@yahoo.com> writes:
    same error:
    creating template1 database in /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/base/1 ... child process was terminated by signal 11
    initdb: data directory "/installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data" not removed at user's request
    OK, that crash should be leaving a core file --- try to get a stack
    trace from the core and post it here. If you didn't already configure
    with --enable-debug, do so and rebuild, else the trace won't be very
    useful. If you're not familar with gdb, the basic idea is

    $ gdb /path/to/postgres-executable /path/to/corefile
    gdb> bt
    gdb> q

    regards, tom lane

    ---------------------------(end of broadcast)---------------------------
    TIP 1: if posting/reading through Usenet, please send an appropriate
    subscribe-nomail command to majordomo@postgresql.org so that your
    message can get through to the mailing list cleanly
  • Nzer Zaidenberg at Aug 12, 2006 at 9:21 pm
    found the process.
    here it goes

    # /usr/local/bin/gdb -c ./src/test/regress/tmp_check/data/core ./src/test/regress/tmp_check/install/usr/local/pgsql/bin/postgres
    GNU gdb 6.5
    Copyright (C) 2006 Free Software Foundation, Inc.
    GDB is free software, covered by the GNU General Public License, and you are
    welcome to change it and/or distribute copies of it under certain conditions.
    Type "show copying" to see the conditions.
    There is absolutely no warranty for GDB. Type "show warranty" for details.
    This GDB was configured as "powerpc-ibm-aix5.3.0.0"...
    ptrace ldinfo: The process does not exist..
    (gdb) bt
    #0 0x3ff29d04 in ?? ()
    #1 0x100206d0 in hash_search (hashp=0x2009bdc0, keyPtr=0x2009ddf8,
    action=HASH_ENTER, foundPtr=0x2009cc60 "") at dynahash.c:673
    #2 0x1004e2bc in formrdesc (relationName=0x2001e660 "",
    relationReltype=4294967295, hasoids=25 '\031', natts=25, att=0x2001dc38)
    at relcache.c:1295
    #3 0x1004fba0 in RelationCacheInitialize () at relcache.c:2185
    #4 0x102033e0 in InitPostgres (dbname=0x20081ef8 "template1", username=0x0)
    at postinit.c:424
    #5 0x10202d50 in BootstrapMain (argc=536872568, argv=0x20081e3c)
    at bootstrap.c:445
    #6 0x10000604 in main (argc=5, argv=0x20081ec8) at main.c:294
    (gdb)

    thanks
    Nezer J. Zaidenberg

    ----- Original Message ----
    From: Tom Lane <tgl@sss.pgh.pa.us>
    To: Nzer Zaidenberg <scipioenterprises@yahoo.com>
    Cc: pgsql-ports@postgresql.org
    Sent: Saturday, August 12, 2006 6:41:51 PM
    Subject: Re: [PORTS] Problem compiling PostgreSQL 8.1.4 on AIX.

    Nzer Zaidenberg <scipioenterprises@yahoo.com> writes:
    same error:
    creating template1 database in /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/base/1 ... child process was terminated by signal 11
    initdb: data directory "/installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data" not removed at user's request
    OK, that crash should be leaving a core file --- try to get a stack
    trace from the core and post it here. If you didn't already configure
    with --enable-debug, do so and rebuild, else the trace won't be very
    useful. If you're not familar with gdb, the basic idea is

    $ gdb /path/to/postgres-executable /path/to/corefile
    gdb> bt
    gdb> q

    regards, tom lane

    ---------------------------(end of broadcast)---------------------------
    TIP 1: if posting/reading through Usenet, please send an appropriate
    subscribe-nomail command to majordomo@postgresql.org so that your
    message can get through to the mailing list cleanly
  • Tom Lane at Aug 14, 2006 at 1:28 am

    Nzer Zaidenberg writes:
    (gdb) bt
    #0 0x3ff29d04 in ?? ()
    #1 0x100206d0 in hash_search (hashp=0x2009bdc0, keyPtr=0x2009ddf8,
    action=HASH_ENTER, foundPtr=0x2009cc60 "") at dynahash.c:673
    That's the dynahash.c problem mentioned in FAQ_AIX. AFAICT this is
    a compiler bug in that particular AIX release, which you can work around
    by applying the patch given in the FAQ entry.

    regards, tom lane

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedAug 11, '06 at 12:44p
activeAug 14, '06 at 1:28a
posts7
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Nzer Zaidenberg: 4 posts Tom Lane: 3 posts

People

Translate

site design / logo © 2022 Grokbase