can you have any idea about toast missing chunk issu resolution - Mailing list pgsql-hackers

From M Tarkeshwar Rao
Subject can you have any idea about toast missing chunk issu resolution
Date
Msg-id 1C16813DAFF3E44B939586605D40E9F011768E46@ESESSMB107.ericsson.se
Whole thread Raw
Responses Re: can you have any idea about toast missing chunk issu resolution
List pgsql-hackers
<div class="WordSection1"><p class="MsoNormal"><span style="color:#1F497D">Hi all,</span><span
style="color:black"></span><pclass="MsoNormal"><span style="color:#1F497D"> </span><span style="color:black"></span><p
class="MsoNormal"><spanstyle="color:#1F497D">We are getting following error message on doing any action on the table
like(Selector open from pgadmin).</span><span style="color:black"></span><p class="MsoNormal"><span
style="color:#1F497D"> </span><spanstyle="color:black"></span><p class="MsoNormal"><span style="color:#1F497D">Please
suggest.</span><spanstyle="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:black"> </span><spanstyle="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:red">ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619</span><span
style="color:black"></span><pclass="MsoNormal"><span lang="EN-US" style="color:red">********** Error
**********</span><spanstyle="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:red"> </span><spanstyle="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:red">ERROR:missing chunk number 0 for toast value 54787 in pg_toast_2619</span><span
style="color:black"></span><pclass="MsoNormal"><span lang="EN-US" style="color:red">SQL state: XX000</span><span
style="color:black"></span><pclass="MsoNormal"><span lang="EN-US" style="color:red"> </span><span
style="color:black"></span><pclass="MsoNormal"><span lang="EN-US" style="color:black"> </span><span
style="color:black"></span><pclass="MsoNormal"><span lang="EN-US" style="color:black">CREATE TABLE
mm_activealarm</span><spanstyle="color:black"></span><p class="MsoNormal"><span lang="SV"
style="color:black">(</span><pclass="MsoNormal"><span lang="SV" style="color:black">  alarm_id integer NOT
NULL,</span><pclass="MsoNormal"><span lang="SV" style="color:black">  </span><span lang="EN-US"
style="color:black">source_addresscharacter varying(255) NOT NULL,</span><span style="color:black"></span><p
class="MsoNormal"><spanlang="EN-US" style="color:black">  alarm_instance_id integer NOT NULL,</span><span
style="color:black"></span><pclass="MsoNormal"><span lang="EN-US" style="color:black">  alarm_raise_time
bigint,</span><spanstyle="color:black"></span><p class="MsoNormal"><span lang="EN-US" style="color:black"> 
alarm_update_timebigint,</span><span style="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:black"> alarm_cease_time bigint,</span><span style="color:black"></span><p class="MsoNormal"><span
lang="EN-US"style="color:black">  alarm_count integer,</span><span style="color:black"></span><p
class="MsoNormal"><spanlang="EN-US" style="color:black">  alarm_severity integer NOT NULL,</span><span
style="color:black"></span><pclass="MsoNormal"><span lang="EN-US" style="color:black">  source_type character
varying(40)NOT NULL,</span><span style="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:black"> alarm_state integer NOT NULL,</span><span style="color:black"></span><p class="MsoNormal"><span
lang="EN-US"style="color:black">  event_type integer,</span><span style="color:black"></span><p class="MsoNormal"><span
lang="EN-US"style="color:black">  notification_id integer NOT NULL,</span><span style="color:black"></span><p
class="MsoNormal"><spanlang="EN-US" style="color:black">  probable_cause integer NOT NULL,</span><span
style="color:black"></span><pclass="MsoNormal"><span lang="EN-US" style="color:black">  specific_problem integer NOT
NULL,</span><spanstyle="color:black"></span><p class="MsoNormal"><span lang="EN-US" style="color:black"> 
alarm_additional_textcharacter varying(10240),</span><span style="color:black"></span><p class="MsoNormal"><span
lang="EN-US"style="color:black">  alarm_ack_time bigint,</span><span style="color:black"></span><p
class="MsoNormal"><spanlang="EN-US" style="color:black">  alarm_ack_user character varying(100) NOT NULL,</span><span
style="color:black"></span><pclass="MsoNormal"><span lang="EN-US" style="color:black">  alarm_ack_system character
varying(100)NOT NULL,</span><span style="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:black"> alarm_proposed_repair_action character varying(10240) NOT NULL,</span><span
style="color:black"></span><pclass="MsoNormal"><span lang="EN-US" style="color:black">  CONSTRAINT mm_activealarm_pk
PRIMARYKEY (alarm_id, source_address)</span><span style="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:black"> USING INDEX TABLESPACE mgrdata</span><span style="color:black"></span><p class="MsoNormal"><span
lang="EN-US"style="color:black">)</span><span style="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:black">WITH(</span><span style="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:black"> OIDS=FALSE</span><span style="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:black">)</span><spanstyle="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:black">TABLESPACEmgrdata;</span><span style="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:black">ALTERTABLE </span><span lang="EN-US" style="color:#1F497D">ss</span><span lang="EN-US"
style="color:black">_activealarm</span><spanstyle="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:black"> OWNER TO </span><span lang="EN-US" style="color:#1F497D">ss_</span><span lang="EN-US"
style="color:black">super;</span><spanstyle="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:black"> </span><spanstyle="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:#1F497D">Regards</span><spanstyle="color:black"></span><p class="MsoNormal"><span lang="EN-US"
style="color:#1F497D">Tarkeshwar</span><spanstyle="color:black"></span><p class="MsoNormal"> </div> 

pgsql-hackers by date:

Previous
From: Воронин Дмитрий
Date:
Subject: Re: ereport bug
Next
From: andres@anarazel.de (Andres Freund)
Date:
Subject: Re: s_lock.h default definitions are rather confused