Re: [GENERAL] Upgrading from 6.3->6.4.2/6.5b1 possible

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
Cc: PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Upgrading from 6.3->6.4.2/6.5b1 possible
Date: 1999-05-31 03:39:07
Message-ID: 199905310339.XAA19326@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry. I need to see the lines causing the error.
Looks like the problem is near here:

INSERT INTO product(title, summary, category, mfrcode, mfr, costprice,
rrprice, taxrate, weight) SELECT 'CF-37L/QD CASE for F-401s,x QD (not
original F-401QD)','FOR F-401,s,x, leatherette, no
strap','24081','814913','21192','75.00','123.75','.32', null;

Remove lines from the file until the load works. I recommend starting
at this line, and removing above and below it. The last line you remove
is the one that is causing the failure. Report back on the cause.

> Bruce,
> I've put up a script for ftp that shows some wierd behaviour. This
> script was created by hand, so it's possible that some errors are caused
> by syntax errors (although I spent a while trying to find them without
> success).
>
> I think the point is that it is not recovering from/ reporting the error
> well (if there is one that is). It just gives errors about "max query
> size exceeded". Something happens part way through, and then you just
> get the same error thousands of times.
>
> ftp://tech.com.au/pub/load-error.gz
>
>
> Bruce Momjian wrote:
> >
> > >
> > > I've seen this problem too in 6.5 beta. I don't have a solution, but I'd
> > > just like to add my voice to say that this problem is real.
> > >
> > > Actually, I did have a kind of solution. If you dump proper insert
> > > statements into the dump and then run every insert in a separate
> > > process. Ugly but workable if the number isn't too great.
> > >
> > > while read A
> > > do
> > > echo "$A" | psql databasename
> > > done <dumpfilename
> > >
> > >
> >
> > We don't hear about this very often. Can someone tell us exactly what a
> > bad load looks like, or a cause.
> >
> > --
> > Bruce Momjian | http://www.op.net/~candle
> > maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> > + If your life is a hard drive, | 830 Blythe Avenue
> > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Keller 1999-05-31 09:25:38 serching in array
Previous Message Howie 1999-05-31 03:35:40 bug in 6.4.2?