Question Re: Crash with divide-by-zero exception in Technology Q&A

Crash with divide-by-zero exception

MCMartin — Fri, 16 Sep 2011 08:40:09 GMT

We have had a divide-by-zero exception in 11.0.1.2606 leading to crash of dbsrv11. Does anyone know if such a problem is already addressed in the current EBF?

Re: Crash with divide-by-zero exception

MarkCulp — Fri, 16 Sep 2011 08:50:34 GMT

There has been at least one issue fixed since 11.0.1.2606 that would result in a divide-by-zero crash - example:

QTS ISSUE 674917 - fixed in 11.0.1.2631 and 12.0.1.3388 and 12.0.0.2706

Under rare conditions, the server could crash when processing parallel queries. This has been fixed.

The crash can be worked around by disabling intra-query parallelism (setting option MAX_QUERY_TASKS=1).

It is hard to tell whether this fix or any of the others will resolve the divide by zero crash that you have seen.

Re: Crash with divide-by-zero exception

MCMartin — Fri, 16 Sep 2011 08:55:33 GMT

So anyway an update of this server sounds like a good idea, thanks Mark

Re: Crash with divide-by-zero exception

MCMartin — Fri, 16 Sep 2011 09:18:48 GMT

I have uploaded the crash dump