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

Reply via email to