<!DOCTYPE html><html><head><title></title><style type="text/css">p.MsoNormal,p.MsoNoSpacing{margin:0}</style></head><body><div style="font-family:Arial;">Conversations.db is an index over lots of interesting bits of the message, but the key part that's used by Xapian is the mapping from G key (aka: GUID, aka: sha1 of the message RFC822 data) to individual email. It's used for deduplication and for mapping from results to messages.<br></div><div style="font-family:Arial;"><br></div><div style="font-family:Arial;">The data in conversations.db is added and removed in real time as messages are appended and updated in the cyrus.index.<br></div><div style="font-family:Arial;"><br></div><div style="font-family:Arial;">The data in the xapian databases on the other hand is append only - so you can wind up with hits that no longer map to existing emails. The way to solve that is with a xapian repack that filters messages - which can be done using the -F flag to squatter.<br></div><div style="font-family:Arial;"><br></div><div style="font-family:Arial;">Cheers,<br></div><div style="font-family:Arial;"><br></div><div style="font-family:Arial;">Bron.<br></div><div style="font-family:Arial;"><br></div><div style="font-family:Arial;">On Sat, Feb 9, 2019, at 23:04, Egoitz Aurrekoetxea wrote:<br></div><blockquote type="cite" id="fastmail-quoted"><p>Good morning,<br></p><p><br></p><p>As far as I understood, for Xapian you first create it's conversation database in order to work. Later you create database(s) for each mailbox where Xapian can search in. You can move data between them, new mails become indexed for instance Squatter in rolling mode... that's ok... and understood I think. I was wondering, what happens when mail indexed in the archive database in removed and then does not exist any more in the database... does Squatter rolling log manage that too?.<br></p><p><br></p><p>By the way. I was wondering if mail gets indexed in the tier databases (for instance in Fastmail in temp, meta, data, archine...) what's the role or function of conversations databases you create with ctl_conversationsdb -b -r ?.<br></p><p><br></p><p>Cheers!<br></p><div><div style="font-family:Arial;">-- <br></div><div style="font-family:Arial;"> <br></div><div style="clear:both;text-align:left;" class="fastmail-quoted-firmasarenet"><div style="margin-top:0px;margin-right:0px;margin-bottom:10px;margin-left:0px;" class="fastmail-quoted-imgsarenet"><img alt="sarenet" src="https://www.sarenet.es/estaticos/LogoSarenetEmails.png?newlogo"><br></div><div style="font-family:Helvetica, Arial, sans-serif;font-weight:bold;font-size:14px;color:rgb(51, 51, 51);" class="fastmail-quoted-titulosarenet"><b>Egoitz Aurrekoetxea</b><br></div><div style="font-family:Helvetica, Arial, sans-serif;font-weight:normal;font-size:12px;color:rgb(51, 51, 51);" class="fastmail-quoted-dptosarenet">Departamento de sistemas<br></div><div style="font-family:Helvetica, Arial, sans-serif;font-weight:normal;font-size:12px;color:rgb(51, 51, 51);" class="fastmail-quoted-textosarenet"><div style="font-family:Arial;">944 209 470<br></div><div style="font-family:Arial;">Parque Tecnológico. Edificio 103<br></div><div style="font-family:Arial;">48170 Zamudio (Bizkaia)<br></div></div><div style="font-family:Helvetica, Arial, sans-serif;font-weight:normal;font-size:12px;color:rgb(0, 122, 196);line-height:1.2;" class="fastmail-quoted-lnksarenet"><label id="fastmail-quoted-label_email">egoitz@sarenet.es<br></label></div><div style="font-family:Helvetica, Arial, sans-serif;font-weight:normal;font-size:12px;color:rgb(0, 122, 196);line-height:1.2;" class="fastmail-quoted-lnksarenet"><a href="http://www.sarenet.es" style="font-size:12px;color:rgb(0, 122, 196);text-decoration-line:underline;text-decoration-style:solid;text-decoration-color:currentcolor;">www.sarenet.es</a><br></div><div style="font-family:Arial;"><br></div><div style="font-family:Helvetica, Arial, sans-serif;font-weight:normal;font-size:10px;color:rgb(160, 195, 97);" class="fastmail-quoted-imprimirsarenet">Antes de imprimir este correo electrónico piense si es necesario hacerlo.<br></div></div></div><div>----<br></div><div>Cyrus Home Page: http://www.cyrusimap.org/<br></div><div>List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/<br></div><div>To Unsubscribe:<br></div><div>https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus<br></div></blockquote><div style="font-family:Arial;"><br></div><div id="sig56629417"><div class="signature">--<br></div><div class="signature"> Bron Gondwana, CEO, FastMail Pty Ltd<br></div><div class="signature"> brong@fastmailteam.com<br></div><div class="signature"><br></div></div><div style="font-family:Arial;"><br></div></body></html>