phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hengesbach, Martin" <>
Subject AW: Duplicate Records Showing in Apache Phoenix
Date Mon, 05 Mar 2018 09:31:35 GMT

we had the same problem in our Phoenix 4.7 installation two or three times. We got it "solved"
with a combination of "update statistics", "delete * from system.stats", rebuilding the indices
of the table and restart of hbase. 

The problem is not reproducible at the moment and occurs very rarely. We are using Phoenix
intensively with many upserts. Our Phoenix installation has > 1.600 tables and a lot of
global indices. I had the impression that the error occurs when the cluster is overloaded
but it's only an impression.


-----Ursprüngliche Nachricht-----
Von: Azharuddin Shaikh [mailto:azharuddin.shaikh@RESILINC.COM] 
Gesendet: Donnerstag, 1. März 2018 10:09
Betreff: Re: Duplicate Records Showing in Apache Phoenix


Have you experienced this Duplicate records issue again on your hbase cluster.

Also, have you tried increasing your guidepost value for your phoenix.

Let me know if you have any specific solution to avoid this apart from dropping system.* tables
to resolve this issue.


Azharuddin Shaikh

Sent from:

FIZ Karlsruhe - Leibniz-Institut für Informationsinfrastruktur GmbH.
Sitz der Gesellschaft: Eggenstein-Leopoldshafen, Amtsgericht Mannheim HRB 101892.
Geschäftsführerin: Sabine Brünger-Weilandt.
Vorsitzender des Aufsichtsrats: MinDirig Dr. Stefan Luther.

View raw message