[postgis-users] [BUGS] ERROR: XX000: function 60821C60 returned NULL

[Obe, Regina]

I asked the pgsql-bugs - (there comments below) and they think its a
PostGIS issue.  I do have a gist index on the_point field.  I think it
does cause a core dump since if I am connected via PgAdmin immediately
after doing a load, my connection is broken and I have to connect again.
I forgot to mention I update the_point field after the data is loaded,
but during load the_point is null and again I suspect it has something
to do with the frequency of my load since the other tables are fine (and
this is fine for a while and then it starts happening).

Thanks,
Regina
 
I'm running "POSTGIS="1.1.6" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.5.0,
22 Oct 2006" USE_STATS"
 ---------------------------------COMMENT FROM Ogbugs
-------------------------------
That's a pretty low-level error; you shouldn't be able to trigger it
yourself without writing your own datatype or some such. Given the set
of types in your table, I'm betting that the bug is actually in PostGIS,
either in the geometry input converter or one of the index support
functions for geometry (you didn't show an index on the_point, but is
there one?). Try asking over there if they know of any such problems as
of 8.2.

regards, tom lane

--------------------
________________________________

From: Obe, Regina 
Sent: Tuesday, January 02, 2007 12:38 PM
To: pgsql-bugs at postgresql.org
Subject: RE: [BUGS] ERROR: XX000: function 60821C60 returned NULL


Correction upgrade to PG 8.2

________________________________

From: pgsql-bugs-owner at postgresql.org
[mailto:pgsql-bugs-owner at postgresql.org] On Behalf Of Obe, Regina
Sent: Tuesday, January 02, 2007 12:36 PM
To: pgsql-bugs at postgresql.org
Subject: [BUGS] ERROR: XX000: function 60821C60 returned NULL


I have an SQL job on SQL Server that dumps data to a table in
PostGreSQL.  This job worked fine when it was going against a PG 8.1.3
server, but since my upgrade to PG 8.2, it has been working
intermittently.  Mostly not working and erroring out with
 
ERROR: XX000: function 60821C60 returned NULL
 
I have other jobs doing similar feeds to other tables, and they still
work fine.  So I can't quite figure out what is wrong with this one.
The only difference with this table is that the copy is done hourly
where as the other ones are done daily.
 
The table being inserted into looks like the below.  If I drop the table
and recreate it, the routine starts working again.  My SQL Server DTS
job uses the ODBC driver, but I tried a .NET script that uses the npgsql
driver and had the same issues.  All fields are inserted into except the
the_point and gid fields.  I'm going to reduce the frequency of
uploading and take out the OID to see if that makes a difference.
 
CREATE TABLE hbasessionsremaining
(
  sessioncode character varying(17) NOT NULL,
  remainingslots integer,
  meetstarttime timestamp without time zone,
  meetendtime timestamp without time zone,
  number smallint NOT NULL,
  date timestamp without time zone,
  course character varying(5) NOT NULL,
  classcode character varying(8) NOT NULL,
  numberwaitlisted integer,
  sessiongroup character varying(17),
  "location" character varying(50),
  locparcelid character(10),
  descrip character varying(50),
  locationcode character varying(3) NOT NULL,
  the_point geometry,
  address character varying(500),
  gid serial NOT NULL,
  CONSTRAINT pk_hbasessionsremaining PRIMARY KEY (sessioncode),
  CONSTRAINT udx_hbasessionsremaining_gid UNIQUE (gid)
) 
WITHOUT OIDS;
ALTER TABLE hbasessionsremaining OWNER TO robedev;
GRANT ALL ON TABLE hbasessionsremaining TO robedev;
GRANT ALL ON TABLE hbasessionsremaining TO dnddtsadmins WITH GRANT
OPTION;
 
Thanks,
Regina
 
 
 
 
 
 

________________________________



The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any computer.