Re: [firebird-support] Error creating Foreign key

2018-06-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.06.2018 16:38, Mourad Hedfi mou...@bilog.fr [firebird-support] wrote: > Yes, the problem is reproduced on EMS but not with Flamerobin. The difference between them is in transaction parameters. Transaction with "nowait" flag can get "object in use" error even of the object is not really in

Re: [firebird-support] Error creating Foreign key

2018-06-12 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi, are you sure that you are the only one attachment to the database?Check this by mon$attachments if present in Fb1.5...You can try to change database file name if it is changed succesfully then you are the only one. Try to add some delay after disconnect. But your real cure is Firebird3.

Re: [firebird-support] Error creating Foreign key

2018-06-12 Thread Mourad Hedfi mou...@bilog.fr [firebird-support]
Thanks for your reply. Yes, the problem is reproduced on EMS but not with Flamerobin. I'm not in the same with you. I've not recompiled a stored procedured. I can't determine exactly the problem origin. I've backuped and restored the database but this's did'nt resolve the problem. I gues that

Re: [firebird-support] Error creating Foreign key

2018-06-12 Thread Mourad Hedfi mou...@bilog.fr [firebird-support]
Hello All, I return to you after many tests and finally I've found that when I've two or more successive FK to create, only the first is created and I've the error "Object in use" for the others. I've tried : 1. Add a commit command after every FK create command 2. Disconnect after every FK