Skip site navigation (1) Skip section navigation (2)

Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build commands

From: "Riendeau, Mike" <mike(dot)riendeau(at)analog(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build commands
Date: 2002-01-31 23:02:25
Message-ID: D84A32D1A483D211A38F0060B06993D008209BE2@wilmexm1.analog.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Your name		: Mike Riendeau
Your email address	: mike(dot)riendeau(at)analog(dot)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



Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-01-31 23:23:05
Subject: Re: Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build commands
Previous:From: ShayDate: 2002-01-31 21:14:06
Subject: cant activate the database ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group