Results 1 to 4 of 4
  1. #1
    Join Date
    May 2012
    Posts
    2

    Unanswered: Could not write to a temporary file.

    When I try to restore a table with a blob field, the next message appears
    264: Could not write to a temporary file.

    Trying restore database, the proces fails on this table.
    Testing restore with backups from other days with the same result.

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    which version please?

    did you check any interesting message in the informix log?
    what does onstat -d say ?

  3. #3
    Join Date
    May 2012
    Posts
    2

    Could not write to a temporary file.

    IBM Informix Dynamic Server Version 11.50.FC6

    onstat -d output

    Dbspaces
    address number flags fchunk nchunks pgsize flags owner name
    4b6fb028 1 0x60001 1 1 2048 N B informix rootdbs
    4b6fb5e0 2 0x60001 2 1 2048 N B informix indices
    4b6fb778 3 0x60001 3 1 2048 N B informix datos
    3 active, 2047 maximum

    Chunks
    address chunk/dbs offset size free bpages flags pathname
    4b6fb1c0 1 1 0 1000000 935249 PO-B- /dev/rootdbsc1
    4b6fb910 2 2 0 1000000 916280 PO-B- /dev/indexc1
    4b6fbb00 3 3 0 5000000 3178870 PO-B- /dev/datosc1

  4. #4
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    So apparently you have free space.
    But I also see you have no tempdbspace created.
    In this case, temp data should go to filesystem ( /tmp )
    Is /tmp close to full ?

    Nothing in the message file ? ( see file name in $INFORMIXDIR/etc/$ONCONFIG , on the MSGPATH line )

Tags for this Thread

Posting Permissions

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