We have in the meantime made the following test:
- copied DB to another machine (always under VB 2.1.4) and
on that machine:
- validate => Error
- dropped a number of fields, but did not change primary
index definition in any way. The original table was
described in one of my previous messages.
Sorry for my long silence too (also buzy...). We have done a few tests,
everything with FB 2.1.4.
The problem was reproducible: each restore (from the one and the same
backup) produced the same problem. (BTW, we are regularly updating this
DB/table weekly. After each backup/restore we are getting
Thank you for your time Vlad. You wrote:
> Interesting. Could you provide DDL of table and index ?
CREATE TABLE MATBEW
(
MSEG_MATNR Varchar(18) NOT NULL,
MSEG_WERKS Varchar(4) NOT NULL,
MSEG_LGORT Varchar(4) NOT NULL,
MSEG_MBLNR Varchar(10) NOT NULL,
MSEG_MJAHR Varchar(4) NOT NULL,
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-constrain
Thank you for your time Maya. You wrote:
> Just some more info here. When you restore a database, it looks at your
> index definitions, and current data, and builds the indices from that.
> That is why backing up and restoring will rectify the problem
> (temporarily, till a new corruption occurs)
Oh, yes, unfortunately we have.
In fact, we became aware of this for the first time under
2.1.4 and hence thought about the unlikely possibility that
it might be some kind of degradation. Since we have not done
such validations before, we then validated a long list of
backups of this DB (here not
Hello!
We are repeatedly stumbling upon a problem which apparently looks like one
already discussed in 2010 (about a year ago):
http://tech.groups.yahoo.com/group/firebird-support/message/106845
Firebird log shows the messages of the type:
Index 1 is corrupt (missing entries) in table (128)
