Skip site navigation (1) Skip section navigation (2)

Re: Hanging with pg_restore and large objects

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Alexander <goal81(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Hanging with pg_restore and large objects
Date: 2011-11-01 04:43:13
Message-ID: 4EAF78E1.5050307@ringerc.id.au (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

Responses

pgsql-bugs by date

Next:From: AlexanderDate: 2011-11-01 06:15:25
Subject: Re: Hanging with pg_restore and large objects
Previous:From: Mark KirkwoodDate: 2011-11-01 04:26:30
Subject: Re: BUG #6275: Horrible performance regression

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group