--- In firebird-support@yahoogroups.com, "Adam" wrote:

> --- In firebird-support@yahoogroups.com, "Ann W. Harrison" wrote:
> > Adam wrote:
> >
> > > Has anyone had the error message "unsuccessful metadata update
> > > request depth exceeded." I have had it twice (in my test
> > > environment, not real world) and was wondering what the likely
> > > culprit(s) are?
> >
> > That would be some type of recursive definition, I think. You'll
> > have to pare down an example ddl file that causes the problem to
> > identify the actual cause. The error message for two many formats
> > is different. This one indicates that the stack depth for a
> > recursive request has been exceeded.
> >
> > Regards,
> >
> >
> > Ann
>
> Thanks Ann,
>
> That is what I suspected, but as there is no pattern to where it is
> popping up (two very distinct parts of the application, in fact one
> of them does not do any update or insert), I find it strange that it
> is not repeatable if it is a stack depth issue. I should be able to
> (I think) using the same database execute the same screens twice
> doing the same thing and see the error message every time.

I don't think we're talking update or insert. The error message was:
"unsuccessful metadata update request depth exceeded.", and "metadata"
is an important part of that message. Hence, look at any ALTER <table>
or ALTER <index> etc. Are you by any chance trying to create a
"recursive foreign key" (TableA -> TableB, and at the same time TableB
-> TableA) or something?

HTH,
Set