| From: | Thomas Eckestad <thomas(dot)eckestad(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #7634: Missing files in global/ after a lot of CREATE DATABASE / DROP DATABASE |
| Date: | 2012-11-02 09:58:24 |
| Message-ID: | CACOF0bzVmKQuPV9n+6b8YRVj57OmyycYBwTPbOUxd_u5UGprNw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
2012/11/1 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>
> That is extremely peculiar --- AFAICS, 9.1 should never assign a
> relfilenode of 12693. (OIDs assigned by initdb don't get past about
> 11900 in that version, and OIDs assigned after normal postmaster start
> should always be above 16384.) Is it always exactly "global/12693"
> that's complained of? Could you monitor the contents of $PGDATA/global
> and see if the set of filenames present changes while you're running
> these tests?
>
> regards, tom lane
>
No, it is not always global/12693. A few days ago it was global/12589 that
got lost.
I am afraid that I can not guarantee that the example that I posted
(global/12693) was triggered with version 9.1.6. It might be for 9.0.x or
9.1.x, if that makes a difference. I am sure though that global/12589 was
triggered using 9.1.5 (upgraded to 9.1.6 just a few days ago).
Sorry for the version confusion.
I will monitor global/ and try to trigger the bug and get back to you next
week.
Regards,
Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Curd Reinert | 2012-11-02 13:23:32 | Re: BUG #6494: Listening to * fails for IP V6 |
| Previous Message | Tom Lane | 2012-11-01 22:33:17 | Re: BUG #7634: Missing files in global/ after a lot of CREATE DATABASE / DROP DATABASE |