On 11/16/12 18:56, Mark Rotteveel wrote: > 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?
Not absolutely sure. But for parsing them it makes no difference. >>> 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. yes, certainly > 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). taking into an account that TIPs should be created - far not sure ------------------------------------------------------------------------------ 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
