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!

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]