From dev-return-60852-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Wed Apr 22 18:47:02 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 7C7A1180181 for ; Wed, 22 Apr 2020 20:47:02 +0200 (CEST) Received: (qmail 75775 invoked by uid 500); 22 Apr 2020 18:47:01 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 75583 invoked by uid 99); 22 Apr 2020 18:47:01 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Apr 2020 18:47:01 +0000 Received: from jira-he-de.apache.org (static.172.67.40.188.clients.your-server.de [188.40.67.172]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id D19E6E30BD for ; Wed, 22 Apr 2020 18:47:00 +0000 (UTC) Received: from jira-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira-he-de.apache.org (ASF Mail Server at jira-he-de.apache.org) with ESMTP id 28BE8780544 for ; Wed, 22 Apr 2020 18:47:00 +0000 (UTC) Date: Wed, 22 Apr 2020 18:47:00 +0000 (UTC) From: "Gokcen Iskender (Jira)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (PHOENIX-5866) IndexTool verification marks a timestamp column as not matching even though they match MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/PHOENIX-5866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gokcen Iskender updated PHOENIX-5866: ------------------------------------- Description: This is a False Negative report from IndexTool verification. The data table is an immutable table and index table has the include column with timestamp. When indexTool -v Only runs, it marks this row as invalid sometimes saying the ActualValue is different than Index tool table value. The data table and index table have the same rows with same values when we query. The IndexTool's actual value is similar to data table value but it is not the same one. We suspect that the timestamp differ by a few millisecods and it is a value from memory not from the data table. > IndexTool verification marks a timestamp column as not matching even though they match > --------------------------------------------------------------------------------------- > > Key: PHOENIX-5866 > URL: https://issues.apache.org/jira/browse/PHOENIX-5866 > Project: Phoenix > Issue Type: Bug > Reporter: Gokcen Iskender > Priority: Major > > This is a False Negative report from IndexTool verification. > The data table is an immutable table and index table has the include column with timestamp. > When indexTool -v Only runs, it marks this row as invalid sometimes saying the ActualValue is different than Index tool table value. The data table and index table have the same rows with same values when we query. The IndexTool's actual value is similar to data table value but it is not the same one. We suspect that the timestamp differ by a few millisecods and it is a value from memory not from the data table. -- This message was sent by Atlassian Jira (v8.3.4#803005)