Re[2]: [BUGS] BUG #12241: uninitialized value $lib_path

From: Aleks Dark <aleks(dot)dark(at)inbox(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re[2]: [BUGS] BUG #12241: uninitialized value $lib_path
Date: 2014-12-16 15:34:23
Message-ID: 1418744063.964279479@f20.i.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello All,

Issue can be closed, found the solution, sorry for disturbance.

Thanks, Tom, for an attempt, but actually the issue was in 3 things of postgresql:

1. /tmp/.s.**** and /var/run/postgresql ownage and chmod settings. (+ pid deleting if not helping and killing all (theoretically) running servers by reported ports.)
2. The server is meant to be started by postgres user, not '-u postgres' . (Don't know why, it just is so... Took long time to figure it out, would be great if someone can give a logical explanation.)
3. Database must by initiated by postgres, and chmod settings of global/pg_filenode.map should be checked. (Default were misconfigured in Debian...)

P.S. /usr/bin/psql is recommended install dir by guide if building postgresql from sources, or using distributed package manager.
P.P.S. Just in case someone used guide, and this solution didn't help to fix the issue, extrainfo: Manual build was installed to other than recommended place ( to avoid messing with package manager.), so extraissues are possible.

--
Lex

Mon, 15 Dec 2014 20:19:38 -0500 от Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>aleks(dot)dark(at)inbox(dot)ru writes:
>> Similar error to case in 2011, but this time no upgrade available. Any hints
>> what is going wrong?
>
>> Use of uninitialized value $lib_path in concatenation (.) or string at
>> /usr/bin/psql line 132.
>> psql (PostgreSQL) 9.3.5
>
>> $ ldd /usr/lib/postgresql/9.3/bin/psql
>
>Note that the complaint is specifically about /usr/bin/psql, not
>/usr/lib/postgresql/9.3/bin/psql.
>
>I would guess that /usr/bin/psql is a Perl script that is supposed to
>invoke the real psql but is going off the rails somehow. You will need
>to speak with whoever produced the PG package you're using, because any
>such script would've been supplied by the packager, not by the Postgres
>community.
>
>regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message chrisgoldstar 2014-12-17 11:34:56 BUG #12257: Cause for: Exception 0xC0000005
Previous Message David G Johnston 2014-12-16 15:15:02 Re: execution plan and record variable in dynamic sql