Subject | Limbo transactions numbers |
---|---|
Author | Fabiano |
Post date | 2012-08-02T18:22:39Z |
Hi,
The code below:
FBMaintenanceManager mm = new FBMaintenanceManager("PURE_JAVA");
mm.setHost("xxxx");
mm.setPort(3050);
mm.setDatabase("xxxx");
mm.setUser("sysdba");
mm.setPassword("xxxx");
mm.setLogger(System.out);
mm.listLimboTransactions();
produces this output:
1089469460
While the command below, executed in the same database:
gfix -list xxxx:xxxx -user sysdba -pass xxxx
produces this output:
Transaction 4255740 is in limbo.
Multidatabase transaction:
Host Site: REPLIC-ES
Transaction 4255740
has been prepared.
Remote Site: <removed>
Database Path: <removed>
Host Site: REPLIC-ES
Transaction 4966552
has been rolled back.
Remote Site: <removed>
Database Path: <removed>
Automated recovery would rollback this transaction.
Why is the transaction number different in jaybird and gfix?
Regards,
Fabiano
The code below:
FBMaintenanceManager mm = new FBMaintenanceManager("PURE_JAVA");
mm.setHost("xxxx");
mm.setPort(3050);
mm.setDatabase("xxxx");
mm.setUser("sysdba");
mm.setPassword("xxxx");
mm.setLogger(System.out);
mm.listLimboTransactions();
produces this output:
1089469460
While the command below, executed in the same database:
gfix -list xxxx:xxxx -user sysdba -pass xxxx
produces this output:
Transaction 4255740 is in limbo.
Multidatabase transaction:
Host Site: REPLIC-ES
Transaction 4255740
has been prepared.
Remote Site: <removed>
Database Path: <removed>
Host Site: REPLIC-ES
Transaction 4966552
has been rolled back.
Remote Site: <removed>
Database Path: <removed>
Automated recovery would rollback this transaction.
Why is the transaction number different in jaybird and gfix?
Regards,
Fabiano