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');
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) |