Re: 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 = '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.
>
>
If you are using Unix file systems for your temporary space a file system
filled up, otherwise if you are using a raw device that has filled up.