Subject Re: [firebird-support] Problems with pages
Author Alexey Kovjazin
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

Sincerely yours,
Alexey Kovyazin

www.ibsurgeon.com
www.ibanalyst.com
www.ibfirstaid.com
www.ibsurgeonviewer.com
news://news.metadataforge.com/ibsurgeon.eng