--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 11:25 PM 29/08/2005 +0000, you wrote:
> >Hi,
> >
> >A few months i have a database of 142,415,004 kb with these definition
> >
> >CREATE TABLE STATEMENTS (
> > CUENTA APLHA_10 COLLATE WIN1251,
> > FECHA_PROCESO FECHA,
> > FRF_STATEMENT ST_BLOB);
> >
> >
> >
> >/* Indices definition */
> >
> >CREATE INDEX STATEMENTS_IDX1 ON STATEMENTS (CUENTA);
> >CREATE INDEX STATEMENTS_IDX2 ON STATEMENTS (CUENTA, FECHA_PROCESO);
> >
> >in these database i start to get the following error when try to
> >insert new big blobs
> >
> >Internal GDS software consistency check (cannot find free space(255)
> >
> >after few questions here i decide to create a sencond database wich
> >now have 19,358,864 but i start to get the same error.
> >
> >The first time i ask for help here some one tell me that is posible i
> >found some limitation in Firebird and wait for firebird 2. Right now i
> >can't wait any more, i hope some one can help, if not i need to change
> >to other database and start a painfull migration process.
> >
> >any one can explain to me what exactly this error means?
>
> It means that you do not have enough space left in your disk storage

system.

>
> >How i am sure this problems will not present in FB2.0?
>
> Even FB2 cannot make more space on your hard drives!
>
> ./heLen

Hi Helen,

I have 117 GB in free space in the array. The documents are bigs but
not that much. I only use 20 GB every 5 months.

These is the reason i am fustrated.

The last time i ask here for these problem Ann H. respond the following :

"

> Internal gds Software Consistency Check (Cannot Find Free Space (255)).
>
> what these error mean?
>

Yup. You've run into a problem with the size of tables. We've got a
fix in V2, which is teetering on the edge of an alpha test. For now,
the best alternative that I know of is to split your table in two.

Regards,


Ann
"

These is the reason i create other database to access new documents,
but i continue with the problem. My clients is very angry with me,
becuase these big documents are very important for them to have acces
in other branches.

any help is welcome, even paying support, i need to resolve these
problem fast.

regards,
Dennis Ortiz Vives
d2ortiz at prtc dot net
dortiz at accuprintpr dot com