<div dir="ltr">Hi,<div><br></div><div>PostGIS 2.2 is End of Life. No bugs are going to be fixed in it. Current version is 2.5.2, please upgrade both. </div><div>GeoJSON serialization was tweaked in 2.5.0, please check if bug still reproduces there.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Mar 21, 2019 at 3:47 PM Micha Silver <<a href="mailto:tsvibar@gmail.com" target="_blank">tsvibar@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div style="direction:ltr" 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="gmail-m_5582982367023026197gmail-m_-4550702160845657856moz-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="gmail-m_5582982367023026197gmail-m_-4550702160845657856moz-quote-pre">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="gmail-m_5582982367023026197gmail-m_-4550702160845657856moz-signature" cols="72">--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
+972-523-665918</pre>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail-m_5582982367023026197gmail_signature"><div dir="ltr"><div><div>Darafei Praliaskouski</div><div>Support me: <a href="http://patreon.com/komzpa" target="_blank">http://patreon.com/komzpa</a></div></div></div></div>