Обсуждение: BUG #1072: "$libdir/ascii_and_mic": No such file or directory

The following bug has been logged online:

Bug reference:      1072
Logged by:          Thomas Borg Salling

Email address:      tbs@navicon.dk

PostgreSQL version: 7.4

Operating system:   Red Hat Linux (2.4.20-20.7)

Description:        "$libdir/ascii_and_mic": No such file or directory

Details:

I have downloaded and built Postgres 7.4.1:

as user 'tbs':
./configure --prefix=/opt/postgres-7.4.1/ --with-perl --enable-thread-safety
make
make check

as user 'root':
make install
mkdir /data/postgres
chown -R postgres /opt/postgres-7.4.1
chgrp -R postgres /opt/postgres-7.4.1
chown -R postgres /data/postgres
chgrp -R postgres /data/postgres

as user 'postgres':
[postgres@hubertus postgres]$ /opt/postgres-7.4.1/bin/initdb -D
/data/postgres/
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale en_US.iso885915.

fixing permissions on existing directory /data/postgres/... ok
creating directory /data/postgres//base... ok
creating directory /data/postgres//global... ok
creating directory /data/postgres//pg_xlog... ok
creating directory /data/postgres//pg_clog... ok
selecting default max_connections... 100
selecting default shared_buffers... 1000
creating configuration files... ok
creating template1 database in /data/postgres//base/1... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ERROR:  could not access file
"$libdir/ascii_and_mic": No such file or directory

initdb: failed


Why does this fail? What can I do to resolve it?

Thanks in advance!

/Thomas.

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> I have downloaded and built Postgres 7.4.1:

> as user 'tbs':
> ./configure --prefix=/opt/postgres-7.4.1/ --with-perl --enable-thread-safety
> make
> make check

Did the "make check" work?

> creating conversions... ERROR:  could not access file
> "$libdir/ascii_and_mic": No such file or directory

What's in /opt/postgres-7.4.1/lib?  If you see an ascii_and_mic.so
there, what does ldd say about it?

            regards, tom lane

Hi Tom,

The make check worked fine (log attached).=20

ascii_and_mic.so lives i /opt/postgres-7.4.1/lib, and ldd yields:

[root@hubertus lib]# ldd ascii_and_mic.so=20
        libc.so.6 =3D> /lib/i686/libc.so.6 (0x42000000)
        /lib/ld-linux.so.2 =3D> /lib/ld-linux.so.2 (0x80000000)

the complete contents of /opt/postgres-7.4.1/lib are:

[postgres@hubertus postgres]$ ll /opt/postgres-7.4.1/lib/
total 4984
-rwxr-xr-x    1 postgres postgres     5759 Feb  2 18:01 ascii_and_mic.so
-rwxr-xr-x    1 postgres postgres    13012 Feb  2 18:01 cyrillic_and_mic.so
-rwxr-xr-x    1 postgres postgres     6065 Feb  2 18:01 euc_cn_and_mic.so
-rwxr-xr-x    1 postgres postgres    11803 Feb  2 18:01 euc_jp_and_sjis.so
-rwxr-xr-x    1 postgres postgres     6065 Feb  2 18:01 euc_kr_and_mic.so
-rwxr-xr-x    1 postgres postgres    10632 Feb  2 18:01 euc_tw_and_big5.so
-rwxr-xr-x    1 postgres postgres     7978 Feb  2 18:01
latin2_and_win1250.so
-rwxr-xr-x    1 postgres postgres     7055 Feb  2 18:01 latin_and_mic.so
-rw-r--r--    1 postgres postgres    65352 Feb  2 18:02 libecpg.a
-rw-r--r--    1 postgres postgres    11470 Feb  2 18:02 libecpg_compat.a
lrwxrwxrwx    1 postgres postgres       21 Feb  2 18:02 libecpg_compat.so ->
libecpg_compat.so.1.1
lrwxrwxrwx    1 postgres postgres       21 Feb  2 18:02 libecpg_compat.so.1
-> libecpg_compat.so.1.1
-rwxr-xr-x    1 postgres postgres    18149 Feb  2 18:02
libecpg_compat.so.1.1
lrwxrwxrwx    1 postgres postgres       14 Feb  2 18:02 libecpg.so ->
libecpg.so.4.1
lrwxrwxrwx    1 postgres postgres       14 Feb  2 18:02 libecpg.so.4 ->
libecpg.so.4.1
-rwxr-xr-x    1 postgres postgres    55093 Feb  2 18:02 libecpg.so.4.1
-rw-r--r--    1 postgres postgres    65710 Feb  2 18:02 libpgtypes.a
lrwxrwxrwx    1 postgres postgres       17 Feb  2 18:02 libpgtypes.so ->
libpgtypes.so.1.1
lrwxrwxrwx    1 postgres postgres       17 Feb  2 18:02 libpgtypes.so.1 ->
libpgtypes.so.1.1
-rwxr-xr-x    1 postgres postgres    58224 Feb  2 18:02 libpgtypes.so.1.1
-rw-r--r--    1 postgres postgres   123638 Feb  2 18:02 libpq.a
lrwxrwxrwx    1 postgres postgres       12 Feb  2 18:02 libpq.so ->
libpq.so.3.1
lrwxrwxrwx    1 postgres postgres       12 Feb  2 18:02 libpq.so.3 ->
libpq.so.3.1
-rwxr-xr-x    1 postgres postgres   105391 Feb  2 18:02 libpq.so.3.1
-rwxr-xr-x    1 postgres postgres  1065390 Feb  2 18:02 plperl.so
-rwxr-xr-x    1 postgres postgres   107331 Feb  2 18:02 plpgsql.so
-rwxr-xr-x    1 postgres postgres     5780 Feb  2 18:01 utf8_and_ascii.so
-rwxr-xr-x    1 postgres postgres   227051 Feb  2 18:01 utf8_and_big5.so
-rwxr-xr-x    1 postgres postgres    14372 Feb  2 18:01 utf8_and_cyrillic.so
-rwxr-xr-x    1 postgres postgres   125049 Feb  2 18:01 utf8_and_euc_cn.so
-rwxr-xr-x    1 postgres postgres   218713 Feb  2 18:01 utf8_and_euc_jp.so
-rwxr-xr-x    1 postgres postgres   137497 Feb  2 18:01 utf8_and_euc_kr.so
-rwxr-xr-x    1 postgres postgres   338009 Feb  2 18:01 utf8_and_euc_tw.so
-rwxr-xr-x    1 postgres postgres  1021504 Feb  2 18:01 utf8_and_gb18030.so
-rwxr-xr-x    1 postgres postgres   354564 Feb  2 18:01 utf8_and_gbk.so
-rwxr-xr-x    1 postgres postgres     6203 Feb  2 18:01
utf8_and_iso8859_1.so
-rwxr-xr-x    1 postgres postgres    32683 Feb  2 18:01 utf8_and_iso8859.so
-rwxr-xr-x    1 postgres postgres   280466 Feb  2 18:01 utf8_and_johab.so
-rwxr-xr-x    1 postgres postgres   129195 Feb  2 18:01 utf8_and_sjis.so
-rwxr-xr-x    1 postgres postgres     9707 Feb  2 18:01 utf8_and_tcvn.so
-rwxr-xr-x    1 postgres postgres   280484 Feb  2 18:01 utf8_and_uhc.so
-rwxr-xr-x    1 postgres postgres     9756 Feb  2 18:01 utf8_and_win1250.so
-rwxr-xr-x    1 postgres postgres     9788 Feb  2 18:01 utf8_and_win1256.so
-rwxr-xr-x    1 postgres postgres     9557 Feb  2 18:01 utf8_and_win874.so

Best regards,
Thomas.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20
Sent: Monday, February 02, 2004 4:38 PM
To: tbs@navicon.dk
Cc: PostgreSQL Bugs List
Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or
directory=20

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> I have downloaded and built Postgres 7.4.1:

