| Subject | Unsuccessful update attempts after big number of DDL operations. |
|---|---|
| Author | dandreikin |
| Post date | 2008-02-28T03:23:58Z |
Description: We have an application that significantly changes the
structure of existing database using DDL commands. Each iteration
makes some changes
to the structure of existing tables and then puts some data to
another table. After many iterations that could execute up to 10.000
DDL
commands, insert queries begin to fail constantly with such error:
"
invalid request BLR at offset 7
table id 2195 is not defined
"
We use ODBC Driver version 1.2 (also problem can be reproduced with
2.0b ODBC FB driver.) and FB Server 2.0.3. ODBC works in autocommit
mode.
structure of existing database using DDL commands. Each iteration
makes some changes
to the structure of existing tables and then puts some data to
another table. After many iterations that could execute up to 10.000
DDL
commands, insert queries begin to fail constantly with such error:
"
invalid request BLR at offset 7
table id 2195 is not defined
"
We use ODBC Driver version 1.2 (also problem can be reproduced with
2.0b ODBC FB driver.) and FB Server 2.0.3. ODBC works in autocommit
mode.