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'); |
- [BUGS] 8.2beta1 (w32): server process crash (tsvector) me
- Re: [BUGS] 8.2beta1 (w32): server process crash (tsve... Tom Lane