Beta2 crash / create type + tsearch2 - Mailing list pgsql-hackers

From Radoslaw Zielinski
Subject Beta2 crash / create type + tsearch2
Date
Msg-id 20071106223723.GA5097@bzium
Whole thread Raw
Responses Re: Beta2 crash / create type + tsearch2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hello,

Beta2 crashes on restoring a dump of tsearch2-enabled database, as
produced by 8.2.x (x==5 IIRC) pg_dump; the shortest way I know to get
the SIG11:
 SET search_path = public, pg_catalog;
 CREATE TYPE tsvector;
 CREATE FUNCTION tsvector_in(cstring) RETURNS tsvector     AS '$libdir/tsearch2', 'tsvector_in'     LANGUAGE c STRICT;
 CREATE FUNCTION tsvector_out(tsvector) RETURNS cstring     AS '$libdir/tsearch2', 'tsvector_out'     LANGUAGE c
STRICT;
 CREATE TYPE tsvector (     INTERNALLENGTH = variable,     INPUT = tsvector_in,     OUTPUT = tsvector_out,
ALIGNMENT= int4,     STORAGE = extended ); 
 select '42'::tsvector;    -- dead


Logs:
 postgres[32542]: [100-1] NOTICE:  return type tsvector is only a shell postgres[32542]: [101-1] NOTICE:  argument type
tsvectoris only a shell postgres[2794]: [98-1] LOG:  server process (PID 32542) was terminated by signal 11:
Segmentationfault postgres[2794]: [99-1] LOG:  terminating any other active server processes postgres[2794]: [100-1]
LOG: all server processes terminated; reinitializing postgres[32543]: [101-1] LOG:  database system was interrupted;
lastknown up at 2007-11-01 22:18:33 GMT postgres[32543]: [102-1] LOG:  database system was not properly shut down;
automaticrecovery in progress postgres[32543]: [103-1] LOG:  redo starts at 0/35053E8 postgres[32543]: [104-1] LOG:
invalidmagic number 0000 in log file 0, segment 3, offset 5283840 postgres[32543]: [105-1] LOG:  redo done at 0/3507FE4
postgres[32546]:[101-1] LOG:  autovacuum launcher started postgres[2794]: [101-1] LOG:  database system is ready to
acceptconnections 


Database: encoding SQL_ASCII, locale C.


Top of the backtrace (postgres --single):
 #0  0x08272e0b in gettoken_tsvector (state=0xbf8e5edc, strval=0x100, lenval=0x0, pos_ptr=0x2da00, poslen=0x842de50,
endptr=0x42b32ebb)    at tsvector_parser.c:356 #1  0x42b1e16f in tsvector_in (fcinfo=0xbf8e5f2c) at tsvector.c:436 #2
0x08288b71in InputFunctionCall (flinfo=0x0, str=0x840ecc0 "42", typioparam=237587, typmod=-1) at fmgr.c:1835 #3
0x0828abdein OidInputFunctionCall (functionId=237588, str=0x840ecc0 "42", typioparam=237587, typmod=-1) at fmgr.c:1939
#4 0x08106f3b in stringTypeDatum (tp=0x42acf8c8, string=0x840ecc0 "42", atttypmod=-1) at parse_type.c:462 #5
0x081096dcin coerce_type (pstate=0x840ee78, node=0x840e890, inputTypeId=705, targetTypeId=237587, targetTypeMod=-1,
ccontext=COERCION_EXPLICIT, cformat=COERCE_EXPLICIT_CAST) at parse_coerce.c:210 



Is contrib/tsearch2 obsolete?


I have noticed that the variables token, toklen, pos and poslen are not
initialized in src/backend/utils/adt/tsvector.c::tsvectorin() (and
contain automatic trash), but are written in (the RETURN_TOKEN macro at)
src/backend/utils/adt/tsvector_parser.c::gettoken_tsvector() if not
NULL... is this correct?

--
Radosław Zieliński <radek@pld-linux.org>

pgsql-hackers by date:

Previous
From: Robert Hodges
Date:
Subject: Re: Test lab
Next
From: "Guillaume Smet"
Date:
Subject: Re: Test lab