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

Re: pg_restore stuck in a loop?

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_restore stuck in a loop?
Date: 2005-04-28 01:00:55
Message-ID: 1114650055.14522.76.camel@home (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, 2005-04-26 at 23:22 -0400, Tom Lane wrote:
> Rod Taylor <pg(at)rbt(dot)ca> writes:
> > I eventually clued in and made a TOC and removed all of the Slony items,
> > but I'm still curious to know what exactly pg_restore had been doing for
> > the last hour or so.
> 
> You tell us ;-).  You've got the test case, attach to it with a debugger
> and find out what it's doing.

I wasn't entirely sure how to "catch it in action" so I just used CTRL+C
to interrupt the pg_restore process, and got these as backtraces:

(gdb) backtrace
#0  0xb74b9589 in mremap () from /lib/tls/libc.so.6
#1  0xb744dc13 in mremap_chunk () from /lib/tls/libc.so.6
#2  0xb744dfd1 in realloc () from /lib/tls/libc.so.6
#3  0xb75e46b9 in enlargePQExpBuffer ()
from /home/rbt/pg8/lib/libpq.so.4
#4  0xb75e481f in appendPQExpBufferChar ()
from /home/rbt/pg8/lib/libpq.so.4
#5  0x0804efe3 in _sendSQLLine ()
#6  0x0804f2bd in ExecuteSqlCommandBuf ()
#7  0x0805019e in _PrintData ()
#8  0x0804fee5 in _PrintTocData ()
#9  0x0804aba2 in RestoreArchive ()
#10 0x0804a525 in main ()

(gdb) backtrace
#0  0xb75e465e in enlargePQExpBuffer ()
from /home/rbt/pg8/lib/libpq.so.4
#1  0xb75e481f in appendPQExpBufferChar ()
from /home/rbt/pg8/lib/libpq.so.4
#2  0x0804efe3 in _sendSQLLine ()
#3  0x0804f2bd in ExecuteSqlCommandBuf ()
#4  0x0805019e in _PrintData ()
#5  0x0804fee5 in _PrintTocData ()
#6  0x0804aba2 in RestoreArchive ()
#7  0x0804a525 in main ()

(gdb) backtrace
#0  0xb75e4800 in appendPQExpBufferChar ()
from /home/rbt/pg8/lib/libpq.so.4
#1  0x0804efe3 in _sendSQLLine ()
#2  0x0804f2bd in ExecuteSqlCommandBuf ()
#3  0x0805019e in _PrintData ()
#4  0x0804fee5 in _PrintTocData ()
#5  0x0804aba2 in RestoreArchive ()
#6  0x0804a525 in main ()





-- 


In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2005-04-28 01:16:47
Subject: Re: Tablepartitioning: Will it be supported in Future?
Previous:From: Juan Jose Costello LevienDate: 2005-04-28 00:53:39
Subject: Re: Developer Community

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