January 9th, 2004, 07:15 AM
FB 1.5 RC8 embedded server crash
When using the embedded version of FB 1.5 it keeps crashing hard when working with BLOBs extensively (page fault exceptions). This is true both for RC7 and RC8 versions. The problem occurs if query on a table with BLOBs uses subselect and there are many rows in the result set. After abt 500 rows the fetch slows down considerably, then after approx 2000 rows RC7 completely freezes, RC8 returns error code (consistency check - bad state). In this situation, it is even impossible to detach from the database (immediate page fault) and reconnect to it, making the client application unusable. The only workaround I've found was to divide the query into many smaller queries (using FIRST and SKIP) and converting to VARCHARs where possible.
Anybody encountered this?