[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] cache lookup failed for index
From:       Willy-Bas Loos <willybas () gmail ! com>
Date:       2016-06-29 15:01:18
Message-ID: CAHnozTjqUTg9ncgnbB+KhQvCX49VAwxOfpnYojqWhCpr+MVv3Q () mail ! gmail ! com
[Download RAW message or body]

On Wed, Jun 29, 2016 at 4:26 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Willy-Bas Loos <willybas@gmail.com> writes:
> > So what i don't get is, -if the above is the case- If  pg_dump expects to
> > find an index, it already knows about its existence. Then why does it
> need
> > to look for it again?
>
>
> pg_dump can't tell the index is no longer there --- but some of the
> backend functions it calls can tell, and they throw errors.
>
> There are various ways this might be rejiggered, but none of them
> entirely remove all risk of failure in the presence of concurrent DDL.
> Personally I'd recommend just retrying the pg_dump until it succeeds.
>
>                         regards, tom lane
>

Now that i know what it is, I can live with it.
Thanks for the insight!

-- 
Willy-Bas Loos

[Attachment #3 (text/html)]

<div dir="ltr"><br><div class="gmail_extra"><div class="gmail_quote">On Wed, Jun 29, \
2016 at 4:26 PM, Tom Lane <span dir="ltr">&lt;<a href="mailto:tgl@sss.pgh.pa.us" \
target="_blank">tgl@sss.pgh.pa.us</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><span class="">Willy-Bas Loos &lt;<a \
href="mailto:willybas@gmail.com">willybas@gmail.com</a>&gt; writes:<br> &gt; So what \
i don&#39;t get is, -if the above is the case- If   pg_dump expects to<br> &gt; find \
an index, it already knows about its existence. Then why does it need<br> &gt; to \
look for it again?<br> <br>
</span><br>
pg_dump can&#39;t tell the index is no longer there --- but some of the<br>
backend functions it calls can tell, and they throw errors.<br>
<br>
There are various ways this might be rejiggered, but none of them<br>
entirely remove all risk of failure in the presence of concurrent DDL.<br>
Personally I&#39;d recommend just retrying the pg_dump until it succeeds.<br>
<br>
                                    regards, tom lane<br>
</blockquote></div><br><div>Now that i know what it is, I can live with \
it.<br></div>Thanks for the insight!<br clear="all"><br>-- <br><div \
class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Willy-Bas \
Loos<br></div></div> </div></div>



[prev in list] [next in list] [prev in thread] [next in thread]