From: | Alexey Parshin <alexeyp(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #5680: Failure to start: too many private dirs demanded |
Date: | 2010-09-28 21:12:40 |
Message-ID: | AANLkTi=-VoB1Qpp4sY181H+xx5zbKyoXTTOgUHpGj3UD@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Sorry. My bad :)
After tracing postmaster as Alvaro suggested, I found the following fragment
(one of thousand):
stat64("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2183, ...}) = 0
stat64("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2183, ...}) = 0
stat64("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2183, ...}) = 0
stat64("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2183, ...}) = 0
stat64("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2183, ...}) = 0
stat64("/usr/share/zoneinfo/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Australia/Eucla",
{st_mode=S_IFREG|0644, st_size=446, ...}) = 0
open("/usr/share/zoneinfo",
O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY|O_CLOEXEC) = 24
getdents64(24, /* 70 entries */, 32768) = 2032
close(24) = 0
And then found a link /usr/share/zoneinfo/Australia/Australia to
/usr/share/zoneinfo/Australia/Australia. Clearly, this isn't PostgreSQL
fault. Removing that link solved it. Thanks a lot.
A simple suggestion that would help in diagnostics: A message like 'too many
dir entries demanded' is more useful if the path in question is shown. For
example, a message like:
*Too many dir entries demanded. The path is
"/usr/share/zoneinfo/Australia/Australia/Australia/Australia/Eucla"*
gives the exact clue on what's wrong and doesn't require developer's time.
I'm really grateful for your help,
Alexey
On 29 September 2010 00:19, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Please trace the postmaster, not pg_ctl, as Alvaro suggested
> (or else add the -f flag to the strace call).
>
> regards, tom lane
>
--
Alexey Parshin,
http://www.sptk.net
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-09-28 22:10:33 | Re: BUG #5680: Failure to start: too many private dirs demanded |
Previous Message | Tom Lane | 2010-09-28 20:36:21 | Re: BUG #5681: Using set returning function as subrequest can result losing rows in result set |