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

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@candle.pha.pa.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@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026