On 11/16/12 17:58, Mark Rotteveel wrote: > On 11-10-2012 09:39, Alex Peshkoff wrote: >> On 10/10/12 22:53, Mark Rotteveel wrote: >>> Does anyone have a good description of the output of the servicemanager >>> repair option isc_spb_rpr_list_limbo_trans. >>> >>> Or if no such description exists, could someone point me to the code >>> that generates that output? >>> >>> I need this to fix http://tracker.firebirdsql.org/browse/JDBC-266 >> Mark, it returns isc_info_svc_limbo_trans information item. A good way >> to parse it is in utilities/fbsvcmgr/fbsvcmgr.cpp, near line 691 (line >> number in trunk). > 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. > 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. ------------------------------------------------------------------------------ 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