Обсуждение: Hanging with pg_restore and large objects
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@gmail.com
On 01/11/11 02:46, Alexander wrote: > 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? Disk issues? Have you checked dmesg, the SMART status of your disks, and syslog? Can you copy the dump with the "cp" command? Can you use "pg_restore" to produce a .sql dump from it? -- Craig Ringer
It does not look like a disk issue - syslog doesn't report any problems, postgresql also seems to work fine. I'll try to make an SQL dump from backup file, but before that I'll try another backup file - probably the one I try to restore is broken due to some reasons (it was transfered over the network). 1 =CE=CF=D1=C2=D2=D1 2011 =C7. 8:43 =D0=CF=CC=D8=DA=CF=D7=C1=D4=C5=CC=D8 Cr= aig Ringer <ringerc@ringerc.id.au>=CE=C1=D0=C9=D3=C1=CC: > On 01/11/11 02:46, Alexander wrote: > > 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? > > Disk issues? Have you checked dmesg, the SMART status of your disks, and > syslog? > > Can you copy the dump with the "cp" command? > > Can you use "pg_restore" to produce a .sql dump from it? > > -- > Craig Ringer >