From: | M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | can you have any idea about toast missing chunk issu resolution |
Date: | 2015-01-15 12:22:29 |
Message-ID: | 1C16813DAFF3E44B939586605D40E9F011768E46@ESESSMB107.ericsson.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hi all,
We are getting following error message on doing any action on the table like(Select or open from pgadmin).
Please suggest.
ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619
********** Error **********
ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619
SQL state: XX000
CREATE TABLE mm_activealarm
(
alarm_id integer NOT NULL,
source_address character varying(255) NOT NULL,
alarm_instance_id integer NOT NULL,
alarm_raise_time bigint,
alarm_update_time bigint,
alarm_cease_time bigint,
alarm_count integer,
alarm_severity integer NOT NULL,
source_type character varying(40) NOT NULL,
alarm_state integer NOT NULL,
event_type integer,
notification_id integer NOT NULL,
probable_cause integer NOT NULL,
specific_problem integer NOT NULL,
alarm_additional_text character varying(10240),
alarm_ack_time bigint,
alarm_ack_user character varying(100) NOT NULL,
alarm_ack_system character varying(100) NOT NULL,
alarm_proposed_repair_action character varying(10240) NOT NULL,
CONSTRAINT mm_activealarm_pk PRIMARY KEY (alarm_id, source_address)
USING INDEX TABLESPACE mgrdata
)
WITH (
OIDS=FALSE
)
TABLESPACE mgrdata;
ALTER TABLE ss_activealarm
OWNER TO ss_super;
Regards
Tarkeshwar
From | Date | Subject | |
---|---|---|---|
Next Message | M Tarkeshwar Rao | 2015-01-15 12:30:20 | can you have any idea about toast missing chunk issu resolution |
Previous Message | amihay gonen | 2015-01-15 11:44:34 | Fwd: What is the best way to model attributes relations ? |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2015-01-15 12:34:11 | Re: s_lock.h default definitions are rather confused |
Previous Message | Воронин Дмитрий | 2015-01-15 12:22:03 | Re: ereport bug |