[Octave-bug-tracker] [bug #54031] [octave forge] (database) Unit test in pq_connect.m segfaults for local database

[Rafael Laboissiere]

URL:
  <http://savannah.gnu.org/bugs/?54031>

                 Summary: [octave forge] (database) Unit test in pq_connect.m
segfaults for local database
                 Project: GNU Octave
            Submitted by: rlaboiss
            Submitted on: Fri 01 Jun 2018 01:42:56 PM UTC
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Segfault, Bus Error, etc.
                  Status: None
             Assigned to: None
         Originator Name: 
        Originator Email: 
             Open/Closed: Open
         Discussion Lock: Any
                 Release: other
        Operating System: GNU/Linux

    _______________________________________________________

Details:

I am trying to run the unit test in pq_connect.m against a PostGreSQL database
created locally, i.e. without root access.  It is segfaulting and I cannot
figure out what is wrong.  Below is the transcript of my session in bash.  I
am also attaching to this bug report the result of strace for the last
octave-cli command below. I am using Octave 4.4, database 2.4.3, and
PostGreSQL 10.

Please, tell me if I should do something else in order to test pq_connect
without root access.  Also, feel free to close this report if this is a
non-bug.


$ export PGDIR=$HOME/pg
$ export PGHOST=/tmp
$ export PGPORT=5433
$ rm -rf $PGDIR
$ mkdir $PGDIR
$ /usr/lib/postgresql/10/bin/initdb -D $PGDIR -U $USER
The files belonging to this database system will be owned by user "rlaboiss".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /home/rlaboiss/pg ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    /usr/lib/postgresql/10/bin/pg_ctl -D /home/rlaboiss/pg -l logfile start

$ /usr/lib/postgresql/10/bin/pg_ctl -D $PGDIR -o "-c
unix_socket_directories=$PGHOST" -w start
waiting for server to start....2018-06-01 10:31:52.801 -03 [11701] LOG: 
listening on IPv6 address "::1", port 5433
2018-06-01 10:31:52.802 -03 [11701] LOG:  listening on IPv4 address
"127.0.0.1", port 5433
2018-06-01 10:31:52.880 -03 [11701] LOG:  listening on Unix socket
"/tmp/.s.PGSQL.5433"
2018-06-01 10:31:52.912 -03 [11702] LOG:  database system was shut down at
2018-06-01 10:31:36 -03
2018-06-01 10:31:52.920 -03 [11701] LOG:  database system is ready to accept
connections
 done
server started
$ echo "create database test with owner = $USER;" | psql template1
CREATE DATABASE
$ echo 'pkg load database; setenv ("PGHOST", "/tmp"); setenv ("PGPORT",
"5433"); test pq_connect' | octave-cli -q
fatal: caught signal Segmentation fault -- stopping myself...
Segmentation fault




    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: Fri 01 Jun 2018 01:42:56 PM UTC  Name:
database-test-pq_connect-strace.txt  Size: 981KiB   By: rlaboiss

<http://savannah.gnu.org/bugs/download.php?file_id=44270>

    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?54031>

_______________________________________________
  Message sent via Savannah
  https://savannah.gnu.org/