Re: PostgreSQL, NetBSD and NFS

On Wednesday 05 February 2003 10:12, Tom Lane wrote:
> "D'Arcy J.M. Cain" <darcy(at)druid(dot)net> writes:
> > Well, it does appear to be working but it never finishes. Here are two
> > backtraces. One was taken while it was running and the other after a
> > kill -9. The primary key file should have had 322846720 bytes based on
> > the database that I was copying in but it only had 4603904 after running
> > the restore for 12 hours. The file seems to get to a static size and
> > just stays there. I am running another test to confirm that.
>
> Hmm --- seems like it must be getting into an infinite loop, but where
> and why? Here is a test plan:

Hmm. This time it passed that point but this happened:

COPY "certificate" FROM stdin;
NOTICE: copy: line 253677, bt_insertonpg[certificate_pkey]: parent page
unfound - fixing branch
ERROR: copy: line 253677, bt_fixlevel[certificate_pkey]: invalid item
order(1) (need to recreate index)
lost synchronization with server, resetting connection

It then continued on. It is currently stuck on the next largest table in our
system. I will try this if it hangs on that other table.

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.