Re: BUG #1072: "$libdir/ascii_and_mic": No such file or directory - Mailing list pgsql-bugs

From Thomas Borg Salling
Subject Re: BUG #1072: "$libdir/ascii_and_mic": No such file or directory
Date
Msg-id 003301c3e9cf$900d7910$0101000a@Umulius
Whole thread Raw
In response to Re: BUG #1072: "$libdir/ascii_and_mic": No such file or directory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1072: "$libdir/ascii_and_mic": No such file or directory
Next
From: Kris Jurka
Date:
Subject: Re: createdb fails