<div dir="ltr"><div>Hi Ruben<br><br></div><div>It can be an issue from Mariadb.  It might be  due to a recent  upgrade of MariaDb. If this is the first time the instance is deployed there, you may try DROP the index of 'label' and recreate it. Double check the column type is varchar, NOT 'text'<br></div><div><br></div><div><code class="gmail-sql"><div class="gmail-sql-highlight gmail-cm-s-default">
          <span class="gmail-cm-keyword"><a class="gmail-cm-sql-doc" href="http://localhost:14081/url.php?url=https://dev.mysql.com/doc/refman/5.7/en/alter-table.html">ALTER</a></span> <span class="gmail-cm-keyword"><a class="gmail-cm-sql-doc" href="http://localhost:14081/url.php?url=https://dev.mysql.com/doc/refman/5.7/en/alter-table.html">TABLE</a></span> <span class="gmail-cm-variable-2">`vtiger_crmentity`</span> <span class="gmail-cm-keyword"><a class="gmail-cm-sql-doc" href="http://localhost:14081/url.php?url=https://dev.mysql.com/doc/refman/5.7/en/drop-index.html">DROP</a></span> <span class="gmail-cm-keyword"><a class="gmail-cm-sql-doc" href="http://localhost:14081/url.php?url=https://dev.mysql.com/doc/refman/5.7/en/drop-index.html">INDEX</a></span> <span class="gmail-cm-variable-2">`vtiger_crmentity_labelidx`</span><span class="gmail-cm-punctuation">;</span></div><div class="gmail-sql-highlight gmail-cm-s-default"><span class="gmail-cm-punctuation"><br></span></div><div class="gmail-sql-highlight gmail-cm-s-default"><span class="gmail-cm-punctuation"><br></span></div><div class="gmail-sql-highlight gmail-cm-s-default"><span class="gmail-cm-punctuation">Thanks<br></span></div><div class="gmail-sql-highlight gmail-cm-s-default"><span class="gmail-cm-punctuation">Sutharsan Jeganathan<br></span>
        </div></code></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jul 28, 2022 at 7:27 AM Rubén A. Estrada Orozco <<a href="mailto:rulotec1@gmail.com">rulotec1@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi,<div><br></div><div>I've been having these errors on a Vtiger 7.3 DB (Mariadb 10.6.8):</div><div><br></div><div>2022-07-27  9:34:38 215 [ERROR] InnoDB: Record in index `vtiger_crmentity_labelidx` of table `vt_produccion`.`vtiger_crmentity` was not found on update: TUPLE (info_bits=0, 2 fields): {[30]Patricia Lopez(0x53616E6472612053616E6479204D75C3B16F7A204665726EC3A16E64657A),[4] =  (0x803DD517)} at: COMPACT RECORD(info_bits=0, 2 fields): {[23]Eugenia Lopez Ch  vez(0x53616E647261205361617665647261204368C3A1766<br>57A),[4] BU (0x804255E8)}<br>2022-07-27 10:09:48 382 [ERROR] InnoDB: Corruption of an index tree: table `vt_produccion`.`vtiger_crmentity` index `vtiger_crmentity_labelidx`, father ptr page no 70022, child page no 273970<br>PHYSICAL RECORD: n_fields 3; compact format; info bits 0<br> 0: len 30; hex 59612064656369646520706f72206f74726120756e697665727369646164; asc Ya decide; (total 90 bytes);<br> 1: len 4; hex 8005fd4d; asc    M;;<br> 2: len 4; hex 00044186; asc   A ;;<br></div><div><br></div><div>Any ideas of what might be causing this? Any input will be appreciated.</div><div><br></div><div><br clear="all"><div><div dir="ltr"><div dir="ltr">Saludos<div><br></div><div>Rubén</div></div></div></div></div></div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><span style="color:rgb(102,102,102)">Development Manager<br>
        Radus28 Software Solution<br></span>
        <span style="color:rgb(102,102,102)"><img src="cid:part4.EAFD845F.485F57C8@radus28.com" title="www.radus28.com" alt="Radus28 Software Solution" width="205" height="60"><br>
        123, Level 2, Mc Larens Building<br>
        Baudhaloka Mw.<br>
        Colombo 04<br>
        Sri Lanka<br>
        M : +94773795291<br>
        E  : <a href="mailto:sutharsan@radus28.com" target="_blank">sutharsan@radus28.com</a><br>
        W : <a href="http://www.radus28.com" target="_blank">www.radus28.com</a></span></div></div>