Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build commands - Mailing list pgsql-bugs

Your name        : Mike Riendeau
Your email address    : mike.riendeau@analog.com

System Configuration
---------------------
  Architecture (example: Intel Pentium)      : Sun Sparc 20

  Operating System (example: Linux 2.0.26 ELF)     : Solaris 2.5.1

  PostgreSQL version (example: PostgreSQL-7.1.3): PostgreSQL-7.1.3

  Compiler used (example:  gcc 2.95.2)        : gcc 2.95.2


Please enter a FULL description of your problem:
------------------------------------------------

 I am having a problem with v7.1.3 PostgreSQL commands generating
 Seg. Faults on exit.

 * I have built v7.0.2 from the sources, on Sun Solaris 2.5.1
   and have been running this version with success.

   I run postgres as follows:

    postmaster -B 16 -N 8 -p8000 -i

   I need the -B and -N options to allow IpcMemshare to work.

 * I am running the server in my own account, not a root installation,
 *  not under a postgres account.

 Version 7.1.3 build and exec issues:
 --------------------------------------

 - Built with the exact same config options as v7.0.2

 ****** Configure process *******************************

   ./configure --prefix=/home/mriendea --with-tcl
--with-tclconfig=/home/mriendea/lib --with-tkconfig=/home/mriendea/lib
--with-includes=/home/mriendea/include --with-pgport=8000 --with-odbc

   Configure did not report any fatal errors.

   ############ CONFIG.LOG ##############################
   .
   .
   configure: In function `main':
   configure:6562: `rl_completion_append_character' undeclared (first use in
this function)
   configure:6562: (Each undeclared identifier is reported only once
   configure:6562: for each function it appears in.)
   configure: failed program was:
   #line 6553 "configure"
   #include "confdefs.h"
   #include <stdio.h>
   #ifdef HAVE_READLINE_READLINE_H
   # include <readline/readline.h>
   #elif defined(HAVE_READLINE_H)
   # include <readline.h>
   #endif

   int main() {
   rl_completion_append_character = 'x';
   ; return 0; }
   configure:6584: checking for rl_completion_matches
   configure:6639: checking for finite
   configure:6648: gcc -o conftest  -g   -I/home/mriendea/include   conftest.c
-lz -lresolv -lge
n -lnsl -lsocket -ldl -lm -lreadline -ltermcap  1>&5
   .
   .
   .
   ########### CONFIG.LOG #####################################



   ************* build process ***************************


   'gmake' reports:

   ############ GMAKE #####################################

   Various warnings also reported in v7.0.2 build.

   ...All of PostgreSQL successfully made. Ready to install.

   ########################################################


  *************** results *********************************

  - postmaster seems to run OK with the same options as v7.0.2
    I am starting it with the pg_ctl command with the
    -o "-B16 -N8  -i" arg and env PGHOST, PGPORT and PGDATA.

  - initdb functions with no problem. It created the database files.

  - createdb manages to create a database, but Seg Faults on exit.

  - psql is able to access the database created with createdb,
    but Seg Faults on exit.

  - regression tests don't get past postmaster for the latter
    reasons.


  ************** GNU debugger ( configged w/ --enable-debug) ****

  bash-2.02{temp}$ gdb ./psql
GDB is free software and you are welcome to 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.
GDB 4.16 (sparc-sun-solaris2.5.1), Copyright 1996 Free Software Foundation,
Inc...
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb) run foo
Starting program: /home/mriendea/temp/./psql foo
warning: Unable to find dynamic linker breakpoint function.
warning: GDB will be unable to debug shared library initializers
warning: and track explicitly loaded dynamic code.
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

foo=#
foo=#
foo=#
foo=#
foo=#
foo=# \h
Available help:
  ABORT                     CREATE TRIGGER            GRANT
  ALTER GROUP               CREATE TYPE               INSERT
  ALTER USER                CREATE VIEW               LOAD
  BEGIN                     DECLARE                   LOCK
  CHECKPOINT                DELETE                    MOVE
  CLOSE                     DROP AGGREGATE            NOTIFY
  CLUSTER                   DROP DATABASE             REINDEX
  COMMENT                   DROP FUNCTION             RESET
  COMMIT                    DROP GROUP                REVOKE
  COPY                      DROP INDEX                ROLLBACK
  CREATE AGGREGATE          DROP LANGUAGE             SELECT
  CREATE CONSTRAINT TRIGGER DROP OPERATOR             SELECT INTO
  CREATE DATABASE           DROP RULE                 SET
  CREATE FUNCTION           DROP SEQUENCE             SET CONSTRAINTS
  CREATE GROUP              DROP TABLE                SET TRANSACTION
  CREATE INDEX              DROP TRIGGER              SHOW
  CREATE LANGUAGE           DROP TYPE                 TRUNCATE
  CREATE OPERATOR           DROP USER                 UNLISTEN
  CREATE RULE               DROP VIEW                 UPDATE
  CREATE SEQUENCE           END                       VACUUM
  CREATE TABLE              EXPLAIN
  CREATE TABLE AS           FETCH
foo=#
foo=#
foo=#
foo=#
foo=# \q

Program received signal SIGSEGV, Segmentation fault.
0xef743b6c in __do_global_dtors_aux ()
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb) q
The program is running.  Quit anyway (and kill it)? (y or n) y
bash-2.02{temp}$

 **************** GNU debugger *******************************


NOTES:

  - When I gmake install the 7.0.2 files back onto my system. the
v7.1.3 executable psql Seg fault problems go away. It talks to the 7.1.3
server OK and connects to the new database OK. Something in
the libraries?

  - Nothing to report in the error.log in any case

Anything else I should try? (I'm a little out of my league)


Regards,

  Mike Riendeau




-

Alcohol and calculus don't mix. Never drink and derive.

a

Michael H. Riendeau
831 Woburn Street, MS-513  *  Wilmington, MA 01887
Office:   (781)937-1788                              Fax:   (781)937-1700

http://www.analog.com/industry/ate