> as user 'tbs':
> ./configure --prefix=3D/opt/postgres-7.4.1/ --with-perl
--enable-thread-safety
> make
> make check

Did the "make check" work?

> creating conversions... ERROR:  could not access file=20
> "$libdir/ascii_and_mic": No such file or directory=20

What's in /opt/postgres-7.4.1/lib?  If you see an ascii_and_mic.so
there, what does ldd say about it?

            regards, tom lane

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> ascii_and_mic.so lives i /opt/postgres-7.4.1/lib, and ldd yields:

> [root@hubertus lib]# ldd ascii_and_mic.so=20
>         libc.so.6 =3D> /lib/i686/libc.so.6 (0x42000000)
>         /lib/ld-linux.so.2 =3D> /lib/ld-linux.so.2 (0x80000000)

Hmm, nothing wrong with the library file itself then.  So why isn't
initdb able to load it?  The only thing I can think of is some
environment difference between your postgres account and your root
account that affects dynamic linking.  Better look at LD_LIBRARY_PATH
discrepancies, for instance.  You might try running ldd as postgres
instead of root to see if it gives a different answer.  Also you might
want to add /opt/postgres-7.4.1/lib/ to your ldconfig search path.

            regards, tom lane

Hi again,

Running ldd as postgres yields the same as root:

[postgres@hubertus postgres]$ ldd /opt/postgres-7.4.1/lib/ascii_and_mic.so
        libc.so.6 => /lib/i686/libc.so.6 (0x42000000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

the problem occurs when initdb tries to run the conversion_create.sql
script:

# Create pg_conversion and support functions

$ECHO_N "creating conversions... "$ECHO_C
grep -v '^DROP CONVERSION' $datadir/conversion_create.sql |
"$PGPATH"/postgres $PGSQL_OPT template1 > /dev/null || exit_nicely
echo "ok"

for some reason - conversion_create.sql the $libdir is not defined. I tried
to print $libdir from bin/initdb, but this variable is empty. $datadir,
however, is correctly set to /opt/postgres-7.4.1//share.

The following envvars are correctly set for user 'postgres':

export PATH=/opt/postgres-7.4.1/bin:${PATH}
export LD_LIBRARY_PATH=/opt/postgres-7.4.1/lib:${LD_LIBRARY_PATH}
export MANPATH=/opt/postgres-7.4.1/man:${MANPATH}
export PGHOST=localhost
export PGPORT=5432

Hmmm.... ?!

Best regards,
Thomas.

-----Original Message-----
From: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Monday, February 02, 2004 6:19 PM
To: Thomas Borg Salling
Cc: 'PostgreSQL Bugs List'
Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or
directory

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> ascii_and_mic.so lives i /opt/postgres-7.4.1/lib, and ldd yields:

> [root@hubertus lib]# ldd ascii_and_mic.so=20
>         libc.so.6 =3D> /lib/i686/libc.so.6 (0x42000000)
>         /lib/ld-linux.so.2 =3D> /lib/ld-linux.so.2 (0x80000000)

Hmm, nothing wrong with the library file itself then.  So why isn't
initdb able to load it?  The only thing I can think of is some
environment difference between your postgres account and your root
account that affects dynamic linking.  Better look at LD_LIBRARY_PATH
discrepancies, for instance.  You might try running ldd as postgres
instead of root to see if it gives a different answer.  Also you might
want to add /opt/postgres-7.4.1/lib/ to your ldconfig search path.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> for some reason - conversion_create.sql the $libdir is not defined. I tried
> to print $libdir from bin/initdb, but this variable is empty.

$libdir is not an environment variable, it's a notation specially
recognized by CREATE FUNCTION.  It should expand to the same directory
printed by "pg_config --pkglibdir".  You might check what that prints.

The only other idea that comes to mind is that you changed your mind
about the install prefix during the installation and didn't do a full
rebuild.  The PKGLIBDIR setting is hardwired into dfmgr.o at compile
time and maybe it didn't get recompiled.

            regards, tom lane

Hi Tom,

I didn't change my mind about prefix. I have tried to do everything by the
book.

[postgres@hubertus postgres]$ pg_config --pkglibdir
/opt/postgres-7.4.1//lib

Really weird.

One thing I have thought of is, shouldn't there be an etc directory in
/opt/postgres-7.4.1:

[postgres@hubertus postgres]$ ll /opt/postgres-7.4.1/
total 24
drwxr-xr-x    2 postgres postgres     4096 Feb  2 18:28 bin
drwxr-xr-x    3 postgres postgres     4096 Feb  2 18:01 doc
drwxr-xr-x    5 postgres postgres     4096 Feb  2 18:02 include
drwxr-xr-x    2 postgres postgres     4096 Feb  2 18:02 lib
drwxr-xr-x    4 postgres postgres     4096 Feb  2 18:01 man
drwxr-xr-x    2 postgres postgres     4096 Feb  2 18:27 share

?

Thanks for your effort!

Rgds
/Thomas.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, February 02, 2004 6:58 PM
To: Thomas Borg Salling
Cc: 'PostgreSQL Bugs List'
Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or
directory

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> for some reason - conversion_create.sql the $libdir is not defined. I
tried
> to print $libdir from bin/initdb, but this variable is empty.

$libdir is not an environment variable, it's a notation specially
recognized by CREATE FUNCTION.  It should expand to the same directory
printed by "pg_config --pkglibdir".  You might check what that prints.

The only other idea that comes to mind is that you changed your mind
about the install prefix during the installation and didn't do a full
rebuild.  The PKGLIBDIR setting is hardwired into dfmgr.o at compile
time and maybe it didn't get recompiled.

            regards, tom lane

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> [postgres@hubertus postgres]$ pg_config --pkglibdir
> /opt/postgres-7.4.1//lib

Hmm.  I wonder if the double slash could be causing a problem?  I
wouldn't think so, but we're running out of ideas.  Could you try
rebuilding with the trailing slash left off your --prefix setting?

> One thing I have thought of is, shouldn't there be an etc directory in
> /opt/postgres-7.4.1:

Nope.

            regards, tom lane

Hi again :-)

I replaced "$libdir" with "/opt/postgres-7.4.1/lib" throughout
/opt/postgres-7.4.1/share/conversion_create.sql -- then initdb succeeded!

I think this'll work for now :-). Thanks for your time and effort!

/Thomas.

-----Original Message-----
From: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Monday, February 02, 2004 7:15 PM
To: Thomas Borg Salling
Cc: 'PostgreSQL Bugs List'
Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or
directory

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> [postgres@hubertus postgres]$ pg_config --pkglibdir
> /opt/postgres-7.4.1//lib

Hmm.  I wonder if the double slash could be causing a problem?  I
wouldn't think so, but we're running out of ideas.  Could you try
rebuilding with the trailing slash left off your --prefix setting?

> One thing I have thought of is, shouldn't there be an etc directory in
> /opt/postgres-7.4.1:

Nope.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> I replaced "$libdir" with "/opt/postgres-7.4.1/lib" throughout
> /opt/postgres-7.4.1/share/conversion_create.sql -- then initdb succeeded!

Well, that proves the shared library wasn't broken, but it leaves us
no wiser about what the problem really was.  I'd like to keep after it.

I tried configuring with a trailing "/" on a Red Hat 8.0 box here, and
it seemed to work just fine.  You did not specify what Red Hat release
you were using, but I suspect that idea is a dead end.

You could investigate further without having to reinitdb, just try the
CREATE FUNCTION command in psql:

CREATE OR REPLACE FUNCTION dummy (INTEGER, INTEGER, CSTRING, CSTRING,INTEGER)
RETURNS VOID AS '$libdir/ascii_and_mic', 'ascii_to_mic' LANGUAGE 'c' STRICT;

I expect this will fail as before.  Could you strace the attached
backend process while it's trying to do this command?

            regards, tom lane

