Re: ERROR: invalid restriction selectivity: 224359728.000000 - Mailing list pgsql-general

From xeb@mail.ru
Subject Re: ERROR: invalid restriction selectivity: 224359728.000000
Date
Msg-id 200711231038.44980.xeb@mail.ru
Whole thread Raw
In response to Re: ERROR: invalid restriction selectivity: 224359728.000000  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> > error message in log:
> > ERROR:  invalid restriction selectivity: 0.000049
>
> [ blink... ]  Surely it didn't really say that, because a moment's
> glance at the code shows that it's impossible:
>
>     if (result < 0.0 || result > 1.0)
>         elog(ERROR, "invalid restriction selectivity: %f", result);
>
> If it really did say that, then you have either seriously flaky hardware
> or a broken compiler.  In either case, us mere database weenies can't
> help much.
>
>             regards, tom lane

Really, it seems that is hardware trouble, beacause it works on virtual
machine (KVM), which is buggy enough :(
Thanks.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: autovacuum process blocks without reporting a deadlock
Next
From: "Thomas Chille"
Date:
Subject: Re: autovacuum process blocks without reporting a deadlock