Hi all,

Maybe somebody can help with this one. I'm running into a nasty
problem using firebird 1.5.2.4731 (actually the embedded library) on
Windows 2000 SP4.

I have this table definition:

CREATE TABLE revisiondata (
iobjid BIGINT NOT NULL,
bdata BLOB sub_type 0 segment size 4096,
icompression SMALLINT,
fidobject BIGINT,
isegment BIGINT,
slast CHAR(1),
itype SMALLINT);
ALTER TABLE revisiondata ADD CONSTRAINT PK_revisiondata PRIMARY KEY
(iobjid);
CREATE INDEX RD_OBJECT_SEGMENT ON revisiondata (fidobject, isegment);


This table is populated with data (fdb is 6MB, 1500 records). Blobs
are not very big, around 200Kb for the biggest and most are a few KB.

Updating the table with a new index:

CREATE INDEX RD_OBJECT ON revisiondata (fidobject)

on a new transaction throws the error "UNSUCCESSFUL METADATA UPDATE:
too many keys defined for index RD_OBJECT".

The point is that the error only shows up on one machine, and I'm not
able to reproduce on the development env.

I have checked fbembed.dll dependencies: mscvrt.dll and msvcp60.dll
are same versions as the machine failing.

The machine that shows the error sistematically fails to create the
index. Curiously, we have other databases with same schema on that
machine that create the index without problems.

Anybody has an idea?