[firebird-support] Primary key with negative value
We have an database in which we supply product catalogs with pricing. The end user can create their own items, too. In order to separate the user's items from the items we supply, we're contemplating using negative primary keys for our items and positive primary keys for the users items. We are using Firebird 2.5.1. Are there any known issues using negative primary key values in this configuration. Thank you.
[firebird-support] Database Corruption
I have a customer database that is returning "internal gds software consistency check (applied differences will not fit in record (177))" whenever I access a particular table. I've run gbak with -g switch and it fails on the one particular table I've run it with and without running gfix -v -full before the gbak. It still fails. One thread I found suggested changing the database to read_only before running the gbak command. It still errors with the same message referred to at the top of the post on the same table. In the firebird.log, there is a deadlock error which occurred 90 minutes before the "...applied differences..." error. This is a Firebird 1.5 database. Any help is appreciated.
[firebird-support] database gone after server reboot
I have two client server applications that are installed in over 200 sites. The applications each use a database, db1 and db2. In the past six months, we've had two strange occurrences. After a scheduled server reboot (Win 2008 R2), the db1 file is missing. Luckily, each company does a backup each night, so it was just a matter of restoring the database. Has anyone encountered something like this before? Ideas on how to prevent this from happening in the future?
[firebird-support] Re: database gone after server reboot
Both instances were using Firebird 2.5 in classic configuration.
RE: [firebird-support] database gone after server reboot
These two occurrences are the only ones I've seen in 17+ years of IB/FB experience. Both after a scheduled Win2008R2 server reboot and both running FB2.5 Classic. One was a physical server and the other was a virtual server. Version: WI-V6.3.1.26351 Firebird 2.5 Creation date = 2014-03-09 09:29:13.2960 Page size = 8192 Number of DB pages allocated = 3902905 DB buffer pages = 0 Actual buffer pages = 75 Database SQL dialect= 3 Sweep interval = 2 Forced Writes are ON Read Only flag is OFF Reserve flag is ON Transaction - oldest = 867893 Transaction - oldest active = 882874 Transaction - oldest snapshot = 882874 Transaction - Next= 899432 ODS = 11.2
[firebird-support] Re: database gone after server reboot
I'm not familiar with the RESERVE flag. I don't think we've set it explicity. What is it function? Does it affect this?: "All pages will be filled to 100% and will be most useful on read-only databases. No space is reserved in each page for updates and/or deletions."