Help - 567: Cannot write sorted rows. 28: No space left on device.

Posted in 1997

"Mr. Himnesh Kapoor" — 27 Aug 1997 07:48:03 -0400 — source: Informix-list mailing list archive (1991-1998)

}From : x>billb@connect3.com To : informix-list@rmy.emory.edu Subject : Help - 567: Cannot write sorted rows. 28: No space left on device. Date : 27/08/97 06:20 Hi Bill, The problem is with the cooked space where it is trying to write teh sorted rows. Check the DBTEMP and create some more space out there or set this parameter to some place where you have more space to write. Himnesh --------------------------------------------------------------------- }Hi all, }> While running this query that should return 259 rows, I get an }>error. }>SELECT * FROM MyTable WHERE MyColumn = 'xxx' ORDER BY }>MyOtherColumn; }>Error: }> 567: Cannot write sorted rows. }> 28: No space left on device }>Can anyone point me in the right direction? Thanks in advance. }>Bill }>billb@connect3.com }>Here's the rest of it: }>Informix 7.01 }>Solaris 2.x }>MyTable: 3000 bytes per row (mostly varchar), 5,820 total rows, 42 }>columns }>npages used - 1463 }>fextsize - 16,039 }>nextsize - 1,603 }>Database: }>no logging }>chunks in database (2k pages): }>(1) 150000 }>(2) 10000 }>42143 pages free.