8.2beta1 (w32): server process crash (tsvector) - Mailing list pgsql-bugs

the following query will crash the server process:

INSERT INTO news.news
SELECT * FROM news.news2;

news.news is empty;
news.news2 contains 600 records. both have the same structure (see end of m=
ail)

when the tsvector column & trigger is dumped from the two tables everything=
 works as expected.

regards,
thomas


full log:

2006-10-17 05:56:18 LOG:  database system was shut down at 2006-10-17 05:56=
:17 W. Europe Daylight Time
2006-10-17 05:56:18 LOG:  Windows fopen("recovery.conf","r") failed: code 2=
, errno 2
2006-10-17 05:56:18 LOG:  Windows fopen("pg_xlog/00000001.history","r") fai=
led: code 2, errno 2
2006-10-17 05:56:18 LOG:  Windows fopen("backup_label","r") failed: code 2,=
 errno 2
2006-10-17 05:56:18 LOG:  checkpoint record is at 0/A0E16030
2006-10-17 05:56:18 LOG:  redo record is at 0/A0E16030; undo record is at 0=
/0; shutdown TRUE
2006-10-17 05:56:18 LOG:  next transaction ID: 0/6899; next OID: 5998391
2006-10-17 05:56:18 LOG:  next MultiXactId: 1; next MultiXactOffset: 0
2006-10-17 05:56:18 LOG:  database system is ready
2006-10-17 05:56:18 LOG:  transaction ID wrap limit is 2147484172, limited =
by database "postgres"
2006-10-17 06:04:07 LOG:  server process (PID 1728) exited with exit code -=
1073741819
2006-10-17 06:04:07 LOG:  terminating any other active server processes
2006-10-17 06:04:07 WARNING:  terminating connection because of crash of an=
other server process
2006-10-17 06:04:07 DETAIL:  The postmaster has commanded this server proce=
ss to roll back the current transaction and exit, because another server pr=
ocess exited abnormally and possibly corrupted shared memory.
2006-10-17 06:04:07 HINT:  In a moment you should be able to reconnect to t=
he database and repeat your command.
2006-10-17 06:04:07 LOG:  all server processes terminated; reinitializing
2006-10-17 06:04:08 LOG:  database system was interrupted at 2006-10-17 06:=
04:01 W. Europe Daylight Time
2006-10-17 06:04:08 LOG:  Windows fopen("recovery.conf","r") failed: code 2=
, errno 2
2006-10-17 06:04:08 LOG:  Windows fopen("pg_xlog/00000001.history","r") fai=
led: code 2, errno 2
2006-10-17 06:04:08 LOG:  Windows fopen("backup_label","r") failed: code 2,=
 errno 2
2006-10-17 06:04:08 LOG:  checkpoint record is at 0/A19FC5E8
2006-10-17 06:04:08 LOG:  redo record is at 0/A19FC5E8; undo record is at 0=
/0; shutdown FALSE
2006-10-17 06:04:08 LOG:  next transaction ID: 0/7089; next OID: 6014775
2006-10-17 06:04:08 LOG:  next MultiXactId: 1; next MultiXactOffset: 0
2006-10-17 06:04:08 LOG:  database system was not properly shut down; autom=
atic recovery in progress
2006-10-17 06:04:08 LOG:  redo starts at 0/A19FC638
2006-10-17 06:04:08 LOG:  unexpected pageaddr 0/9B2CC000 in log file 0, seg=
ment 162, offset 2932736
2006-10-17 06:04:08 LOG:  redo done at 0/A22CBF88
2006-10-17 06:04:08 LOG:  database system is ready
2006-10-17 06:04:08 LOG:  Windows fopen("global/pg_fsm.cache","rb") failed:=
 code 2, errno 2
2006-10-17 06:04:08 LOG:  transaction ID wrap limit is 2147484172, limited =
by database "postgres"
2006-10-17 06:04:08 LOG:  Windows fopen("global/pgstat.stat","rb") failed: =
code 2, errno 2



-- Table: news.news

-- DROP TABLE news.news;

CREATE TABLE news.news
(
  id integer NOT NULL DEFAULT nextval('news_id_seq'::regclass),
  "show" boolean NOT NULL DEFAULT false,
  date_news timestamp without time zone(-4) NOT NULL DEFAULT now(),
  date_added timestamp without time zone(-4) NOT NULL DEFAULT now(),
  headline character varying(100) NOT NULL DEFAULT ''::character varying,
  editor character varying(50) NOT NULL DEFAULT ''::character varying,
  text_raw text NOT NULL DEFAULT ''::text,
  text_formated text NOT NULL DEFAULT ''::text,
  text_summary character varying(400) NOT NULL DEFAULT ''::character varyin=
g,
  image_large character varying(100) NOT NULL DEFAULT ''::character varying,
  image_small character varying(100) NOT NULL DEFAULT ''::character varying,
  image_height integer NOT NULL DEFAULT 0,
  image_caption character varying(100) NOT NULL DEFAULT ''::character varyi=
ng,
  link1_url character varying(255) NOT NULL DEFAULT ''::character varying,
  link1_title character varying(70) NOT NULL DEFAULT ''::character varying,
  link2_url character varying(255) NOT NULL DEFAULT ''::character varying,
  link2_title character varying(70) NOT NULL DEFAULT ''::character varying,
  "comment" character varying(400) NOT NULL DEFAULT ''::character varying, =
-- interner kommentar
  forum_count integer NOT NULL DEFAULT 0,
  forum_id integer NOT NULL DEFAULT 0,
  source_title character varying(70) NOT NULL DEFAULT ''::character varying,
  source_url character varying(255) NOT NULL DEFAULT ''::character varying,
  idxfti tsvector,
  text_content text DEFAULT ''::text,
  text_lead character varying(120) NOT NULL DEFAULT ''::character varying,
  CONSTRAINT news_pkey PRIMARY KEY (id)
)=20
WITHOUT OIDS;
ALTER TABLE news.news OWNER TO db_outnow;
COMMENT ON COLUMN news.news."comment" IS 'interner kommentar';


-- Index: news.news_date_idx

-- DROP INDEX news.news_date_idx;

CREATE INDEX news_date_idx
  ON news.news
  USING btree
  (date_news);

-- Index: news.news_id_idx

-- DROP INDEX news.news_id_idx;

CREATE INDEX news_id_idx
  ON news.news
  USING btree
  (id);



-- Trigger: news_ts_update on news.news

-- DROP TRIGGER news_ts_update ON news.news;

CREATE TRIGGER news_ts_update
  BEFORE INSERT OR UPDATE
  ON news.news
  FOR EACH ROW
  EXECUTE PROCEDURE tsearch2('idxfti', 'headline', 'text_content');