[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:  medium  |   Milestone:           
Component:  raster  |     Version:  trunk    
 Keywords:          |  
--------------------+-------------------------------------------------------
Changes (by strk):

  * priority:  critical => medium


Comment:

 Confirmed the intensive CPU has nothing to do with postgresql or pipes.
 It's running at ~100% CPU since 10 minutes now, with output directed to
 /dev/null

 I guess this ticket can be closed as Invalid, but I'd still interested in
 knowing more about where all that time goes...

 Attaching the process via gdb and interrupting arbitrarely shows code in
 printf:
 {{{
 (gdb) bt
 #0  0x00007f73800b5f90 in _IO_vfprintf_internal (s=s at entry=0x7fff0fa387a0,
 format=<optimized out>,
     format at entry=0x419e78 "%s%s%s", ap=ap at entry=0x7fff0fa388c8) at
 vfprintf.c:1655
 #1  0x00007f7380179544 in ___vsprintf_chk (s=0x3aa3af0
 "\230\247B\200s\177", flags=1, slen=18446744073709551615,
     format=0x419e78 "%s%s%s", args=args at entry=0x7fff0fa388c8) at
 vsprintf_chk.c:84
 #2  0x00007f738017948d in ___sprintf_chk (s=s at entry=0x3aa3af0
 "\230\247B\200s\177", flags=flags at entry=1,
     slen=slen at entry=18446744073709551615, format=format at entry=0x419e78
 "%s%s%s") at sprintf_chk.c:32
 #3  0x0000000000406c94 in sprintf (__fmt=0x419e78 "%s%s%s", __s=0x3aa3af0
 "\230\247B\200s\177")
     at /usr/include/x86_64-linux-gnu/bits/stdio2.h:33
 #4  insert_records (schema=<optimized out>, table=0x21b8370
 "\"timeseq_change00_12\"",
     column=0x21b72e0 "\"rast\"", filename=0x0, file_column_name=0x21c04f0
 "\"filename\"",
     copy_statements=<optimized out>, tileset=tileset at entry=0x7fff0fa38b70,
 buffer=buffer at entry=0x2197ca0)
     at raster2pgsql.c:860
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2798#comment:5>
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.