<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>