8.2beta1 (w32): server process crash (tsvector)

From: <me(at)alternize(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: 8.2beta1 (w32): server process crash (tsvector)
Date: 2006-10-17 04:14:32
Message-ID: 056101c6f1a2$c02eb400$6501a8c0@iwing
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 mail)

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") failed: 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 another server process
2006-10-17 06:04:07 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2006-10-17 06:04:07 HINT: In a moment you should be able to reconnect to the 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") failed: 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; automatic 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, segment 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 varying,
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 varying,
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)
)
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');

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Rusty Conover 2006-10-17 04:51:05 BUG #2697: 8.2beta1 SIGSEGV crash/assertion on insert statement w/ sub-select and placeholders
Previous Message Rusty Conover 2006-10-16 22:31:39 BUG #2697: SIGSEGV crash/assertion on insert statement w/ subselect (very simple test case)