<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">
<p>Thanks, I'll try</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 3/21/19 3:27 PM, Darafei "Komяpa"
Praliaskouski wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAC8Q8t+b1bARei+z4BQ1dL+pJRwD=r5yBy_g7tc+M_4nzpw4RA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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" moz-do-not-send="true">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"
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">http://patreon.com/komzpa</a></div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918</pre>
</body>
</html>