Subject Re: [firebird-support] Illegal seek error
Author Helen Borrie
At 10:11 AM 26/10/2008, you wrote:
>Hello *,
>
>I'm running PHP application on one server and FB 2.1 SS on other
>server (Slackware linux box). From time to time (once per two days,
>twice per day, ...) I got error for particular database:
>I/O error for file "/fbsql/xxx.fdb"
>Error while trying to write to file
>Illegal seek
>
>Other databases are running fine. Restart of FB solves the problem.
>
>Any clue what to try to test (problem is that I cannot reproduce this
>easily :()?

Do you have a sort operation (group by, distinct, order by) that might need to go to disk and you don't have any firebird group authorised temp space for it?

./heLen