Subject | Database Server Error:unsuccessful metadata update cannot delete DOMAIN RDB$1749 |
---|---|
Author | karolbieniaszewski |
Post date | 2011-04-01T12:12:37Z |
Hi
when i update database then i get
"Database Server Error: unsuccessful metadata update cannot delete DOMAIN RDB$1749 there are 1 dependencies"
how can i check what dependicies exists on field listed in
RDB$FIELDS?
SELECT *
FROM RDB$FIELDS a
WHERE
a.RDB$FIELD_NAME like 'RDB$1749%'
result me 1 record
but
SELECT *
FROM RDB$RELATION_FIELDS a
where
a.RDB$FIELD_SOURCE like 'RDB$1749%'
return 0 records
-------------------------------------------------
when i rollback transaction
and try once again update database metadata now all scripts pass
i check database with gfix
is possible to some other corruption which gfix cannot find?
or i can ignor this message and after second update - always without error - database metadata are ok?
Karol Bieniaszewski
when i update database then i get
"Database Server Error: unsuccessful metadata update cannot delete DOMAIN RDB$1749 there are 1 dependencies"
how can i check what dependicies exists on field listed in
RDB$FIELDS?
SELECT *
FROM RDB$FIELDS a
WHERE
a.RDB$FIELD_NAME like 'RDB$1749%'
result me 1 record
but
SELECT *
FROM RDB$RELATION_FIELDS a
where
a.RDB$FIELD_SOURCE like 'RDB$1749%'
return 0 records
-------------------------------------------------
when i rollback transaction
and try once again update database metadata now all scripts pass
i check database with gfix
is possible to some other corruption which gfix cannot find?
or i can ignor this message and after second update - always without error - database metadata are ok?
Karol Bieniaszewski