Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14897: Segfault on statitics SQL request - Mailing list pgsql-bugs

From Vincent Lachenal
Subject Re: [BUGS] BUG #14897: Segfault on statitics SQL request
Date
Msg-id CAA2tJ7odG4KB=wvu_+5FfssxckbLTnEuR9C_TXRyeU_35z+CSA@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14897: Segfault on statitics SQL request  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [BUGS] BUG #14897: Segfault on statitics SQL request  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
Here is the resut of pg_config:
$ pg_config  
BINDIR = /usr/bin
DOCDIR = /usr/share/doc/postgresql
HTMLDIR = /usr/share/doc/postgresql
INCLUDEDIR = /usr/include
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/server
LIBDIR = /usr/lib
PKGLIBDIR = /usr/lib/postgresql
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/man
SHAREDIR = /usr/share/postgresql
SYSCONFDIR = /etc/postgresql
PGXS = /usr/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/usr' '--mandir=/usr/share/man' '--datadir=/usr/share/postgresql' '--sysconfdir=/etc' '--with-gssapi' '--with-libxml' '--with-openssl' '--with-pe
rl' '--with-python' 'PYTHON=/usr/bin/python2' '--with-tcl' '--with-pam' '--with-system-tzdata=/usr/share/zoneinfo' '--with-uuid=e2fs' '--enable-nls' '--enable-thread-s
afety' 'CFLAGS=-march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt' 'LDFLAGS=-Wl,-O1,--sort-common,--as-needed,-z,relro,-z,now' 'CPPFLAGS=-D_FORTI
FY_SOURCE=2'
CC = gcc
CPPFLAGS = -DFRONTEND -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwr
apv -fexcess-precision=standard -march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong -fno-plt
CFLAGS_SL = -fPIC
LDFLAGS = -L../../src/common -Wl,-O1,--sort-common,--as-needed,-z,relro,-z,now -Wl,--as-needed -Wl,-rpath,'/usr/lib',--enable-new-dtags
LDFLAGS_EX =  
LDFLAGS_SL =  
LIBS = -lpgcommon -lpgport -lpthread -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lrt -lcrypt -ldl -lm   
VERSION = PostgreSQL 10.1

If it is not help, I will recreate database and inject dump. It could be a migration bug.
Archlinux does not provide debugging symbol package and my other computer is under Gentoo (and it will take a long time to have a stable release). If bug persists, I will open a bug on Archlinux bugtracker.

Regards.

Vincent

Le ven. 10 nov. 2017 à 21:46, Tom Lane <tgl@sss.pgh.pa.us> a écrit :
Vincent Lachenal <vincent.lachenal@gmail.com> writes:
> The request returns this result on this database :
> select name,setting,source from pg_settings where source != 'default';

Hmm .... not much help there.  I wonder if this is specific to ArchLinux.
We do have an Arch machine in the buildfarm, but it's an ARM, so that
might not prove much about Arch on other hardware.

One other thing that might be useful: could you send the output of
"pg_config" (that's a command-line program, not a SQL command)?

                        regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14897: Segfault on statitics SQL request
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14897: Segfault on statitics SQL request