Re: [firebird-support] Why I cannot remove FK constraint
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] From the error messages above - are there any triggers defined that are looking at this table/field? -- Daniel
Re: [firebird-support] Firebird 2.5 - Data committed to database is not found after a while
Hi Also look at application logic. When invoice is commited before or after print?What is your transaction setup? Do you depend on some automatic commit/rollback or you call commit explicity? Do you use commit retaining? Regards,Karol Bieniaszewski null
Re: [firebird-support] Firebird 2.5 - Data committed to database is not found after a while
25.01.2019 17:30, duque.herna...@yahoo.com [firebird-support] wrote: > Have anyone had this situation? > > Is it posible that it is related to a Windows version? If your database file has GDB extension, Windows System Restore (including automatic one after some minor reboot errors) can silently substitute your database with some old backup. -- 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/
[firebird-support] Firebird 2.5 - Data committed to database is not found after a while
Hi, I have a legacy application written in Delphi XE6 using Firebird 2.5. Since several months ago have noticed that some times table records are not commited to database. I thougt that it was user mistakes with the application but not. They show me evidences that data was typed correctly: For example, one invoice that is fully created and printed, after a while is not found in the database and information is loosed. I thought that could be some issue related to Sweep interval and Forced writes but the issue persists. It is not constant and I have been unable to reproduce it. Have checked the database with gfix dont finding errors. I susspect that it is related to some kind of data cache that for any unkown reason finally doesn't post changes to disk. Have anyone had this situation? Is it posible that it is related to a Windows version? Sincerely dont know how to work arround this. Any help will be appreciated. Regards Hernando.
ODP: [firebird-support] Question about delay in fetch operation
Hi. Look at gstat output You probably have very long version this particular record Regards, Karol Bieniaszewski
ODP: [firebird-support] Firebird database executing DML queries very slowly.
Hi. When you gain slowdows Run gstat -h and put here results. Problem probably is because of some long running transaction. Regards, Karol Bieniaszewski