Subject | Problem with FIREBIRD on WIN32 |
---|---|
Author | Krzysztof Dyczkowski |
Post date | 2002-10-07T13:58:33Z |
Hi everyone,
A few weeks ago we posted a problem description concerning index page
corruptions on the win32 version of FB.
Thank you all who tried to help us and got our sample code and database,
nonetheless we've got no answer so far and the problem is still not solved
and
can affect other FB users as well.
So, we are describing it once more hoping someone would eventually find a
solution.
The problem occurs in the following scenario:
1. open the transaction
2. update some records of table T
3. commit the transaction
4. execute a stored procedure deleting/inserting records of T (among which
are
those previously updated).
* run 1-4 in a loop, say 20 times
After that gfix shows corrupted index pages (of many different indices on
T).
This behaviour seems to occur only on win32 version of FB (tested on Win98
and
XP with the same result) while the linux version _seems_ to works fine. The
client is written in Delphi 4 using IBObjects 4.2Hj and we're using the
current
stable version of FB.
We can send sample code and a small database which we use for testing and
which
produces the errors.
thank you in advance
Krzysztof Dyczkowski
A few weeks ago we posted a problem description concerning index page
corruptions on the win32 version of FB.
Thank you all who tried to help us and got our sample code and database,
nonetheless we've got no answer so far and the problem is still not solved
and
can affect other FB users as well.
So, we are describing it once more hoping someone would eventually find a
solution.
The problem occurs in the following scenario:
1. open the transaction
2. update some records of table T
3. commit the transaction
4. execute a stored procedure deleting/inserting records of T (among which
are
those previously updated).
* run 1-4 in a loop, say 20 times
After that gfix shows corrupted index pages (of many different indices on
T).
This behaviour seems to occur only on win32 version of FB (tested on Win98
and
XP with the same result) while the linux version _seems_ to works fine. The
client is written in Delphi 4 using IBObjects 4.2Hj and we're using the
current
stable version of FB.
We can send sample code and a small database which we use for testing and
which
produces the errors.
thank you in advance
Krzysztof Dyczkowski