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<t...@iblogmanager.com>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 > > >