Subject Re: [firebird-support] select * order by.. error in Firebird 1.5.1
Author Helen Borrie
At 11:47 PM 19/10/2004 +0800, you wrote:

>I'm running Firebird 1.5.1 on gentoo linux (kernel
>Firebird is installed via gentoo 'emerge' (auto compiles from source).
>It should be a super server.
>I have a basic test table :
>create table TEST_A ( id integer, name char(20))
>Running from isql on the local pc:
>select * from TEST_A order by id
>produce the following error when the table has up to a certain rows.
>In my test, query up to 2730 rows is fine. More than that results in
>the following error (more columns, less rows) :
>SQL> select * from test_a order by id;
>Statement failed, SQLCODE = -902
>I/O error for file ""
>-Error while trying to open file
>-Permission denied
>I must add that query without 'order by' runs fine, tested with no
>problem with 100,000 rows.

Have you configured any temp sort space and given the firebird user rw
permissions to it? Best guess is the sort was looking for sort space on
disk once it ran out of RAM, and hit a rock.

>Similar test runs without any issue on Firebird 1.0.3 / Win98.

Win98 doesn't protect the filesystem.