Thank you for your suggestion Nick: > 1 Drop the primary key constraint of the table in question > 2 create index on the 6 fields > 3 validate
I have tried this during the night: no, that does not help either, i.e. the fact that index is being built as a secondary one and without unique-constraints does not change anything - the same validation problem is there again, immediately after building this index (no primary index there at that time any more, as I followed your steps closely). Also, one of the two problem databases has a secondary index. I have not mentioned this explicitly, but there is a validation error on that secondary index too (also noticeable, I believe, from my excerpts from firebird.log and DB statistics from yesterday). BTW, I have tried yesterday the diagnostics of IBFirstAID - this is what it found on the original DB (everything else is OK): 19.04.2011 16:27:36 INFO: Analyzing database low-level structures... 19.04.2011 16:27:36 INFO: Process database file #1 of 1 files. 19.04.2011 16:37:44 INFO: Actual PageCount: 2997391 found in database 19.04.2011 16:37:44 INFO: Found 7870 undefined pages. The rest was: 19.04.2011 16:39:58 INFO: Running procedure: Header page check 19.04.2011 16:39:58 INFO: ODS Major = 11 (32779) 19.04.2011 16:39:58 INFO: ODS Minor = 1 19.04.2011 16:39:58 INFO: Next transaction = 23213 19.04.2011 16:39:58 INFO: Oldest transaction = 23208 19.04.2011 16:39:58 INFO: Oldest active = 23209 19.04.2011 16:39:58 INFO: Oldest snapshot = 23209 19.04.2011 16:39:58 INFO: PageSize is Ok = 16384 19.04.2011 16:39:58 INFO: Running procedure: Checking of RDB$Pages consistency 19.04.2011 16:40:02 INFO: Checking of RDB$Pages consistency: Ok 19.04.2011 16:40:02 INFO: Running procedure: Low-level check of all relations 19.04.2011 18:04:17 INFO: Low-level check of all relations: Ok I am not sure if a number of undefined pages is of significance and what it actually means. Regards, Borut ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
