On 16-11-2012 15:38, Alex Peshkoff wrote: >> Am I correct to assume that isc_spb_rpr_list_limbo_trans will only >> return the info items: >> - isc_spb_tra_id (?), >> - isc_spb_single_tra_id and >> - isc_spb_multi_tra_id >> >> And will not include the isc_info_svc_limbo_trans items: >> - isc_spb_tra_state, >> - isc_spb_tra_host_site, >> - isc_spb_tra_remote_site and >> - isc_spb_tra_db_path > > Sorry, you are wrong.
Are those items (and isc_spb_tra_advise which I forgot above) only available for isc_spb_multi_tra_id? >> What is a simple way to get Firebird to include a isc_spb_tra_id and a >> isc_spb_multi_tra_id item in the infoblock (to test this)? > > That depends upon what we call simple :) > I do not know a way without API programming. You should start multiple > transaction, precommit it and abort your program. After it you will > have limbo transaction. The Jaybird tests are capable of creating limbo transactions (see createLimboTransaction(int count) in http://firebird.svn.sourceforge.net/viewvc/firebird/client-java/trunk/src/test/org/firebirdsql/management/TestFBMaintenanceManager.java?revision=57355&view=markup ). Those however are only isc_spb_single_tra_id. The problem was that FBMaintenanceManager.listLimboTransactions() only looked for isc_spb_single_tra_id and made a mess when it received other info-items. So I would prefer a test where I have all possible info-items in the output of isc_spb_rpr_list_limbo_trans. On a related note: Is there also a way to artificially raise the transaction id on a newly created database or to even enforce a specific transaction id without resorting to iteratively creating a large number of transactions? The original code had some oddities in how it decoded integers (which actually contributed to the problem). Mark -- Mark Rotteveel ------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
