[postgis-devel] A postgres crash with alpha6

Andrea Peri aperi2007 at gmail.com
Fri Feb 24 13:19:18 PST 2012 

Hi,
Uisng the alpha6 release for windows and try-ing this query:

select
    1 as id,
    a.nome,
    'DBTopografico RT da Ristrutturazione Multiscala - selezione
provinciale'::text as titolo,
    '13-02-2012'::text as data_estrazione,
    ST_Multi(ST_Union(a.geom))::geometry(MULTIPOLYGON,3003) as geometry
from
    tematici.am_prov_region_am_prov as a,
    gb.porzioneterritoriorestituito as b
where
    nome='LIVORNO'
    and
    b.codporzioneterritoriorestituito NOT LIKE 'RT98%'
    and
    ST_Intersects(a.geom,b.geometry)
group by
    a.nome
;

I see the postgres (9.1.2) will stop after few seconds.

I set the log to debug level and this is the results:

--------------------
2012-02-24 22:12:10 CET DEBUG:  InitPostgres
2012-02-24 22:12:10 CET DEBUG:  my backend ID is 3
2012-02-24 22:12:10 CET DEBUG:  StartTransaction
2012-02-24 22:12:10 CET DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2012-02-24 22:12:10 CET DEBUG:  received password packet
2012-02-24 22:12:10 CET DEBUG:  CommitTransaction
2012-02-24 22:12:10 CET DEBUG:  name: unnamed; blockState:       STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2012-02-24 22:12:10 CET DEBUG:  parse <unnamed>: SELECT pg_backend_pid()
2012-02-24 22:12:10 CET DEBUG:  StartTransactionCommand
2012-02-24 22:12:10 CET DEBUG:  StartTransaction
2012-02-24 22:12:10 CET DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2012-02-24 22:12:10 CET DEBUG:  bind <unnamed> to <unnamed>
2012-02-24 22:12:10 CET DEBUG:  CommitTransactionCommand
2012-02-24 22:12:10 CET DEBUG:  CommitTransaction
2012-02-24 22:12:10 CET DEBUG:  name: unnamed; blockState:       STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2012-02-24 22:12:14 CET DEBUG:  parse <unnamed>: select
        1 as id,
        a.nome,
        'DBTopografico RT da Ristrutturazione Multiscala - selezione
provinciale'::text as titolo,
        '13-02-2012'::text as data_estrazione,
        ST_Multi(ST_Union(a.geom))::geometry(MULTIPOLYGON,3003) as geometry
    from
        tematici.am_prov_region_am_prov as a,
        gb.porzioneterritoriorestituito as b
    where
        nome='LIVORNO'
        and
        b.codporzioneterritoriorestituito NOT LIKE 'RT98%'
        and
        ST_Intersects(a.geom,b.geometry)
    group by
        a.nome

2012-02-24 22:12:14 CET DEBUG:  StartTransactionCommand
2012-02-24 22:12:14 CET DEBUG:  StartTransaction
2012-02-24 22:12:14 CET DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2012-02-24 22:12:14 CET DEBUG:  bind <unnamed> to <unnamed>
TopMemoryContext: 63168 total in 9 blocks; 1840 free (6 chunks); 61328 used
  PostGIS Prepared Geometry Backend MemoryContext Hash: 8192 total in 1
blocks; 4872 free (0 chunks); 3320 used
  TableSpace cache: 8192 total in 1 blocks; 5640 free (0 chunks); 2552 used
  Type information cache: 24576 total in 2 blocks; 14072 free (6 chunks);
10504 used
  Operator lookup cache: 24576 total in 2 blocks; 14072 free (6 chunks);
10504 used
  CFuncHash: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used
  TopTransactionContext: 8192 total in 1 blocks; 7696 free (1 chunks); 496
used
  MessageContext: 8192 total in 1 blocks; 7072 free (0 chunks); 1120 used
  Operator class cache: 8192 total in 1 blocks; 4872 free (0 chunks); 3320
used
  smgr relation table: 8192 total in 1 blocks; 760 free (0 chunks); 7432
used
  TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks);
