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

    Red face Unanswered: SQL state: 53100

    I am trying to update a very large number of rows (over 300,000) and keep getting the following error msg:

    ERROR: could not write to hash-join temporary file: No space left on device
    SQL state: 53100

    The problem is that we have checked and there is plenty disk space available in the server.

    What space is it looking for?

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    If it is a *nix type server be sure that there is space left where ever your data and tmp directories are.

Posting Permissions

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