Subject | Blob Fields any gotchas |
---|---|
Author | gkrishna@jlmatrix.com |
Post date | 2003-03-20T13:28:04Z |
Running FB 1.0 build 794 on windows 2000 SP3.
Occasionally (maybe once in 10 days) during operation the database will get corrupted.
This is always on a BLOB field.
If i run gfix with mend and then run gbak to backup and restore.
it says gds$segment failed trying to read more sectors than required on blob field
I am using IBO to do access the database. There is a blob field in a table and there are lot of records there. Some of the quite large.
I am sure there must be something wrong in what i am doing. But got no clue on how to address it.
Any tips or gotchas with blob fields that I should be aware of.
Any wild guess?
gk
Occasionally (maybe once in 10 days) during operation the database will get corrupted.
This is always on a BLOB field.
If i run gfix with mend and then run gbak to backup and restore.
it says gds$segment failed trying to read more sectors than required on blob field
I am using IBO to do access the database. There is a blob field in a table and there are lot of records there. Some of the quite large.
I am sure there must be something wrong in what i am doing. But got no clue on how to address it.
Any tips or gotchas with blob fields that I should be aware of.
Any wild guess?
gk