Re: [firebird-support] URGENT: Invalid request BLR

2012-06-08 Thread Thomas Steinmaurer
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

Re: [firebird-support] URGENT: Invalid request BLR

2012-06-08 Thread Alec Swan
Thomas, What can you expect if Firebird needs temporary disk space which isn't available to create/activate an index? I expect the statement to fail but but not corrupt the state of the database. Similarly to how a query with a large sort would fail if there is not enough disk space for the

Re: [firebird-support] URGENT: Invalid request BLR

2012-06-07 Thread Thomas Steinmaurer
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

Re: [firebird-support] URGENT: Invalid request BLR

2012-06-07 Thread Alec Swan
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,