Hi Janos,
thank you for your quick reply!
Is there anything I can do to track down the root cause?
Or would you just ignore the difference?
As I assume that the data in table counter is wrong: is there any way to
correct the data there?
Thyn you again for a respone
Andreas
----- Ursprüngliche Mail -----
| Von: "Janos SUTO" <s...@acts.hu>
| An: "Piler User" <piler-user@list.acts.hu>
| Gesendet: Donnerstag, 5. Oktober 2023 18:25:02
| Betreff: Re: Data discrepancy in piler database?
| To me 107595+4997 are close to 111k. Anyway, perhaps there
| were some errors during the processing, and might have counted
| as a received message. Not sure.
|
| Janos
|
| On 2023-10-05 08:25, Andreas wrote:
|> Hi,
|>
|> I received a database dump, all files from /var/piler/store and some
|> more stuff from my provider and migrated that into my docker instance.
|>
|> Now i carfeully check the data I have received and i see a discrepance
|> i do not understand. The discrepancy is based only on the data I
|> received (I did not archive any additional mails).
|>
|> As administrator in the UI i can see
|> * received messages 111,114
|> * duplicate messages 4,997
|> this is exaclty what is stored in the table counter
|>
|> In the auditors ui i can see 107595 messages.
|> This is also the amount of messages i can count from table rcpt (based
|> on id) and metadata
|>
|> Where can the discrepancy come from? Sorry, i really have no idea
|> where to start analysis.
|> Thank you for your help in advance
|>
| > Andreas
(null)