Divide by Zero error when deleting rows. Bug#50002288

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob Hallquist - 27 May 2008 12:34 GMT

Does anyone know when/if a SP is going to be released for this issue? I
can't release a hotfix to a customer.

Thanks,

Signature

Rob

Reply to this Message

Ginny Caughey MVP - 27 May 2008 13:20 GMT

Rob,

I'm not familiar with this issue. Can you provide an example? Do you see the
same issue with SQL Compact 3.5 sp1 beta?

Thanks,

Ginny Caughey
Device Application Development MVP

> Does anyone know when/if a SP is going to be released for this issue? I
> can't release a hotfix to a customer.
>
> Thanks,

Reply to this Message

Rob Hallquist - 27 May 2008 13:45 GMT

The issue is when you delete records too quickly, the database can get into a
state where it will not allow you to delete or update records. The only
error you get is a divide by zero error which seems quite odd. If you want
more information about the issue, look here:
http://support.microsoft.com/kb/947002

Because my scenario is quite complex with many threads, it would be hard to
post an example, but as an overview, I'm using a SQL CE database for the
storage of a queue. We used to use a file based queue, but that was fragile
and not transactional. I like the transactional support of SQL CE and it is
quite responsive except for this issue. I'm bypassing this issue by having a
thread that will periodically delete the records instead of deleting them so
rapidly.

I can't install beta software on my machine as it might affect other
projects. There should be information somewhere if this beta version fixes
this issue and I have not found any.

Thanks,

Signature

Rob

> Rob,
>
[quoted text clipped - 10 lines]
> >
> > Thanks,

Reply to this Message

Ginny Caughey MVP - 27 May 2008 14:53 GMT

Rob,

Thanks for the detailed explanation and also for the link. I do understand
why you don't want to install beta software. I'll see if I can find out the
answer to your question, or if you can come up with a small sample that does
reproduce the behavior, I'll be glad to try it on my machine and let you
know.

Ginny

> The issue is when you delete records too quickly, the database can get
> into a
[quoted text clipped - 40 lines]
>> >
>> > Thanks,

Reply to this Message

Ginny Caughey MVP - 27 May 2008 15:48 GMT

Rob,

This fix is included in sp1 but of course that is still beta currently. Also
once you get the hotfix for the RTM 3.5 product from Microsoft CSS which is
available now, you are allowed to redistribute that to your customers as
part of your app if you wish to do so. (They don't each have to request it
individually.) So you do have an option now for a supported fix for 3.5 RTM.

Let me know if you have more questions about this. By the way, the engineer
who provided me with the answer also explained that it is indeed difficult
to reproduce, so don't worry about trying to provide me with a sample.

Ginny

> The issue is when you delete records too quickly, the database can get
> into a
[quoted text clipped - 40 lines]
>> >
>> > Thanks,

Reply to this Message

Rob Hallquist - 27 May 2008 18:15 GMT

Thank you for your timely information. My application will not be delivered
for a few months. Unfortunately delivering a hotfix that may not have been
thoroughly tested (this is stated in the kb article) does not sound like a
viable option either. Is there an ETA for the service pack? I know it is in
beta, but is there a timeframe for when it will be generally available?

Thanks,

Signature

Rob

> Rob,
>
[quoted text clipped - 54 lines]
> >> >
> >> > Thanks,

Reply to this Message

Ginny Caughey MVP - 27 May 2008 19:00 GMT

Rob,

I have not seen any date announced yet for SQL Compact 3.5 sp1 release other
than this statement which says "this summer":
http://blogs.msdn.com/stevelasker/archive/2008/01/15/msdn-webcast-introducing-sq
l-server-compact-3-5.aspx.
It sounds like that might work with your schedule though if everything stays
on track.

As I understand it, it SQL Compact 3.5 sp1 will ship with either Visual
Studio 2008 sp1 or SQL Server 2008, whichever comes first, so you might
check http://msdn.microsoft.com/en-us/vstudio/products/default.aspx and here
http://www.microsoft.com/sql/default.mspx for announcements.

Ginny

> Thank you for your timely information. My application will not be
> delivered
[quoted text clipped - 78 lines]
>> >> >
>> >> > Thanks,

Reply to this Message

Rob Hallquist - 29 May 2008 22:23 GMT

Thanks for the great information!

Signature

Rob

> Rob,
>
[quoted text clipped - 93 lines]
> >> >> >
> >> >> > Thanks,

Reply to this Message