Your name : Mike Riendeau
Your email address : [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
