Commented by: @hvlad

The reason of BUGCHECK is that on second commit new relation_id is assigned to both newly created tables and when foreign key's index created master relation can't be found in metadata cache.

Patch below solve this issue but i can't say about side effects so far.

cvs -z9 diff -u -wb jrd\dfw.epp
Index: jrd/dfw.epp

RCS file: /cvsroot/firebird/firebird2/src/jrd/dfw.epp,v
retrieving revision 1.258
diff -u -w -b -r1.258 dfw.epp
--- jrd/dfw.epp 23 Dec 2008 13:34:18 -0000 1.258
+++ jrd/dfw.epp 19 Jan 2009 09:22:08 -0000
@@ -2210,6 +2210,38 @@
return true;

case 3:

+ request = CMP_find_request(tdbb, irq_c_relation2, IRQ_REQUESTS);
+
+ if (work->dfw_id)
+ {
+ bool err = true;
+
+ FOR(REQUEST_HANDLE request)
+ X IN RDB$RELATIONS WITH
+ X.RDB$RELATION_NAME EQ work->dfw_name.c_str()
+
+ if (!REQUEST(irq_c_relation2))
+ REQUEST(irq_c_relation2) = request;
+
+ if (!X.RDB$RELATION_ID.NULL &&
+ X.RDB$RELATION_ID == work->dfw_id)
+ {
+ err = false;
+ }
+
+ END_FOR;
+
+ if (!REQUEST(irq_c_relation2))
+ REQUEST(irq_c_relation2) = request;
+
+ if (err)
+ ERR_post(Arg::Gds(isc_no_meta_update) <<
+ Arg::Gds(isc_table_name) << Arg::Str(work->dfw_name) <<
+ Arg::Gds(isc_imp_exc));
+
+ return true;
+ }
+
/* Take a relation lock on rel id -1 before actually
generating a relation id. */

@@ -2304,6 +2336,8 @@
{
relation = MET_relation(tdbb, rel_id);
DPM_create_relation(tdbb, relation);
+
+ work->dfw_id = rel_id;
}

	return true;