Hi Tom,

I am running a Red Hat 9.0 on a Dell server.

On the datafiles I created using the "absolute path"-hack to replace
$libdir, I started postmaster. I configured postgresql.conf to accept tcp
connections. I then ran

[postgres@hubertus postgres]$ /opt/postgres-7.4.1/bin/createdb testdb

CREATE DATABASE

Which work ok. Finally, I started psql (as user postgres), and tried your
suggested statement:

[postgres@hubertus postgres]$ /opt/postgres-7.4.1/bin/psql -d testdb

Welcome to psql 7.4.1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

testdb=3D# CREATE OR REPLACE FUNCTION dummy (INTEGER, INTEGER, CSTRING,
CSTRING,INTEGER)
testdb-# RETURNS VOID AS '$libdir/ascii_and_mic', 'ascii_to_mic' LANGUAGE
'c' STRICT;
ERROR:  could not access file "$libdir/ascii_and_mic": No such file or
directory
ERROR:  could not access file "$libdir/ascii_and_mic": No such file or
directory
testdb=3D#

And you are right -- the problem is back.=20

I assume that $libdir is evaluating to either a wrong or an empty string. I
am not sure, but I tend to believe the latter.

Does this give you any clues ?

Regards,
Thomas.

-----Original Message-----
From: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Monday, February 02, 2004 7:44 PM
To: Thomas Borg Salling
Cc: 'PostgreSQL Bugs List'
Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or
directory=20

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> I replaced "$libdir" with "/opt/postgres-7.4.1/lib" throughout
> /opt/postgres-7.4.1/share/conversion_create.sql -- then initdb succeeded!

Well, that proves the shared library wasn't broken, but it leaves us
no wiser about what the problem really was.  I'd like to keep after it.

I tried configuring with a trailing "/" on a Red Hat 8.0 box here, and
it seemed to work just fine.  You did not specify what Red Hat release
you were using, but I suspect that idea is a dead end.

You could investigate further without having to reinitdb, just try the
CREATE FUNCTION command in psql:

CREATE OR REPLACE FUNCTION dummy (INTEGER, INTEGER, CSTRING,
CSTRING,INTEGER)
RETURNS VOID AS '$libdir/ascii_and_mic', 'ascii_to_mic' LANGUAGE 'c' STRICT;

I expect this will fail as before.  Could you strace the attached
backend process while it's trying to do this command?

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> Does this give you any clues ?

That's what I expected, but it doesn't tell me anything new.  Could you
try strace-ing the backend while you execute the CREATE FUNCTION
command?

            regards, tom lane

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> createdb, and started psql to create function. The result from strace (when
> running the CREATE FUNCTION) of the backend is:

> "Q\0\0\0\237CREATE OR REPLACE FUNCTION "..., 8192, 0) = 160
> gettimeofday({1075756990, 462661}, NULL) = 0
> stat64("/usr/local/pgsql/lib/ascii_and_mic", 0xbfffca10) = -1 ENOENT (No
> such file or directory)
> stat64("/usr/local/pgsql/lib/ascii_and_mic.so", 0xbfffca10) = -1 ENOENT (No
> such file or directory)
> stat64("$libdir/ascii_and_mic", 0xbfffcad0) = -1 ENOENT (No such file or
> directory)
> write(2, "ERROR:  could not access file \"$"..., 81) = 81

> It seems to search in /usr/local/pgsql.

Evidently.  So, somehow src/backend/utils/fmgr/dfmgr.o got compiled with
the wrong value of PKGLIBDIR.  You should look in src/Makefile.global to
check that it has the correct setting for pkglibdir (note difference in
case).  Also try going to src/backend/utils/fmgr, removing dfmgr.o, and
saying "make" to see what -D switch gets passed by the makefile.

            regards, tom lane

Yes; you're right. Sorry. Meanwhile, I also discovered, my RedHat may
originally have put a competing postgres onto the system from some RPM.

[root@hubertus root]# rpm -q postgresql
postgresql-7.2.1-5

So now I've done:
[root@hubertus root]# rpm --erase postgresql postgresql-server
postgresql-contrib php-pgsql

After having done the "rpm --erase" I cleaned the /data/postgres and
/opt/postgres-7.4.1 directories; re-created the postgres user, but initdb
still had the same fault. So I re-inserted the "absolute path"-hack;
createdb, and started psql to create function. The result from strace (when
running the CREATE FUNCTION) of the backend is:

