Kbase P101344: AI files growing rapidly but no changes are being made to the database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/10/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.0x
SYMPTOM(s):
AI file is growing rapidly
BI file is also being written when no changes are being made to the database
No changes are being made to this database.
Connected to multiple databases.
Code assigns data from a table from one database into a table in another database.
No physical record, index or schema changes are being made to the original database.
All changes are being made to the target database.
Database that transaction is being copied from is read no-lock.
Thousands of RL_TBGN and RL_TBEND notes being written to the ai file where database changes are not occurring.
rfutil dbname -C aimage scan verbose -a dbname.a1 file showing thousands of transactions where no changes are being made to the database.
Update counter from aimage scan verbose output is not changing.
Sample output from aimage scan verbose that show no changes:
Trid: 498 Tue Mar 1 10:52:06 2005. (2598)
User Id: user1. (2599)
code = RL_TEND (1637)
transaction index = 498 (1638)
dbkey = 0 update counter = 0 (1639)
Trid: 498 Tue Mar 1 10:52:06 2005. (2598)
code = RL_TBGN (1637)
transaction index = 499 (1638)
CAUSE:
Bug# OE00114009
CAUSE:
Transaction end source code was not taking into consideration when a distributed transaction was occurring between a source and target database and no changes were occurring on the source database.
FIX:
Upgrade to OpenEdge 10.1A.