Re: pg_restore stuck in a loop?
От | Rod Taylor |
---|---|
Тема | Re: pg_restore stuck in a loop? |
Дата | |
Msg-id | 1114650055.14522.76.camel@home обсуждение исходный текст |
Ответ на | Re: pg_restore stuck in a loop? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: pg_restore stuck in a loop?
Re: pg_restore stuck in a loop? |
Список | pgsql-hackers |
On Tue, 2005-04-26 at 23:22 -0400, Tom Lane wrote: > Rod Taylor <pg@rbt.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 () --
В списке pgsql-hackers по дате отправления: