[postgis-users] Shp2pgsql load error

[strk at refractions.net]

On Tue, May 24, 2005 at 01:27:12PM -0400, Kralidis,Tom [Burlington] wrote:
> 
> 1./ Is this on: http://postgis.refractions.net/bugs/?  I can't find
> anything there
> 
> 2./ is the bugfix committed?  I can fetch CVS.

It is committed in CVS, you can fetch by the pgis_1_0_1 tag.
That would be 1.0.1 release and has the fix included.

--strk;

PS: the bug tracker is broken AFAIKT

> 
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net 
> > [mailto:postgis-users-bounces at postgis.refractions.net] On 
> > Behalf Of strk at refractions.net
> > Sent: Tuesday, 24 May, 2005 13:19
> > To: PostGIS Users Discussion
> > Subject: Re: [postgis-users] Shp2pgsql load error
> > 
> > 
> > Oh.. BTW, which version are you using ?
> > Upcoming 1.0.1 contains a bugfix in shp2pgsql:
> > 
> >         - BUGFIX in shp2pgql escape functions
> > 
> > We might be facing a known bug..
> > 
> > --strk;
> > 
> > On Tue, May 24, 2005 at 07:17:33PM +0200, strk at refractions.net wrote:
> > > A segfault from malloc ?!  Never seen before...
> > > And... doesn't happen w/out -W flag ?
> > > Which architecture ?
> > > Can you provide (the smallest) shapefile reproducing the bug ?
> > > 
> > > --strk;
> > > 
> > > On Tue, May 24, 2005 at 01:10:29PM -0400, Kralidis,Tom [Burlington] 
> > > wrote:
> > > > 
> > > > 
> > > > > -----Original Message-----
> > > > > From: Kralidis,Tom [Burlington]
> > > > > Sent: Tuesday, 24 May, 2005 13:09
> > > > > To: 'PostGIS Users Discussion'
> > > > > Subject: RE: [postgis-users] Shp2pgsql load error
> > > > > 
> > > > > 
> > > > > > > 
> > > > > > > Hi,
> > > > > > > 
> > > > > > > Thanks for the previous help on the encoding issues.  When 
> > > > > > > trying again with the following command:
> > > > > > > 
> > > > > > > $ /usr/local/pgsql/bin/shp2pgsql -W ISO8859-1 -s 
> > 42304 wshed_p 
> > > > > > > public.wshed_p | /usr/local/pgsql/bin/psql -d devgeodb -U 
> > > > > > > postgres
> > > > > > > 
> > > > > > > ERROR:  unterminated quoted string at or near
> > > > > > > 
> > > > > > 
> > > > > 
> > "'SRID=42304;<SNIP_TONS_OF_GEOMETRY>64BA4041F6365E936DC3F8400151CD
> > > > > 483F
> > > > > > > BA
> > > > > > > 404199B6A0E30AC4F8406EA" at character 158
> > > > > > > LINE 1:
> > > > > > > 
> > ...066.31678','281229.63625','485','01AM','Oromocto','SRID=4230...
> > > > > > > 
> > > > > > > Any suggestions?
> > > > > > 
> > > > > > First of all redirect to a file instead of piping.
> > > > > > Then run psql -f on that file, so the error will tell 
> > you line 
> > > > > > number causing it. Collapse your TONS of geometry and 
> > see what 
> > > > > > sound wrong in quoting.
> > > > > > 
> > > > >   
> > > > > I can't even get that far because shp2pgsql gives me back a
> > > > > segfault when I want to redirect to file.  So trying 
> > this in gdb:
> > > > > 
> > > > > $ gdb /usr/local/pgsql/bin/shp2pgsql
> > > > > $ run -W ISO8859-1 -s 42304 wshed_p public.wshed_p
> > > > > <SNIP>
> > > > > $
> > > > > INSERT INTO "public"."wshed_p" 
> > > > > ("area","perimeter","wshed_","wshed","shedname","the_geom") 
> > > > > VALUES 
> > > > > ('2127022066.31678','281229.63625','485','01AM','Oromocto','SR
> > > > > ID=42304;<SNIP>
> > > > > 
> > > > > Program received signal SIGSEGV, Segmentation fault. 
> > 0x00872f18 in 
> > > > > _int_malloc () from /lib/tls/libc.so.6
> > > > > 
> > > > 
> > > > Whoops, forgot trace to shp2pgsql.c:
> > > > 
> > > > #0  0x00872f18 in _int_malloc () from /lib/tls/libc.so.6
> > > > #1  0x0087225d in malloc () from /lib/tls/libc.so.6
> > > > #2  0x0804dc5a in safe_malloc (size=4) at shp2pgsql.c:130 #3  
> > > > 0x0804ed41 in FindPolygons (obj=0x8a92a30, Out=0x1) at 
> > > > shp2pgsql.c:847 #4  0x0804f12c in InsertPolygon () at 
> > > > shp2pgsql.c:997 #5  0x0804e62b in LoadData () at shp2pgsql.c:640
> > > > #6  0x0804e10c in main (ARGC=7, ARGV=0xbfe437f4) at 
> > shp2pgsql.c:401
> > > > 
> > > > _______________________________________________
> > > > postgis-users mailing list postgis-users at postgis.refractions.net
> > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > _______________________________________________
> > > postgis-users mailing list postgis-users at postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > _______________________________________________
> > postgis-users mailing list postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users