Re: Data discrepancy in piler database?
On 2023-10-07 07:05, Andreas wrote: 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? I'd say, fix it in the counter table in the mysql piler database. Janos
Re: Data discrepancy in piler database?
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" | An: "Piler User" | 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)
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
Data discrepancy in piler database?
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
