| Subject | Re: [firebird-support] HELP "Object in use" |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-11-24T04:38:11Z |
At 04:49 AM 24/11/2004 +0100, you wrote:
involved) are the one and only user on the system and that you are not
running any concurrent transactions. Even if you think you are alone, if
you are using a tool that is showing you any system information or data of
any sort, then you have at least one other transaction running.
./heLen
>Hi AllWell, you didn't need to go to all that trouble....
>
>With FB 1.52 RC3 I tried to place a Foreign Key
>
>ALTER TABLE APK ADD CONSTRAINT F_APK_GROUPID
> FOREIGN KEY (GROUPID) REFERENCES APKGROUP
> (APKGROUPID)
>
>But at commit it gives
>
>ISC ERROR CODE:335544351
>ISC ERROR MESSAGE:
>unsuccessful metadata update
>object APKGROUP is in use
>
>This happens even after shutdown, gbak backup and restore, reboot
>Does anyone know a solution ?Yes. Just make sure that you (as SYSDBA or as Owner of the tables
involved) are the one and only user on the system and that you are not
running any concurrent transactions. Even if you think you are alone, if
you are using a tool that is showing you any system information or data of
any sort, then you have at least one other transaction running.
./heLen