[firebird-support] Re: database gone after server reboot

2014-04-17 Thread jakefeed
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."

RE: [firebird-support] database gone after server reboot

2014-04-15 Thread jakefeed
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:2

[firebird-support] Re: database gone after server reboot

2014-04-15 Thread jakefeed
Both instances were using Firebird 2.5 in classic configuration.

[firebird-support] database gone after server reboot

2014-04-15 Thread jakefeed
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 backu

[firebird-support] Database Corruption

2012-07-02 Thread jakefeed
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

[firebird-support] Primary key with negative value

2012-03-29 Thread jakefeed
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 ar