maybe the linux firebird user doesn't have access to the /tmp
directory to get to the sort file?

-steve

On 8/9/2010 5:46 AM, Tamas Kiss wrote:
>
> Dear Members,
>
> I am facing a strange error.
>
> We have a Linux Centos server running a Firebird 2.1 (LI-V6.3.3.18185).
>
> I have products table with 52 fields with some varchar(80), varchar(100),
> varchar(255) fields amongst them.
>
> Default Character set is WIN1250, default collation for fields is
> PXW_HUNDC.
>
> For correct display of data I need to order by on productname field
> collate
> PXW_HUNDC.
>
> My problem is that when I execute a query on this table selecting just a
> several fields everything works fine and fast.
>
> But as soon as I try running "SELECT * from Products order by productname
> collate PXW_HUNDC"
>
> an error says: "operating system directive open failed , no such file or
> directory".
>
> The same happens when I include almost all fields of the table. I tried to
> figure out which field contains erroneous data for sorting but everything
> seemed OK.
>
> Our database is small, below 300 MB. The table contains 50000 records.
> Page
> size is 8K but also tried with 16k.
>
> Clients run their Delphi application on Windows XP or later, query tested
> with IBX, FIBPLUS.
>
> Database restores correctly from backup so there is no sign of database
> corruption.
>
> I updated productname to be 'product_' || productid (so it wouldn't
> contain
> special characters) and even updated all non-requied varchar fields of the
> relation to NULL but it didn't help.
>
> Interestingly, I have the partners table with around 100 fields containing
> varchar fields (50, 80 and 100 char length) but the error doesn't show up
> with a similar query, order and collation of its fields.
>
> I read through the similar posts but nothing seemed to help.
>
> Any kind of help is greatly appreciated.
>
> Thank you.
>
> Regards,
>
> Tamas Kiss
>
> [Non-text portions of this message have been removed]
>
>

--
Steve Wiser
President
Specialized Business Software
6325 Cochran Road, Unit 1
Solon, OH 44139

www.specializedbusinesssoftware.com
(440) 542-9145 - fax (440) 542-9143
Toll Free: (866) 328-4936




This message and any files transmitted with it may contain information that is privileged, confidential, and exempt from disclosure under applicable law. They are intended solely for the use of the intended recipient. If you are not the intended recipient, distributing, copying, disclosing, or reliance on the contents of this communication is strictly prohibited. If this has reached you in error, kindly destroy this message and notify the sender immediately. Thank you for your assistance.

We attempt to sweep harmful content (e.g. viruses) from e-mail and attachments, however we cannot guarantee their safety and can accept no liability for any resulting damage. The recipient is responsible to verify the safety of this message and any attachments before accepting them.