| From: | Mike Yeap <wkk1020(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes |
| Date: | 2019-02-20 10:12:59 |
| Message-ID: | CAMVYW_6Ee-cYdpZ++VLnab_-3hmcorOA_kmBtsnw2R+n0nVxMw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all, I have encountered a problem related to LDAP authenticated session
with Postgres foreign data wrapper (postgres_fdw).
The server crashed with following errors and other active server processes
are terminated as well:
2019-02-20 14:53:30.496 SGT [PID=1353 application="" user_name= database=
host(port)=] LOG: server process (PID 26306) was terminated by signal 11:
Segmentation fault
2019-02-20 14:53:30.496 SGT [PID=1353 application="" user_name= database=
host(port)=] LOG: terminating any other active server processes
I can reproduce it in a test server with many other sessions connected:
1. login using non-LDAP-authenticated user, query local & foreign tables -
OK
2. login using LDAP-authenticated user, query local table - OK
3. login using LDAP-authenticated user, query foreign table - ERROR, server
crashes with signal 11: Segmentation fault error when I quit the psql
session
It seems like the problem only when the LDAP-authenticated session (which
queried foreign table) is terminated. In dmesg log, I can see following:
[16385512.182231] traps: postmaster[26306] general protection
ip:7f1e758b638c sp:7ffef7ed8858 error:0 in libc-2.17.so[7f1e75836000+1b6000]
Has anyone encountered similar issue?
######################
PostgreSQL version: 10.6
Platform: CentOS Linux
######################
Thank you.
Regards,
Mike Yeap
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Niels Jespersen | 2019-02-20 10:58:51 | RE: Implementing pgaudit extension on Microsoft Windows |
| Previous Message | Samuel Williams | 2019-02-20 00:39:18 | Re: Partial index on JSON column |