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

Posted in 1997

Sujit Pal — 27 Aug 1997 11:38:13 -0400 — source: Informix-list mailing list archive (1991-1998)

Bill What is your DBSPACETEMP set to? If not set, the ORDER BY is using the = rootdbs to create temporary tables during the sort else it is using = whatever dbspace your DBSPACETEMP (onconfig parameter) points to. And it = is running out of space. HTH Sujit Pal ---------- From: Bill Bertovich[SMTP:billb@connect3.com] Sent: Tuesday, August 26, 1997 2:54 PM To: informix-list@rmy.emory.edu Subject: Help - 567: Cannot write sorted rows. 28: No space left on = device. Hi all, While running this query that should return 259 rows, I get an error. SELECT * FROM MyTable WHERE MyColumn =3D '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.