[Vtigercrm-developers] vtiger_crmentity_labelidx errors in DB logs

[Sutharsan J]

Hi Ruben

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'

ALTER
<http://localhost:14081/url.php?url=https://dev.mysql.com/doc/refman/5.7/en/alter-table.html>
TABLE
<http://localhost:14081/url.php?url=https://dev.mysql.com/doc/refman/5.7/en/alter-table.html>
`vtiger_crmentity` DROP
<http://localhost:14081/url.php?url=https://dev.mysql.com/doc/refman/5.7/en/drop-index.html>
INDEX
<http://localhost:14081/url.php?url=https://dev.mysql.com/doc/refman/5.7/en/drop-index.html>
`vtiger_crmentity_labelidx`;


Thanks
Sutharsan Jeganathan

On Thu, Jul 28, 2022 at 7:27 AM Rubén A. Estrada Orozco <rulotec1 at gmail.com>
wrote:

> Hi,
>
> I've been having these errors on a Vtiger 7.3 DB (Mariadb 10.6.8):
>
> 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
> 57A),[4] BU (0x804255E8)}
> 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
> PHYSICAL RECORD: n_fields 3; compact format; info bits 0
>  0: len 30; hex
> 59612064656369646520706f72206f74726120756e697665727369646164; asc Ya
> decide; (total 90 bytes);
>  1: len 4; hex 8005fd4d; asc    M;;
>  2: len 4; hex 00044186; asc   A ;;
>
> Any ideas of what might be causing this? Any input will be appreciated.
>
>
> Saludos
>
> Rubén
> _______________________________________________
> http://www.vtiger.com/



-- 
Development Manager
Radus28 Software Solution
[image: Radus28 Software Solution]
123, Level 2, Mc Larens Building
Baudhaloka Mw.
Colombo 04
Sri Lanka
M : +94773795291
E  : sutharsan at radus28.com
W : www.radus28.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220728/db0f9dd7/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logo_web.png
Type: image/png
Size: 15612 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220728/db0f9dd7/attachment-0001.png>