[postgis-tickets] [PostGIS] #2798: raster2pgsql spins CPU on statement timeout

[PostGIS]

#2798: raster2pgsql spins CPU on statement timeout
----------------------+-----------------------------------------------------
 Reporter:  strk      |       Owner:  dustymugs
     Type:  defect    |      Status:  new      
 Priority:  critical  |   Milestone:           
Component:  raster    |     Version:  trunk    
 Keywords:            |  
----------------------+-----------------------------------------------------

Comment(by strk):

 Forgot to mention, the potgresql log extract:
 {{{
 2014-06-30 18:35:36.298 CEST psql 13231 LOG:  duration: 62.469 ms
 statement: CREATE TABLE "timeseq_change00_12"
 ("rid" serial PRIMARY KEY,"rast" raster);
 2014-06-30 18:40:36.634 CEST psql 13231 ERROR:  canceling statement due to
 statement timeout
 2014-06-30 18:40:36.634 CEST psql 13231 CONTEXT:  COPY
 timeseq_change00_12, line 9147:
 "01000001000000000000003E400000000000003EC00000000080DB3CC10000000000ED224100000000000000000000000000..."
 2014-06-30 18:40:36.634 CEST psql 13231 STATEMENT:  COPY
 "timeseq_change00_12" ("rast") FROM stdin;
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2798#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.