Re: BUG #5984: Got FailedAssertion("!(opaque->btpo_prev == target)", File: "nbtpage.c", Line: 1166) - Mailing list pgsql-bugs

<meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">



    Hi Robert,

    I'll try this, if possible, with one of the server with
    "duplicates".
    I found another problem to generate duplicates: play with DB with no
    disk space left.

    After that, if I launch a VACCUM FULL, same crash.

    Global question as I didn't find it: are "ERROR:   duplicate key
      value violates unique constraint" fatal errors ? As they may
    (most of the time) be corrected with reindexdb --all
    Someone told me some weeks ago "it's only a notice, the database
      is not corrupted" ...

    Regards,

      <div style="font-size: 13.3px; font-family:
        Verdana,Arial,Helvetica,sans-serif;">

          <span style="font-weight: bold;
              color: rgb(51, 51, 51);">Pascal BORSCHNECK<br
              style="color: rgb(51, 51, 51);">
            Port: +33
              (0)630495775
             
            <a
                href="mailto:borschneck@hotmail.com">borschneck@hotmail.com
              http://www.arfy.fr

        My profiles:  <a
          href="http://fr.linkedin.com/in/pascalborschneck"
          style="text-decoration: underline;"><img alt="LinkedIn"
            style="padding: 0px 0px 5px; vertical-align: middle;"
            src="cid:part1.06080504.05080708@hotmail.com" width="16"
            border="0" height="16"> <a
          href="http://www.facebook.com/borschneck"
          style="text-decoration: underline;"><img alt="Facebook"
            style="padding: 0px 0px 5px; vertical-align: middle;"
            src="cid:part2.08010508.01010204@hotmail.com" width="16"
            border="0" height="16"> <a
          href="http://twitter.com/Arfang" style="text-decoration:
          underline;"><img alt="Twitter" style="padding: 0px 0px 5px;
            vertical-align: middle;"
            src="cid:part3.02000203.07070804@hotmail.com" width="16"
            border="0" height="16">
        Chat <img alt="MSN"
          style="padding: 0px 0px 5px; vertical-align: middle;"
          src="cid:part4.04030500.08000303@hotmail.com" width="16"
          border="0" height="16"> borschneck@hotmail.com <img
          alt="Skype" style="padding: 0px 0px 5px; vertical-align:
          middle;" src="cid:part5.06070705.07090906@hotmail.com"
          width="16" border="0" height="16"> arfyfr <img alt="Google
          Talk" style="padding: 0px 0px 5px; vertical-align: middle;"
          src="cid:part6.08050308.01000907@hotmail.com" width="16"
          border="0" height="16"> pascal.borschneck@gmail.com
        Arfy's
            blog <a
            href="http://feedproxy.google.com/%7Er/Arfyz/%7E3/uUwbMY5UHSg/index.php"><span
              style="color: rgb(0, 0, 238); text-decoration: underline;">Geeky-gadgets.com
              - Eton Raptor Solar Survival Tool
        <img src="cid:part7.00040903.02000002@hotmail.com" width="1"
          height="1">



    Le 23/05/2011 19:12, Robert Haas a écrit :
    <blockquote
      cite="mid:BANLkTim2GUXA9TF93jRfDxCR6pTUOWZu3A@mail.gmail.com"
      type="cite">On Mon, May 16, 2011 at 8:04 AM, Pascal Borschneck <span
        dir="ltr"><<a moz-do-not-send="true"
          href="mailto:borschneck@hotmail.com">borschneck@hotmail.com>
      wrote:

        <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
          0.8ex; border-left: 1px solid rgb(204, 204, 204);
          padding-left: 1ex;">

            Hi Robert,


            Sorry for the late reply, I was not here last week.


            About your question: "That's kind of surprising, but
                I can't help wondering if it's a bug in what
                virtualization tool you are using."
            I noticed the problem FIRST on VM.  And by
              pausing/stopping/launching a VM it was easy to get these
              error back.


            But since some weeks, I also had duplicates on
              real server.  And same result if I try to launch a VACUUM:
              crash with the same assertion.
            Which "stack trace on the assertion failure" do
              you want to have ?





      Well, when a backend crashes, it would be helpful to know what was
      going on when it crashed.  See this wiki page:

      <a moz-do-not-send="true"

href="http://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend">http://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend<br
        clear="all">

      --
      Robert Haas
      EnterpriseDB: <a moz-do-not-send="true"
        href="http://www.enterprisedb.com" target="_blank">http://www.enterprisedb.com
      The Enterprise PostgreSQL Company