16 used
  Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
  PortalMemory: 8192 total in 1 blocks; 8040 free (0 chunks); 152 used
    PortalHeapMemory: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
      ExecutorState: 1783456 total in 5 blocks; 30360 free (4 chunks);
1753096 used
2012-02-24 22:12:22 CET DEBUG:  reaping dead processes
2012-02-24 22:12:22 CET DEBUG:  server process (PID 3432) was terminated by
exception 0xC0000005
2012-02-24 22:12:22 CET HINT:  See C include file "ntstatus.h" for a
description of the hexadecimal value.
2012-02-24 22:12:22 CET LOG:  server process (PID 3432) was terminated by
exception 0xC0000005
2012-02-24 22:12:22 CET HINT:  See C include file "ntstatus.h" for a
description of the hexadecimal value.
2012-02-24 22:12:22 CET LOG:  terminating any other active server processes
2012-02-24 22:12:22 CET DEBUG:  sending SIGQUIT to process 2032
2012-02-24 22:12:22 CET DEBUG:  sending SIGQUIT to process 2372
2012-02-24 22:12:22 CET WARNING:  terminating connection because of crash
of another server process
2012-02-24 22:12:22 CET 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.
2012-02-24 22:12:22 CET HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2012-02-24 22:12:22 CET DEBUG:  shmem_exit(-1): 0 callbacks to make
2012-02-24 22:12:22 CET DEBUG:  proc_exit(-1): 0 callbacks to make
2012-02-24 22:12:22 CET DEBUG:  sending SIGQUIT to process 4768
2012-02-24 22:12:22 CET DEBUG:  shmem_exit(-1): 0 callbacks to make
2012-02-24 22:12:22 CET DEBUG:  proc_exit(-1): 0 callbacks to make
2012-02-24 22:12:22 CET DEBUG:  sending SIGQUIT to process 3736
2012-02-24 22:12:22 CET DEBUG:  shmem_exit(-1): 0 callbacks to make
2012-02-24 22:12:22 CET DEBUG:  proc_exit(-1): 0 callbacks to make
2012-02-24 22:12:22 CET DEBUG:  sending SIGQUIT to process 2680
2012-02-24 22:12:22 CET WARNING:  terminating connection because of crash
of another server process
2012-02-24 22:12:22 CET 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.
2012-02-24 22:12:22 CET HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2012-02-24 22:12:22 CET DEBUG:  shmem_exit(-1): 0 callbacks to make
2012-02-24 22:12:22 CET DEBUG:  proc_exit(-1): 0 callbacks to make
2012-02-24 22:12:22 CET DEBUG:  server process (PID 2032) exited with exit
code 2
2012-02-24 22:12:22 CET DEBUG:  reaping dead processes
2012-02-24 22:12:22 CET DEBUG:  reaping dead processes
2012-02-24 22:12:22 CET LOG:  all server processes terminated;
reinitializing
2012-02-24 22:12:22 CET DEBUG:  shmem_exit(1): 2 callbacks to make
2012-02-24 22:12:22 CET DEBUG:  invoking IpcMemoryCreate(size=145563648)
2012-02-24 22:12:32 CET FATAL:  pre-existing shared memory block is still
in use
2012-02-24 22:12:32 CET HINT:  Check if there are any old server processes
still running, and terminate them.
2012-02-24 22:12:32 CET DEBUG:  shmem_exit(1): 0 callbacks to make
2012-02-24 22:12:32 CET DEBUG:  proc_exit(1): 1 callbacks to make
2012-02-24 22:12:32 CET DEBUG:  exit(1)
2012-02-24 22:12:32 CET DEBUG:  shmem_exit(-1): 0 callbacks to make
2012-02-24 22:12:32 CET DEBUG:  proc_exit(-1): 0 callbacks to make
2012-02-24 22:12:32 CET DEBUG:  logger shutting down
2012-02-24 22:12:32 CET DEBUG:  shmem_exit(0): 0 callbacks to make
2012-02-24 22:12:32 CET DEBUG:  proc_exit(0): 0 callbacks to make
2012-02-24 22:12:32 CET DEBUG:  exit(0)

------------------------------




-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20120224/16b5fa65/attachment.html>

More information about the postgis-devel mailing list