From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] "out of free buffers: time to abort" message? |
Date: | 1999-08-17 21:59:52 |
Message-ID: | 199908172159.RAA08653@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> I have just checked in a little test script that I've been using for a
> while (since before 6.5) to pound on lesser-used paths in the optimizer.
> It's called src/test/regress/regressplans.sh, and it just runs the
> regular regression tests with different PGOPTIONS settings to force
> varying plan type selections.
>
> The reason I bring it up is that recently the thing has been failing
> with backend messages "ERROR: out of free buffers: time to abort" (often
> followed by a core dump) at what seem to be random places. Running the
> regression test standalone with the same PGOPTIONS settings does not
> reproduce the error, and in fact it happens to different tests if you
> run the script over and over.
>
> I have also sometimes seen failures out of mdblindwrt, apparently trying
> to dump a dirty buffer for a no-longer-existing database.
>
> Anyone have any idea how to debug this, or what might be triggering it?
> The best theory I've come up with is that it's got something to do with
> the repeated destruction and re-creation of the "regression" database.
> But usually the failure occurs during the later tests within a
> particular regression set, so you'd think any effects of destroying
> the previous incarnation of the DB would be long gone.
If you restart the postmaster for every test, does the problem go away?
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Mercer | 1999-08-17 22:23:29 | getting at the actual int4 value of an abstime |
Previous Message | Tom Lane | 1999-08-17 21:32:19 | "out of free buffers: time to abort" message? |