Comments - indexes in subquery causing MariaDB crash ???

4 years, 9 months ago Nigel Gomm

2019-11-19 9:13:54 99 [ERROR] InnoDB: Clustered record for sec rec not found index `Dealid` of table `dbabsoluteestateagents`.`invoices` Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 4; hex 8000012e; asc .;; Nov 19 09:13:54 server5 mysqld[30807]: 1: len 4; hex 8000025a; asc Z;; Nov 19 09:13:54 server5 mysqld[30807]: InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0 Nov 19 09:13:54 server5 mysqld[30807]: 0: len 8; hex 696e66696d756d00; asc infimum ;; Nov 19 09:13:54 server5 mysqld[30807]: TRANSACTION 422038467468224, ACTIVE 0 sec starting index read Nov 19 09:13:54 server5 mysqld[30807]: mysql tables in use 4, locked 0 N

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.