Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 10 of 19 total |
Two records sharing the same blob data |
Thu, May 18 2006 3:00 PM | Permanent Link |
I have a problem that takes several steps to recreate.
(DBISAM 4.22 Build 6 in C/S mode, Delphi 5) Taking a certain action in my app somehow creates a duplicate of the current record. It would appear that this record is a duplicate in every way, right down to the auto-incrementing ID field, and presumably to the contents of blob offsets in the blob fields. I then use DBSys to delete one of the duplicate records, and this corrupts the table. On accessing the original record, I get and error # 8963 BLOB block buffers corrupt in the table 'Assignment'. If I then repair the table, the contents of all the blob fields in the record are gone. Presumably, deleting the second record wiped out the blobs that the first record was referring to. As for the "certain action" in my app that starts this sorry chain of events... The VCL for the DBNavigator, when handling a click on the Post button, appear to make a nested call to an OnExit handler of mine which also contains a Post call. --Bill Sparrow-- | |
Thu, May 18 2006 4:48 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bill,
<< (DBISAM 4.22 Build 6 in C/S mode, Delphi 5) Taking a certain action in my app somehow creates a duplicate of the current record. It would appear that this record is a duplicate in every way, right down to the auto-incrementing ID field, and presumably to the contents of blob offsets in the blob fields. I then use DBSys to delete one of the duplicate records, and this corrupts the table. On accessing the original record, I get and error # 8963 BLOB block buffers corrupt in the table 'Assignment'. If I then repair the table, the contents of all the blob fields in the record are gone. Presumably, deleting the second record wiped out the blobs that the first record was referring to. >> It's probably this bug: http://www.elevatesoft.com/scripts/incident.dll?action=viewrep&release=4.22&type=f&incident=2173 -- Tim Young Elevate Software www.elevatesoft.com |
Fri, May 19 2006 5:45 AM | Permanent Link |
No, it's not that one.
- I'm not editing the blob fields when this happens - It happens every time - My app really does create two Siamese twin records - Deleting either record corrupts the other's blob fields --Bill Sparrow-- | |
Fri, May 19 2006 5:56 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bill,
<< No, it's not that one. - I'm not editing the blob fields when this happens - It happens every time - My app really does create two Siamese twin records - Deleting either record corrupts the other's blob fields >> In that case, please send me an example and I'll take a look. Thanks, -- Tim Young Elevate Software www.elevatesoft.com |
Mon, May 22 2006 9:19 AM | Permanent Link |
I'll put one together when I get a few minutes.
Cheers, --Bill Sparrow-- | |
Mon, May 22 2006 11:40 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bill,
<< I'll put one together when I get a few minutes. >> Thanks very much. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, May 23 2006 6:53 PM | Permanent Link |
Tim,
I have sent you an example by email. Will it bounce? I believe I have not emailed you with an attachment before, so I won't be on your white list. Cheers, --Bill Sparrow-- | |
Wed, May 24 2006 7:38 AM | Permanent Link |
It bounced.
--Bill Sparrow-- > A message that you sent could not be delivered to one or more of its > recipients. This is a permanent error. The following address(es) failed: > > timyoung@elevatesoft.com > SMTP error from remote mail server after end of data: > host mail.elevatesoft.com [64.65.248.118]: 554 Transaction failed - >invalid message headers | |
Wed, May 24 2006 5:42 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bill,
<< I have sent you an example by email. Will it bounce? I believe I have not emailed you with an attachment before, so I won't be on your white list. >> It's not the white list, it's that the email headers don't match the sending information - your sending from cix.uk according to your email header, but the sending mail server identifies itself as: |
Wed, May 24 2006 5:44 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bill,
Sorry, posted that too soon. It identifies itself as: lon-gs2dmrelay.mistral.net and the domains don't match. We only accept emails directly from a sending mail server with the same root domain as the sender in the email header. At any rate, if you could please post it to the Binaries newsgroup, that will work fine also. Thanks, -- Tim Young Elevate Software www.elevatesoft.com |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |