Re: [Firebird-devel] Sweep Start/Finish via Trace API?
> I've checked the various servivce filters available, but haven't found > anything in respect to tracing a sweep operation. > > Is it technically possible to add some kind of sweep start/finish events > in the Trace API for both, manual and automatical (sweep interval) > triggered? Sure. Feel free to fill new ticket at tracker :) Regards, Vlad -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Support conditional trigger firing (WHEN clause ala Oracle)
07.11.2011 11:23, Thomas Steinmaurer wrote: > With all the discussion, is it worth to create a JIRA issue for this > feature request? I don't mind :-) Dmitry -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Sweep Start/Finish via Trace API?
Hello, I've checked the various servivce filters available, but haven't found anything in respect to tracing a sweep operation. Is it technically possible to add some kind of sweep start/finish events in the Trace API for both, manual and automatical (sweep interval) triggered? Thanks, Thomas -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Support conditional trigger firing (WHEN clause ala Oracle)
> is there any plan for supporting conditional trigger firing as in Oracle > when specifying an optional WHEN clause in the trigger DDL syntax? > > Currently in Firebird, to omit trigger code execution, one can wrap the > entire trigger body into an IF block, but the trigger still fires, but > no PSQL code is executed. > > So the question is: Is it worth to think about conditional trigger > firing or is trigger firing in Firebird that cheap, so we don't have to > bother? With all the discussion, is it worth to create a JIRA issue for this feature request? Thanks, Thomas -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Lock error in CCH
Den 2011-11-06 07:59 skrev Dmitry Yemanov såhär: > 06.11.2011 3:01, Vlad Khorsun wrote: > >>> Running CORE-3650 test-case in different isql embedded sessions with >>> SharedCache and SharedDatabase, I had (one time) a hang and a crash. The >>> crash happened after the first command. I ran it in session1, session2, >>> session1, etc (or some variant). >> >> This is more or less expected. When shared page cache was introduced i said >> that lock manager is not ready to work in this mode. > > And it's worth mentioning that this issue is being worked on these days. > The lock manager is more or less easy to fix, but other related issues > have appeared after that so the complete solution is unlikely to appear > very soon. As a FB user this scares me a bit, because it sounds rather serious. I would be very grateful if you would describe exactly what configurations are affected, e.g. does it affect embedded access only, and only with two or more processes connected to the same database? Thanks, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Lock error in CCH
06.11.2011 12:56, Kjell Rilbe wrote: > As a FB user this scares me a bit, because it sounds rather serious. It affects only v3.0, so you shouldn't be scared. And it will be fixed before the Alpha release. Dmitry -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3653) rollback of drop FK-constraint in session #1 can lead to violation of FK due to session #2
rollback of drop FK-constraint in session #1 can lead to violation of FK due to session #2 -- Key: CORE-3653 URL: http://tracker.firebirdsql.org/browse/CORE-3653 Project: Firebird Core Issue Type: Bug Reporter: Pavel Zotov SESSION #1 - isql -n test0.fdb SQL> recreate table tdetl(id int primary key, pid int); SQL> recreate table tmain(id int primary key); SQL> commit; SQL> insert into tmain values( 1); SQL> commit; SQL> insert into tdetl values( 1, null); SQL> alter table tdetl add constraint tdetl_fk foreign key (pid) references tmain(id); SQL> commit; SESSION #2 - isql -n test0.fdb SQL> alter table tdetl drop constraint tdetl_fk; SQL> SESSION #1 - SQL> update tdetl set pid=-111 where id=1; SQL> commit; -- PASSED! though there is no confirmation of dropping FK in SESSION #2... SESSION #2 - SQL> rollback; SQL> exit; SESSION #1 - SQL> exit; Hereafter in single session: isql -n test0.fdb SQL> set list on; SQL> select * from rdb$relation_constraints rc where rc.rdb$constraint_name = 'TDETL_FK'; RDB$CONSTRAINT_NAME TDETL_FK RDB$CONSTRAINT_TYPE FOREIGN KEY RDB$RELATION_NAME TDETL RDB$DEFERRABLE NO RDB$INITIALLY_DEFERRED NO RDB$INDEX_NAME TDETL_FK -- yes, old FK is alive SQL> insert into tdetl values(2,-222); Statement failed, SQLSTATE = 23000 violation of FOREIGN KEY constraint "TDETL_FK" on table "TDETL" -Foreign key reference target does not exist SQL> set list off; SQL> select d.*,m.id master_id from tdetl d left join tmain m on d.pid=m.id; ID PIDMASTER_ID 1 -111 As result we have data in child table that are not present in parent. This effect also appears for TIL = read committed; // i.e. wait = ON, by default The only TIL when database is protected from this is read committed no wait. Checked on: 1) 2.0.6.13266 2) 2.1.4.18393 3) 2.5.2.26387 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Lock error in CCH
06.11.2011 3:01, Vlad Khorsun wrote: >> Running CORE-3650 test-case in different isql embedded sessions with >> SharedCache and SharedDatabase, I had (one time) a hang and a crash. The >> crash happened after the first command. I ran it in session1, session2, >> session1, etc (or some variant). > > This is more or less expected. When shared page cache was introduced i said > that lock manager is not ready to work in this mode. And it's worth mentioning that this issue is being worked on these days. The lock manager is more or less easy to fix, but other related issues have appeared after that so the complete solution is unlikely to appear very soon. Dmitry -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel