pg_restore hangs on locale

From: "Paul Sundling(\"Webdaddy\")" <tkz(at)tkz(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_restore hangs on locale
Date: 2003-04-24 10:31:11
Message-ID: 3EA7BCEF.7070406@tkz.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

With a fresh install of Redhat 9 and an apt-get update I am having
pg_restore hang, while it appears to be opening
/usr/lib/locale/locale-archive which is probably related to a lock or
something along those lines. Anyone have any ideas? Doing lsof on the
local-archive file resulted in 61 processes and none of them are
hanging, so other processes must be using the file.

Paul Sundling
spam<AT>tkz.net

[tkz(at)honesty tmp]$ strace pg_restore
[snip snip snip long strace output]
open("/usr/lib/locale/locale-archive", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=30301680, ...}) = 0
mmap2(NULL, 2097152, PROT_READ, MAP_PRIVATE, 3, 0) = 0x402b7000
close(3) = 0
time(NULL) = 1051178259
fstat64(0, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 0), ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x40017000
read(0, <****HANGS HERE*****>

[root(at)honesty lock]# rpm -qf /usr/lib/locale/locale-archive
file /usr/lib/locale/locale-archive is not owned by any package

[root(at)honesty lock]# ls -l /usr/lib/locale/locale-archive
-rw-r--r-- 1 root root 30301680 Apr 24 02:09
/usr/lib/locale/locale-archive

[root(at)honesty lock]# rpm -qa | grep postg
postgresql-test-7.3.2-3
postgresql-libs-7.3.2-3
postgresql-7.3.2-3
postgresql-docs-7.3.2-3
postgresql-odbc-7.2.5-1
postgresql-contrib-7.3.2-3
postgresql72-libs-1-3
postgresql-server-7.3.2-3
postgresql-devel-7.3.2-3
gnucash-backend-postgres-1.8.1-3
postgresql-tcl-7.3.2-3
postgresql-jdbc-7.3.2-3
postgresql-pl-7.3.2-3
postgresql-python-7.3.2-3

Browse pgsql-bugs by date

  From Date Subject
Next Message Donald Fraser 2003-04-24 11:05:38 Parsing the result of a function to a view in an INSERT statement.
Previous Message Axel Spallek 2003-04-24 09:18:20 Select Statements freeze.