From: Rajesh Kumar Mallah. <mallah@trade-india.com>
To: Nikola Ivacic <nikola@rs-pi.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ales Kuclar <ales.kuclar@rs-pi.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: COPY command problems
Date: Fri, 27 Dec 2002 16:47:34 +0530
Message-ID: <200212271647.34446.mallah@trade-india.com> (raw)
In-Reply-To: <013101c2ab64$d368df60$1100a8c0@rspi>
References: <007d01c2ab36$85d92760$1100a8c0@rspi>
<19755.1040743489@sss.pgh.pa.us>
<013101c2ab64$d368df60$1100a8c0@rspi>
http://www.memtest86.com/
may be useful.
regds
mallah.
On Tuesday 24 December 2002 09:25 pm, Nikola Ivacic wrote:
> It must be internal error:
> two reasons:
> 1.) the original file is OK (I checked with grep + there is no network
> envolved)
> 2.) Error has strange patern: it substitutes 0x31 with 0x21 (1 with !) also
> 0x34 with 0x24 (4 with $)
> and 0x39 with 0x29 (9 with ) )
>
> so I guess you are right.
>
> can you suggest some tools for FreeBSD
> to test RAM, because I think the hard disk is ok.
>
> p.s. right now I am testing it with splited file
>
> thanks
>
> Nikola
>
> ----- Original Message -----
> From: "Tom Lane" <tgl@sss.pgh.pa.us>
> To: "Nikola Ivacic" <nikola@rs-pi.com>
> Cc: <pgsql-sql@postgresql.org>
> Sent: Tuesday, December 24, 2002 4:24 PM
> Subject: Re: [SQL] COPY command problems
>
> > "Nikola Ivacic" <nikola@rs-pi.com> writes:
> > > Has somebody experienced difficulties using COPY command on large
> > > files. I have a large (250MB) file and each time I insert records I've
> > > got one
>
> or =
>
> > > more (< 30 of cca 1079000) corrupted
> > > records. The number of corrupted records is not constant (i.e. 1, 30,
> > > 7,
>
> 23=
>
> > > etc..)
> >
> > I'd bet on flaky hardware --- have you run memory and disk tests? If
> > the COPY data is passing across a network, then network problems are
> > also worthy of suspicion.
> >
> > regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com, nikola@rs-pi.com, tgl@sss.pgh.pa.us, ales.kuclar@rs-pi.com
Subject: Re: COPY command problems
In-Reply-To: <200212271647.34446.mallah@trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox