BUG: Vacuum Analyze - datumGetSize: Invalid typLen 0

From: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Cc: <teodor(at)sigaev(dot)ru>, <oleg(at)sai(dot)msu(dot)su>
Subject: BUG: Vacuum Analyze - datumGetSize: Invalid typLen 0
Date: 2003-03-27 01:42:26
Message-ID: 3252.63.226.186.156.1048729346.squirrel@mail.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

System: NetBSD / Alpha 1.6 (64 bit)
Postgresql 7.3.2

Bug: after vacuum analyze, I'm unable to do a simple select. Instead I'm
getting this error:

ERROR: datumGetSize: Invalid typLen 0

Many thanks to Teodor Sigaev for helping verify this bug. The following
test suite came from Teodor:

Reproduce bug:
initdb and start postmaster
%createdb foo
%psql foo < bug.sql
CREATE TABLE
INSERT 16996 1
INSERT 16997 1
CREATE TABLE
INSERT 17003 1
ts_name | ts_name
---------+---------
default | default
default | default
(2 rows)

VACUUM
ERROR: datumGetSize: Invalid typLen 0

bug.sql is very simple:
------------------------------------------------
CREATE TABLE pg_ts_cfgmap (
ts_name text
);

insert into pg_ts_cfgmap values ('default');
insert into pg_ts_cfgmap values ('default');

CREATE TABLE pg_ts_cfg (
ts_name text
);

insert into pg_ts_cfg values ('default');

select
*
from
pg_ts_cfgmap,
pg_ts_cfg
where
pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name;

vacuum analyze pg_ts_cfgmap;

select
*
from
pg_ts_cfgmap,
pg_ts_cfg
where
pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name;

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

Thomas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-03-27 01:55:34 Solution to UPDATE...INSERT problem
Previous Message Kevin Brown 2003-03-26 23:42:24 Re: A bad behavior under autocommit off mode