Kbase P100461: SQL-89 ODBC clients causing bi file to grow
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/18/2008 |
|
Status: Verified
SYMPTOM(s):
SQL-89 ODBC clients causing bi file to grow
Database performs abnormal shutdown because bi file reached 2 GB limit.
Some SQL-89 clients are only performing queries and not actually updating the database.
Some SQL-89 clients are performing updates against the database.
FACT(s) (Environment):
Progress 8.x
All Supported Operating Systems
CAUSE:
Bug# 20000616-005
CAUSE:
Our SQL-89 implementation in version 8 started a transaction in the bi file upon connection. Because some users were not actually making changes to the database, this initial begin transaction note in the bi file would never have an associated end transaction note ever processed for this user. This resulted in the database engine being unable to re-use space in the bi file due to an open transaction.
FIX:
Upgrade to Progress version 9 or later. This problem was fixed in version 9 by by not actually writing a transaction begin note to the bi file until the user made their first change, thus if the user only reads then as far as the bi file is concerned its as though a transaction never started. This feature was called delayed transaction begin.