[firebird-support] Re: Strange items in log file

Hello I'm so sorry - it was syslog :-( My fault I have open many files, and mismatch what i actually see. Sorry to all. Best regards, Tom

[firebird-support] Strange items in log file

Hello I have one instance on Debian in which today we detect strange items in the firebird.log Apr 24 11:44:23 hansen systemd[1]: Time has been changed Apr 24 11:44:23 hansen systemd[1]: apt-daily.timer: Adding 5h 43min 28.514255s random time. Apr 24 11:44:23 hansen systemd[1]:

[firebird-support] Re: wrong ordering in WITH RECURSIVE query

Hi, I've found the reason :-) create view view_strom_pujcoven with recursive n (ID_PUJC, NAZEV, FK_BUDOVA, PK_PUJCOVNA, PORADI, FK_UCETNI_JEDNOTKA, JE_UK, SIGLA, JE_ONLINE, ID_BUDOVA_PUV, FK_NADR, JE_EXEMP, uroven, razeni) as ( SELECT ID_PUJC, NAZEV, FK_BUDOVA, PK_PUJCOVNA, PORADI,

[firebird-support] Re: wrong ordering in WITH RECURSIVE query

Hi all, it is ordered according to order of inserts I have tried to delete one row and reinsert it - and the row is now last :-( So is there some logical error in my query? Or is it the error in fb engine? Thank you a lot. Tom

[firebird-support] wrong ordering in WITH RECURSIVE query

Hi, I have table with tree structure of records, so I use select to read them in this way. The best is with recursive n () and it works usually fine. But one customer reported me failure in ordering - one node is not ordered according tu ORDER BY column - it is allways the last

[firebird-support] Re: Why I cannot remove FK constraint

Hi the first query returns 4 rows with FK that are on VYKONY_AUT - one of them I want to drop the second query does not return rows :-( Tom

[firebird-support] Re: Why I cannot remove FK constraint

Hi I tried backup - restore, gfix and it did not help I drop all dependencies - views, stored procedures, triggers that was dependend on the table But it did not help - still the same error. The full FB version is 2.5.8.27089 Thank for your help. Tom

[firebird-support] Re: Why I cannot remove FK constraint

Hi I use FB 2.5 - i can check subversion in these cases - but I think it is not the cause of problem - in one case we have 10 databases on one server - 9 OK, 1 KO Yes I have tried to backup and restore it - it did not help. I can try gfix - I will send feedback Thanks, Tomas

[firebird-support] Why I cannot remove FK constraint

Hello I have problem with part of our databases. All our databases should have the same structure, but in some of them I cannot drop constraint ALTER TABLE VYKONY_AUT DROP CONSTRAINT FK_VYKONY_AUT_VYKON chyba: java.sql.SQLSyntaxErrorException: unsuccessful metadata update; ERASE

[firebird-support] Re: Firing event when deleting in MON$ATTACHMENTS

Hello There is BEFORE_DISCONNECT trigger - try it. You cannot (as I think) stop disconnection - but you can reconnect in your application Tom

[firebird-support] Firebird crash on FreeBSD

Hello, we have one customer using FreeBSD and Firebird 2.5.4 It works fine till this week when firebird crashes twice. In Firebird.log i found this text verbis Mon Sep 5 22:44:01 2016 Operating system call semaphore.h: release: sem_post() failed. Error code 22 verbis Mon Sep 5 22:44:01 2016

[firebird-support] Errors in firebird.log

Hi, I have firebird 2.5.4 super server on Win 2007 SP2 32bit server. I have to reinstall it - because it occasionally (app. 4x a week) falls and needs to restart whole server. Now it looks much better, but after 5 days of service there are these rows in firebird.conf SERVER01 (Server)