Re: HEAD crashes on windows when doing VACUUM ANALYZE

2012/8/30 Albe Laurenz <laurenz.albe@wien.gv.at>:
> Matthias wrote:
>> when running VACUUM ANALYZE on my database built on win32-x86 from
>> yesterday's git checkout I always get this at some point during VACUUM
>> ANALYZE:
>>
>> LOG:  server process (PID 5880) was terminated by exception 0xC0000094
>> DETAIL:  Failed process was running: VACUUM VERBOSE ANALYZE
>> HINT:  See C include file "ntstatus.h" for a description of the
>> hexadecimal value.
>> LOG:  terminating any other active server processes
>>
>> I am not sure if it's useful to report it here, but I thought I'd do
>> it anyway :)
>
> That seems to be STATUS_INTEGER_DIVIDE_BY_ZERO.
>
> Does it only happen with a certain table?
> Are you sure there is no data corruption?
> A stack trace would help:
> http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_Postg
> reSQL_backend_on_Windows

Attached the debugger.

It crashes in rangetypes_typeanalyze.c at line 186:
   delta = (non_empty_cnt - 1) / (num_hist - 1);

According to the debugger num_hist = 1, so it divides by zero. I guess
this is due to the new statistics collection for range types?

-Matthias