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
