Subject Re: [firebird-support] Err -663 "Too many keys defined for index" while trying to create single field index on table with 4 records..
Author Ann W. Harrison
Ann W. Harrison wrote:
> For what it's worth, the database has some abandoned records in
> RDB$INDEX_SEGMENTS. I'm trying to figure out how they got there and why
> they don't show up when you look for them.

Well, I found it. Nasty interaction between the system transaction and
a rolled back user transaction.