Re: [firebird-support] Why I cannot remove FK constraint
On 1/25/2019 7:11 PM, Daniel Miller dmil...@amfes.com [firebird-support] wrote: On 1/24/2019 7:56 AM, respekt...@post.cz [firebird-support] wrote: 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 RDB$RELATION_CONSTRAINTS failed; action cancelled by trigger (1) to preserve data integrity; Cannot delete trigger used by a CHECK Constraint; At trigger 'RDB$TRIGGER_34' [SQLState:42000, ISC error code:335544351] java.sql.SQLSyntaxErrorException: unsuccessful metadata update; ERASE RDB$RELATION_CONSTRAINTS failed; action cancelled by trigger (1) to preserve data integrity; Cannot delete trigger used by a CHECK Constraint; At trigger 'RDB$TRIGGER_34' [SQLState:42000, ISC error code:335544351] Try this - see if either of these queries show you what might need to be fixed. Otherwise you'll need to share your database structure: select * from RDB$RELATION_CONSTRAINTS where RDB$RELATION_NAME = 'VYKONY_AUT'; and select * from RDB$RELATION_CONSTRAINTS where RDB$RELATION_NAME = 'FK_VYKONY_AUT_VYKON'; -- Daniel
Re: [firebird-support] Re: How to "shape" indexes to avoid index depth > 3
29.01.2019 21:13, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > the multi-segment indexes are to optimize commonly used queries. In this case you can consider removing one or two fields from the index and see how much selectivity it lose and how much performance would be affected. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
RE: [firebird-support] Re: How to "shape" indexes to avoid index depth > 3
> > All the FB articles/docs/postings that I have seen have said for > > performance, index depth should be no more than 3. > > This is not a hard requirement, 4 levels may be also OK. Are those multi- > segment indices primary/unique keys or just for lookup purposes? {Sorry for the delay in responding, was away on vacation} Most of our PK are generator values, the multi-segment indexes are to optimize commonly used queries. Sean
Re: [firebird-support] Question about delay in fetch operation
Op 29-01-2019 om 12:45 schreef Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]: >Two last things come to mind... >- a memory issue on the server >What happens if you change page buffers? >- a disk issue on the server >What happens if you leave the original file on the server and try a copy of the database >on a different disk location >on a different disk >on a different computer? >Just thinking along... there must be a bottleneck somewhere >John _John, I’ve tested on 3 different machines, the clients server, my own PC, and our companies cloud server. The same behavior happens exactly the same. Ehm... page buffers?
RE: [firebird-support] Question about delay in fetch operation
>Two last things come to mind... >- a memory issue on the server >What happens if you change page buffers? >- a disk issue on the server >What happens if you leave the original file on the server and try a copy of >the database >on a different disk location >on a different disk >on a different computer? >Just thinking along... there must be a bottleneck somewhere... >John _John, I’ve tested on 3 different machines, the clients server, my own PC, and our companies cloud server. The same behavior happens exactly the same.
ODP: [firebird-support] Firebird database executing DML queries very slowly.
Hi Is this from problematic time with connected clients? If yes than i do no see problems. You must provide more details about issue. What exact comand is slow? What are the query plan and query sats? Did you tested HDD isues? … Regards, Karol Bieniaszewski
Re: [firebird-support] Question about delay in fetch operation
Two last things come to mind... - a memory issue on the server What happens if you change page buffers? - a disk issue on the server What happens if you leave the original file on the server and try a copy of the database on a different disk location on a different disk on a different computer? Just thinking along... there must be a bottleneck somewhere... John
[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