FW: getting error while running sql on mm_activealrm table

Поиск
Список
Период
Сортировка
От M Tarkeshwar Rao
Тема FW: getting error while running sql on mm_activealrm table
Дата
Msg-id 1C16813DAFF3E44B939586605D40E9F011737C1B@ESESSMB107.ericsson.se
обсуждение исходный текст
Ответы Re: FW: getting error while running sql on mm_activealrm table  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general

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 по дате отправления:

Предыдущее
От: Guyren Howe
Дата:
Сообщение: I did some testing of GIST/GIN vs BTree indexing…
Следующее
От: sri harsha
Дата:
Сообщение: TRUNCATE and CREATE TABLE LIKE for foreign tables