Alec,

> Thomas, the index used to exist but for some reason it was lost, probably
> because of the lack of disk space during index rebuild. Firebird should not
> leave the database in a bad state like this if ALTER INDEX ACTIVATE fails
> because of lack of disk space!

What can you expect if Firebird needs temporary disk space which isn't
available to create/activate an index?

This all might be also related to:
http://tracker.firebirdsql.org/browse/CORE-3757


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/

> Alec
>
> On Thu, Jun 7, 2012 at 12:27 PM, Thomas Steinmaurer<ts@...>wrote:
>
>> **
>>
>>
>>> We are getting the following error during a SELECT-query and gfix with
>>> gback do not fix it.
>>>
>>> org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544343. invalid
>>> request BLR at offset 226
>>> there is no index IDX_p39A2dTscKu7xw43c5lrjQ== for table COPY
>>>
>>> The customer is really frustrated, what should we do?
>>
>> Are you forcing the optimizer to use an index via an explicit PLAN, but
>> the index doesn't exist?
>>
>> Regards,
>> Thomas
>>
>>
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>