Bug #742: 7.2.1 createdb test gives segmentation fault

Started by PostgreSQL Bugs Listover 23 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

John Nealy (john.nealy@sdhc.k12.fl.us) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
7.2.1 createdb test gives segmentation fault

Long Description
When installing PG 7.2.1 from source on S/390 Linux using the
--enable-multibyte option I cannot create databases and psql does not work at all. Everything is fine using plain ./configure. I wanted to use the multibyte because I need to compile a PHP 4.x Apache module to interface with PgSQL. Without it I get Undefined symbol... pg_encoding_to_char then starting Apache. Anyway, below is some relevant output:

first do initdb:
[postgres@linux1 postgres]$/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

Fixing permissions on existing directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
creating template1 database in /usr/local/pgsql/data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
creating system views... ok
loading pg_description... ok
vacuuming database template1... ok
copying template1 to template0... ok

Success. You can now start the database server using:

/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
or
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

[postgres@linux1 postgres]$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
postmaster successfully started

[postgres@linux1 postgres]$ /usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/createdb: line 172: 9309 Segmentation fault (core dum
ped) ${PATHNAME}psql $PSQLOPT -d template1 -c "CREATE DATABASE \"$dbname\"$withs
tring"
createdb: database creation failed
[postgres@linux1 postgres]$

logfile has
DEBUG: database system was shut down at 2002-08-22 09:15:04 GMT
DEBUG: checkpoint record is at 0/113640
DEBUG: redo record is at 0/113640; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 89; next oid: 16556
DEBUG: database system is ready
DEBUG: pq_recvbuf: unexpected EOF on client connection

from command line:
[postgres@linux1 postgres]$ psql template1
Segmentation fault (core dumped)
[postgres@linux1 postgres]$

Should I just try a previous version on Pg (or PHP)? Any help is greatly appreciated.

Sample Code

No file was uploaded with this report

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: Bug #742: 7.2.1 createdb test gives segmentation fault

pgsql-bugs@postgresql.org writes:

When installing PG 7.2.1 from source on S/390 Linux using the
--enable-multibyte option I cannot create databases and psql does not
work at all. Everything is fine using plain ./configure.

I suspect you have a problem with psql linking to a
non-multibyte-enabled copy of libpq.so. Check what "ldd psql" has to
say about resolution of shared library references.

regards, tom lane