Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.4.20
-
None
Description
2021-11-05 10:07:51 131 [ERROR] InnoDB: Clustered record for sec rec not found index `items_1` of table `zabbix`.`items`
InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
0: len 8; hex 0000000000002f6d; asc /m;;
1: len 30; hex 646f636b65722e6d6f6e69746f725b757365642e6d656d2c736f6e64612d; asc docker.monitor[used.mem,sonda-; (total 41 bytes);
2: len 8; hex 000000000005f5be; asc ;;
InnoDB: clust index record PHYSICAL RECORD: n_fields 62; compact format; info bits 0
0: len 8; hex 000000000005f4bf; asc ;;
1: len 6; hex 000000000000; asc ;;
2: len 7; hex 80000000000000; asc ;;
3: len 4; hex 80000012; asc ;;
4: len 0; hex ; asc ;;
5: len 0; hex ; asc ;;
6: len 8; hex 0000000000002f99; asc / ;;
7: len 20; hex 436f66726520666f7261207375626e6574203332; asc Cofre fora subnet 32;;
8: len 9; hex 7375626e65745f3332; asc subnet_32;;
9: len 1; hex 30; asc 0;;
10: len 2; hex 3764; asc 7d;;
11: len 4; hex 33363564; asc 365d;;
12: len 4; hex 80000001; asc ;;
13: len 4; hex 80000003; asc ;;
14: len 0; hex ; asc ;;
15: len 0; hex ; asc ;;
16: len 0; hex ; asc ;;
17: len 4; hex 80000000; asc ;;
18: len 0; hex ; asc ;;
19: len 0; hex ; asc ;;
20: len 0; hex ; asc ;;
21: len 0; hex ; asc ;;
22: SQL NULL;
23: SQL NULL;
24: len 0; hex ; asc ;;
25: len 0; hex ; asc ;;
26: len 4; hex 80000000; asc ;;
27: len 0; hex ; asc ;;
28: len 0; hex ; asc ;;
29: len 0; hex ; asc ;;
30: len 0; hex ; asc ;;
31: len 4; hex 80000000; asc ;;
32: SQL NULL;
33: len 0; hex ; asc ;;
34: len 0; hex ; asc ;;
35: len 4; hex 80000000; asc ;;
36: len 3; hex 333064; asc 30d;;
37: len 4; hex 80000000; asc ;;
38: len 4; hex 80000000; asc ;;
39: len 0; hex ; asc ;;
40: len 4; hex 80000000; asc ;;
41: len 0; hex ; asc ;;
42: len 8; hex 000000000005f4b7; asc ;;
43: len 2; hex 3373; asc 3s;;
44: len 0; hex ; asc ;;
45: len 0; hex ; asc ;;
46: len 0; hex ; asc ;;
47: len 3; hex 323030; asc 200;;
48: len 4; hex 80000001; asc ;;
49: len 4; hex 80000000; asc ;;
50: len 0; hex ; asc ;;
51: len 0; hex ; asc ;;
52: len 4; hex 80000000; asc ;;
53: len 4; hex 80000000; asc ;;
54: len 4; hex 80000000; asc ;;
55: len 0; hex ; asc ;;
56: len 0; hex ; asc ;;
57: len 0; hex ; asc ;;
58: len 4; hex 80000000; asc ;;
59: len 4; hex 80000000; asc ;;
60: len 4; hex 80000000; asc ;;
61: SQL DEFAULT;
TRANSACTION 421703784035608, ACTIVE 3 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 131, OS thread handle 140220371769088, query id 65567758 zabbix-infra02.sep.local 10.170.20.36 zabbix Sending data
select t.itemid,t.lastlogsize,t.mtime from item_rtdata t,items i,hosts h where t.itemid=i.itemid and i.hostid=h.hostid and h.proxy_hostid=12216 order by t.itemid
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
Attachments
Issue Links
- relates to
-
MDEV-26917 InnoDB: Clustered record for sec rec not found index
- Closed