<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi Robert!</p>
<p><br /></p>
<p>I see! I though you only needed to run Squatter in rolling mode in the slave.. I though the roling mode was just for slaves to take the Squatter changes caused by a normal squatter command launched in the master... So, if I run Squatter in the master in rolling mode... then I assume there's no need to launch manually squatter command in the master... isn't it?.</p>
<p><br /></p>
<p>I'm planning to upgrade some 2.3 running machines to either 2.4 or 3.0.... and you know... is a big responsability... am doing tons of sandbox testing... is it known (as Michael stated) not to be working traditional squatter in 3.0 if you don't want to use now the Xapian engine?.</p>
<p><br /></p>
<p>I'll read the post right now :) :)</p>
<p><br /></p>
<p>Thank you so much for all your help mate :)</p>
<p>Cheers!</p>
<div>---<br />
<div class="firmasarenet" style="clear: both; text-align: left;">
<div class="imgsarenet" style="margin: 0 0 10px 0;"><img src="https://www.sarenet.es/estaticos/LogoSarenetEmails.png?newlogo" alt="sarenet" /></div>
<div class="titulosarenet" style="font-family: Helvetica, Arial, sans-serif; font-weight: bold; font-size: 14px; color: #333333;"><strong>Egoitz Aurrekoetxea</strong></div>
<div class="dptosarenet" style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 12px; color: #333333;">Departamento de sistemas</div>
<div class="textosarenet" style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 12px; color: #333333;">944 209 470<br />Parque Tecnológico. Edificio 103<br />48170 Zamudio (Bizkaia)</div>
<div class="lnksarenet" style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 12px; color: #007ac4; line-height: 1.2;"><a id="mailto" style="font-size: 12px; color: #007ac4; text-decoration: underline;" href="mailto:egoitz@sarenet.es"><label id="label_email">egoitz@sarenet.es</label></a></div>
<div class="lnksarenet" style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 12px; color: #007ac4; line-height: 1.2;"><a style="font-size: 12px; color: #007ac4; text-decoration: underline;" href="http://www.sarenet.es">www.sarenet.es</a></div>
<br />
<div class="imprimirsarenet" style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 10px; color: #a0c361;">Antes de imprimir este correo electrónico piense si es necesario hacerlo.</div>
</div>
</div>
<p><br /></p>
<p>El 07-01-2019 19:24, Robert Stepanek escribió:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --> <!-- head ignored --><!-- meta ignored -->
<div>Hi Egon,</div>
<div> </div>
<div>Yes, the slave should index in conversations.db automatically AFAIK. </div>
<div> </div>
<div>You should run squatter in rolling mode on the master, too. </div>
<div> </div>
<div>BTW: in 2014, Bron wrote a blog post about the search setup at FastMail: <a href="https://fastmail.blog/2014/12/01/email-search-system/" target="_blank" rel="noopener noreferrer">https://fastmail.blog/2014/12/01/email-search-system/</a></div>
<div>It's quite technical, but should give you a good idea at how it's set up for fast indexing and search </div>
<div> </div>
<div>Cheers, Robert </div>
<div> </div>
<div> </div>
<div>On Mon, Jan 7, 2019, at 5:54 PM, Egoitz Aurrekoetxea wrote:</div>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<p>Hi Robert!</p>
<p><br /></p>
<p>Thank you so much for helping us (mainly which is the one boring the list with questions :) although I promise I've checked the doc before asking :) :) ).</p>
<p><br /></p>
<p>When you have a master/slave config... in the slave one, when running Squatter in rolling mode... does it update the conversations db too?. By the way, Squatter in rolling mode only makes sense in slave machines isn't it?.</p>
<p><br /></p>
<p>Many thanks!</p>
<p><br /></p>
<div>
<div>---</div>
<div> </div>
<div style="clear: both; text-align: left;">
<div style="margin: 0px 0px 10px 0px;"><img src="https://www.fastmailusercontent.com/proxy/a5d9804681aecc18b32a831c35a8175e04d4299aad69fa43dc45f6a4d4a2bb40/8647470737a3f2f2777777e237162756e65647e25637f256374716479636f637f2c4f676f635162756e6564754d61696c637e207e676f3e65677c6f676f6/LogoSarenetEmails.png" alt="sarenet" /></div>
<div style="font-family: Helvetica, Arial, sans-serif; font-weight: bold; font-size: 14px; color: #333333;"><strong>Egoitz Aurrekoetxea</strong></div>
<div style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 12px; color: #333333;">Departamento de sistemas</div>
<div style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 12px; color: #333333;">
<div>944 209 470</div>
<div>Parque Tecnológico. Edificio 103</div>
<div>48170 Zamudio (Bizkaia)</div>
</div>
<div style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 12px; color: #007ac4; line-height: 1.2;"><label>egoitz@sarenet.es<br /></label></div>
<div style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 12px; color: #007ac4; line-height: 1.2;"><a style="font-size: 12px; color: #007ac4; text-decoration: underline;" href="http://www.sarenet.es" target="_blank" rel="noopener noreferrer">www.sarenet.es</a></div>
<div> </div>
<div style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 10px; color: #a0c361;">Antes de imprimir este correo electrónico piense si es necesario hacerlo.</div>
</div>
</div>
<p><br /></p>
<p>El 07-01-2019 16:42, Robert Stepanek escribió:</p>
<blockquote style="border-left-width: 2px; border-left-style: solid; border-left-color: #1010ff; padding: 0px 0.4em 0px 0.4em; margin: 0px;">
<div>Hi,</div>
<div> </div>
<div>Sebastian is right:</div>
<div> </div>
<div>On Mon, Jan 7, 2019, at 3:57 PM, Sebastian Hagedorn wrote:</div>
<blockquote style="border-left-width: 2px; border-left-style: solid; border-left-color: #1010ff; padding: 0px 0.4em 0px 0.4em; margin: 0px;">
<div> </div>
<div>squatter is nowadays a bit of a misnomer, because it uses whatever index</div>
<div>you have configured. In cyrus 2.4, squatter would always create a SQUAT</div>
<div>index. When you run squatter with Xapian, it will build the index, but for</div>
<div>the index to actually work, you also need the conversationsdb.</div>
</blockquote>
<div> </div>
<div>conversations.db is indeed a misnomer now. The database was only used to keep track of mail threads (hence the name), but its role expanded. One of the indexes it stores is the SHA1 hashes of every message, and separate hashes for each of that message MIME parts. Such a hash is named the GUID, and for each GUID we store a list of all mailbox:UID[bodypart] pairs where this content occurs in.</div>
<div> </div>
<div>For search, we keep track of the indexed messages by GUID, so we can avoid reindexing duplicate mails. To return a search result, we can now map that GUID back to its mailbox:message pairs. That's why we need conversations.db for search.</div>
<div> </div>
<div>I can't help with upgrading from 2.4, unfortunately, but if you re-index your mailboxes once in conversations.db, you should be all set.</div>
<div> </div>
<div>Cheers,</div>
<div>Robert</div>
<div> </div>
<div style="font-family: monospace; padding: 0px; margin: 0px;">
<div>----</div>
<div>Cyrus Home Page: <a href="http://www.cyrusimap.org/" target="_blank" rel="noopener noreferrer">http://www.cyrusimap.org/</a></div>
<div>List Archives/Info: <a href="http://lists.andrew.cmu.edu/pipermail/info-cyrus/" target="_blank" rel="noopener noreferrer">http://lists.andrew.cmu.edu/pipermail/info-cyrus/</a></div>
<div>To Unsubscribe:</div>
<div><a href="https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus" target="_blank" rel="noopener noreferrer">https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus</a></div>
</div>
</blockquote>
</blockquote>
<div> </div>
</blockquote>
</body></html>