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 CAA2tJ7qsopt0hHbsm397H62LMsaE4hjRwaUu3FQdNgo5AYAGXA@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>)
List pgsql-bugs
Tree view
The request returns this result on this database :
select name,setting,source from pg_settings where source != 'default';
           name            |      setting      |        source         
----------------------------+-------------------+----------------------
application_name           | psql              | client
client_encoding            | UTF8              | client
data_checksums             | off               | override
DateStyle                  | ISO, DMY          | configuration file
default_text_search_config | pg_catalog.french | configuration file
dynamic_shared_memory_type | posix             | configuration file
lc_collate                 | fr_FR.utf8        | override
lc_ctype                   | fr_FR.utf8        | override
lc_messages                | fr_FR.utf8        | configuration file
lc_monetary                | fr_FR.utf8        | configuration file
lc_numeric                 | fr_FR.utf8        | configuration file
lc_time                    | fr_FR.utf8        | configuration file
log_timezone               | Europe/Paris      | configuration file
max_connections            | 100               | configuration file
max_stack_depth            | 2048              | environment variable
server_encoding            | UTF8              | override
shared_buffers             | 16384             | configuration file
TimeZone                   | Europe/Paris      | configuration file
transaction_deferrable     | off               | override
transaction_isolation      | read committed    | override
transaction_read_only      | off               | override
wal_buffers                | 512               | override

On postgres database, it returns :
select name,setting,source from pg_settings where source != 'default';
           name            |                setting                 |        source         
----------------------------+----------------------------------------+----------------------
application_name           | psql                                   | client
client_encoding            | UTF8                                   | client
config_file                | /var/lib/postgres/data/postgresql.conf | override
data_checksums             | off                                    | override
data_directory             | /var/lib/postgres/data                 | override
DateStyle                  | ISO, DMY                               | configuration file
default_text_search_config | pg_catalog.french                      | configuration file
dynamic_shared_memory_type | posix                                  | configuration file
hba_file                   | /var/lib/postgres/data/pg_hba.conf     | override
ident_file                 | /var/lib/postgres/data/pg_ident.conf   | override
lc_collate                 | fr_FR.utf8                             | override
lc_ctype                   | fr_FR.utf8                             | override
lc_messages                | fr_FR.utf8                             | configuration file
lc_monetary                | fr_FR.utf8                             | configuration file
lc_numeric                 | fr_FR.utf8                             | configuration file
lc_time                    | fr_FR.utf8                             | configuration file
log_timezone               | Europe/Paris                           | configuration file
max_connections            | 100                                    | configuration file
max_stack_depth            | 2048                                   | environment variable
server_encoding            | UTF8                                   | override
shared_buffers             | 16384                                  | configuration file
TimeZone                   | Europe/Paris                           | configuration file
transaction_deferrable     | off                                    | override
transaction_isolation      | read committed                         | override
transaction_read_only      | off                                    | override
wal_buffers                | 512                                    | override

Regards.

Vincent

Le ven. 10 nov. 2017 à 21:12, Tom Lane <tgl@sss.pgh.pa.us> a écrit :
Vincent Lachenal <vincent.lachenal@gmail.com> writes:
> Sorry. I didn't find the way to create an attachment in the interface.
> You can find the database dump as attachment.

Thanks for sending the data!  However, the given query doesn't crash for
me, so there must be something non-default about your parameter settings.
Could you send the result of

select name,setting,source from pg_settings where source != 'default';

                        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