>> On some servers we encounter a sudden reboot after FB install.
>> [...]
> Wasn't it BSOD because of hardware malfunction? In Windows system
> setting turn off automatic reboot on error.
No. A BSOD needs a user intervention in order for the machine to
reboot. In the cases I have seen, Windows
Hi Diimitry,
Just checked with our hardware man, according to him there was no hardware
malfunction. The server is doing a proper shutdown and restart, but there is no
confirmation dialog prior to the restart. I know it's a difficult problem to
trace since it's only happening every now and
Hi Dimitry,
It's happening sometimes, certainly not everytime, it's difficult to say when,
but I will check your suggestion with our network people. Thanks a lot for your
fast reply !
13.06.2018 9:54, meanbe...@yahoo.com [firebird-support] wrote:
> On some servers we encounter a sudden reboot after FB install. Version is
> 2.5.7.27050 64
> bit. It's happening on a variety of operating systems, even just a client
> install. The
> reboot happens suddenly without asking any
13.06.2018 8:47, Mourad Hedfi mou...@bilog.fr [firebird-support] wrote:
> "You must use "wait" transaction for metadata changes. " ==> What command I
> must add for
> that ?
https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-transacs-statements.html
For example, I've 5 FK on this table and only the first was created and the
others, as shown, are in error :
ALTER TABLE TABLE FINSMR_INDIC_SMR_ATR ADD CONSTRAINT
FK2_FINSMR_INDIC_SMR_ATR FOREIGN KEY (FINSMR_SP_CODE_FK_PK) REFERENCES
SP_SPECIALITE (SP_CODE_SQ_PK) ON DELETE CASCADE - This
What are the names of the foreign keys? Just in case Firebird thinks two
foreign keys are identical, e.g. the naming of both foreign keys have the
same first 27 letters and only differ later (don't know if the limit is 27,
I think it was 27 or 28 for tables earlier, have no clue about FKs). Are
Thanks for your suggestions.
The database file is not in use and I can rename.
I've tried to drop / create FK without executing update commands and it
works fine. After that, I've executed to whole process :
1. DROP FK
2. Execute insert / update / delete SQL commands
3. Create FK ===> the