Hi,

At November 22, 2004, 15:09, Bogusław Brandys wrote:

> Alexey Kovjazin wrote:
>> Hello, Ales!
>>
>>
>>>I've written some short python code using the kinterbasdb module
>>>to fill a database table with 600 million records in order to see
>>>how Firebird behaves with such a huge amount of data. After about
>>>430 million inserts (a hard commit after every 10000 records) I
>>>got the following error:
>>
>>
>>>gbak: 422260000 records written
>>>gbak: ERROR: internal gds software consistency check (pointer page vanished
>>
>>>from DPM_next (249))
>>
>>
>> This is the limit of InterBase/Firebird table size.
>> In short, database cannot contain table with physical size >36,6 gb.
>>
>> Details are here:
>>
>> http://www.ibsurgeon.com/interbase/firebird/bug/research.html


> OK.I assume that threr is are plans to fix this limit in 1.5.2 , right ?

Not in 1.5.2, but fixed for 2.0. IIRC, the fix has already been
applied to the FB 2.0 code, and required an ODS change. And, because
of the ODS change, it wasn't possible to backport it to FB 1.5.2.

> Would be interesting to know if Interbase 7.1 has this limit too.

It's seems highly possible that it still exists. I haven't found an
entry in Quality Central and it's not mentioned in the notes for IB
7.1.


--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)