[postgis-users] Intersects(geometry,geometry) fails

[David Valentine]

logs that are not really useful.

Jan 13 06:54:44 apollo postgres[22673]: [ID 748848 local0.info] [8-1] 
LOG:  server process (PID 20490) was terminated by signal 11
Jan 13 06:54:44 apollo postgres[22673]: [ID 748848 local0.info] [9-1] 
LOG:  terminating any other active server processes
Jan 13 06:54:44 apollo postgres[20501]: [ID 748848 local0.notice] [8-1] 
WARNING:  terminating connection because of crash of another server 
process
Jan 13 06:54:44 apollo postgres[20501]: [ID 748848 local0.notice] [8-2] 
DETAIL:  The postmaster has commanded this server process to roll back 
the current transaction and exit, because another server
Jan 13 06:54:44 apollo postgres[20501]: [ID 748848 local0.notice] [8-3] 
  process exited abnormally and possibly corrupted shared memory.
Jan 13 06:54:44 apollo postgres[20501]: [ID 748848 local0.notice] [8-4] 
HINT:  In a moment you should be able to reconnect to the database and 
repeat your command.
Jan 13 06:54:44 apollo postgres[22673]: [ID 748848 local0.info] [10-1] 
LOG:  all server processes terminated; reinitializing
Jan 13 06:54:44 apollo postgres[20502]: [ID 748848 local0.info] [11-1] 
LOG:  database system was interrupted at 2004-01-12 23:47:04 PST
Jan 13 06:54:44 apollo postgres[20502]: [ID 748848 local0.info] [12-1] 
LOG:  checkpoint record is at 5/ACC6B450
Jan 13 06:54:44 apollo postgres[20502]: [ID 748848 local0.info] [13-1] 
LOG:  redo record is at 5/ACC6B450; undo record is at 0/0; shutdown 
FALSE
Jan 13 06:54:44 apollo postgres[20502]: [ID 748848 local0.info] [14-1] 
LOG:  next transaction ID: 7357507; next OID: 125349275
Jan 13 06:54:44 apollo postgres[20502]: [ID 748848 local0.info] [15-1] 
LOG:  database system was not properly shut down; automatic recovery in 
progress
Jan 13 06:54:44 apollo postgres[20502]: [ID 748848 local0.info] [16-1] 
LOG:  record with zero length at 5/ACC6B490
Jan 13 06:54:44 apollo postgres[20502]: [ID 748848 local0.info] [17-1] 
LOG:  redo is not required
Jan 13 06:54:48 apollo postgres[20502]: [ID 748848 local0.info] [18-1] 
LOG:  database system is ready
Jan 13 06:56:18 apollo postgres[22673]: [ID 748848 local0.info] [11-1] 
LOG:  server process (PID 20754) was terminated by signal 11
Jan 13 06:56:18 apollo postgres[22673]: [ID 748848 local0.info] [12-1] 
LOG:  terminating any other active server processes
Jan 13 06:56:18 apollo postgres[20757]: [ID 748848 local0.notice] 
[11-1] WARNING:  terminating connection because of crash of another 
server process
Jan 13 06:56:18 apollo postgres[20757]: [ID 748848 local0.notice] 
[11-2] DETAIL:  The postmaster has commanded this server process to 
roll back the current transaction and exit, because another server
Jan 13 06:56:18 apollo postgres[20757]: [ID 748848 local0.notice] 
[11-3]  process exited abnormally and possibly corrupted shared memory.
Jan 13 06:56:18 apollo postgres[20757]: [ID 748848 local0.notice] 
[11-4] HINT:  In a moment you should be able to reconnect to the 
database and repeat your command.
Jan 13 06:56:18 apollo postgres[22673]: [ID 748848 local0.info] [13-1] 
LOG:  all server processes terminated; reinitializing
Jan 13 06:56:18 apollo postgres[20758]: [ID 748848 local0.info] [14-1] 
LOG:  database system was interrupted at 2004-01-13 06:54:48 PST
Jan 13 06:56:18 apollo postgres[20758]: [ID 748848 local0.info] [15-1] 
LOG:  checkpoint record is at 5/ACC6B490
Jan 13 06:56:18 apollo postgres[20758]: [ID 748848 local0.info] [16-1] 
LOG:  redo record is at 5/ACC6B490; undo record is at 0/0; shutdown 
TRUE
Jan 13 06:56:18 apollo postgres[20758]: [ID 748848 local0.info] [17-1] 
LOG:  next transaction ID: 7357507; next OID: 125349275
Jan 13 06:56:18 apollo postgres[20758]: [ID 748848 local0.info] [18-1] 
LOG:  database system was not properly shut down; automatic recovery in 
progress
Jan 13 06:56:18 apollo postgres[20758]: [ID 748848 local0.info] [19-1] 
LOG:  record with zero length at 5/ACC6B4D0
Jan 13 06:56:18 apollo postgres[20758]: [ID 748848 local0.info] [20-1] 
LOG:  redo is not required
Jan 13 06:56:23 apollo postgres[20758]: [ID 748848 local0.info] [21-1] 
LOG:  database system is ready

On Jan 12, 2004, at 4:17 PM, Paul Ramsey wrote:

> Werks fer me.
> What GEOS version? Operating system, compiler?
>
> ogc=# select intersects(GeometryFromText('POLYGON((2 0,5 0,5 3,2 3,2 
> 0))',54001),'SRID=54001;POLYGON((0 0,2 0,7 5,2 5,0 0))');
>
>  intersects
> ------------
>  t
> (1 row)
>
> Greg Janée wrote:
>
>> Using Intersects(geometry,geometry) fails and furthermore causes the 
>> database connection to get hosed:
>
>
>
> -- 
>       __
>      /
>      | Paul Ramsey
>      | Refractions Research
>      | Email: pramsey at refractions.net
>      | Phone: (250) 885-0632
>      \_
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users