Re: [BUGS] BUG #14531: server process (PID 12714) was terminated bysignal 11: Segmentation fault

I did not mention anything about logs thinking the back trace would be enough to solve the issue. Sorry for that.

I have enabled the log_statement=all already and each time it gives different queries. But until now i have seen postmaster crashed during SELECT query. 

Eg:  Crashed yesterday while executing query [PID] 11221 DETAIL:  Failed process was running: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 19175) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum

For your Information the previous query in the log is "select COLUMN_VALUE from TABLE_NAME where COLUMN_VALUE=3"

The crash is reproducible with different queries.

Previous crashed query(just format) log:- select column1,column2, column3 from table_name where column4>-1 

Regards,

Naveen Ch.