Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007
    Posts
    25

    Unanswered: SQL state: XX001

    Running the following
    copy public.cards
    from '/home/snaptest/kwi_data/cards6c.csv' DELIMITER ',';
    I get the following error

    ERROR: could not read block 33880 of relation base/37115/37587: read only 0 of 8192 bytes
    CONTEXT: COPY cards, line 128778: "6003928400297053,XXXXWEAR,7053,219,219,43533,Acti vated,f"

    ********** Error **********

    ERROR: could not read block 33880 of relation base/37115/37587: read only 0 of 8192 bytes
    SQL state: XX001
    Context: COPY cards, line 128778: "6003928400297053,XXXXWEAR,7053,219,219,43533,Acti vated,f"

    This was the third batch, I had no prolems with batch 1 and 2 and 2,000,000 were loaded into the table. PG documentation all it says is data corruption.

    Where is the corruption, I vaccumed the table and still get the error.

    HELP

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    That sounds more like a file system problem (e.g. a flaky harddisk)

  3. #3
    Join Date
    Mar 2007
    Posts
    25
    Thank you for your input, we are looking at the disk now.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •