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: [email protected] [mailto:[email protected]] On Behalf Of Andrea Peri 2007 Sent: Saturday, October 02, 2010 7:43 AM To: [email protected] 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
