[firebird-support] Index Corruption Firebird 1.5
Hi, Recently we have started noticing problems at many of our customers where the index on certain tables are either corrupted or inactive. These are three different scenarios that we have and I hope you can give me some info on what is causing this. 1. Index's are in the inactive state.2. Index whose definition was changed and also in inactive state.3. Indexes are active but the select using that index was not returning any results but once we inactivate and reactivate the indexes it starts to work properly. We are using Firebird 1.5.5.4926 and IBO components. We do a background process at night to inactivate and reactivate all indexes but this hasn't really helped the cause. We have checked to make sure that no person is playing with the database and causing this issue and its something in the program or some other factor which is causing this issue. We have checked the code around the tables where these problems exist and couldn't find anything that could cause the problem. I hope that some of you can let me know what to look for to fix this issue. Thanks [Non-text portions of this message have been removed]
[firebird-support] Re: Index Corruption Firebird 1.5
Yes we plan to move to the latest version which is already under way but lately these index issues have become a daily nag. Will try and upgrade the customer to 1.56 in the mean while and see if that solves it for the time being. Thanks --- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote: > > >> Recently we have started noticing problems at many of our customers > >> where the index on certain tables are either corrupted or inactive. > >> These are three different scenarios that we have and I hope you can give > >> me some info on what is causing this. > >> 1. Index's are in the inactive state.2. Index whose definition was > >> changed and also in inactive state.3. Indexes are active but the select > >> using that index was not returning any results but once we inactivate > >> and reactivate the indexes it starts to work properly. > >> We are using Firebird 1.5.5.4926 and IBO components. We do a background > >> process at night to inactivate and reactivate all indexes but this > >> hasn't really helped the cause. We have checked to make sure that no > >> person is playing with the database and causing this issue and its > >> something in the program or some other factor which is causing this > >> issue. We have checked the code around the tables where these problems > >> exist and couldn't find anything that could cause the problem. > >> I hope that some of you can let me know what to look for to fix this > >> issue. > > > > AFAIR, quite some index corruption issues have been fixed in the 2.x series. > > If you need to stay at 1.5 as a short-term plan, you should at least > update to 1.5.6, because it has the following fixed: > > http://tracker.firebirdsql.org/browse/CORE-1830 > > -- > With regards, > Thomas Steinmaurer > http://www.upscene.com/ >
[firebird-support] URGENT : Corrupt Firebird dabase
Hi, One of our clients has a corrupted database (we are getting internal gds error). Its a Firebird Database version 1.5.6, the files size is almost 7.5GB, we are unable to recover it with the normal tools, we have run the Repair procedure in IBFIRST aid and followed the recommended steps following that, using GFIX and GBAK command lines. Backup fails with the following error on a table gbak: ERROR: Internal gds software consistency check (wrong record length (183)) gbak: ERROR: gds_$receive failed We are not able to even delete the table or its data to continue with the backup. The client is down for the last one day. I would really appreciate if any one can help me in find a way to get this database up and running. Thanks
[firebird-support] Forced Write turning off
We recently had database corruptions and had turned on forced write on our databases on windows environment but we found that after we run our client application gstat was no more showing the forced write status. We are using Delphi and IBO components but not sure what in the application is resetting this status. Has anyone come across this problem or know what could be doing this. thanks
[firebird-support] Forced write
Hi, We are on Firebird 1.56 and recently encountered database corruption problem with a customer. Found that forced write was turned off on the database and after the database was restored turned it on. However on checking the next day forced write was again turned off. We do daily sweep, reindex and backup on the database as maintenance at the the eod. Will any of this cause forced write to be turned off. Thanks
[firebird-support] Re: Forced write
We found it the ibo components was set to forced write no and that was causing the problem. Thanks --- In firebird-support@yahoogroups.com, Helen Borrie wrote: > > At 08:55 a.m. 18/07/2013, rddymanohar wrote: > >Hi, > >We are on Firebird 1.56 and recently encountered database corruption problem > >with a customer. Found that forced write was turned off on the database and > >after the database was restored turned it on. However on checking the next > >day forced write was again turned off. We do daily sweep, reindex and backup > >on the database as maintenance at the the eod. Will any of this cause forced > >write to be turned off. > > None of the above will change the Forced Write setting. However, in the very > ancient version of Firebird that you are using, a client can do it, via the > connection API. The very first thing I would recommend is to examine closely > the connection settings on all client applications. > > A common source of this problem is Delphi applications that provide > properties and/or arrays of properties in the connection component > (connection alone, or database component). If this is your case, look at > *both* the property in question (ForcedWrites TRUE/FALSE) and *also* the > Params property of the connection/database component. > > > Helen Borrie, Support Consultant, IBPhoenix (Pacific) > Author of "The Firebird Book" and "The Firebird Book Second Edition" > http://www.firebird-books.net > __ >
