Subject | Statement failed, SQLCODE = -607 |
---|---|
Author | Jiri Cincura |
Post date | 2006-04-22T20:43:25Z |
Hi *,
I'm running FB2.0 RC1, and if I try to do this command
alter table ITEMS add constraint FK_ITEMS_1 foreign key (FEED_ID)
references FEEDS(ID) on delete CASCADE on update CASCADE;
I got this error message:
ERROR:
Statement failed, SQLCODE = -607
unsuccessful metadata update
-virtual memory exhausted
The memory on server is about 300MB free, during the run of the command too.
I've upgraded FB from 1.5.3 to 2.0 RC1 and now I used backup&restore a
during restore I've got error on the FK index, so I've dropped the FK a
tryied to create it again, but this error occured.
Any ideas?
--
Jiri Cincura
http://www.cincura.net/
I'm running FB2.0 RC1, and if I try to do this command
alter table ITEMS add constraint FK_ITEMS_1 foreign key (FEED_ID)
references FEEDS(ID) on delete CASCADE on update CASCADE;
I got this error message:
ERROR:
Statement failed, SQLCODE = -607
unsuccessful metadata update
-virtual memory exhausted
The memory on server is about 300MB free, during the run of the command too.
I've upgraded FB from 1.5.3 to 2.0 RC1 and now I used backup&restore a
during restore I've got error on the FK index, so I've dropped the FK a
tryied to create it again, but this error occured.
Any ideas?
--
Jiri Cincura
http://www.cincura.net/