novaBBS - comp.databases.ingres - Loading stats generates warning W

Loading stats generates warning W_OP0973

<53fe72b3-57f7-4597-b852-694bd5737b65n@googlegroups.com>

https://www.novabbs.com/devel/article-flat.php?id=104&group=comp.databases.ingres#104

copy link Newsgroups: comp.databases.ingres

X-Received: by 2002:a37:d86:: with SMTP id 128mr3020247qkn.299.1627528552395;
Wed, 28 Jul 2021 20:15:52 -0700 (PDT)
X-Received: by 2002:a05:6830:544:: with SMTP id l4mr2064712otb.164.1627528552087;
Wed, 28 Jul 2021 20:15:52 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Wed, 28 Jul 2021 20:15:51 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=1.129.110.132; posting-account=uL8iyAoAAABmcpUSs5hxN0c_ls8MZOL5
NNTP-Posting-Host: 1.129.110.132
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <53fe72b3-57f7-4597-b852-694bd5737b65n@googlegroups.com>
Subject: Loading stats generates warning W_OP0973
From: s.anders...@gmail.com (Steve)
Injection-Date: Thu, 29 Jul 2021 03:15:52 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 25

by: Steve - Thu, 29 Jul 2021 03:15 UTC

Hi folks

Recently I generated tables stats in our DR environment, writing them to a file rather than the System Catalogs - that sounds awfully like the Ingres documentation :) - using the -o optimizedb flag. Later when loading the stats into our production environment, I received several W_OP0973 warnings.

Searching the Actian website, it seems the issue re warning W_OP0973 was fixed in 9.2 - below is the note from "Patch 14296 for Ingres 9.2 Service Pack 1 (9.2.1) on Sun Solaris UltraSPARC":

"Bug 122605 (GENERIC)

optimizedb generates incorrect exact histogram cell counts for date columns.. Loading these stats via optimizedb will generate W_OP0973 warnings."

(NB: Am running Ingres 11.0 on Solaris SPARC)

Should I interpret these warnings to suggest the bug may not be fixed? Should I be raising this with Actian?

Further, all but one of the columns with this warning are ingresdate columns. The exception is column defined as a float4.

Thanks
Steve

Re: [Info-ingres] Loading stats generates warning W_OP0973

<mailman.70.1627542179.1681.info-ingres@lists.planetingres.org>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=105&group=comp.databases.ingres#105

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Thu, 29 Jul 2021 02:04:03 -0500
Return-Path: <martin.bowes@ndph.ox.ac.uk>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
From: martin.b...@ndph.ox.ac.uk (Martin Bowes)
To: Steve <s.anderson.au@gmail.com>, "info-ingres@lists.planetingres.org"
<info-ingres@lists.planetingres.org>
Date: Thu, 29 Jul 2021 07:02:56 +0000
References: <53fe72b3-57f7-4597-b852-694bd5737b65n@googlegroups.com>
In-Reply-To: <53fe72b3-57f7-4597-b852-694bd5737b65n@googlegroups.com>
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-WatchGuard-AntiVirus: part scanned. clean action=allow
Subject: Re: [Info-ingres] Loading stats generates warning W_OP0973
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.70.1627542179.1681.info-ingres@lists.planetingres.org>
Lines: 59
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-5h6bkj7brsguvmJB0r//0KOteF9dcPuhHBk624D1UHGm/pVEzMgrvZmAgrT0lrs0f1JoaswY2QHYbJH!1JXjsq4txmXpTBxlK+s00nqPzfF5td7VZQpnqmqTe5Q9uUzUv6Nhb4dAnExrMdhJA935pptxx4zo!ZKo8vPoHZZQo2YXBv0nKZg==
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 4176

by: Martin Bowes - Thu, 29 Jul 2021 07:02 UTC

Hi Stevo,

The short answer is yes. You're paying for service, you may as well use it.

But out of curiosity...

What z flags did you use in the optimisation call?

For example (using 11.1.0 +p15599 a64.lnx) on a table with 15000+ rows and an ingresdate field I did:
optimizedb -zk -zr1000 -zu1000 -zns -o stats.txt -uace ace_trove_live -rfield -atcounted

And then:
optimizedb -i stats.txt -uace ace_trove_live -rfield -atcounted

No errors, warnings, or informationals were generated.

You may like to experiment with the -zn# option as well. Try a -zn9 and see if that helps.

Martin Bowes

-----Original Message-----
From: Steve <s.anderson.au@gmail.com>
Sent: 29 July 2021 04:16
To: info-ingres@lists.planetingres.org
Subject: [Info-ingres] Loading stats generates warning W_OP0973