can you have any idea about toast missing chunk issu resolution

Поиск
Список
Период
Сортировка

 

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

 

В списке pgsql-general по дате отправления:

Предыдущее
От: amihay gonen
Дата:
Сообщение: Fwd: What is the best way to model attributes relations ?
Следующее
От: Daniel Begin
Дата:
Сообщение: Indexing large table of coordinates with GiST