[postgis-users] server crash

sdjiangwei sdjiangwei at sina.com
Thu Aug 21 22:07:12 PDT 2003

gis=# select transfrom('SRID=2001,POINT(100 100)'::geometry,2001);
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: LOG:  server process (pid 22849) was terminated by signal 11
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing shared memory and semaphores
FATAL:  The database system is starting up
!# LOG:  database system was interrupted at 2003-08-22 12:00:37 CST
LOG:  checkpoint record is at 0/11CA5E94
LOG:  redo record is at 0/11CA5E94; undo record is at 0/0; shutdown FALSE
LOG:  next transaction id: 1444566; next oid: 382105
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 0/11CA5ED4
LOG:  ReadRecord: record with zero length at 0/11F0E7B0
LOG:  redo done at 0/11F0E78C

[postgres at database contrib]$ ldd /usr/local/pgsql/lib/libpostgis.so
        libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x40030000)
        libgeos.so.1 => /usr/local/lib/libgeos.so.1 (0x400e3000)
        libproj.so.0 => /usr/local/lib/libproj.so.0 (0x401a3000)
        libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
        libm.so.6 => /lib/tls/libm.so.6 (0x401d6000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x401f8000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

More information about the postgis-users mailing list