Subject Re: [firebird-support] Re: BLOB not found error when no blob in the update query ?
Author Helen Borrie
At 08:39 PM 5/12/2009, you wrote:
>i never (but never) touch the system table ... if the mess is in the system table

It probably isn't. I only asked that, because it was an ad hoc error concerning a lost blob - probably a lost page.

>1/ so the bug look like in Firebird 2.1.3 because it's appear after i install the Firebird 2.1.3

If it were a Firebird 2.1.3 bug, other people would have experienced it. Insert statements are not unusual. ;-)

>2/ how to correct it ? backup restore ?

You could try that. Of course, do *not* restore over the top of the existing database.

When you do the backup, use the -v -y <filename> flags so you get a log you can review, in case the backup bumps into a related problem. Then, you will possibly have some clues about where this error is occurring.