[postgis-users] Hanging Postgres 9.0 + Postgis 1.5.2 on windows

[Paragon Corporation]

Andrea,

I assume you are running 32-bit?  

No we haven't run into any issues yet, but haven't migrated our bigger apps
to PostgreSQL 9.0 yet.

Can you provide a sample query that you are running that triggers this
error?  If its loading from file, maybe a sample load file and script.  You
can provide that to us off list if you want?

I guess to rule out PostGIS as the culprit -- you could try upgrading your
Postgres 8.4.4 to 1.5.2 (a quick way is to copy over the postgis-1.5.dll
,libxml, and geos binaries in bin folde) -- making sure to backup your
existing and restart.  Binaries are available Postgis 1.5 8.4 binaries.
http://www.postgis.org/download/windows/#windbinaries

Two changes we did make -- which hopefully is not the cause of this is that
we are no longer statically compiling in libxml.  In the 1.5.1  we did
because we were getting crashes when using GeomFromKML/GML, but we found a
work around for it which seemed to work fine.  The other is the 1.5.2 is
compiled against GEOS 3.2.2 instead of GEOS 3.2.0

I assume your load script is not using ST_GeomFromGML, KML etc?  If it is,
we may need to reinvestigate.

If it is a PostGIS issue -- it might also be in the GEOS 3.2.2 in which
case, we would like to rule out PostGIS as the culprit.   I doubt this since
we have been running fairly intensive queries in PostgreSQL 8.4 using the
newer GEOS.

Thanks,
Leo and Regina
http://www.postgis.us




-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Andrea
Peri 2007
Sent: Saturday, October 02, 2010 7:43 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Hanging Postgres 9.0 + Postgis 1.5.2 on windows

  Hi,

I experience a bad crash of the couple Postgres 9.0 + Postgis 1.5.2 on
windows 7.

The crash of postgres occur meanwhile I run a my program executable that
read from a textual file many data and load them on some geometry tables .

This procedure is very tested because is the same that I use without any
problem on the couple

Postgres 8.4.4 + Postgis 1.5.1 always on the same windows 7 machine.

Infact after see this crash I immediatly retry the same procedure on the
istance of Postgres 8.4.4 + postgis 1.5.1 on the same data and no error
occur.

I see the log of postgres 9.0 and see this error.

2010-10-01 22:38:56 CEST LOG:  database system is ready to accept
connections
2010-10-01 22:44:20 CEST LOG:  server process (PID 2540) was terminated by
exception 0xC0000005
2010-10-01 22:44:20 CEST HINT:  See C include file "ntstatus.h" for a
description of the hexadecimal value.
2010-10-01 22:44:20 CEST LOG:  terminating any other active server processes
2010-10-01 22:44:20 CEST WARNING:  terminating connection because of crash
of another server process
2010-10-01 22:44:20 CEST DETAIL:  The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2010-10-01 22:44:20 CEST HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2010-10-01 22:44:20 CEST WARNING:  terminating connection because of crash
of another server process
2010-10-01 22:44:20 CEST DETAIL:  The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2010-10-01 22:44:20 CEST HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2010-10-01 22:44:20 CEST LOG:  all server processes terminated;
reinitializing
2010-10-01 22:44:31 CEST FATAL:  pre-existing shared memory block is still
in use
2010-10-01 22:44:31 CEST HINT:  Check if there are any old server processes
still running, and terminate them.

I really think this error is due to Postgres 9.0 and no relation there is
with Postgis 1.5.2.

But I don't know how to do to retrieve more information to understand what
is happening.

So I like to know if there is others with these problems of an istance of
postgres 9.0 that is hanging.

Thx,

Andrea.

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users