Skip to Content
0
Former Member
Feb 01, 2008 at 08:59 AM

Error "[-109]: Lob file dropped" sometimes ...

42 Views

I get the error

[-109]: Lob file dropped

when I try to insert a record containing a BLOB. Strange as it seems, the error seems to occur depending on some parameters which I can not identify, the inserting of certain records in my app does always yield this error, inserting of some other records (into the same table) using the same piece of code would always succeed. But I can not identify what makes the difference.

I found the thread lob-file-dropped where there was the suggestion to look at the diagnosis files, so I did this, but saw no oddity at all - this is the knldiag.err file just after the -109 error occurred:

-


Date Time TID(hex) Typ MsgID Label Message-Text

-


2008-01-10 13:13:57 --- Starting GMT 2008-01-10 12:13:57 7.6.00 Build 037-121-149-748

2008-01-11 14:01:47 ___ Stopping GMT 2008-01-11 13:01:47 7.6.00 Build 037-121-149-748

2008-01-11 14:01:48 --- Starting GMT 2008-01-11 13:01:48 7.6.00 Build 037-121-149-748

2008-01-15 10:41:04 ___ Stopping GMT 2008-01-15 09:41:04 7.6.00 Build 037-121-149-748

2008-01-15 10:41:05 --- Starting GMT 2008-01-15 09:41:05 7.6.00 Build 037-121-149-748

My DB is a 7.6.00.37 engine.

How can I tackle this problem?

TIA,

Alex