| From: | Alexander <goal81(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Hanging with pg_restore and large objects |
| Date: | 2011-10-31 18:46:42 |
| Message-ID: | 1843207079.20111031224642@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi all.
I've encountered the following problem: pg_restore hangs while
restoring LOBs. The situation is as follows:
1) TARed dump, created by pg_dump 8.3.6
2) pg_restore from Postgresql 9.1.1
3) pg_restore restores schema and most of LOBs, but hangs on one of
them (the same LOB every time). 'ps' shows 'R+' state for
pg_restore, and GDB (attached to pg_restore) gives the following:
(gdb) bt
#0 0x0000003ec6ec6750 in __read_nocancel () from /lib64/libc.so.6
#1 0x0000003ec6e6cd57 in _IO_new_file_underflow () from /lib64/libc.so.6
#2 0x0000003ec6e6ba4e in _IO_file_xsgetn_internal () from /lib64/libc.so.6
#3 0x0000003ec6e61dd2 in fread () from /lib64/libc.so.6
#4 0x000000000040d0e2 in PQconnectdbParams ()
#5 0x000000000040d7fd in PQconnectdbParams ()
#6 0x000000000040e78a in PQconnectdbParams ()
#7 0x0000000000408035 in PQconnectdbParams ()
#8 0x0000000000409116 in PQconnectdbParams ()
#9 0x0000000000403b91 in PQconnectdbParams ()
#10 0x0000003ec6e1d994 in __libc_start_main () from /lib64/libc.so.6
#11 0x0000000000402f99 in PQconnectdbParams ()
#12 0x00007fff51ae6188 in ?? ()
#13 0x0000000000000000 in ?? ()
Does anyone know, what can be wrong?
--
С уважением,
Alexander mailto:goal81(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-10-31 19:39:57 | Re: BUG #6278: Index scans on '>' condition on field with many NULLS |
| Previous Message | Robert Haas | 2011-10-31 18:41:00 | Re: BUG #6278: Index scans on '>' condition on field with many NULLS |