<html style="direction: ltr;">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body bidimailui-charset-is-forced="true" style="direction: ltr;"
text="#000000" bgcolor="#FFFFFF">
I am getting a segfault when trying to display geom as GeoJSON. My
Postgresql server is 9.4, with PostGIS 2.2 running on top. Other
functions to display geom seem to be working fine (As_EWKT, As_Text,
As_EWKB, As_KML etc...)
<div class="moz-text-html" lang="x-unicode">
<p><br>
</p>
<p><font size="+1">I increased the debug level, and attached is
the relevant part of my Postgresql log.</font></p>
<font size="+1"> </font>
<p><font size="+1"><br>
</font> </p>
<font size="+1"> </font>
<p><font size="+1">Any tips are welcome. </font></p>
<font size="+1"> </font>
<p><font size="+1">Thanks,</font></p>
<font size="+1"> </font>
<p><font size="+1"><br>
</font> </p>
<font size="+1"> </font>
<p><font size="+1">Versions:</font><br>
</p>
<p><br>
</p>
<p> <tt>geodata=# select version();</tt><tt>
version </tt><tt><br>
</tt><tt>----------------------------------------------------------------------------------------------------------------</tt><tt><br>
</tt><tt> PostgreSQL 9.4.21 on x86_64-unknown-linux-gnu,
compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36),
64-bit</tt><tt><br>
</tt><tt>(1 row)</tt><tt><br>
</tt><tt>geodata=# select postgis_version();</tt><tt><br>
</tt><tt> postgis_version </tt><tt><br>
</tt><tt>---------------------------------------</tt><tt><br>
</tt><tt> 2.2 USE_GEOS=1 USE_PROJ=1 USE_STATS=1</tt><tt><br>
</tt><tt>(1 row)</tt><tt><br>
</tt></p>
<p><br>
</p>
<p><font size="+1">and this is what I get from abrt:</font></p>
<pre class="moz-quote-pre" wrap="">reason: postgres killed by SIGSEGV
cmdline: 'postgres: geodba geodata 192.168.1.29(51278) SELECT' '' '' ''
executable: /usr/pgsql-9.4/bin/postgres
package: postgresql94-server-9.4.21-1PGDG.rhel7
component: postgresql94
pid: 29785
pwd: /var/lib/pgsql/9.4/data
hostname: nekarot
count: 4
abrt_version: 2.1.11
analyzer: CCpp
architecture: x86_64
event_log:
global_pid: 29785
kernel: 3.10.0-957.5.1.el7.x86_64
last_occurrence: 1553166685
os_release: CentOS Linux release 7.6.1810 (Core)
pkg_arch: x86_64
pkg_epoch: 0
pkg_fingerprint: 1F16 D2E1 442D F0F8
pkg_name: postgresql94-server
pkg_release: 1PGDG.rhel7
pkg_vendor: PostgreSQL Global Development Group
pkg_version: 9.4.21
runlevel: N 3
time: Thu 21 Mar 2019 12:04:15 PM IST
type: CCpp
uid: 26
username: postgres
uuid: 0d18aed0d162f863b3a330db343a76b887319e0b</pre>
<p> </p>
</div>
<pre class="moz-signature" cols="72">--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
+972-523-665918</pre>
</body>
</html>