"Q\0\0\0\237CREATE OR REPLACE FUNCTION "..., 8192, 0) =3D 160
gettimeofday({1075756990, 462661}, NULL) =3D 0
stat64("/usr/local/pgsql/lib/ascii_and_mic", 0xbfffca10) =3D -1 ENOENT (No
such file or directory)
stat64("/usr/local/pgsql/lib/ascii_and_mic.so", 0xbfffca10) =3D -1 ENOENT (=
No
such file or directory)
stat64("$libdir/ascii_and_mic", 0xbfffcad0) =3D -1 ENOENT (No such file or
directory)
write(2, "ERROR:  could not access file \"$"..., 81) =3D 81
send(8, "E\0\0\0\202SERROR\0C58P01\0Mcould not ac"..., 131, 0) =3D 131
rt_sigprocmask(SIG_SETMASK, ~[QUIT ILL TRAP ABRT BUS FPE KILL SEGV CONT STOP
SYS], NULL, 8) =3D 0
time(NULL)                              =3D 1075756990
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) =3D 0
send(8, "Z\0\0\0\5I", 6, 0)             =3D 6
recv(8,=20

It seems to search in /usr/local/pgsql -- but that directory does not exist
(at least not after the rpm --erase).

Does this give you a clue ?

Rgds
/Thomas.

=20
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20
Sent: Monday, February 02, 2004 9:52 PM
To: Thomas Borg Salling
Cc: 'PostgreSQL Bugs List'
Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or
directory=20

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> Does this give you any clues ?

That's what I expected, but it doesn't tell me anything new.  Could you
try strace-ing the backend while you execute the CREATE FUNCTION
command?

            regards, tom lane

So, I removed dfmgr.o, and remade it:

[tbs@hubertus fmgr]$ make
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations -I../../../../src/include -D_GNU_SOURCE
-DPKGLIBDIR=3D\"/opt/postgres-7.4.1//lib\" -DDLSUFFIX=3D\".so\"  -c -o dfmg=
r.o
dfmgr.c
/usr/bin/ld -r -o SUBSYS.o dfmgr.o fmgr.o funcapi.o

The  Makefile.global looks ok (I didn't touch it), excerpts:

...
prefix :=3D /opt/postgres-7.4.1/
...
libdir :=3D ${exec_prefix}/lib
pkglibdir =3D $(libdir)
ifeq "$(findstring pgsql, $(pkglibdir))" ""
ifeq "$(findstring postgres, $(pkglibdir))" ""
override pkglibdir :=3D $(pkglibdir)/postgresql
endif
endif
...

I did a "make install" following the rebuild of dfmgr.o -- and now things
work!

I am wondering how I came into this situation? Trying to recall my first
steps; I think that I did a ./configure first (it ran to the end) -- and
then I ran ./configure again with the options. Hmm... I will make a complete
new build (from a fresh tarball and directory) and see what happens.

I am not sure this was any help to you? Anyway - thanks for pointing to the
source of my problem!

/Thomas.

-----Original Message-----
From: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Monday, February 02, 2004 10:36 PM
To: Thomas Borg Salling
Cc: 'PostgreSQL Bugs List'
Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or
directory=20

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> createdb, and started psql to create function. The result from strace
(when
> running the CREATE FUNCTION) of the backend is:

> "Q\0\0\0\237CREATE OR REPLACE FUNCTION "..., 8192, 0) =3D 160
> gettimeofday({1075756990, 462661}, NULL) =3D 0
> stat64("/usr/local/pgsql/lib/ascii_and_mic", 0xbfffca10) =3D -1 ENOENT (No
> such file or directory)
> stat64("/usr/local/pgsql/lib/ascii_and_mic.so", 0xbfffca10) =3D -1 ENOENT
(No
> such file or directory)
> stat64("$libdir/ascii_and_mic", 0xbfffcad0) =3D -1 ENOENT (No such file or
> directory)
> write(2, "ERROR:  could not access file \"$"..., 81) =3D 81

> It seems to search in /usr/local/pgsql.

Evidently.  So, somehow src/backend/utils/fmgr/dfmgr.o got compiled with
the wrong value of PKGLIBDIR.  You should look in src/Makefile.global to
check that it has the correct setting for pkglibdir (note difference in
case).  Also try going to src/backend/utils/fmgr, removing dfmgr.o, and
saying "make" to see what -D switch gets passed by the makefile.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> Here is the strace (with my comments in -----shes):

It looks like you strace'd the postmaster ... I wanted the backend
subprocess that's spawned for the particular psql connection.

            regards, tom lane

Hi again,

Here is the strace (with my comments in -----shes):

[postgres@hubertus postgres]$ strace /opt/postgres-7.4.1/bin/postmaster -D
/data/postgres/ -i
execve("/opt/postgres-7.4.1/bin/postmaster",
["/opt/postgres-7.4.1/bin/postmaster", "-D", "/data/postgres/", "-i"], [/*
27 vars */]) =3D 0
uname({sys=3D"Linux", node=3D"hubertus", ...}) =3D 0
brk(0)                                  =3D 0x8270984
open("/etc/ld.so.preload", O_RDONLY)    =3D -1 ENOENT (No such file or
directory)
open("/usr/local/pgsql/lib/mmx/libz.so.1", O_RDONLY) =3D -1 ENOENT (No such
file or directory)
stat64("/usr/local/pgsql/lib/mmx", 0xbfffdf80) =3D -1 ENOENT (No such file =
or
directory)
open("/usr/local/pgsql/lib/libz.so.1", O_RDONLY) =3D -1 ENOENT (No such file
or directory)
stat64("/usr/local/pgsql/lib", 0xbfffdf80) =3D -1 ENOENT (No such file or
directory)
open("/opt/postgres-7.4.1/lib/mmx/libz.so.1", O_RDONLY) =3D -1 ENOENT (No s=
uch
file or directory)
stat64("/opt/postgres-7.4.1/lib/mmx", 0xbfffdf80) =3D -1 ENOENT (No such fi=
le
or directory)
open("/opt/postgres-7.4.1/lib/libz.so.1", O_RDONLY) =3D -1 ENOENT (No such
file or directory)
stat64("/opt/postgres-7.4.1/lib", {st_mode=3DS_IFDIR|0755, st_size=3D4096, =
...})
=3D 0
open("mmx/libz.so.1", O_RDONLY)         =3D -1 ENOENT (No such file or
directory)
open("libz.so.1", O_RDONLY)             =3D -1 ENOENT (No such file or
directory)
open("/etc/ld.so.cache", O_RDONLY)      =3D 3
fstat64(3, {st_mode=3DS_IFREG|0644, st_size=3D116236, ...}) =3D 0
old_mmap(NULL, 116236, PROT_READ, MAP_PRIVATE, 3, 0) =3D 0x40014000
close(3)                                =3D 0
open("/usr/lib/libz.so.1", O_RDONLY)    =3D 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20\31\0"..., 1024)
=3D 1024
fstat64(3, {st_mode=3DS_IFREG|0755, st_size=3D59778, ...}) =3D 0
old_mmap(NULL, 54984, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =3D 0x40031000
mprotect(0x4003d000, 5832, PROT_NONE)   =3D 0
old_mmap(0x4003d000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0xb000) =3D 0x4003d000
close(3)                                =3D 0
open("/opt/postgres-7.4.1/lib/libreadline.so.4", O_RDONLY) =3D -1 ENOENT (No
such file or directory)
open("mmx/libreadline.so.4", O_RDONLY)  =3D -1 ENOENT (No such file or
directory)
open("libreadline.so.4", O_RDONLY)      =3D -1 ENOENT (No such file or
directory)
open("/usr/lib/libreadline.so.4", O_RDONLY) =3D 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\240\243"..., 1024)
=3D 1024
fstat64(3, {st_mode=3DS_IFREG|0755, st_size=3D184567, ...}) =3D 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
=3D 0x4003f000
old_mmap(NULL, 153200, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =3D 0x400400=
00
mprotect(0x40061000, 18032, PROT_NONE)  =3D 0
old_mmap(0x40061000, 16384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x21000) =3D 0x40061000
old_mmap(0x40065000, 1648, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) =3D 0x40065000
close(3)                                =3D 0
open("/opt/postgres-7.4.1/lib/libtermcap.so.2", O_RDONLY) =3D -1 ENOENT (No
such file or directory)
open("mmx/libtermcap.so.2", O_RDONLY)   =3D -1 ENOENT (No such file or
directory)
open("libtermcap.so.2", O_RDONLY)       =3D -1 ENOENT (No such file or
directory)
open("/lib/libtermcap.so.2", O_RDONLY)  =3D 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\260\r\0"..., 1024)
=3D 1024
fstat64(3, {st_mode=3DS_IFREG|0755, st_size=3D11832, ...}) =3D 0
old_mmap(NULL, 14932, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =3D 0x40066000
mprotect(0x40069000, 2644, PROT_NONE)   =3D 0
old_mmap(0x40069000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x2000) =3D 0x40069000
close(3)                                =3D 0
open("/opt/postgres-7.4.1/lib/libcrypt.so.1", O_RDONLY) =3D -1 ENOENT (No s=
uch
file or directory)
open("mmx/libcrypt.so.1", O_RDONLY)     =3D -1 ENOENT (No such file or
directory)
open("libcrypt.so.1", O_RDONLY)         =3D -1 ENOENT (No such file or
directory)
open("/lib/libcrypt.so.1", O_RDONLY)    =3D 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\340\t\0"..., 1024)
=3D 1024
fstat64(3, {st_mode=3DS_IFREG|0755, st_size=3D23575, ...}) =3D 0
old_mmap(NULL, 182876, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =3D 0x4006a0=
00
mprotect(0x4006f000, 162396, PROT_NONE) =3D 0
old_mmap(0x4006f000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x4000) =3D 0x4006f000
old_mmap(0x40070000, 158300, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) =3D 0x40070000
close(3)                                =3D 0
open("/opt/postgres-7.4.1/lib/libresolv.so.2", O_RDONLY) =3D -1 ENOENT (No
such file or directory)
open("mmx/libresolv.so.2", O_RDONLY)    =3D -1 ENOENT (No such file or
directory)
open("libresolv.so.2", O_RDONLY)        =3D -1 ENOENT (No such file or
directory)
open("/lib/libresolv.so.2", O_RDONLY)   =3D 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20\'\0"..., 1024) =
=3D
1024
fstat64(3, {st_mode=3DS_IFREG|0755, st_size=3D68925, ...}) =3D 0
old_mmap(NULL, 69408, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =3D 0x40097000
mprotect(0x400a5000, 12064, PROT_NONE)  =3D 0
old_mmap(0x400a5000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0xe000) =3D 0x400a5000
old_mmap(0x400a6000, 7968, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) =3D 0x400a6000
close(3)                                =3D 0
open("/opt/postgres-7.4.1/lib/libnsl.so.1", O_RDONLY) =3D -1 ENOENT (No such
file or directory)
open("mmx/libnsl.so.1", O_RDONLY)       =3D -1 ENOENT (No such file or
directory)
open("libnsl.so.1", O_RDONLY)           =3D -1 ENOENT (No such file or
directory)
open("/lib/libnsl.so.1", O_RDONLY)      =3D 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`:\0\000"..., 1024)
=3D 1024
fstat64(3, {st_mode=3DS_IFREG|0755, st_size=3D89424, ...}) =3D 0
old_mmap(NULL, 84636, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =3D 0x400a8000
mprotect(0x400ba000, 10908, PROT_NONE)  =3D 0
old_mmap(0x400ba000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x12000) =3D 0x400ba000
old_mmap(0x400bb000, 6812, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) =3D 0x400bb000
close(3)                                =3D 0
open("/opt/postgres-7.4.1/lib/libdl.so.2", O_RDONLY) =3D -1 ENOENT (No such
file or directory)
open("mmx/libdl.so.2", O_RDONLY)        =3D -1 ENOENT (No such file or
directory)
open("libdl.so.2", O_RDONLY)            =3D -1 ENOENT (No such file or
directory)
open("/lib/libdl.so.2", O_RDONLY)       =3D 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\360\31"..., 1024) =
=3D
1024
fstat64(3, {st_mode=3DS_IFREG|0755, st_size=3D12102, ...}) =3D 0
old_mmap(NULL, 11640, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =3D 0x400bd000
mprotect(0x400bf000, 3448, PROT_NONE)   =3D 0
old_mmap(0x400bf000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x1000) =3D 0x400bf000
close(3)                                =3D 0
open("/opt/postgres-7.4.1/lib/libm.so.6", O_RDONLY) =3D -1 ENOENT (No such
file or directory)
open("mmx/libm.so.6", O_RDONLY)         =3D -1 ENOENT (No such file or
directory)
open("libm.so.6", O_RDONLY)             =3D -1 ENOENT (No such file or
directory)
open("/lib/i686/libm.so.6", O_RDONLY)   =3D 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`7\0\000"..., 1024)
=3D 1024
fstat64(3, {st_mode=3DS_IFREG|0755, st_size=3D173359, ...}) =3D 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
=3D 0x400c0000
old_mmap(NULL, 138292, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =3D 0x400c10=
00
mprotect(0x400e2000, 3124, PROT_NONE)   =3D 0
old_mmap(0x400e2000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x20000) =3D 0x400e2000
close(3)                                =3D 0
open("/opt/postgres-7.4.1/lib/libc.so.6", O_RDONLY) =3D -1 ENOENT (No such
file or directory)
open("mmx/libc.so.6", O_RDONLY)         =3D -1 ENOENT (No such file or
directory)
open("libc.so.6", O_RDONLY)             =3D -1 ENOENT (No such file or
directory)
open("/lib/i686/libc.so.6", O_RDONLY)   =3D 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`u\1B4\0"..., 1024)
=3D 1024
fstat64(3, {st_mode=3DS_IFREG|0755, st_size=3D1401027, ...}) =3D 0
old_mmap(0x42000000, 1264928, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =3D
0x42000000
mprotect(0x4212c000, 36128, PROT_NONE)  =3D 0
old_mmap(0x4212c000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x12c000) =3D 0x4212c000
old_mmap(0x42131000, 15648, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) =3D 0x42131000
close(3)                                =3D 0
munmap(0x40014000, 116236)              =3D 0
brk(0)                                  =3D 0x8270984
brk(0x82709b4)                          =3D 0x82709b4
brk(0x8271000)                          =3D 0x8271000
brk(0x8272000)                          =3D 0x8272000
open("/usr/share/locale/locale.alias", O_RDONLY) =3D 3
fstat64(3, {st_mode=3DS_IFREG|0644, st_size=3D2601, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x40014000
read(3, "# Locale name alias data base.\n#"..., 4096) =3D 2601
read(3, "", 4096)                       =3D 0
close(3)                                =3D 0
munmap(0x40014000, 4096)                =3D 0
open("/usr/lib/locale/en_US.iso885915/LC_COLLATE", O_RDONLY) =3D 3
fstat64(3, {st_mode=3DS_IFREG|0644, st_size=3D22592, ...}) =3D 0
mmap2(NULL, 22592, PROT_READ, MAP_PRIVATE, 3, 0) =3D 0x40014000
close(3)                                =3D 0
open("/usr/lib/gconv/gconv-modules.cache", O_RDONLY) =3D 3
fstat64(3, {st_mode=3DS_IFREG|0644, st_size=3D20666, ...}) =3D 0
mmap2(NULL, 20666, PROT_READ, MAP_SHARED, 3, 0) =3D 0x4001a000
close(3)                                =3D 0
open("/usr/lib/locale/en_US.iso885915/LC_CTYPE", O_RDONLY) =3D 3
fstat64(3, {st_mode=3DS_IFREG|0644, st_size=3D173680, ...}) =3D 0
mmap2(NULL, 173680, PROT_READ, MAP_PRIVATE, 3, 0) =3D 0x400e3000
brk(0x8273000)                          =3D 0x8273000
close(3)                                =3D 0
open("/usr/lib/locale/en_US.iso885915/LC_MESSAGES", O_RDONLY) =3D 3
fstat64(3, {st_mode=3DS_IFDIR|0755, st_size=3D4096, ...}) =3D 0
close(3)                                =3D 0
open("/usr/lib/locale/en_US.iso885915/LC_MESSAGES/SYS_LC_MESSAGES",
O_RDONLY) =3D 3
fstat64(3, {st_mode=3DS_IFREG|0644, st_size=3D58, ...}) =3D 0
mmap2(NULL, 58, PROT_READ, MAP_PRIVATE, 3, 0) =3D 0x40020000
close(3)                                =3D 0
geteuid32()                             =3D 26
getuid32()                              =3D 26
geteuid32()                             =3D 26
umask(077)                              =3D 022
getpid()                                =3D 7463
brk(0x8276000)                          =3D 0x8276000
brk(0x8279000)                          =3D 0x8279000
open("/etc/localtime", O_RDONLY)        =3D 3
fstat64(3, {st_mode=3DS_IFREG|0644, st_size=3D766, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x40021000
read(3, "TZif\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\6\0\0\0\6\0"..., 4096) =
=3D
766
close(3)                                =3D 0
munmap(0x40021000, 4096)                =3D 0
stat64("/data/postgres/", {st_mode=3DS_IFDIR|0700, st_size=3D4096, ...}) =
=3D 0
open("/data/postgres//PG_VERSION", O_RDONLY|O_LARGEFILE) =3D 3
fstat64(3, {st_mode=3DS_IFREG|0600, st_size=3D4, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x40021000
read(3, "7.4\n", 4096)                  =3D 4
close(3)                                =3D 0
munmap(0x40021000, 4096)                =3D 0
open("/data/postgres//global/pg_control", O_RDONLY|O_LARGEFILE) =3D 3
close(3)                                =3D 0
open("/data/postgres/postgresql.conf", O_RDONLY|O_LARGEFILE) =3D 3
brk(0x827e000)                          =3D 0x827e000
fstat64(3, {st_mode=3DS_IFREG|0600, st_size=3D7828, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x40021000
read(3, "# -----------------------------\n"..., 8192) =3D 7828
read(3, "", 4096)                       =3D 0
read(3, "", 8192)                       =3D 0
close(3)                                =3D 0
munmap(0x40021000, 4096)                =3D 0
open("/usr/lib/locale/en_US.iso885915/LC_MONETARY", O_RDONLY) =3D 3
fstat64(3, {st_mode=3DS_IFREG|0644, st_size=3D292, ...}) =3D 0
mmap2(NULL, 292, PROT_READ, MAP_PRIVATE, 3, 0) =3D 0x40021000
close(3)                                =3D 0
open("/usr/lib/locale/en_US.iso885915/LC_NUMERIC", O_RDONLY) =3D 3
fstat64(3, {st_mode=3DS_IFREG|0644, st_size=3D60, ...}) =3D 0
mmap2(NULL, 60, PROT_READ, MAP_PRIVATE, 3, 0) =3D 0x40022000
close(3)                                =3D 0
open("/usr/lib/locale/en_US.iso885915/LC_TIME", O_RDONLY) =3D 3
fstat64(3, {st_mode=3DS_IFREG|0644, st_size=3D2457, ...}) =3D 0
mmap2(NULL, 2457, PROT_READ, MAP_PRIVATE, 3, 0) =3D 0x40023000
close(3)                                =3D 0
stat64("/opt/postgres-7.4.1/bin/postgres", {st_mode=3DS_IFREG|0755,
st_size=3D2310646, ...}) =3D 0
geteuid32()                             =3D 26
getpid()                                =3D 7463
open("/data/postgres/postmaster.pid", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE,
0600) =3D 3
write(3, "7463\n/data/postgres\n", 20)  =3D 20
close(3)                                =3D 0
open("/data/postgres/base", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) =
=3D 3
fstat64(3, {st_mode=3DS_IFDIR|0700, st_size=3D4096, ...}) =3D 0
fcntl64(3, F_SETFD, FD_CLOEXEC)         =3D 0
brk(0x8280000)                          =3D 0x8280000
getdents64(0x3, 0x827d488, 0x1000, 0x827d488) =3D 136
open("/data/postgres/base/1/pgsql_tmp",
O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) =3D -1 ENOENT (No such file or
directory)
open("/data/postgres/base/17141/pgsql_tmp",
O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) =3D -1 ENOENT (No such file or
directory)
open("/data/postgres/base/17142/pgsql_tmp",
O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) =3D -1 ENOENT (No such file or
directory)
getdents64(0x3, 0x827d488, 0x1000, 0x827d488) =3D 0
close(3)                                =3D 0
socket(PF_INET6, SOCK_STREAM, 0)        =3D -1 EAFNOSUPPORT (Address family
not supported by protocol)
open("/usr/share/locale/en_US.iso885915/LC_MESSAGES/libc.mo", O_RDONLY) =3D=
 -1
ENOENT (No such file or directory)
open("/usr/share/locale/en_US/LC_MESSAGES/libc.mo", O_RDONLY) =3D -1 ENOENT
(No such file or directory)
open("/usr/share/locale/en.iso885915/LC_MESSAGES/libc.mo", O_RDONLY) =3D -1
ENOENT (No such file or directory)
open("/usr/share/locale/en/LC_MESSAGES/libc.mo", O_RDONLY) =3D -1 ENOENT (No
such file or directory)
write(2, "LOG:  could not create IPv6 sock"..., 77LOG:  could not create
IPv6 socket: Address family not supported by protocol
) =3D 77
socket(PF_INET, SOCK_STREAM, IPPROTO_IP) =3D 3
setsockopt(3, SOL_SOCKET, SO_REUSEADDR, [1], 4) =3D 0
bind(3, {sin_family=3DAF_INET, sin_port=3Dhtons(5432),
sin_addr=3Dinet_addr("0.0.0.0")}}, 16) =3D 0
listen(3, 200)                          =3D 0
getpid()                                =3D 7463
open("/tmp/.s.PGSQL.5432.lock", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0600) =
=3D 4
write(4, "7463\n/data/postgres\n", 20)  =3D 20
close(4)                                =3D 0
unlink("/tmp/.s.PGSQL.5432")            =3D -1 ENOENT (No such file or
directory)
socket(PF_UNIX, SOCK_STREAM, 0)         =3D 4
bind(4, {sin_family=3DAF_UNIX, path=3D"/tmp/.s.PGSQL.5432"}, 110) =3D 0
chmod("/tmp/.s.PGSQL.5432", 0777)       =3D 0
listen(4, 200)                          =3D 0
shmget(5432001, 10436608, IPC_CREAT|IPC_EXCL|0x180|0600) =3D 6520841
shmat(6520841, 0, 0)                    =3D 0x4010e000
open("/data/postgres/postmaster.pid", O_RDWR|O_LARGEFILE) =3D 5
read(5, "7463\n/data/postgres\n", 8092) =3D 20
_llseek(5, 0, [0], SEEK_SET)            =3D 0
write(5, "7463\n/data/postgres\n  5432001   "..., 40) =3D 40
close(5)                                =3D 0
getpid()                                =3D 7463
open("/data/postgres/global/pg_control", O_RDWR|O_LARGEFILE) =3D 5
read(5, "Q\1vB\334\320\244\266H\0\0\0\303}\360\v\1\0\0\0\237\271"..., 360) =
=3D
360
close(5)                                =3D 0
semget(5432001, 17, IPC_CREAT|IPC_EXCL|0x180|0600) =3D 43253761
semctl(43253761, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) =3D 0
semop(43253761, 0xbfffe7d0, 1)          =3D 0
semctl(43253761, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 5, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 6, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 7, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 8, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 9, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 10, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 11, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 12, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 13, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 14, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43253761, 15, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semget(5432002, 17, IPC_CREAT|IPC_EXCL|0x180|0600) =3D 43286530
semctl(43286530, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) =3D 0
semop(43286530, 0xbfffe7d0, 1)          =3D 0
semctl(43286530, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 5, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 6, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 7, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 8, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 9, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 10, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 11, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 12, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 13, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 14, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43286530, 15, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semget(5432003, 17, IPC_CREAT|IPC_EXCL|0x180|0600) =3D 43319299
semctl(43319299, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) =3D 0
semop(43319299, 0xbfffe7d0, 1)          =3D 0
semctl(43319299, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 5, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 6, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 7, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 8, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 9, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 10, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 11, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 12, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 13, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 14, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43319299, 15, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semget(5432004, 17, IPC_CREAT|IPC_EXCL|0x180|0600) =3D 43352068
semctl(43352068, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) =3D 0
semop(43352068, 0xbfffe7d0, 1)          =3D 0
semctl(43352068, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 5, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 6, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 7, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 8, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 9, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 10, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 11, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 12, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 13, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 14, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43352068, 15, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semget(5432005, 17, IPC_CREAT|IPC_EXCL|0x180|0600) =3D 43384837
semctl(43384837, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) =3D 0
semop(43384837, 0xbfffe7d0, 1)          =3D 0
semctl(43384837, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 5, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 6, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 7, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 8, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 9, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 10, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 11, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 12, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 13, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 14, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43384837, 15, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semget(5432006, 17, IPC_CREAT|IPC_EXCL|0x180|0600) =3D 43417606
semctl(43417606, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) =3D 0
semop(43417606, 0xbfffe7d0, 1)          =3D 0
semctl(43417606, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 5, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 6, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 7, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 8, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 9, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 10, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 11, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 12, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 13, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 14, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43417606, 15, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semget(5432007, 17, IPC_CREAT|IPC_EXCL|0x180|0600) =3D 43450375
semctl(43450375, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) =3D 0
semop(43450375, 0xbfffe7d0, 1)          =3D 0
semctl(43450375, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43450375, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43450375, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43450375, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
semctl(43450375, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) =3D 0
stat64("/opt/postgres-7.4.1/bin/postmaster", {st_mode=3DS_IFREG|0755,
st_size=3D2310646, ...}) =3D 0
geteuid32()                             =3D 26
open("/data/postgres/postmaster.opts", O_WRONLY|O_CREAT|O_TRUNC|O_LARGEFILE,
0666) =3D 5
fstat64(5, {st_mode=3DS_IFREG|0600, st_size=3D0, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x40024000
write(5, "/opt/postgres-7.4.1/bin/postmast"..., 63) =3D 63
close(5)                                =3D 0
munmap(0x40024000, 4096)                =3D 0
rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS], NULL, 8)
=3D 0
rt_sigaction(SIGHUP, {0x812b664, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) =
=3D
0
rt_sigaction(SIGINT, {0x812b700, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) =
=3D
0
rt_sigaction(SIGQUIT, {0x812b700, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) =
=3D
0
rt_sigaction(SIGTERM, {0x812b700, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) =
=3D
0
rt_sigaction(SIGALRM, {SIG_IGN}, {SIG_DFL}, 8) =3D 0
rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_DFL}, 8) =3D 0
rt_sigaction(SIGUSR1, {0x812c864, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) =
=3D
0
rt_sigaction(SIGUSR2, {0x812c9b8, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) =
=3D
0
rt_sigaction(SIGCHLD, {0x812ba24, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) =
=3D
0
rt_sigaction(SIGTTIN, {SIG_IGN}, {SIG_DFL}, 8) =3D 0
rt_sigaction(SIGTTOU, {SIG_IGN}, {SIG_DFL}, 8) =3D 0
rt_sigaction(SIGXFSZ, {SIG_IGN}, {SIG_DFL}, 8) =3D 0
time(NULL)                              =3D 1075755436
getpid()                                =3D 7463
unlink("/data/postgres/global/pgstat.stat") =3D 0
gettimeofday({1075755436, 467187}, NULL) =3D 0
getpid()                                =3D 7463
open("/etc/resolv.conf", O_RDONLY)      =3D 5
fstat64(5, {st_mode=3DS_IFREG|0644, st_size=3D20, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x40024000
read(5, "nameserver 10.0.1.1\n", 4096)  =3D 20
read(5, "", 4096)                       =3D 0
close(5)                                =3D 0
munmap(0x40024000, 4096)                =3D 0
uname({sys=3D"Linux", node=3D"hubertus", ...}) =3D 0
socket(PF_UNIX, SOCK_STREAM, 0)         =3D 5
connect(5, {sin_family=3DAF_UNIX, path=3D"/var/run/.nscd_socket"}, 110) =3D=
 -1
ENOENT (No such file or directory)
close(5)                                =3D 0
open("/etc/nsswitch.conf", O_RDONLY)    =3D 5
fstat64(5, {st_mode=3DS_IFREG|0644, st_size=3D1667, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x40024000
read(5, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) =3D 1667
read(5, "", 4096)                       =3D 0
close(5)                                =3D 0
munmap(0x40024000, 4096)                =3D 0
open("/opt/postgres-7.4.1/lib/libnss_files.so.2", O_RDONLY) =3D -1 ENOENT (=
No
such file or directory)
open("mmx/libnss_files.so.2", O_RDONLY) =3D -1 ENOENT (No such file or
directory)
open("libnss_files.so.2", O_RDONLY)     =3D -1 ENOENT (No such file or
directory)
open("/etc/ld.so.cache", O_RDONLY)      =3D 5
fstat64(5, {st_mode=3DS_IFREG|0644, st_size=3D116236, ...}) =3D 0
old_mmap(NULL, 116236, PROT_READ, MAP_PRIVATE, 5, 0) =3D 0x40b02000
close(5)                                =3D 0
open("/lib/libnss_files.so.2", O_RDONLY) =3D 5
read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\0\35\0"..., 1024) =
=3D
1024
fstat64(5, {st_mode=3DS_IFREG|0755, st_size=3D45415, ...}) =3D 0
old_mmap(NULL, 37848, PROT_READ|PROT_EXEC, MAP_PRIVATE, 5, 0) =3D 0x40024000
mprotect(0x4002d000, 984, PROT_NONE)    =3D 0
old_mmap(0x4002d000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 5,
0x9000) =3D 0x4002d000
close(5)                                =3D 0
munmap(0x40b02000, 116236)              =3D 0
open("/etc/host.conf", O_RDONLY)        =3D 5
fstat64(5, {st_mode=3DS_IFREG|0644, st_size=3D17, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x4002e000
read(5, "order hosts,bind\n", 4096)     =3D 17
read(5, "", 4096)                       =3D 0
close(5)                                =3D 0
munmap(0x4002e000, 4096)                =3D 0
open("/etc/hosts", O_RDONLY)            =3D 5
fcntl64(5, F_GETFD)                     =3D 0
fcntl64(5, F_SETFD, FD_CLOEXEC)         =3D 0
fstat64(5, {st_mode=3DS_IFREG|0644, st_size=3D685, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x4002e000
read(5, "# Do not remove the following li"..., 4096) =3D 685
read(5, "", 4096)                       =3D 0
close(5)                                =3D 0
munmap(0x4002e000, 4096)                =3D 0
open("/opt/postgres-7.4.1/lib/libnss_nis.so.2", O_RDONLY) =3D -1 ENOENT (No
such file or directory)
open("mmx/libnss_nis.so.2", O_RDONLY)   =3D -1 ENOENT (No such file or
directory)
open("libnss_nis.so.2", O_RDONLY)       =3D -1 ENOENT (No such file or
directory)
open("/etc/ld.so.cache", O_RDONLY)      =3D 5
fstat64(5, {st_mode=3DS_IFREG|0644, st_size=3D116236, ...}) =3D 0
old_mmap(NULL, 116236, PROT_READ, MAP_PRIVATE, 5, 0) =3D 0x40b02000
close(5)                                =3D 0
open("/lib/libnss_nis.so.2", O_RDONLY)  =3D 5
read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\300\33"..., 1024) =
=3D
1024
fstat64(5, {st_mode=3DS_IFREG|0755, st_size=3D44746, ...}) =3D 0
old_mmap(NULL, 40864, PROT_READ|PROT_EXEC, MAP_PRIVATE, 5, 0) =3D 0x40b1f000
mprotect(0x40b28000, 4000, PROT_NONE)   =3D 0
old_mmap(0x40b28000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 5,
0x8000) =3D 0x40b28000
close(5)                                =3D 0
brk(0x8281000)                          =3D 0x8281000
munmap(0x40b02000, 116236)              =3D 0
uname({sys=3D"Linux", node=3D"hubertus", ...}) =3D 0
open("/var/yp/binding/navicon.2", O_RDONLY) =3D -1 ENOENT (No such file or
directory)
gettimeofday({1075755436, 537449}, NULL) =3D 0
socket(PF_INET, SOCK_DGRAM, IPPROTO_UDP) =3D 5
getpid()                                =3D 7463
bind(5, {sin_family=3DAF_INET, sin_port=3Dhtons(855),
sin_addr=3Dinet_addr("0.0.0.0")}}, 16) =3D -1 EACCES (Permission denied)
ioctl(5, 0x5421, [1])                   =3D 0
setsockopt(5, SOL_IP, IP_RECVERR, [1], 4) =3D 0
sendto(5, "=3D\316\273^\0\0\0\0\0\0\0\2\0\1\206\240\0\0\0\2\0\0\0\3"..., 56,
0, {sin_family=3DAF_INET, sin_port=3Dhtons(111),
sin_addr=3Dinet_addr("127.0.0.1")}}, 16) =3D 56
poll([{fd=3D5, events=3DPOLLIN, revents=3DPOLLIN}], 1, 5000) =3D 1
recvfrom(5, "=3D\316\273^\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,
400, 0, {sin_family=3DAF_INET, sin_port=3Dhtons(111),
sin_addr=3Dinet_addr("127.0.0.1")}}, [16]) =3D 28
close(5)                                =3D 0
open("/opt/postgres-7.4.1/lib/libnss_dns.so.2", O_RDONLY) =3D -1 ENOENT (No
such file or directory)
open("mmx/libnss_dns.so.2", O_RDONLY)   =3D -1 ENOENT (No such file or
directory)
open("libnss_dns.so.2", O_RDONLY)       =3D -1 ENOENT (No such file or
directory)
open("/etc/ld.so.cache", O_RDONLY)      =3D 5
fstat64(5, {st_mode=3DS_IFREG|0644, st_size=3D116236, ...}) =3D 0
old_mmap(NULL, 116236, PROT_READ, MAP_PRIVATE, 5, 0) =3D 0x40b02000
close(5)                                =3D 0
open("/lib/libnss_dns.so.2", O_RDONLY)  =3D 5
read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\320\r\0"..., 1024)
=3D 1024
fstat64(5, {st_mode=3DS_IFREG|0755, st_size=3D16051, ...}) =3D 0
old_mmap(NULL, 15912, PROT_READ|PROT_EXEC, MAP_PRIVATE, 5, 0) =3D 0x40b29000
mprotect(0x40b2c000, 3624, PROT_NONE)   =3D 0
old_mmap(0x40b2c000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 5,
0x2000) =3D 0x40b2c000
close(5)                                =3D 0
munmap(0x40b02000, 116236)              =3D 0
socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) =3D 5
connect(5, {sin_family=3DAF_INET, sin_port=3Dhtons(53),
sin_addr=3Dinet_addr("10.0.1.1")}}, 28) =3D 0
send(5, "\204y\1\0\0\1\0\0\0\0\0\0\tlocalhost\0\0\34\0\1", 27, 0) =3D 27
gettimeofday({1075755436, 541777}, NULL) =3D 0
poll([{fd=3D5, events=3DPOLLIN, revents=3DPOLLIN}], 1, 5000) =3D 1
recvfrom(5, "\204y\201\200\0\1\0\0\0\1\0\1\tlocalhost\0\0\34\0\1\tl"...,
1024, 0, {sin_family=3DAF_INET, sin_port=3Dhtons(53),
sin_addr=3Dinet_addr("10.0.1.1")}}, [16]) =3D 66
close(5)                                =3D 0
gettimeofday({1075755436, 542281}, NULL) =3D 0
getpid()                                =3D 7463
open("/etc/resolv.conf", O_RDONLY)      =3D 5
fstat64(5, {st_mode=3DS_IFREG|0644, st_size=3D20, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x4002e000
read(5, "nameserver 10.0.1.1\n", 4096)  =3D 20
read(5, "", 4096)                       =3D 0
close(5)                                =3D 0
munmap(0x4002e000, 4096)                =3D 0
uname({sys=3D"Linux", node=3D"hubertus", ...}) =3D 0
socket(PF_UNIX, SOCK_STREAM, 0)         =3D 5
connect(5, {sin_family=3DAF_UNIX, path=3D"/var/run/.nscd_socket"}, 110) =3D=
 -1
ENOENT (No such file or directory)
close(5)                                =3D 0
open("/etc/hosts", O_RDONLY)            =3D 5
fcntl64(5, F_GETFD)                     =3D 0
fcntl64(5, F_SETFD, FD_CLOEXEC)         =3D 0
fstat64(5, {st_mode=3DS_IFREG|0644, st_size=3D685, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x4002e000
read(5, "# Do not remove the following li"..., 4096) =3D 685
close(5)                                =3D 0
munmap(0x4002e000, 4096)                =3D 0
socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) =3D 5
bind(5, {sin_family=3DAF_INET, sin_port=3Dhtons(0),
sin_addr=3Dinet_addr("127.0.0.1")}}, 16) =3D 0
getsockname(5, {sin_family=3DAF_INET, sin_port=3Dhtons(33043),
sin_addr=3Dinet_addr("127.0.0.1")}}, [16]) =3D 0
connect(5, {sin_family=3DAF_INET, sin_port=3Dhtons(33043),
sin_addr=3Dinet_addr("127.0.0.1")}}, 16) =3D 0
fcntl64(5, F_SETFL, O_RDONLY|O_NONBLOCK) =3D 0
pipe([6, 7])                            =3D 0
time(NULL)                              =3D 1075755436
fork()                                  =3D 7465
open("/data/postgres/pg_hba.conf", O_RDONLY|O_LARGEFILE) =3D 8
fstat64(8, {st_mode=3DS_IFREG|0600, st_size=3D3288, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x4002e000
read(8, "# PostgreSQL Client Authenticati"..., 4096) =3D 3288
read(8, "", 4096)                       =3D 0
close(8)                                =3D 0
munmap(0x4002e000, 4096)                =3D 0
open("/data/postgres/pg_ident.conf", O_RDONLY|O_LARGEFILE) =3D 8
fstat64(8, {st_mode=3DS_IFREG|0600, st_size=3D1441, ...}) =3D 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
=3D
0x4002e000
read(8, "# PostgreSQL Ident Authenticatio"..., 4096) =3D 1441
read(8, "", 4096)                       =3D 0
close(8)                                =3D 0
munmap(0x4002e000, 4096)                =3D 0
open("/data/postgres/global/pg_pwd", O_RDONLY|O_LARGEFILE) =3D -1 ENOENT (No
such file or directory)
open("/data/postgres/global/pg_group", O_RDONLY|O_LARGEFILE) =3D -1 ENOENT =
(No
such file or directory)
fork()                                  =3D 7467
LOG:  database system was shut down at 2004-02-02 21:57:03 CET
LOG:  checkpoint record is at 0/9D34D8
LOG:  redo record is at 0/9D34D8; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 541; next OID: 17145
gettimeofday({1075755436, 618626}, {4294967236, 0}) =3D 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) =3D 0
select(5, [3 4], NULL, NULL, {60, 0}LOG:  database system is ready
)   =3D ? ERESTARTNOHAND (To be restarted)
--- SIGCHLD (Child exited) ---
rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS], NULL, 8)
=3D 0
wait4(-1, [WIFEXITED(s) && WEXITSTATUS(s) =3D=3D 0], WNOHANG, NULL) =3D 7467
time(NULL)                              =3D 1075755436
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) =3D 0
sigreturn()                             =3D ? (mask now [])
rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS], NULL, 8)
=3D 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) =3D 0
select(5, [3 4], NULL, NULL, {60, 0}

----- server startup complete; about to connect psql -----------------------

)   =3D 1 (in [3], left {35, 180000})
rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS], NULL, 8)
=3D 0
gettimeofday({1075755461, 448481}, {4294967236, 0}) =3D 0
accept(3, {sin_family=3DAF_INET, sin_port=3Dhtons(33470),
sin_addr=3Dinet_addr("127.0.0.1")}}, [16]) =3D 8
getsockname(8, {sin_family=3DAF_INET, sin_port=3Dhtons(5432),
sin_addr=3Dinet_addr("127.0.0.1")}}, [16]) =3D 0
setsockopt(8, SOL_TCP, TCP_NODELAY, [1], 4) =3D 0
setsockopt(8, SOL_SOCKET, SO_KEEPALIVE, [1], 4) =3D 0
fork()                                  =3D 7470
close(8)                                =3D 0
time(NULL)                              =3D 1075755461
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) =3D 0
select(5, [3 4], NULL, NULL, {275, 0}

----- psql connected; about to CREATE FUNCTION -----------------------------

ERROR:  could not access file "$libdir/ascii_and_mic": No such file or
directory

----- CREATE FUNCTION attempted --------------------------------------------

Best regards,
Thomas.

-----Original Message-----
From: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Monday, February 02, 2004 7:44 PM
To: Thomas Borg Salling
Cc: 'PostgreSQL Bugs List'
Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or
directory=20

"Thomas Borg Salling" <tbs@navicon.dk> writes:
> I replaced "$libdir" with "/opt/postgres-7.4.1/lib" throughout
> /opt/postgres-7.4.1/share/conversion_create.sql -- then initdb succeeded!

Well, that proves the shared library wasn't broken, but it leaves us
no wiser about what the problem really was.  I'd like to keep after it.

I tried configuring with a trailing "/" on a Red Hat 8.0 box here, and
it seemed to work just fine.  You did not specify what Red Hat release
you were using, but I suspect that idea is a dead end.

You could investigate further without having to reinitdb, just try the
CREATE FUNCTION command in psql:

CREATE OR REPLACE FUNCTION dummy (INTEGER, INTEGER, CSTRING,
CSTRING,INTEGER)
RETURNS VOID AS '$libdir/ascii_and_mic', 'ascii_to_mic' LANGUAGE 'c' STRICT;

I expect this will fail as before.  Could you strace the attached
backend process while it's trying to do this command?

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend